Package org.jooq.util

Examples of org.jooq.util.SchemaDefinition

271
272
273
274
275
276
277
278
279
280
281
                Columns.TABLE_NAME.asc(),
                Columns.COLUMN_NAME.asc())
            .fetch();

        for (Record record : records) {
            SchemaDefinition schema = getSchema(record.getValue(Columns.TABLE_SCHEMA));

            String comment = record.getValue(Columns.COLUMN_COMMENT);
            String table = record.getValue(Columns.TABLE_NAME);
            String column = record.getValue(Columns.COLUMN_NAME);
            String name = table + "_" + column;
View Full Code Here
362
363
364
365
366
367
368
369
370
371
372
            Result<?> overloads = entry.getValue();

            for (int i = 0; i < overloads.size(); i++) {
                Record record = overloads.get(i);

                SchemaDefinition schema = getSchema(record.getValue(DB));
                String name = record.getValue(Proc.NAME);
                String comment = record.getValue(Proc.COMMENT);
                String params = new String(record.getValue(Proc.PARAM_LIST));
                String returns = new String(record.getValue(Proc.RETURNS));
                ProcType type = record.getValue(Proc.TYPE);
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
public class CUBRIDDatabase extends AbstractDatabase {

    @Override
    protected void loadPrimaryKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys(DB_INDEX.IS_UNIQUE.isTrue().and(DB_INDEX.IS_PRIMARY_KEY.isFalse()))) {
            SchemaDefinition schema = getSchema(record.getValue(DB_CLASS.OWNER_NAME));
            String key = record.getValue("constraint_name", String.class);
            String tableName = record.getValue(DB_CLASS.CLASS_NAME);
            String columnName = record.getValue(DB_INDEX_KEY.KEY_ATTR_NAME);

            TableDefinition table = getTable(schema, tableName);
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    }

    @Override
    protected void loadUniqueKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys(DB_INDEX.IS_PRIMARY_KEY.isTrue())) {
            SchemaDefinition schema = getSchema(record.getValue(DB_CLASS.OWNER_NAME));
            String key = record.getValue("constraint_name", String.class);
            String tableName = record.getValue(DB_CLASS.CLASS_NAME);
            String columnName = record.getValue(DB_INDEX_KEY.KEY_ATTR_NAME);

            TableDefinition table = getTable(schema, tableName);
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
                .from(DB_INDEX)
                .where(DB_INDEX.IS_FOREIGN_KEY.isTrue())
                .fetch(DB_INDEX.CLASS_NAME)) {

            for (Record record : create().fetch(meta.getImportedKeys(null, null, table))) {
                SchemaDefinition foreignKeySchema = getSchema(getInputSchemata().get(0));
                SchemaDefinition uniqueKeySchema = getSchema(getInputSchemata().get(0));

                String foreignKeyName =
                    record.getValue("FKTABLE_NAME", String.class) +
                    "__" +
                    record.getValue("FK_NAME", String.class);
View Full Code Here
165
166
167
168
169
170
171
172
173
174
        for (String name : create()
                .select(DB_USER.NAME)
                .from(DB_USER)
                .fetch(DB_USER.NAME)) {

            result.add(new SchemaDefinition(this, name, ""));
        }

        return result;
    }
View Full Code Here
184
185
186
187
188
189
190
191
192
193
194
                    field("owner.name", String.class).as("owner"))
                .from(DB_SERIAL)
                .where(field("owner.name", String.class).in(getInputSchemata()))
                .fetch()) {

            SchemaDefinition schema = getSchema(record.getValue("owner", String.class));
            BigInteger value = record.getValue(DB_SERIAL.MAX_VAL, BigInteger.class, BigInteger.valueOf(Long.MAX_VALUE));
            DataTypeDefinition type = getDataTypeForMAX_VAL(schema, value);

            result.add(new DefaultSequenceDefinition(
                schema,
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
                .orderBy(
                    DB_CLASS.OWNER_NAME.asc(),
                    DB_CLASS.CLASS_NAME.asc())
                .fetch()) {

            SchemaDefinition schema = getSchema(record.getValue(DB_CLASS.OWNER_NAME));
            String name = record.getValue(DB_CLASS.CLASS_NAME);

            CUBRIDTableDefinition table = new CUBRIDTableDefinition(schema, name, null);
            result.add(table);
        }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    }

    @Override
    protected void loadPrimaryKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys("PRIMARY KEY")) {
            SchemaDefinition schema = getSchema(record.getValue(Constraints.TABLE_SCHEMA));
            String tableName = record.getValue(Constraints.TABLE_NAME);
            String columnList = record.getValue(Constraints.COLUMN_LIST);
            String primaryKey = record.getValue(Constraints.CONSTRAINT_NAME);

            TableDefinition table = getTable(schema, tableName);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
    }

    @Override
    protected void loadUniqueKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys("UNIQUE")) {
            SchemaDefinition schema = getSchema(record.getValue(Constraints.TABLE_SCHEMA));
            String tableName = record.getValue(Constraints.TABLE_NAME);
            String columnList = record.getValue(Constraints.COLUMN_LIST);
            String primaryKey = record.getValue(Constraints.CONSTRAINT_NAME);

            TableDefinition table = getTable(schema, tableName);
View Full Code Here
TOP

Related Classes of org.jooq.util.SchemaDefinition

  • org.jooq.util.ase.ASEDatabase
  • org.jooq.util.cubrid.CUBRIDDatabase
  • org.jooq.util.db2.DB2Database
  • org.jooq.util.derby.DerbyDatabase
  • org.jooq.util.firebird.FirebirdDatabase
  • org.jooq.util.h2.H2Database
  • org.jooq.util.hsqldb.HSQLDBDatabase
  • org.jooq.util.ingres.IngresDatabase
  • org.jooq.util.jdbc.JDBCDatabase
  • org.jooq.util.mysql.MySQLDatabase
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.