private final void dropColumnsInBlock(Context<?> ctx) { begin(ctx); for (int i = 0; i < dropColumns.size(); i++) { Field<?> f = dropColumns.get(i); if (i > 0) ctx.formatSeparator(); ctx.visit(alterTable(table).dropColumn(f)).sql(';'); } end(ctx); }
private final void alterColumnTypeAndNullabilityInBlock(Context<?> ctx) { begin(ctx); accept1(ctx); ctx.sql(';').formatSeparator(); switch (ctx.family()) { case POSTGRES: { AlterTableAlterStep<?> step = ctx.dsl().alterTable(table).alterColumn(alterColumn); ctx.visit(alterColumnType.nullable() ? step.dropNotNull() : step.setNotNull()); break; } } end(ctx); }
private final void accept0(Context<?> ctx) { boolean c = comment != null && EMULATE_COMMENT_IN_BLOCK.contains(ctx.family()); boolean i = !indexes.isEmpty() && EMULATE_INDEXES_IN_BLOCK.contains(ctx.family()); if (c || i) { begin(ctx); accept1(ctx); ctx.sql(';'); if (c) { ctx.formatSeparator(); ctx.visit(commentOnTable(table).is(comment)); ctx.sql(';'); } if (i) { for (Index index : indexes) { ctx.formatSeparator(); if ("".equals(index.getName())) ctx.visit(createIndex().on(index.getTable(), index.getFields())); else ctx.visit(createIndex(index.getUnqualifiedName()).on(index.getTable(), index.getFields())); ctx.sql(';'); } } end(ctx); return; } accept1(ctx); }