Examples of SchemaDefinition


Examples of org.jooq.util.SchemaDefinition

        for (Column column : info.getColumns()) {
            if (StringUtils.equals(table.getTableCatalog(), column.getTableCatalog()) &&
                StringUtils.equals(table.getTableSchema(), column.getTableSchema()) &&
                StringUtils.equals(table.getTableName(), column.getTableName())) {

                SchemaDefinition schema = getDatabase().getSchema(column.getTableSchema());

                DataTypeDefinition type = new DefaultDataTypeDefinition(
                    getDatabase(),
                    schema,
                    column.getDataType(),
View Full Code Here

Examples of org.jooq.util.SchemaDefinition

public class DerbyDatabase extends AbstractDatabase {

  @Override
  protected void loadPrimaryKeys(DefaultRelations relations) throws SQLException {
      for (Record record : fetchKeys("P")) {
          SchemaDefinition schema = getSchema(record.getValue(Sysschemas.SCHEMANAME));
          String key = record.getValue(Sysconstraints.CONSTRAINTNAME);
            String tableName = record.getValue(Systables.TABLENAME);
            String descriptor = record.getValue(Sysconglomerates.DESCRIPTOR, String.class);

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

Examples of org.jooq.util.SchemaDefinition

     * {@inheritDoc}
     */
    @Override
    protected void loadUniqueKeys(DefaultRelations relations) throws SQLException {
        for (Record record : fetchKeys("U")) {
            SchemaDefinition schema = getSchema(record.getValue(Sysschemas.SCHEMANAME));
            String key = record.getValue(Sysconstraints.CONSTRAINTNAME);
            String tableName = record.getValue(Systables.TABLENAME);
            String descriptor = record.getValue(Sysconglomerates.DESCRIPTOR, String.class);

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

Examples of org.jooq.util.SchemaDefinition

          .join("sys.sysconstraints   pc").on("pc.constraintid = f.keyconstraintid")
          .join("sys.sysschemas       ps").on("pc.schemaid = ps.schemaid")
          .where("fc.type = 'F'")
          .fetch()) {

          SchemaDefinition foreignKeySchema = getSchema(record.getValue(fkSchema));
          SchemaDefinition uniqueKeySchema = getSchema(record.getValue(ukSchema));

          String foreignKeyName = record.getValue(fkName);
            String foreignKeyTableName = record.getValue(fkTable);
            List<Integer> foreignKeyIndexes = decode(record.getValue(fkDescriptor, String.class));
            String uniqueKeyName = record.getValue(ukName);
View Full Code Here

Examples of org.jooq.util.SchemaDefinition

        for (String name : create()
                .select(Sysschemas.SCHEMANAME)
                .from(SYSSCHEMAS)
                .fetch(Sysschemas.SCHEMANAME)) {

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

        return result;
    }
View Full Code Here

Examples of org.jooq.util.SchemaDefinition

                .orderBy(
                    Sysschemas.SCHEMANAME,
                    Syssequences.SEQUENCENAME)
                .fetch()) {

            SchemaDefinition schema = getSchema(record.getValue(Sysschemas.SCHEMANAME));

            DataTypeDefinition type = new DefaultDataTypeDefinition(
                this,
                schema,
                record.getValue(Syssequences.SEQUENCEDATATYPE)
View Full Code Here

Examples of org.jooq.util.SchemaDefinition

                .orderBy(
                    Sysschemas.SCHEMANAME,
                    Systables.TABLENAME)
              .fetch()) {

        SchemaDefinition schema = getSchema(record.getValue(Sysschemas.SCHEMANAME));
        String name = record.getValue(Systables.TABLENAME);
        String id = record.getValue(Systables.TABLEID);

        DerbyTableDefinition table = new DerbyTableDefinition(schema, name, id);
            result.add(table);
View Full Code Here

Examples of org.jooq.util.SchemaDefinition

    @Override
    protected void loadUniqueKeys(DefaultRelations relations) throws SQLException {
        for (UniqueKey<?> key : create().meta().getPrimaryKeys()) {
            Schema schema = key.getTable().getSchema();
            SchemaDefinition s = getSchema(schema == null ? "" : schema.getName());

            if (s != null) {
                TableDefinition t = getTable(s, key.getTable().getName());

                if (t != null) {
View Full Code Here

Examples of org.jooq.util.SchemaDefinition

    @Override
    protected List<SchemaDefinition> getSchemata0() throws SQLException {
        List<SchemaDefinition> result = new ArrayList<SchemaDefinition>();

        for (Schema schema : getSchemasFromMeta()) {
            result.add(new SchemaDefinition(this, schema.getName(), ""));
        }

        return result;
    }
View Full Code Here

Examples of org.jooq.util.SchemaDefinition

    protected List<SequenceDefinition> getSequences0() throws SQLException {
        List<SequenceDefinition> result = new ArrayList<SequenceDefinition>();

        for (Schema schema : getSchemasFromMeta()) {
            for (Sequence<?> sequence : schema.getSequences()) {
                SchemaDefinition sd = getSchema(schema.getName());

                DataTypeDefinition type = new DefaultDataTypeDefinition(
                    this,
                    sd,
                    sequence.getDataType().getTypeName()
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.