Examples of org.hsqldb_voltpatches.lib.Iterator

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

        }


        PersistentStore store = database.persistentStoreCollection.getStore(t);


        // Intermediate holders
        Iterator schemas;
        String   schema;
        String   dcsSchema = SqlInvariants.INFORMATION_SCHEMA;
        String   dcsName   = ValuePool.getString("UTF16");
        String   sqlPath   = null;
        Grantee  user      = session.getGrantee();
        Object[] row;


        // column number mappings
        final int schema_catalog                = 0;
        final int schema_name                   = 1;
        final int schema_owner                  = 2;
        final int default_character_set_catalog = 3;
        final int default_character_set_schema  = 4;
        final int default_character_set_name    = 5;
        final int sql_path                      = 6;


        // Initialization
        schemas = database.schemaManager.fullSchemaNamesIterator();


        // Do it.
        while (schemas.hasNext()) {
            schema = (String) schemas.next();


            if (!user.hasSchemaUpdateOrGrantRights(schema)) {
                continue;
            }

View Full Code Here

        }


        PersistentStore store = database.persistentStoreCollection.getStore(t);


        // Intermediate holders
        Iterator     tables;
        Table        table;
        Constraint[] constraints;
        int          constraintCount;
        Constraint   constraint;
        String       cat;
        String       schem;
        Object[]     row;


        // column number mappings
        final int constraint_catalog = 0;
        final int constraint_schema  = 1;
        final int constraint_name    = 2;
        final int constraint_type    = 3;
        final int table_catalog      = 4;
        final int table_schema       = 5;
        final int table_name         = 6;
        final int is_deferable       = 7;
        final int initially_deferred = 8;


        // initialization
        tables =
            database.schemaManager.databaseObjectIterator(SchemaObject.TABLE);
        table = null;    // else compiler complains


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


            /** @todo - requires table level INSERT or UPDATE or DELETE or REFERENCES (not SELECT) right */
            if (table.isView() || !isAccessibleTable(table)) {
                continue;
            }

View Full Code Here

        final int trigger_name    = 2;
        final int table_catalog   = 3;
        final int table_schema    = 4;
        final int table_name      = 5;
        final int column_name     = 6;
        Iterator  it;
        Object[]  row;


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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

View Full Code Here

        final int trigger_schema   = 1;
        final int trigger_name     = 2;
        final int specific_catalog = 3;
        final int specific_schema  = 4;
        final int specific_name    = 5;
        Iterator  it;
        Object[]  row;


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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

View Full Code Here

        final int trigger_schema   = 1;
        final int trigger_name     = 2;
        final int sequence_catalog = 3;
        final int sequence_schema  = 4;
        final int sequence_name    = 5;
        Iterator  it;
        Object[]  row;


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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

View Full Code Here

        final int trigger_schema  = 1;
        final int trigger_name    = 2;
        final int table_catalog   = 3;
        final int table_schema    = 4;
        final int table_name      = 5;
        Iterator  it;
        Object[]  row;


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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

View Full Code Here

        final int action_reference_old_table = 12;
        final int action_reference_new_table = 13;
        final int action_reference_old_row   = 14;
        final int action_reference_new_row   = 15;
        final int created                    = 16;
        Iterator  it;
        Object[]  row;


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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

View Full Code Here

        final int trigger_name         = 2;
        final int event_object_catalog = 3;
        final int event_object_schema  = 4;
        final int event_object_table   = 5;
        final int event_object_column  = 6;
        Iterator  it;
        Object[]  row;


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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

View Full Code Here

        final int       object_name    = 4;
        final int       object_type    = 5;
        final int       privilege_type = 6;
        final int       is_grantable   = 7;
        PersistentStore store = database.persistentStoreCollection.getStore(t);
        Iterator objects =
            new WrapperIterator(database.schemaManager
                .databaseObjectIterator(SchemaObject.SEQUENCE), database
                .schemaManager.databaseObjectIterator(SchemaObject.COLLATION));


        objects = new WrapperIterator(
            objects,
            database.schemaManager.databaseObjectIterator(
                SchemaObject.CHARSET));
        objects = new WrapperIterator(
            objects,
            database.schemaManager.databaseObjectIterator(
                SchemaObject.DOMAIN));


/*
        objects = new WrapperIterator(
            objects,
            database.schemaManager.databaseObjectIterator(SchemaObject.TYPE));
*/
        OrderedHashSet grantees =
            session.getGrantee().getGranteeAndAllRolesWithPublic();


        while (objects.hasNext()) {
            SchemaObject object = (SchemaObject) objects.next();


            for (int i = 0; i < grantees.size(); i++) {
                Grantee granteeObject = (Grantee) grantees.get(i);
                OrderedHashSet rights =
                    granteeObject.getAllDirectPrivileges(object);

View Full Code Here

        final int       source_dtd_identifier      = 27;
        final int       ref_dtd_identifier         = 28;
        final int       declared_data_type         = 29;
        final int       declared_numeric_precision = 30;
        final int       declared_numeric_scale     = 31;
        Iterator it =
            database.schemaManager.databaseObjectIterator(SchemaObject.DOMAIN);


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


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

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb_voltpatches.lib.Iterator

org.hsqldb_voltpatches.DatabaseManager

org.hsqldb_voltpatches.dbinfo.DatabaseInformationFull

org.hsqldb_voltpatches.dbinfo.DatabaseInformationMain

org.hsqldb_voltpatches.dbinfo.DINameSpace

org.hsqldb_voltpatches.jdbc.pool.JDBCXADataSource

org.hsqldb_voltpatches.persist.Cache

org.hsqldb_voltpatches.persist.HsqlDatabaseProperties

org.hsqldb_voltpatches.persist.Log

org.hsqldb_voltpatches.persist.PersistentStoreCollectionSession

org.hsqldb_voltpatches.RangeVariableResolver

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.