本文整理汇总了Java中org.jooq.impl.SQLDataType类的典型用法代码示例。如果您正苦于以下问题:Java SQLDataType类的具体用法?Java SQLDataType怎么用?Java SQLDataType使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SQLDataType类属于org.jooq.impl包,在下文中一共展示了SQLDataType类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try (Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("groups"))
.column(field("group_id", SQLDataType.BIGINT.identity(true)))
.column(field("name", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("description", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("write_protected", SQLDataType.BOOLEAN.nullable(false)))
.constraints(
constraint().primaryKey(field("group_id")),
constraint().unique(field("name"))
).getSQL();
stmt.execute(ddl);
}
}
示例2: setUp
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@BeforeEach
void setUp() throws Exception {
context = Helper.createInMemoryContext();
context.createTable("tableA")
.column("A", SQLDataType.INTEGER)
.column("B", SQLDataType.INTEGER)
.execute();
context.createTable("tableB")
.column("C", SQLDataType.INTEGER)
.column("D", SQLDataType.INTEGER)
.column("E", SQLDataType.INTEGER)
.execute();
Helper.loadCsv(context, "tableA.csv", "tableA");
Helper.loadCsv(context, "tableB.csv", "tableB");
}
开发者ID:HPI-Information-Systems,项目名称:AdvancedDataProfilingSeminar,代码行数:19,代码来源:DatabaseValidationTest.java
示例3: basicSelectQuery
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
/**
* Build select query
*
* @return selected records
*/
private SelectSelectStep<Record16<Long, Integer, Integer, String, String, String, String, Integer, Integer, String, String, String, Byte, Timestamp, Timestamp, Long>> basicSelectQuery() {
return create.select(
TRANSFER_TIMING_FILE_TRANSITION_HISTORY_ID,
FILE.ID.as("fileId"),
ATABLE.ID.as("atableId"),
ATABLE.NAME.as("atableName"),
USER.USERNAME,
FILE.CODE,
FILE_TYPE.NAME.as("fileTypeName"),
TRANSFER_TIMING_VISUAL_COUNT,
TRANSFER_TIMING_SOMETHING_COUNT,
field(name("tableFromState", TRANSITION_STATE.NAME.getName()), SQLDataType.VARCHAR(50)).as("fromStatus"),
field(name("tableToState", TRANSITION_STATE.NAME.getName()), SQLDataType.VARCHAR(50)).as("toStatus"),
FILE_TRANSITION_HISTORY.LOCATION_IPV4,
TRANSFER_TIMING_TRANSFER_STATUS,
TRANSFER_TIMING_TRANSFER_STARTED_AT,
TRANSFER_TIMING_TRANSFER_ENDED_AT,
TRANSFER_TIMING_TRANSFER_TIME_SPENT_IN_SECONDS
);
}
开发者ID:Blackdread,项目名称:filter-sort-jooq-api,代码行数:26,代码来源:TransferTimingPageRepositoryImplPureJooq.java
示例4: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try(Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("oidc_providers"))
.column(field("oidc_provider_id", SQLDataType.BIGINT.identity(true)))
.column(field("name", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("api_key", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("api_secret", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("scope", SQLDataType.VARCHAR(100)))
.column(field("response_type", SQLDataType.VARCHAR(100)))
.column(field("authorization_endpoint", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("token_endpoint", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("token_endpoint_auth_method", SQLDataType.VARCHAR(10).nullable(false)))
.constraints(
constraint().primaryKey(field("oidc_provider_id"))
).getSQL();
stmt.execute(ddl);
}
}
示例5: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try (Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("assignments"))
.column(field("group_id", SQLDataType.BIGINT.nullable(false)))
.column(field("role_id", SQLDataType.BIGINT.nullable(false)))
.column(field("realm_id", SQLDataType.BIGINT.nullable(false)))
.constraints(
constraint().primaryKey(field("group_id"), field("role_id"), field("realm_id")),
constraint().foreignKey(field("group_id")).references(table("groups"), field("group_id")),
constraint().foreignKey(field("role_id")).references(table("roles"), field("role_id")),
constraint().foreignKey(field("realm_id")).references(table("realms"), field("realm_id"))
).getSQL();
stmt.execute(ddl);
}
}
示例6: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try (Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("realms"))
.column(field("realm_id", SQLDataType.BIGINT.identity(true)))
.column(field("name", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("url", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("application_id", SQLDataType.BIGINT.nullable(false)))
.column(field("description", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("write_protected", SQLDataType.BOOLEAN.nullable(false)))
.constraints(
constraint().primaryKey(field("realm_id")),
constraint().unique(field("name")),
constraint().foreignKey(field("application_id")).references(table("applications"), field("application_id"))
).getSQL();
stmt.execute(ddl);
}
}
示例7: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try(Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("oidc_users"))
.column(field("oidc_provider_id", SQLDataType.BIGINT.nullable(false)))
.column(field("user_id", SQLDataType.BIGINT.nullable(false)))
.column(field("oidc_sub", SQLDataType.VARCHAR(255).nullable(false)))
.constraints(
constraint().primaryKey(field("oidc_provider_id"), field("user_id")),
constraint().foreignKey(field("oidc_provider_id")).references(table("oidc_providers"), field("oidc_provider_id")),
constraint().foreignKey(field("user_id")).references(table("users"), field("user_id"))
).getSQL();
stmt.execute(ddl);
}
}
示例8: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try (Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("roles"))
.column(field("role_id", SQLDataType.BIGINT.identity(true)))
.column(field("name", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("description", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("write_protected", SQLDataType.BOOLEAN.nullable(false)))
.constraints(
constraint().primaryKey(field("role_id")),
constraint().unique(field("name"))
).getSQL();
stmt.execute(ddl);
}
}
示例9: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try(Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("user_sessions"))
.column(field("user_session_id", SQLDataType.BIGINT.identity(true)))
.column(field("user_id", SQLDataType.BIGINT.nullable(false)))
.column(field("token", SQLDataType.VARCHAR(36).nullable(false)))
.column(field("remote_address", SQLDataType.VARCHAR(255)))
.column(field("user_agent", SQLDataType.VARCHAR(255)))
.column(field("created_at", SQLDataType.TIMESTAMP.nullable(false)))
.constraints(
constraint().primaryKey(field("user_session_id")),
constraint().foreignKey(field("user_id")).references(table("users"), field("user_id"))
).getSQL();
stmt.execute(ddl);
}
}
示例10: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try (Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("permissions"))
.column(field("permission_id", SQLDataType.BIGINT.identity(true)))
.column(field("name", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("description", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("write_protected", SQLDataType.BOOLEAN.nullable(false)))
.constraints(
constraint().primaryKey(field("permission_id")),
constraint().unique(field("name"))
).getSQL();
stmt.execute(ddl);
}
}
示例11: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try(Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.alterTable(table("oidc_invitations"))
.renameColumn(field("oidc_sub")).to(field("oidc_payload", SQLDataType.CLOB))
.getSQL();
if (create.configuration().dialect() == SQLDialect.MYSQL) {
Matcher m = Pattern.compile("\\s+RENAME\\s+COLUMN\\s+(\\w+)\\s+TO\\s+", Pattern.CASE_INSENSITIVE).matcher(ddl);
StringBuffer sb = new StringBuffer();
if (m.find()) {
m.appendReplacement(sb, " change " + m.group(1) + " ");
m.appendTail(sb);
sb.append(" text not null");
ddl = sb.toString();
}
}
stmt.execute(ddl);
}
}
示例12: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection) throws Exception {
try (Statement stmt = connection.createStatement()) {
DSLContext create = DSL.using(connection);
String ddl = create.createTable(table("applications"))
.column(field("application_id", SQLDataType.BIGINT.identity(true)))
.column(field("name", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("virtual_path", SQLDataType.VARCHAR(50).nullable(false)))
.column(field("pass_to", SQLDataType.VARCHAR(255).nullable(false)))
.column(field("top_page", SQLDataType.VARCHAR(255).nullable(false)))
.column(field("description", SQLDataType.VARCHAR(100).nullable(false)))
.column(field("write_protected", SQLDataType.BOOLEAN.nullable(false)))
.constraints(
constraint().primaryKey(field("application_id")),
constraint().unique(field("virtual_path"))
).getSQL();
stmt.execute(ddl);
}
}
示例13: createDDL
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
private String createDDL(DefaultConfiguration config) {
DSLContext create = DSL.using(config);
String ddl = create.alterTable(table("oidc_invitations"))
.renameColumn(field("oidc_sub"))
.to(field("oidc_payload", SQLDataType.CLOB))
.getSQL();
if (create.configuration().dialect() == SQLDialect.MYSQL) {
Matcher m = Pattern.compile("\\s+RENAME\\s+COLUMN\\s+(\\w+)\\s+TO\\s+", Pattern.CASE_INSENSITIVE).matcher(ddl);
StringBuffer sb = new StringBuffer();
if (m.find()) {
m.appendReplacement(sb, " change " + m.group(1) + " ");
m.appendTail(sb);
sb.append(" text not null");
ddl = sb.toString();
}
}
return ddl;
}
示例14: migrate
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
@Override
public void migrate(Connection connection, DSLContext create) {
create.createSequence("S_AUTHOR_ID").execute();
String authorTableName = "AUTHOR";
create.createTable(authorTableName)
.column("ID", SQLDataType.INTEGER.nullable(false))
.column("FIRST_NAME", SQLDataType.VARCHAR.length(50))
.column("LAST_NAME", SQLDataType.VARCHAR.length(50).nullable(false))
.column("DATE_OF_BIRTH", SQLDataType.DATE)
.column("YEAR_OF_BIRTH", SQLDataType.INTEGER)
.column("ADDRESS", SQLDataType.VARCHAR.length(50))
.execute();
create.alterTable(authorTableName).add(constraint("PK_T_AUTHOR").primaryKey("ID")).execute();
String bookTableName = "BOOK";
create.createTable(bookTableName)
.column("ID", SQLDataType.INTEGER.nullable(false))
.column("AUTHOR_ID", SQLDataType.INTEGER.nullable(false))
.column("TITLE", SQLDataType.VARCHAR.length(400).nullable(false))
.execute();
create.alterTable(bookTableName).add(constraint("PK_T_BOOK").primaryKey("ID")).execute();
create.alterTable(bookTableName).add(
constraint("FK_T_BOOK_AUTHOR_ID").foreignKey("AUTHOR_ID").references(authorTableName, "ID"))
.execute();
}
开发者ID:cluelessjoe,项目名称:jooq-flyway-typesafe-migration,代码行数:30,代码来源:V1__createAuthorAndBookTables.java
示例15: addOCFColumns
import org.jooq.impl.SQLDataType; //导入依赖的package包/类
private void addOCFColumns(final DBConnection icdb, final Table<?> table) {
boolean converted = Arrays.stream(table.fields())
.anyMatch(field -> field.getName().endsWith(Format.IC_SUFFIX));
if (converted) {
logger.debug("Table already converted. Skipping {}", table.getName());
return;
}
// Loop through each field and create a corresponding column
Arrays.stream(table.fields()).forEach(field -> {
// Create a svc column
icdb.getCreate().alterTable(table).add(field.getName() + Format.IC_SUFFIX, MySQLDataType.TINYBLOB)
.execute();
// Create a serial column
icdb.getCreate().alterTable(table).add(field.getName() + Format.SERIAL_SUFFIX, SQLDataType.BIGINT)
.execute();
});
}