Package org.jooq.util

Examples of org.jooq.util.SchemaDefinition

97
98
99
100
101
102
103
104
105
106
107
     * {@inheritDoc}
     */
    @Override
    protected void loadUniqueKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys("U")) {
            SchemaDefinition schema = getSchema(record.getValue(ALL_CONS_COLUMNS.OWNER));
            String key = record.getValue(ALL_CONS_COLUMNS.CONSTRAINT_NAME);
            String tableName = record.getValue(ALL_CONS_COLUMNS.TABLE_NAME);
            String columnName = record.getValue(ALL_CONS_COLUMNS.COLUMN_NAME);

            TableDefinition table = getTable(schema, tableName);
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
166
                    ALL_CONS_COLUMNS.TABLE_NAME,
                    ALL_CONS_COLUMNS.CONSTRAINT_NAME,
                    ALL_CONS_COLUMNS.POSITION)
                .fetch()) {

            SchemaDefinition foreignKeySchema = getSchema(record.getValue(ALL_CONS_COLUMNS.OWNER));
            SchemaDefinition uniqueKeySchema = getSchema(record.getValue(ALL_CONSTRAINTS.R_OWNER));

            String foreignKeyName = record.getValue(ALL_CONS_COLUMNS.CONSTRAINT_NAME);
            String foreignKeyTableName = record.getValue(ALL_CONS_COLUMNS.TABLE_NAME);
            String foreignKeyColumnName = record.getValue(ALL_CONS_COLUMNS.COLUMN_NAME);
            String uniqueKeyName = record.getValue(ALL_CONSTRAINTS.R_CONSTRAINT_NAME);
View Full Code Here
180
181
182
183
184
185
186
187
188
189
        for (String name : create()
                .selectDistinct(ALL_USERS.USERNAME)
                .from(ALL_USERS)
                .fetch(ALL_USERS.USERNAME)) {

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

        return result;
    }
View Full Code Here
205
206
207
208
209
210
211
212
213
214
215
                    ALL_SEQUENCES.SEQUENCE_OWNER,
                    ALL_SEQUENCES.SEQUENCE_NAME)
                .fetch()) {


            SchemaDefinition schema = getSchema(record.getValue(ALL_SEQUENCES.SEQUENCE_OWNER));
            BigInteger value = record.getValue(ALL_SEQUENCES.MAX_VALUE, BigInteger.class, BigInteger.valueOf(Long.MAX_VALUE));
            DataTypeDefinition type = getDataTypeForMAX_VAL(schema, value);

            result.add(new DefaultSequenceDefinition(
                schema,
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
            .orderBy(
                ALL_TAB_COMMENTS.OWNER,
                ALL_TAB_COMMENTS.TABLE_NAME)
            .fetch()) {

            SchemaDefinition schema = getSchema(record.getValue(ALL_TAB_COMMENTS.OWNER));
            String name = record.getValue(ALL_TAB_COMMENTS.TABLE_NAME);
            String comment = record.getValue(ALL_TAB_COMMENTS.COMMENTS);

            OracleTableDefinition table = new OracleTableDefinition(schema, name, comment);
            result.add(table);
View Full Code Here
275
276
277
278
279
280
281
282
283
284
285
            .orderBy(
                ALL_TYPES.OWNER,
                ALL_TYPES.TYPE_NAME)
            .fetch()) {

            SchemaDefinition schema = getSchema(record.getValue(ALL_TYPES.OWNER));
            String name = record.getValue(ALL_TYPES.TYPE_NAME);

            result.add(new OracleUDTDefinition(schema, name, null));
        }
View Full Code Here
166
167
168
169
170
171
172
173
    }

    @Override
    protected List<SchemaDefinition> getSchemata0() throws SQLException {
        List<SchemaDefinition> result = new ArrayList<SchemaDefinition>();
        result.add(new SchemaDefinition(this, "", ""));
        return result;
    }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
    }

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

            TableDefinition table = getTable(schema, tableName);
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
    }

    @Override
    protected void loadUniqueKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys("UNIQUE")) {
            SchemaDefinition schema = getSchema(record.getValue(KEY_COLUMN_USAGE.TABLE_SCHEMA));
            String key = record.getValue(KEY_COLUMN_USAGE.CONSTRAINT_NAME);
            String tableName = record.getValue(KEY_COLUMN_USAGE.TABLE_NAME);
            String columnName = record.getValue(KEY_COLUMN_USAGE.COLUMN_NAME);

            TableDefinition table = getTable(schema, tableName);
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
163
                KEY_COLUMN_USAGE.CONSTRAINT_NAME.asc(),
                KEY_COLUMN_USAGE.ORDINAL_POSITION.asc())
            .fetch();

        for (Record record : result) {
            SchemaDefinition foreignKeySchema = getSchema(record.getValue(KEY_COLUMN_USAGE.TABLE_SCHEMA));
            SchemaDefinition uniqueKeySchema = getSchema(record.getValue(REFERENTIAL_CONSTRAINTS.UNIQUE_CONSTRAINT_SCHEMA));

            String foreignKey = record.getValue(KEY_COLUMN_USAGE.CONSTRAINT_NAME);
            String foreignKeyTable = record.getValue(KEY_COLUMN_USAGE.TABLE_NAME);
            String foreignKeyColumn = record.getValue(KEY_COLUMN_USAGE.COLUMN_NAME);
            String uniqueKey = record.getValue(REFERENTIAL_CONSTRAINTS.UNIQUE_CONSTRAINT_NAME);
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.