Examples of org.hsqldb.NumberSequence

org.hsqldb.NumberSequence
Maintains a sequence of numbers. @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.7.2

        final int next_value                 = 15;


        //
        Iterator       it;
        Object[]       row;
        NumberSequence sequence;


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


        while (it.hasNext()) {
            sequence = (NumberSequence) it.next();


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


            row = t.getEmptyRowData();


            NumberType type = (NumberType) sequence.getDataType();
            int radix =
                (type.typeCode == Types.SQL_NUMERIC || type.typeCode == Types
                    .SQL_DECIMAL) ? 10
                                  : 2;


            row[sequence_catalog] = database.getCatalogName().name;
            row[sequence_schema]  = sequence.getSchemaName().name;
            row[sequence_name]    = sequence.getName().name;
            row[data_type]        = sequence.getDataType().getFullNameString();
            row[numeric_precision] =
                ValuePool.getInt((int) type.getPrecision());
            row[numeric_precision_radix]    = ValuePool.getInt(radix);
            row[numeric_scale]              = ValuePool.INTEGER_0;
            row[maximum_value] = String.valueOf(sequence.getMaxValue());
            row[minimum_value] = String.valueOf(sequence.getMinValue());
            row[increment] = String.valueOf(sequence.getIncrement());
            row[cycle_option]               = sequence.isCycle() ? "YES"
                                                                 : "NO";
            row[declared_data_type]         = row[data_type];
            row[declared_numeric_precision] = row[numeric_precision];
            row[declared_numeric_scale]     = row[declared_numeric_scale];
            row[start_with] = String.valueOf(sequence.getStartValue());
            row[next_value]                 = String.valueOf(sequence.peek());


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


        return t;

View Full Code Here

        final int next_value                 = 15;


        //
        Iterator       it;
        Object[]       row;
        NumberSequence sequence;


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


        while (it.hasNext()) {
            sequence = (NumberSequence) it.next();


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


            row = t.getEmptyRowData();


            NumberType type = (NumberType) sequence.getDataType();
            int radix =
                (type.typeCode == Types.SQL_NUMERIC || type.typeCode == Types
                    .SQL_DECIMAL) ? 10
                                  : 2;


            row[sequence_catalog] = database.getCatalogName().name;
            row[sequence_schema]  = sequence.getSchemaName().name;
            row[sequence_name]    = sequence.getName().name;
            row[data_type]        = sequence.getDataType().getFullNameString();
            row[numeric_precision] =
                ValuePool.getInt((int) type.getPrecision());
            row[numeric_precision_radix]    = ValuePool.getInt(radix);
            row[numeric_scale]              = ValuePool.INTEGER_0;
            row[maximum_value] = String.valueOf(sequence.getMaxValue());
            row[minimum_value] = String.valueOf(sequence.getMinValue());
            row[increment] = String.valueOf(sequence.getIncrement());
            row[cycle_option]               = sequence.isCycle() ? "YES"
                                                                 : "NO";
            row[declared_data_type]         = row[data_type];
            row[declared_numeric_precision] = row[numeric_precision];
            row[declared_numeric_scale]     = row[declared_numeric_scale];
            row[start_with] = String.valueOf(sequence.getStartValue());
            row[next_value]                 = String.valueOf(sequence.peek());


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


        return t;

View Full Code Here

        int            columnCount;
        Iterator       tables;
        Table          table;
        Object[]       row;
        OrderedHashSet columnList;
        NumberSequence sequence;


        // Initialization
        tables = allTables();


        while (tables.hasNext()) {
            table = (Table) tables.next();


            if (!table.hasIdentityColumn()) {
                continue;
            }


            columnList =
                session.getGrantee().getColumnsForAllPrivileges(table);


            if (columnList.isEmpty()) {
                continue;
            }


            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

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

View Full Code Here

                                hsqlname.getSchemaQualifiedStatementName());
                        }
                        break;


                    case SchemaObject.SEQUENCE :
                        NumberSequence sequence =
                            (NumberSequence) granteeManager.database
                                .schemaManager
                                .findSchemaObject(hsqlname.name,
                                                  hsqlname.schema.name,
                                                  SchemaObject.SEQUENCE);

View Full Code Here

        final int next_value                 = 15;


        //
        Iterator       it;
        Object[]       row;
        NumberSequence sequence;


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


        while (it.hasNext()) {
            sequence = (NumberSequence) it.next();


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


            row = t.getEmptyRowData();


            NumberType type = (NumberType) sequence.getDataType();
            int radix =
                (type.typeCode == Types.SQL_NUMERIC || type.typeCode == Types
                    .SQL_DECIMAL) ? 10
                                  : 2;


            row[sequence_catalog] = database.getCatalogName().name;
            row[sequence_schema]  = sequence.getSchemaName().name;
            row[sequence_name]    = sequence.getName().name;
            row[data_type]        = sequence.getDataType().getFullNameString();
            row[numeric_precision] =
                ValuePool.getInt((int) type.getPrecision());
            row[numeric_precision_radix]    = ValuePool.getInt(radix);
            row[numeric_scale]              = ValuePool.INTEGER_0;
            row[maximum_value] = String.valueOf(sequence.getMaxValue());
            row[minimum_value] = String.valueOf(sequence.getMinValue());
            row[increment] = String.valueOf(sequence.getIncrement());
            row[cycle_option]               = sequence.isCycle() ? "YES"
                                                                 : "NO";
            row[declared_data_type]         = row[data_type];
            row[declared_numeric_precision] = row[numeric_precision];
            row[declared_numeric_scale]     = row[declared_numeric_scale];
            row[start_with] = String.valueOf(sequence.getStartValue());
            row[next_value]                 = String.valueOf(sequence.peek());


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


        return t;

View Full Code Here

        final int next_value                 = 15;


        //
        Iterator       it;
        Object[]       row;
        NumberSequence sequence;


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


        while (it.hasNext()) {
            sequence = (NumberSequence) it.next();


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


            row = t.getEmptyRowData();


            NumberType type = (NumberType) sequence.getDataType();
            int radix =
                (type.typeCode == Types.SQL_NUMERIC || type.typeCode == Types
                    .SQL_DECIMAL) ? 10
                                  : 2;


            row[sequence_catalog] = database.getCatalogName().name;
            row[sequence_schema]  = sequence.getSchemaName().name;
            row[sequence_name]    = sequence.getName().name;
            row[data_type]        = sequence.getDataType().getFullNameString();
            row[numeric_precision] =
                ValuePool.getInt((int) type.getPrecision());
            row[numeric_precision_radix]    = ValuePool.getInt(radix);
            row[numeric_scale]              = ValuePool.INTEGER_0;
            row[maximum_value] = String.valueOf(sequence.getMaxValue());
            row[minimum_value] = String.valueOf(sequence.getMinValue());
            row[increment] = String.valueOf(sequence.getIncrement());
            row[cycle_option]               = sequence.isCycle() ? "YES"
                                                                 : "NO";
            row[declared_data_type]         = row[data_type];
            row[declared_numeric_precision] = row[numeric_precision];
            row[declared_numeric_scale]     = row[declared_numeric_scale];
            row[start_with] = String.valueOf(sequence.getStartValue());
            row[next_value]                 = String.valueOf(sequence.peek());


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


        return t;

View Full Code Here

        int            columnCount;
        Iterator       tables;
        Table          table;
        Object[]       row;
        OrderedHashSet columnList;
        NumberSequence sequence;


        // Initialization
        tables = allTables();


        while (tables.hasNext()) {
            table = (Table) tables.next();


            if (!table.hasIdentityColumn()) {
                continue;
            }


            columnList =
                session.getGrantee().getColumnsForAllPrivileges(table);


            if (columnList.isEmpty()) {
                continue;
            }


            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

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

View Full Code Here

        final int next_value                 = 15;


        //
        Iterator       it;
        Object[]       row;
        NumberSequence sequence;


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


        while (it.hasNext()) {
            sequence = (NumberSequence) it.next();


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


            row = t.getEmptyRowData();


            NumberType type = (NumberType) sequence.getDataType();
            int radix =
                (type.typeCode == Types.SQL_NUMERIC || type.typeCode == Types
                    .SQL_DECIMAL) ? 10
                                  : 2;


            row[sequence_catalog] = database.getCatalogName().name;
            row[sequence_schema]  = sequence.getSchemaName().name;
            row[sequence_name]    = sequence.getName().name;
            row[data_type]        = sequence.getDataType().getFullNameString();
            row[numeric_precision] =
                ValuePool.getInt((int) type.getPrecision());
            row[numeric_precision_radix]    = ValuePool.getInt(radix);
            row[numeric_scale]              = ValuePool.INTEGER_0;
            row[maximum_value] = String.valueOf(sequence.getMaxValue());
            row[minimum_value] = String.valueOf(sequence.getMinValue());
            row[increment] = String.valueOf(sequence.getIncrement());
            row[cycle_option]               = sequence.isCycle() ? "YES"
                                                                 : "NO";
            row[declared_data_type]         = row[data_type];
            row[declared_numeric_precision] = row[numeric_precision];
            row[declared_numeric_scale]     = row[declared_numeric_scale];
            row[start_with] = String.valueOf(sequence.getStartValue());
            row[next_value]                 = String.valueOf(sequence.peek());


            t.insertSys(store, row);
        }


        return t;

View Full Code Here

0 1 2

TOP

Related Classes of org.hsqldb.NumberSequence

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.lib.OrderedHashSet

org.hsqldb.rights.Grantee

java.math.BigDecimal

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.