[DDLUTILS-249] make it possible to ignore foreign keys

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Core (No specific database)
• Environment: Ubuntu 9.04
• Assignee: Thomas Dudziak
• Reporter: Tomislav Nakic-Alfirevic
• Created: 31/May/09 16:08
• Updated: 31/May/09 16:08

Description

I use ddlutils for warehouse-related tasks and so don't need all the foreign key support. However, foreign keys in some databases I worked with prevented my ddlutils ant scripts to break. I performed the following quick fix:
Index: main/java/org/apache/ddlutils/platform/SqlBuilder.java
===================================================================
— main/java/org/apache/ddlutils/platform/SqlBuilder.java (revision 753277)
+++ main/java/org/apache/ddlutils/platform/SqlBuilder.java (working copy)
@@ -696,7 +696,7 @@

{ _log.warn("Foreign key table is null for key " + foreignKey); }

• else
  + else if (false) // we don't want foreign keys
  {
  writeTableAlterStmt(table);

I understand that this is unacceptable as a general solution, but maybe a parameter could be introduced to choose if the "else" clause will be called or not, something like "ignoreForeignKeys=yes|no"?