Examples of org.hsqldb.lib.Iterator

org.hsqldb.lib.Iterator
@author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.7.2

        // not in JDBC, but in SQL CLI SQLDA / ODBC
        //------------------------------------------
        final int       iinterval_precision = 18;
        PersistentStore store = session.sessionData.getRowStore(t);
        Object[]        row;
        Iterator        it = Type.typeNames.keySet().iterator();
        boolean translateDTI = database.getProperties().isPropertyTrue(
            HsqlDatabaseProperties.jdbc_translate_dti_types);


        while (it.hasNext()) {
            String typeName = (String) it.next();
            int    typeCode = Type.typeNames.get(typeName);
            Type   type     = Type.getDefaultType(typeCode);


            if (type == null) {
                continue;

View Full Code Here

        final int type_name    = 2;
        final int class_name   = 3;
        final int data_type    = 4;
        final int remarks      = 5;
        final int base_type    = 6;
        Iterator it =
            database.schemaManager.databaseObjectIterator(SchemaObject.TYPE);


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


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

View Full Code Here

        String  tableName;
        Grantee granteeObject;


// intermediate holders
        User     user;
        Iterator tables;
        Table    table;
        Object[] row;


// column number mappings
        final int grantor        = 0;
        final int grantee        = 1;
        final int table_catalog  = 2;
        final int table_schema   = 3;
        final int table_name     = 4;
        final int column_name    = 5;
        final int privilege_type = 6;
        final int is_grantable   = 7;


        // enumerations
        OrderedHashSet grantees =
            session.getGrantee().getGranteeAndAllRolesWithPublic();


// Initialization
        tables = allTables();


        while (tables.hasNext()) {
            table        = (Table) tables.next();
            tableName    = table.getName().name;
            tableCatalog = database.getCatalogName().name;
            tableSchema  = table.getSchemaName().name;


            for (int i = 0; i < grantees.size(); i++) {

View Full Code Here

        final int declared_numeric_scale     = 13;
        final int start_with                 = 14;
        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;
            }

View Full Code Here

        final int declared_numeric_scale     = 13;
        final int start_with                 = 14;
        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;
            }

View Full Code Here

        String  tableName;
        Grantee granteeObject;
        String  privilege;


        // intermediate holders
        Iterator tables;
        Table    table;
        Object[] row;


        // column number mappings
        final int grantor        = 0;
        final int grantee        = 1;
        final int table_catalog  = 2;
        final int table_schema   = 3;
        final int table_name     = 4;
        final int privilege_type = 5;
        final int is_grantable   = 6;
        final int with_hierarchy = 7;
        OrderedHashSet grantees =
            session.getGrantee().getGranteeAndAllRolesWithPublic();


        tables = allTables();


        while (tables.hasNext()) {
            table        = (Table) tables.next();
            tableName    = table.getName().name;
            tableCatalog = table.getCatalogName().name;
            tableSchema  = table.getSchemaName().name;


            for (int i = 0; i < grantees.size(); i++) {

View Full Code Here

        }


        PersistentStore store = session.sessionData.getRowStore(t);


        // intermediate holders
        Iterator  tables;
        Table     table;
        Object[]  row;
        final int table_catalog                = 0;
        final int table_schema                 = 1;
        final int table_name                   = 2;
        final int table_type                   = 3;
        final int self_referencing_column_name = 4;
        final int reference_generation         = 5;
        final int user_defined_type_catalog    = 6;
        final int user_defined_type_schema     = 7;
        final int user_defined_type_name       = 8;
        final int is_insertable_into           = 9;
        final int is_typed                     = 10;
        final int commit_action                = 11;


        // Initialization
        tables = allTables();


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


            if (!isAccessibleTable(session, table)) {
                continue;
            }

View Full Code Here

        }
    }


    public void removeDbObjects(OrderedHashSet nameSet) {


        Iterator it = nameSet.iterator();


        while (it.hasNext()) {
            HsqlName name = (HsqlName) it.next();


            for (int i = 0; i < map.size(); i++) {
                Grantee g = (Grantee) map.get(i);


                g.revokeDbObject(name);

View Full Code Here

    public String[] getSQL() {


        HsqlArrayList list = new HsqlArrayList();


        // roles
        Iterator it = getRoles().iterator();


        while (it.hasNext()) {
            Grantee grantee = (Grantee) it.next();


            // ADMIN_ROLE_NAME is not persisted
            if (!GranteeManager.isReserved(grantee.getNameString())) {
                list.add(grantee.getSQL());
            }
        }


        // users
        it = getGrantees().iterator();


        for (; it.hasNext(); ) {
            Grantee grantee = (Grantee) it.next();


            if (grantee instanceof User) {
                list.add(grantee.getSQL());
            }
        }

View Full Code Here

    }


    public String[] getRightstSQL() {


        HsqlArrayList list     = new HsqlArrayList();
        Iterator      grantees = getGrantees().iterator();


        while (grantees.hasNext()) {
            Grantee grantee = (Grantee) grantees.next();
            String  name    = grantee.getNameString();


            // _SYSTEM user, DBA Role grants not persisted
            if (GranteeManager.isImmutable(name)) {
                continue;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.lib.Iterator

org.hsqldb.ColumnSchema

org.hsqldb.CompiledStatementManager

org.hsqldb.Constraint

org.hsqldb.DatabaseInformationFull

org.hsqldb.DatabaseInformationMain

org.hsqldb.DatabaseManager

org.hsqldb.DatabaseObjectNames

org.hsqldb.DatabaseScript

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.dbinfo.DatabaseInformationMain

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.