Examples of org.hsqldb.ColumnSchema

org.hsqldb.ColumnSchema
Implementation of SQL table column metadata.
@author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.9.0

            }


            columnCount = table.getColumnCount();


            for (int i = 0; i < columnCount; i++) {
                ColumnSchema column = table.getColumn(i);


                type = column.getDataType();


                if (!columnList.contains(column.getName())) {
                    continue;
                }


                row                   = t.getEmptyRowData();
                row[table_cat]        = database.getCatalogName().name;
                row[table_schem]      = table.getSchemaName().name;
                row[table_name]       = table.getName().name;
                row[column_name]      = column.getName().name;
                row[ordinal_position] = ValuePool.getLong(i + 1);
                row[column_default]   = column.getDefaultSQL();
                row[is_nullable]      = column.isNullable() ? "YES"
                                                            : "NO";
                row[data_type]        = type.getFullNameString();


                // common type block
                if (type.isCharacterType()) {
                    row[character_maximum_length] =
                        ValuePool.getLong(type.precision);
                    row[character_octet_length] =
                        ValuePool.getLong(type.precision * 2);
                    row[character_set_catalog] =
                        database.getCatalogName().name;
                    row[character_set_schema] =
                        ((CharacterType) type).getCharacterSet()
                            .getSchemaName().name;
                    row[character_set_name] =
                        ((CharacterType) type).getCharacterSet().getName()
                            .name;
                    row[collation_catalog] = database.getCatalogName().name;
                    row[collation_schema] =
                        ((CharacterType) type).getCollation().getSchemaName()
                            .name;
                    row[collation_name] =
                        ((CharacterType) type).getCollation().getName().name;
                } else if (type.isNumberType()) {
                    row[numeric_precision] = ValuePool.getLong(
                        ((NumberType) type).getNumericPrecisionInRadix());
                    row[declared_numeric_precision] = ValuePool.getLong(
                        ((NumberType) type).getNumericPrecisionInRadix());


                    if (type.isExactNumberType()) {
                        row[numeric_scale] = row[declared_numeric_scale] =
                            ValuePool.getLong(type.scale);
                    }


                    row[numeric_precision_radix] =
                        ValuePool.getLong(type.getPrecisionRadix());
                } else if (type.isBooleanType()) {


                    //
                } else if (type.isDateTimeType()) {
                    row[datetime_precision] = ValuePool.getLong(type.scale);
                } else if (type.isIntervalType()) {
                    row[data_type] = "INTERVAL";
                    row[interval_type] =
                        ((IntervalType) type).getQualifier(type.typeCode);
                    row[interval_precision] =
                        ValuePool.getLong(type.precision);
                    row[datetime_precision] = ValuePool.getLong(type.scale);
                } else if (type.isBinaryType()) {
                    row[character_maximum_length] =
                        ValuePool.getLong(type.precision);
                    row[character_octet_length] =
                        ValuePool.getLong(type.precision);
                } else if (type.isBitType()) {
                    row[character_maximum_length] =
                        ValuePool.getLong(type.precision);
                    row[character_octet_length] =
                        ValuePool.getLong(type.precision);
                } else if (type.isArrayType()) {
                    row[maximum_cardinality] =
                        ValuePool.getLong(type.arrayLimitCardinality());
                    row[data_type] = "ARRAY";
                }


                if (type.isDomainType()) {
                    row[domain_catalog] = database.getCatalogName().name;
                    row[domain_schema]  = type.getSchemaName().name;
                    row[domain_name]    = type.getName().name;
                }


                if (type.isDistinctType()) {
                    row[udt_catalog] = database.getCatalogName().name;
                    row[udt_schema]  = type.getSchemaName().name;
                    row[udt_name]    = type.getName().name;
                }


                row[scope_catalog]       = null;
                row[scope_schema]        = null;
                row[scope_name]          = null;
                row[dtd_identifier]      = type.getDefinition();
                row[is_self_referencing] = null;
                row[is_identity]         = column.isIdentity() ? "YES"
                                                               : "NO";


                if (column.isIdentity()) {
                    NumberSequence sequence = column.getIdentitySequence();


                    row[identity_generation] = sequence.isAlways() ? "ALWAYS"
                                                                   : "BY DEFAULT";
                    row[identity_start] =
                        Long.toString(sequence.getStartValue());
                    row[identity_increment] =
                        Long.toString(sequence.getIncrement());
                    row[identity_maximum] =
                        Long.toString(sequence.getMaxValue());
                    row[identity_minimum] =
                        Long.toString(sequence.getMinValue());
                    row[identity_cycle] = sequence.isCycle() ? "YES"
                                                             : "NO";
                }


                row[is_generated] = "NEVER";


                if (column.isGenerated()) {
                    row[is_generated] = "ALWAYS";
                    row[generation_expression] =
                        column.getGeneratingExpression().getSQL();
                }


                row[is_updatable]       = table.isWritable() ? "YES"
                                                             : "NO";
                row[declared_data_type] = row[data_type];

View Full Code Here

            }


            columnCount = table.getColumnCount();


            for (int i = 0; i < columnCount; i++) {
                ColumnSchema column = table.getColumn(i);


                if (!columnList.contains(column.getName())) {
                    continue;
                }


                type = column.getDataType();


                if (type.isDistinctType() || type.isDomainType()
                        || !type.isArrayType()) {
                    continue;
                }


                row                             = t.getEmptyRowData();
                row[object_catalog] = database.getCatalogName().name;
                row[object_schema]              = table.getSchemaName().name;
                row[object_name]                = table.getName().name;
                row[object_type]                = "TABLE";
                row[collection_type_identifier] = type.getDefinition();


                addTypeInfo(row, ((ArrayType) type).collectionBaseType());


                try {
                    t.insertSys(session, store, row);
                } catch (HsqlException e) {}
            }
        }


        Iterator it =
            database.schemaManager.databaseObjectIterator(SchemaObject.DOMAIN);


        while (it.hasNext()) {
            type = (Type) it.next();


            if (!type.isDomainType() || !type.isArrayType()) {
                continue;
            }


            if (!session.getGrantee().isAccessible(type)) {
                continue;
            }


            row                             = t.getEmptyRowData();
            row[object_catalog]             = database.getCatalogName().name;
            row[object_schema]              = type.getSchemaName().name;
            row[object_name]                = type.getName().name;
            row[object_type]                = "DOMAIN";
            row[collection_type_identifier] = type.getDefinition();


            addTypeInfo(row, ((ArrayType) type).collectionBaseType());
            t.insertSys(session, store, row);
        }


        it = database.schemaManager.databaseObjectIterator(SchemaObject.TYPE);


        while (it.hasNext()) {
            type = (Type) it.next();


            if (!type.isDistinctType() || !type.isArrayType()) {
                continue;
            }


            if (!session.getGrantee().isAccessible(type)) {
                continue;
            }


            row                             = t.getEmptyRowData();
            row[object_catalog]             = database.getCatalogName().name;
            row[object_schema]              = type.getSchemaName().name;
            row[object_name]                = type.getName().name;
            row[object_type]                = "USER-DEFINED TYPE";
            row[collection_type_identifier] = type.getDefinition();


            addTypeInfo(row, ((ArrayType) type).collectionBaseType());


            try {
                t.insertSys(session, store, row);
            } catch (HsqlException e) {}
        }


        it = database.schemaManager.databaseObjectIterator(
            SchemaObject.SPECIFIC_ROUTINE);


        while (it.hasNext()) {
            Routine routine = (Routine) it.next();


            if (!session.getGrantee().isAccessible(routine)) {
                continue;
            }


            type = routine.isProcedure() ? null
                                         : routine.getReturnType();


            if (type == null || type.isDistinctType() || type.isDomainType()
                    || !type.isArrayType()) {


                //
            } else {
                row                             = t.getEmptyRowData();
                row[object_catalog] = database.getCatalogName().name;
                row[object_schema]              = routine.getSchemaName().name;
                row[object_name]                = routine.getName().name;
                row[object_type]                = "ROUTINE";
                row[collection_type_identifier] = type.getDefinition();


                addTypeInfo(row, ((ArrayType) type).collectionBaseType());


                try {
                    t.insertSys(session, store, row);
                } catch (HsqlException e) {}
            }


            Type returnType = type;
            int  paramCount = routine.getParameterCount();


            for (int i = 0; i < paramCount; i++) {
                ColumnSchema param = routine.getParameter(i);


                type = param.getDataType();


                if (type.isDistinctType() || type.isDomainType()
                        || !type.isArrayType()) {
                    continue;
                }

View Full Code Here

            for (int i = 0; i < specifics.length; i++) {
                routine     = specifics[i];
                columnCount = routine.getParameterCount();


                for (int j = 0; j < columnCount; j++) {
                    ColumnSchema column = routine.getParameter(j);


                    type                  = column.getDataType();
                    row                   = t.getEmptyRowData();
                    row[specific_cat]     = database.getCatalogName().name;
                    row[specific_schem]   = routine.getSchemaName().name;
                    row[specific_name]    = routine.getSpecificName().name;
                    row[parameter_name]   = column.getName().name;
                    row[ordinal_position] = ValuePool.getLong(j + 1);


                    switch (column.getParameterMode()) {


                        case SchemaObject.ParameterModes.PARAM_IN :
                            row[parameter_mode] = "IN";
                            break;

View Full Code Here

            if (colIndexes == null) {
                continue;
            }


            for (int i = 0; i < colIndexes.length; i++) {
                ColumnSchema column =
                    trigger.getTable().getColumn(colIndexes[i]);


                row                       = t.getEmptyRowData();
                row[trigger_catalog]      = database.getCatalogName().name;
                row[trigger_schema]       = trigger.getSchemaName().name;
                row[trigger_name]         = trigger.getName().name;
                row[event_object_catalog] = database.getCatalogName().name;
                row[event_object_schema] =
                    trigger.getTable().getSchemaName().name;
                row[event_object_table]  = trigger.getTable().getName().name;
                row[event_object_column] = column.getNameString();


                t.insertSys(session, store, row);
            }
        }

View Full Code Here

                             : i;
            Object o = data[j];
            Type   t = types[j];


            if (cols != null) {
                ColumnSchema col = (ColumnSchema) cols.get(j);


                writeFieldPrefix();
                writeString(col.getName().statementName);
            }


            writeData(t, o);
        }
    }

View Full Code Here

        Type   oldtype  = null;
        Type   newtype  = null;
        Object colvalue = null;


        if (adjust >= 0 && colindex != -1) {
            ColumnSchema column = ((Table) table).getColumn(colindex);


            colvalue = column.getDefaultValue(session);
            newtype  = ((Table) table).getColumnTypes()[colindex];
        }


        if (adjust <= 0 && colindex != -1) {
            oldtype = ((Table) other.getTable()).getColumnTypes()[colindex];

View Full Code Here

            }


            columnCount = table.getColumnCount();


            for (int i = 0; i < columnCount; i++) {
                ColumnSchema column = table.getColumn(i);


                if (!column.isIdentity()) {
                    continue;
                }


                sequence = column.getIdentitySequence();


                if (sequence.getName() == null) {
                    continue;
                }


                if (!columnList.contains(column.getName())) {
                    continue;
                }


                row                   = t.getEmptyRowData();
                row[table_cat]        = database.getCatalogName().name;
                row[table_schem]      = table.getSchemaName().name;
                row[table_name]       = table.getName().name;
                row[column_name]      = column.getName().name;
                row[sequence_catalog] = database.getCatalogName().name;
                row[sequence_schema]  = sequence.getSchemaName().name;
                row[sequence_name]    = sequence.getName().name;


                t.insertSys(session, store, row);

View Full Code Here

            ti.setTable(table);


            int colCount = table.getColumnCount();


            for (int i = 0; i < colCount; i++) {
                ColumnSchema column = table.getColumn(i);


                if (column.getName().comment == null) {
                    continue;
                }


                row              = t.getEmptyRowData();
                row[catalog]     = database.getCatalogName().name;
                row[schema]      = table.getSchemaName().name;
                row[name]        = table.getName().name;
                row[type]        = "COLUMN";
                row[column_name] = column.getName().name;
                row[remark]      = column.getName().comment;


                t.insertSys(session, store, row);
            }


            if (table.getTableType() != Table.INFO_SCHEMA_TABLE

View Full Code Here

    }


    protected final void addColumn(Table t, String name, Type type) {


        HsqlName     cn;
        ColumnSchema c;


        cn = database.nameManager.newInfoSchemaColumnName(name, t.getName());
        c  = new ColumnSchema(cn, type, true, false, null);


        t.addColumn(c);
    }

View Full Code Here


            scope  = ti.getBRIScope();
            pseudo = ti.getBRIPseudo();


            for (int i = 0; i < cols.length; i++) {
                ColumnSchema column = table.getColumn(i);
                Type         type   = types[i];


                if (translateTTI) {
                    if (type.isIntervalType()) {
                        type = ((IntervalType) type).getCharacterType();
                    } else if (type.isDateTimeTypeWithZone()) {
                        type = ((DateTimeType) type)
                            .getDateTimeTypeWithoutZone();
                    }
                }


                row                 = t.getEmptyRowData();
                row[iscope]         = scope;
                row[icolumn_name]   = column.getName().name;
                row[idata_type]     = ValuePool.getInt(type.getJDBCTypeCode());
                row[itype_name]     = type.getNameString();
                row[icolumn_size] = ValuePool.getInt(type.getJDBCPrecision());
                row[ibuffer_length] = null;
                row[idecimal_digits] = type.acceptsScale()
                                       ? ValuePool.getInt(type.getJDBCScale())
                                       : null;
                row[ipseudo_column] = pseudo;
                row[itable_cat]     = tableCatalog;
                row[itable_schem]   = tableSchema;
                row[itable_name]    = tableName;
                row[inullable] = ValuePool.getInt(column.getNullability());
                row[iinKey]         = inKey;


                t.insertSys(session, store, row);
            }
        }

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.hsqldb.ColumnSchema

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.dbinfo.DITableInfo

org.hsqldb.HsqlNameManager.HsqlName

org.hsqldb.lib.Iterator

org.hsqldb.lib.OrderedHashSet

org.hsqldb.persist.RowStoreAVL

org.hsqldb.persist.ScriptRunner

org.hsqldb.RangeGroup.RangeGroupSimple

org.hsqldb.rowio.RowOutputBase

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.