protected void writeForeignKey(
DdlWrite write,
String fkName,
String tableName,
String[] columns,
String refTable,
String[] refColumns)
throws IOException {
tableName = lowerName(tableName);
DdlBuffer fkeyBuffer = write.applyForeignKeys();
fkeyBuffer
.append("alter table ")
.append(tableName)
.append(" add constraint ")
.append(fkName)
.append(" foreign key");
appendColumns(columns, fkeyBuffer);
fkeyBuffer.append(" references ").append(lowerName(refTable));
appendColumns(refColumns, fkeyBuffer);
fkeyBuffer.appendWithSpace(platformDdl.getForeignKeyRestrict()).endOfStatement();
String indexName = determineForeignKeyIndexName(tableName, columns);
boolean addIndex = indexSet.add(columns);
if (addIndex) {
// no matching unique constraint so add the index
fkeyBuffer.append("create index ").append(indexName).append(" on ").append(tableName);
appendColumns(columns, fkeyBuffer);
fkeyBuffer.endOfStatement();
}
fkeyBuffer.end();
if (addIndex) {
write.rollbackForeignKeys().append("drop index ").append(indexName).endOfStatement();
}
write
.rollbackForeignKeys()
.append("alter table ")
.append(tableName)
.append(" drop constraint ")
.append(fkName)
.endOfStatement();
write.rollbackForeignKeys().end();
}
