public void createConfigTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " name VARCHAR(255) NOT NULL,\n" + " payload %2$s NOT NULL,\n" + " PRIMARY KEY(name)\n" + ")", tableName, getPayloadType() ) ) ); }
public void createDataSourceTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " dataSource VARCHAR(255) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " commit_metadata_payload %2$s NOT NULL,\n" + " commit_metadata_sha1 VARCHAR(255) NOT NULL,\n" + " PRIMARY KEY (dataSource)\n" + ")", tableName, getPayloadType() ) ) ); }
public void createRulesTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id VARCHAR(255) NOT NULL,\n" + " dataSource VARCHAR(255) NOT NULL,\n" + " version VARCHAR(255) NOT NULL,\n" + " payload %2$s NOT NULL,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getPayloadType() ), StringUtils.format("CREATE INDEX idx_%1$s_datasource ON %1$s(dataSource)", tableName) ) ); }
public void createEntryTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id VARCHAR(255) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " datasource VARCHAR(255) NOT NULL,\n" + " payload %2$s NOT NULL,\n" + " status_payload %2$s NOT NULL,\n" + " active BOOLEAN NOT NULL DEFAULT FALSE,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getPayloadType() ), StringUtils.format("CREATE INDEX idx_%1$s_active_created_date ON %1$s(active, created_date)", tableName) ) ); }
public void createLogTable(final String tableName, final String entryTypeName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id %2$s NOT NULL,\n" + " %4$s_id VARCHAR(255) DEFAULT NULL,\n" + " log_payload %3$s,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getSerialType(), getPayloadType(), entryTypeName ), StringUtils.format("CREATE INDEX idx_%1$s_%2$s_id ON %1$s(%2$s_id)", tableName, entryTypeName) ) ); }
public void createLockTable(final String tableName, final String entryTypeName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id %2$s NOT NULL,\n" + " %4$s_id VARCHAR(255) DEFAULT NULL,\n" + " lock_payload %3$s,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getSerialType(), getPayloadType(), entryTypeName ), StringUtils.format("CREATE INDEX idx_%1$s_%2$s_id ON %1$s(%2$s_id)", tableName, entryTypeName) ) ); }
public void createSupervisorsTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id %2$s NOT NULL,\n" + " spec_id VARCHAR(255) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " payload %3$s NOT NULL,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getSerialType(), getPayloadType() ), StringUtils.format("CREATE INDEX idx_%1$s_spec_id ON %1$s(spec_id)", tableName) ) ); }
private void createAuditTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id %2$s NOT NULL,\n" + " audit_key VARCHAR(255) NOT NULL,\n" + " type VARCHAR(255) NOT NULL,\n" + " author VARCHAR(255) NOT NULL,\n" + " comment VARCHAR(2048) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " payload %3$s NOT NULL,\n" + " PRIMARY KEY(id)\n" + ")", tableName, getSerialType(), getPayloadType() ), StringUtils.format("CREATE INDEX idx_%1$s_key_time ON %1$s(audit_key, created_date)", tableName), StringUtils.format("CREATE INDEX idx_%1$s_type_time ON %1$s(type, created_date)", tableName), StringUtils.format("CREATE INDEX idx_%1$s_audit_time ON %1$s(created_date)", tableName) ) ); }
public void createSegmentTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id VARCHAR(255) NOT NULL,\n" + " dataSource VARCHAR(255) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " start VARCHAR(255) NOT NULL,\n" + " %3$send%3$s VARCHAR(255) NOT NULL,\n" + " partitioned BOOLEAN NOT NULL,\n" + " version VARCHAR(255) NOT NULL,\n" + " used BOOLEAN NOT NULL,\n" + " payload %2$s NOT NULL,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getPayloadType(), getQuoteString() ), StringUtils.format("CREATE INDEX idx_%1$s_used ON %1$s(used)", tableName), StringUtils.format( "CREATE INDEX idx_%1$s_datasource_used_end ON %1$s(dataSource, used, %2$send%2$s)", tableName, getQuoteString() ) ) ); }
+ " UNIQUE (sequence_name_prev_id_sha1)\n" + ")", tableName, getPayloadType(), getQuoteString() ), StringUtils.format(
public void createConfigTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " name VARCHAR(255) NOT NULL,\n" + " payload %2$s NOT NULL,\n" + " PRIMARY KEY(name)\n" + ")", tableName, getPayloadType() ) ) ); }
public void createDataSourceTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " dataSource VARCHAR(255) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " commit_metadata_payload %2$s NOT NULL,\n" + " commit_metadata_sha1 VARCHAR(255) NOT NULL,\n" + " PRIMARY KEY (dataSource)\n" + ")", tableName, getPayloadType() ) ) ); }
public void createRulesTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id VARCHAR(255) NOT NULL,\n" + " dataSource VARCHAR(255) NOT NULL,\n" + " version VARCHAR(255) NOT NULL,\n" + " payload %2$s NOT NULL,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getPayloadType() ), StringUtils.format("CREATE INDEX idx_%1$s_datasource ON %1$s(dataSource)", tableName) ) ); }
public void createEntryTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id VARCHAR(255) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " datasource VARCHAR(255) NOT NULL,\n" + " payload %2$s NOT NULL,\n" + " status_payload %2$s NOT NULL,\n" + " active BOOLEAN NOT NULL DEFAULT FALSE,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getPayloadType() ), StringUtils.format("CREATE INDEX idx_%1$s_active_created_date ON %1$s(active, created_date)", tableName) ) ); }
public void createLockTable(final String tableName, final String entryTypeName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id %2$s NOT NULL,\n" + " %4$s_id VARCHAR(255) DEFAULT NULL,\n" + " lock_payload %3$s,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getSerialType(), getPayloadType(), entryTypeName ), StringUtils.format("CREATE INDEX idx_%1$s_%2$s_id ON %1$s(%2$s_id)", tableName, entryTypeName) ) ); }
public void createLogTable(final String tableName, final String entryTypeName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id %2$s NOT NULL,\n" + " %4$s_id VARCHAR(255) DEFAULT NULL,\n" + " log_payload %3$s,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getSerialType(), getPayloadType(), entryTypeName ), StringUtils.format("CREATE INDEX idx_%1$s_%2$s_id ON %1$s(%2$s_id)", tableName, entryTypeName) ) ); }
public void createSupervisorsTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id %2$s NOT NULL,\n" + " spec_id VARCHAR(255) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " payload %3$s NOT NULL,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getSerialType(), getPayloadType() ), StringUtils.format("CREATE INDEX idx_%1$s_spec_id ON %1$s(spec_id)", tableName) ) ); }
private void createAuditTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id %2$s NOT NULL,\n" + " audit_key VARCHAR(255) NOT NULL,\n" + " type VARCHAR(255) NOT NULL,\n" + " author VARCHAR(255) NOT NULL,\n" + " comment VARCHAR(2048) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " payload %3$s NOT NULL,\n" + " PRIMARY KEY(id)\n" + ")", tableName, getSerialType(), getPayloadType() ), StringUtils.format("CREATE INDEX idx_%1$s_key_time ON %1$s(audit_key, created_date)", tableName), StringUtils.format("CREATE INDEX idx_%1$s_type_time ON %1$s(type, created_date)", tableName), StringUtils.format("CREATE INDEX idx_%1$s_audit_time ON %1$s(created_date)", tableName) ) ); }
public void createSegmentTable(final String tableName) { createTable( tableName, ImmutableList.of( StringUtils.format( "CREATE TABLE %1$s (\n" + " id VARCHAR(255) NOT NULL,\n" + " dataSource VARCHAR(255) NOT NULL,\n" + " created_date VARCHAR(255) NOT NULL,\n" + " start VARCHAR(255) NOT NULL,\n" + " %3$send%3$s VARCHAR(255) NOT NULL,\n" + " partitioned BOOLEAN NOT NULL,\n" + " version VARCHAR(255) NOT NULL,\n" + " used BOOLEAN NOT NULL,\n" + " payload %2$s NOT NULL,\n" + " PRIMARY KEY (id)\n" + ")", tableName, getPayloadType(), getQuoteString() ), StringUtils.format("CREATE INDEX idx_%1$s_used ON %1$s(used)", tableName), StringUtils.format( "CREATE INDEX idx_%1$s_datasource_used_end ON %1$s(dataSource, used, %2$send%2$s)", tableName, getQuoteString() ) ) ); }
+ " UNIQUE (sequence_name_prev_id_sha1)\n" + ")", tableName, getPayloadType(), getQuoteString() ), StringUtils.format(