Examples of org.jooq.util.SchemaDefinition

org.jooq.util.SchemaDefinition
The definition of a database schema @author Lukas Eder

                .orderBy(
                    SEQUENCES.SEQUENCE_SCHEMA,
                    SEQUENCES.SEQUENCE_NAME)
                .fetch()) {


            SchemaDefinition schema = getSchema(record.getValue(SEQUENCES.SEQUENCE_SCHEMA));


            DataTypeDefinition type = new DefaultDataTypeDefinition(
                this, schema,
                record.getValue(SEQUENCES.DATA_TYPE),
                0,

View Full Code Here

                String nspname = type.getValue(PG_NAMESPACE.NSPNAME);
                String typname = type.getValue(PG_TYPE.TYPNAME);


                DefaultEnumDefinition definition = null;
                for (String label : enumLabels(nspname, typname)) {
                    SchemaDefinition schema = getSchema(nspname);
                    String typeName = String.valueOf(typname);


                    if (definition == null || !definition.getName().equals(typeName)) {
                        definition = new DefaultEnumDefinition(schema, typeName, null);
                        result.add(definition);

View Full Code Here

                    .orderBy(
                        ATTRIBUTES.UDT_SCHEMA,
                        ATTRIBUTES.UDT_NAME)
                    .fetch()) {


                SchemaDefinition schema = getSchema(record.getValue(ATTRIBUTES.UDT_SCHEMA));
                String name = record.getValue(ATTRIBUTES.UDT_NAME);


                result.add(new PostgresUDTDefinition(schema, name, null));
            }
        }

View Full Code Here

    }


    @Override
    protected List<SchemaDefinition> getSchemata0() throws SQLException {
        List<SchemaDefinition> result = new ArrayList<SchemaDefinition>();
        result.add(new SchemaDefinition(this, "", ""));
        return result;
    }

View Full Code Here

                .select(RDB$GENERATORS.RDB$GENERATOR_NAME.trim())
                .from(RDB$GENERATORS)
                .orderBy(1)
                .fetch(RDB$GENERATORS.RDB$GENERATOR_NAME.trim())) {


            SchemaDefinition schema = getSchemata().get(0);
            DataTypeDefinition type = new DefaultDataTypeDefinition(
                this, schema, FirebirdDataType.BIGINT.getTypeName()
            );


            result.add(new DefaultSequenceDefinition(schema, sequenceName, type ));

View Full Code Here

    private static final JooqLogger log = JooqLogger.getLogger(MySQLDatabase.class);


    @Override
    protected void loadPrimaryKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys(true)) {
            SchemaDefinition schema = getSchema(record.getValue(Statistics.TABLE_SCHEMA));
            String constraintName = record.getValue(Statistics.INDEX_NAME);
            String tableName = record.getValue(Statistics.TABLE_NAME);
            String columnName = record.getValue(Statistics.COLUMN_NAME);


            String key = getKeyName(tableName, constraintName);

View Full Code Here

    }


    @Override
    protected void loadUniqueKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys(false)) {
            SchemaDefinition schema = getSchema(record.getValue(Statistics.TABLE_SCHEMA));
            String constraintName = record.getValue(Statistics.INDEX_NAME);
            String tableName = record.getValue(Statistics.TABLE_NAME);
            String columnName = record.getValue(Statistics.COLUMN_NAME);


            String key = getKeyName(tableName, constraintName);

View Full Code Here

                    KeyColumnUsage.CONSTRAINT_SCHEMA.asc(),
                    KeyColumnUsage.CONSTRAINT_NAME.asc(),
                    KeyColumnUsage.ORDINAL_POSITION.asc())
                .fetch()) {


            SchemaDefinition foreignKeySchema = getSchema(record.getValue(ReferentialConstraints.CONSTRAINT_SCHEMA));
            SchemaDefinition uniqueKeySchema = getSchema(record.getValue(ReferentialConstraints.UNIQUE_CONSTRAINT_SCHEMA));


            String foreignKey = record.getValue(ReferentialConstraints.CONSTRAINT_NAME);
            String foreignKeyColumn = record.getValue(KeyColumnUsage.COLUMN_NAME);
            String foreignKeyTableName = record.getValue(ReferentialConstraints.TABLE_NAME);
            String referencedKey = record.getValue(ReferentialConstraints.UNIQUE_CONSTRAINT_NAME);

View Full Code Here

        for (String name : create()
                .select(Schemata.SCHEMA_NAME)
                .from(SCHEMATA)
                .fetch(Schemata.SCHEMA_NAME)) {


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


        return result;
    }

View Full Code Here

            .orderBy(
                Tables.TABLE_SCHEMA,
                Tables.TABLE_NAME)
            .fetch()) {


            SchemaDefinition schema = getSchema(record.getValue(Tables.TABLE_SCHEMA));
            String name = record.getValue(Tables.TABLE_NAME);
            String comment = record.getValue(Tables.TABLE_COMMENT);


            MySQLTableDefinition table = new MySQLTableDefinition(schema, name, comment);
            result.add(table);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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

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.