byte[] metadata = tableRefToTableMetadata.get(tableRef); String partialSql = ctx.createTable(tableName(tableRef)) .column(ROW_NAME, VARBINARY.nullable(false)) .column(COL_NAME, VARBINARY.nullable(false))
: temporary ? ctx.dsl.createTemporaryTable(tableName) : ctx.dsl.createTable(tableName); : temporary ? ctx.dsl.createTemporaryTable(tableName) : ctx.dsl.createTable(tableName); CreateTableColumnStep s2 = s1.columns(fields); CreateTableConstraintStep s3 = constraints.isEmpty()
@Override public CreateTableAsStep<Record> createTable( Table<?> table) { return delegate.createTable(table); }
@Override public CreateTableAsStep<Record> createTable(String table) { return delegate.createTable(table); }
@Override public CreateTableAsStep<Record> createTable(Name table) { return delegate.createTable(table); }
public static JdbcTimestampBoundStore create(final JdbcKeyValueService kvs) { final JdbcTimestampBoundStore store = new JdbcTimestampBoundStore(kvs); kvs.run((Function<DSLContext, Void>) ctx -> { String partialSql = ctx.createTable(store.TABLE) .column(DUMMY_COLUMN, INTEGER.nullable(false)) .column(LATEST_TIMESTAMP, BIGINT.nullable(false)) .getSQL(); int endIndex = partialSql.lastIndexOf(')'); String fullSql = partialSql.substring(0, endIndex) + "," + " CONSTRAINT " + kvs.primaryKey(TIMESTAMP_TABLE) + " PRIMARY KEY (" + DUMMY_COLUMN.getName() + ")" + partialSql.substring(endIndex); try { ctx.execute(fullSql); } catch (DataAccessException e) { kvs.handleTableCreationException(e); } ctx.insertInto(store.TABLE, DUMMY_COLUMN, LATEST_TIMESTAMP) .select(ctx.select(DUMMY_COLUMN, LATEST_TIMESTAMP) .from(kvs.values(ctx, new RowN[] {(RowN) DSL.row(0, 10000L)}, "t", DUMMY_COLUMN.getName(), LATEST_TIMESTAMP.getName())) .whereNotExists(ctx.selectOne() .from(store.TABLE) .where(DUMMY_COLUMN.eq(0)))) .execute(); return null; }); return store; }
String partialSql = ctx.createTable(kvs.METADATA_TABLE) .column(TABLE_NAME, VARCHAR.nullable(false)) .column(METADATA, BLOB.nullable(false))
/** * Create a new DSL <code>CREATE TABLE</code> statement. * * @see DSLContext#createTable(Table) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE }) public static CreateTableAsStep<Record> createTable(Table<?> table) { return dsl().createTable(table); }
/** * Create a new DSL <code>CREATE TABLE</code> statement. * * @see DSLContext#createTable(Name) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE }) public static CreateTableAsStep<Record> createTable(Name table) { return dsl().createTable(table); }
/** * Create a new DSL <code>CREATE TABLE</code> statement. * * @see DSLContext#createTable(String) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE }) public static CreateTableAsStep<Record> createTable(String table) { return dsl().createTable(table); }
private final Query createTable(Table<?> table) { return ctx.createTable(table) .columns(table.fields()) .constraints(constraints(table)); }
public void create(DSLContext dsl) throws DatabaseDefinitionException { ArrayList<String> created = new ArrayList<>(); for (String tableName : tables.keySet()) { TableDefinition table = tables.get(tableName); ArrayList<Field<?>> fields = table.getFields(dsl); ArrayList<Constraint> constraints = table.getPkConstraints(dsl, tableName); CreateTableConstraintStep query = dsl.createTable(DSL.name(tableName)).columns(fields) .constraints(constraints); logger.info("Executing SQL: " + query.getSQL()); query.execute(); created.add(tableName); } for (String tableName : created) { TableDefinition table = tables.get(tableName); for (Constraint constraint : table.getFkConstraints(dsl, tableName, this)) { AlterTableUsingIndexStep query = dsl.alterTable(DSL.name(tableName)).add(constraint); logger.info("Executing SQL: " + query.getSQL()); query.execute(); } } }
ctx.createTable(table) .columns(table.fields()) .constraints(constraints)
dsl.createTable(USERS) .column(UIDX, UIDX.getDataType().nullable(false)) .column(USER_ID, USER_ID.getDataType().nullable(false)) dsl.createTable(ITEMS) .column(IIDX, IIDX.getDataType().nullable(false)) .column(ITEM_ID, ITEM_ID.getDataType().nullable(false)) dsl.createTable(DATA) .column(UIDX, UIDX.getDataType().nullable(false)) .column(IIDX, IIDX.getDataType().nullable(false))