@Override
public String toString() {
StringBuilder b = new StringBuilder();
b.append("ALTER TABLE ").append(table.getFullyQualifiedName()).append(" ADD ");
if (columnName != null) {
b.append("COLUMN ").append(columnName).append(" ").append(dataType.toString());
} else if (pkColumns != null) {
b.append("PRIMARY KEY (").append(PlainSelect.getStringList(pkColumns)).append(")");
} else if (ukColumns != null) {
b.append("UNIQUE KEY ")
.append(ukName)
.append(" (")
.append(PlainSelect.getStringList(ukColumns))
.append(")");
} else if (fkColumns != null) {
b.append("FOREIGN KEY (")
.append(PlainSelect.getStringList(fkColumns))
.append(") REFERENCES ")
.append(fkSourceTable)
.append(" (")
.append(PlainSelect.getStringList(fkSourceColumns))
.append(")");
if (isOnDeleteCascade()) {
b.append(" ON DELETE CASCADE");
} else if (isOnDeleteRestrict()) {
b.append(" ON DELETE RESTRICT");
} else if (isOnDeleteSetNull()) {
b.append(" ON DELETE SET NULL");
}
} else if (fkIndex != null) {
b.append(fkIndex);
}
return b.toString();
}
@Override
public String toString() {
String sql = "";
sql = "CREATE " + (unlogged ? "UNLOGGED " : "") + "TABLE " + table;
if (select != null) {
sql += " AS " + select.toString();
} else {
sql += " (";
sql += PlainSelect.getStringList(columnDefinitions, true, false);
if (indexes != null && indexes.size() != 0) {
sql += ", ";
sql += PlainSelect.getStringList(indexes);
}
sql += ")";
String options = PlainSelect.getStringList(tableOptionsStrings, false, false);
if (options != null && options.length() > 0) {
sql += " " + options;
}
}
return sql;
}
public void deParse(Update update) {
buffer
.append("UPDATE ")
.append(PlainSelect.getStringList(update.getTables(), true, false))
.append(" SET ");
for (int i = 0; i < update.getColumns().size(); i++) {
Column column = update.getColumns().get(i);
buffer.append(column.getFullyQualifiedName()).append(" = ");
Expression expression = update.getExpressions().get(i);
expression.accept(expressionVisitor);
if (i < update.getColumns().size() - 1) {
buffer.append(", ");
}
}
if (update.getFromItem() != null) {
buffer.append(" FROM ").append(update.getFromItem());
if (update.getJoins() != null) {
for (Join join : update.getJoins()) {
if (join.isSimple()) {
buffer.append(", ").append(join);
} else {
buffer.append(" ").append(join);
}
}
}
}
if (update.getWhere() != null) {
buffer.append(" WHERE ");
update.getWhere().accept(expressionVisitor);
}
}
@Override
public String toString() {
return type
+ " "
+ PlainSelect.getStringList(columnsNames, true, true)
+ (name != null ? " " + name : "");
}