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);


                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

            }


            HsqlName name = table.getName();


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


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


                OrderedHashSet set = column.getGeneratedColumnReferences();


                if (set != null) {
                    for (int j = 0; j < set.size(); j++) {
                        row                   = t.getEmptyRowData();
                        row[table_catalog]    = database.getCatalogName().name;
                        row[table_schema]     = name.schema.name;
                        row[table_name]       = name.name;
                        row[column_name]      = ((HsqlName) set.get(j)).name;
                        row[dependent_column] = column.getName().name;


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

View Full Code Here

            table       = (Table) tables.next();
            columnCount = table.getColumnCount();
            tableName   = table.getName();


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


                type = column.getDataType();


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


                if (!grantee.isFullyAccessibleByRole(type.getName())) {
                    continue;
                }


                row                 = t.getEmptyRowData();
                row[domain_catalog] = database.getCatalogName().name;
                row[domain_schema]  = type.getSchemaName().name;
                row[domain_name]    = type.getName().name;
                row[table_catalog]  = database.getCatalogName().name;
                row[table_schema]   = tableName.schema.name;
                row[table_name]     = tableName.name;
                row[column_name]    = column.getNameString();


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

View Full Code Here

            table       = (Table) tables.next();
            columnCount = table.getColumnCount();
            tableName   = table.getName();


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


                type = column.getDataType();


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


                if (!grantee.isFullyAccessibleByRole(type.getName())) {
                    continue;
                }


                row                = t.getEmptyRowData();
                row[udt_catalog]   = database.getCatalogName().name;
                row[udt_schema]    = type.getSchemaName().name;
                row[udt_name]      = type.getName().name;
                row[table_catalog] = database.getCatalogName().name;
                row[table_schema]  = tableName.schema.name;
                row[table_name]    = tableName.name;
                row[column_name]   = column.getNameString();


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

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);


                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

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.