Package org.jooq.util

Examples of org.jooq.util.DataTypeDefinition

231
232
233
234
235
236
237
238
239
240
241
        for (String name : create().select(SYSSEQUENCE.SEQUENCE_NAME)
            .from(SYSSEQUENCE)
            .orderBy(SYSSEQUENCE.SEQUENCE_NAME)
            .fetch(SYSSEQUENCE.SEQUENCE_NAME)) {

            DataTypeDefinition type = new DefaultDataTypeDefinition(
                this, getSchema(),
                SybaseDataType.NUMERIC.getTypeName(), 0, 38, 0);

            result.add(new DefaultSequenceDefinition(getSchema(), name, type));
        }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
            }
            else {
                throw new IllegalArgumentException("Stored procedure param is neither in or out mode!");
            }

            DataTypeDefinition type = new DefaultDataTypeDefinition(
                getDatabase(),
                getSchema(),
                record.getValue(SYSDOMAIN.DOMAIN_NAME),
                record.getValue(SYSPROCPARM.WIDTH),
                record.getValue(SYSPROCPARM.WIDTH),
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
             .on(SYSTABCOL.DOMAIN_ID.equal(SYSDOMAIN.DOMAIN_ID))
             .where(SYSTAB.TABLE_NAME.equal(getName()))
             .orderBy(SYSTABCOL.COLUMN_ID)
             .fetch()) {

            DataTypeDefinition type = new DefaultDataTypeDefinition(
                getDatabase(),
                getSchema(),
                record.getValue(SYSDOMAIN.DOMAIN_NAME),
                record.getValue(SYSTABCOL.WIDTH),
                record.getValue(SYSTABCOL.WIDTH),
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
          .where(ALL_TAB_COLS.OWNER.equal(getSchema().getName()))
          .and(ALL_TAB_COLS.TABLE_NAME.equal(getName()))
          .orderBy(ALL_TAB_COLS.COLUMN_ID)
          .fetch()) {

            DataTypeDefinition type = new DefaultDataTypeDefinition(
                getDatabase(),
                getSchema(),
                record.getValue(ALL_TAB_COLS.DATA_TYPE),
                record.getValueAsInteger("data_length", 0),
                record.getValueAsInteger(ALL_TAB_COLS.DATA_PRECISION, 0),
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
            .from(ALL_TYPE_ATTRS)
            .where(ALL_TYPE_ATTRS.OWNER.equal(getSchema().getName()))
            .and(ALL_TYPE_ATTRS.TYPE_NAME.equal(getName()))
            .orderBy(ALL_TYPE_ATTRS.ATTR_NO).fetch()) {

            DataTypeDefinition type = new DefaultDataTypeDefinition(
                getDatabase(),
                getSchema(),
                record.getValue(ALL_TYPE_ATTRS.ATTR_TYPE_NAME),
                record.getValueAsInteger(ALL_TYPE_ATTRS.LENGTH, 0),
                record.getValueAsInteger(ALL_TYPE_ATTRS.PRECISION, 0),
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
      for (Record record : result) {
          InOutDefinition inOut =
                InOutDefinition.getFromString(record.getValue(ALL_ARGUMENTS.IN_OUT));

            DataTypeDefinition type = new DefaultDataTypeDefinition(
                getDatabase(),
                getSchema(),
                record.getValue(ALL_ARGUMENTS.DATA_TYPE),
                record.getValue(ALL_ARGUMENTS.DATA_LENGTH),
                record.getValue(ALL_ARGUMENTS.DATA_PRECISION),
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
                .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,
                record.getValue(ALL_SEQUENCES.SEQUENCE_NAME),
                type));
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
    public SQLServerRoutineDefinition(SchemaDefinition schema, String name, String specificName, String dataType, Number length, Number precision, Number scale) {
        super(schema, null, name, null, null);

        if (!StringUtils.isBlank(dataType)) {
            DataTypeDefinition type = new DefaultDataTypeDefinition(getDatabase(), schema, dataType, length, precision, scale);
            this.returnValue = new DefaultParameterDefinition(this, "RETURN_VALUE", -1, type);
        }

        this.specificName = specificName;
    }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
            .orderBy(PARAMETERS.ORDINAL_POSITION.asc()).fetch();

        for (Record record : result) {
            String inOut = record.getValue(PARAMETERS.PARAMETER_MODE);

            DataTypeDefinition type = new DefaultDataTypeDefinition(
                getDatabase(),
                getSchema(),
                record.getValue(PARAMETERS.DATA_TYPE),
                record.getValue(PARAMETERS.CHARACTER_MAXIMUM_LENGTH),
                record.getValue(PARAMETERS.NUMERIC_PRECISION),
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
                    SEQUENCES.SEQUENCE_NAME)
                .fetch()) {

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

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

            result.add(new DefaultSequenceDefinition(
View Full Code Here
TOP

Related Classes of org.jooq.util.DataTypeDefinition

  • org.jooq.util.ase.ASETableDefinition
  • org.jooq.util.cubrid.CUBRIDDatabase
  • org.jooq.util.cubrid.CUBRIDTableDefinition
  • org.jooq.util.db2.DB2Database
  • org.jooq.util.db2.DB2RoutineDefinition
  • org.jooq.util.db2.DB2TableDefinition
  • org.jooq.util.db2.DB2UDTDefinition
  • org.jooq.util.derby.DerbyDatabase
  • org.jooq.util.derby.DerbyTableDefinition
  • org.jooq.util.firebird.FirebirdDatabase
    • 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.