Examples of org.hsqldb.lib.HsqlArrayList

org.hsqldb.lib.HsqlArrayList
Intended as an asynchronous alternative to Vector. Use HsqlLinkedList instead if its better suited. @author dnordahl@users @version 1.9.0 @since 1.7.0

        int[]         mainCols;
        int[]         refCols;
        Constraint[]  constraints;
        Constraint    constraint;
        int           constraintCount;
        HsqlArrayList fkConstraintsList;
        Object[]      row;


        // column number mappings
        final int ipk_table_cat   = 0;
        final int ipk_table_schem = 1;
        final int ipk_table_name  = 2;
        final int ipk_column_name = 3;
        final int ifk_table_cat   = 4;
        final int ifk_table_schem = 5;
        final int ifk_table_name  = 6;
        final int ifk_column_name = 7;
        final int ikey_seq        = 8;
        final int iupdate_rule    = 9;
        final int idelete_rule    = 10;
        final int ifk_name        = 11;
        final int ipk_name        = 12;
        final int ideferrability  = 13;


        tables =
            database.schemaManager.databaseObjectIterator(SchemaObject.TABLE);


        // We must consider all the constraints in all the user tables, since
        // this is where reference relationships are recorded.  However, we
        // are only concerned with Constraint.FOREIGN_KEY constraints here
        // because their corresponing Constraint.MAIN entries are essentially
        // duplicate data recorded in the referenced rather than the
        // referencing table.  Also, we skip constraints where either
        // the referenced, referencing or both tables are not accessible
        // relative to the session of the calling context
        fkConstraintsList = new HsqlArrayList();


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


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


            constraints     = table.getConstraints();
            constraintCount = constraints.length;


            for (int i = 0; i < constraintCount; i++) {
                constraint = (Constraint) constraints[i];


                if (constraint.getConstraintType() == SchemaObject
                        .ConstraintTypes
                        .FOREIGN_KEY && isAccessibleTable(session, constraint
                            .getRef())) {
                    fkConstraintsList.add(constraint);
                }
            }
        }


        // Now that we have all of the desired constraints, we need to
        // process them, generating one row in our ouput table for each
        // imported/exported column pair of each constraint.
        // Do it.
        for (int i = 0; i < fkConstraintsList.size(); i++) {
            constraint     = (Constraint) fkConstraintsList.get(i);
            pkTable        = constraint.getMain();
            pkTableName    = pkTable.getName().name;
            fkTable        = constraint.getRef();
            fkTableName    = fkTable.getName().name;
            pkTableCatalog = pkTable.getCatalogName().name;

View Full Code Here

        }


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


        // Intermediate holders
        HsqlArrayList users;
        User          user;
        Object[]      row;
        HsqlName      initialSchema;


        // Initialization
        users = database.getUserManager().listVisibleUsers(session);


        // Do it.
        for (int i = 0; i < users.size(); i++) {
            row           = t.getEmptyRowData();
            user          = (User) users.get(i);
            initialSchema = user.getInitialSchema();
            row[0]        = user.getNameString();
            row[1]        = ValuePool.getBoolean(user.isAdmin());
            row[2]        = ((initialSchema == null) ? null
                                                     : initialSchema.name);

View Full Code Here

        return roleMap.containsKey(name);
    }


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


        String[] array = new String[list.size()];


        list.toArray(array);


        return array;
    }

View Full Code Here

        return array;
    }


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


            HsqlArrayList subList = grantee.getRightsSQL();


            list.addAll(subList);
        }


        String[] array = new String[list.size()];

View Full Code Here

        return false;
    }


    public HsqlArrayList getRightsSQL() {


        HsqlArrayList list       = new HsqlArrayList();
        String        roleString = getDirectRolesAsString();


        if (roleString.length() != 0) {
            StringBuffer sb = new StringBuffer(128);


            sb.append(Tokens.T_GRANT).append(' ').append(roleString);
            sb.append(' ').append(Tokens.T_TO).append(' ');
            sb.append(getStatementName());
            list.add(sb.toString());
        }


        MultiValueHashMap rightsMap = getRights();
        Iterator          dbObjects = rightsMap.keySet().iterator();


        while (dbObjects.hasNext()) {
            Object   nameObject = dbObjects.next();
            Iterator rights     = rightsMap.get(nameObject);


            while (rights.hasNext()) {
                Right        right    = (Right) rights.next();
                StringBuffer sb       = new StringBuffer(128);
                HsqlName     hsqlname = (HsqlName) nameObject;


                switch (hsqlname.type) {


                    case SchemaObject.TABLE :
                    case SchemaObject.VIEW :
                        Table table =
                            granteeManager.database.schemaManager
                                .findUserTable(null, hsqlname.name,
                                               hsqlname.schema.name);


                        if (table != null) {
                            sb.append(Tokens.T_GRANT).append(' ');
                            sb.append(right.getTableRightsSQL(table));
                            sb.append(' ').append(Tokens.T_ON).append(' ');
                            sb.append(Tokens.T_TABLE).append(' ');
                            sb.append(
                                hsqlname.getSchemaQualifiedStatementName());
                        }
                        break;


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


                        if (sequence != null) {
                            sb.append(Tokens.T_GRANT).append(' ');
                            sb.append(Tokens.T_USAGE);
                            sb.append(' ').append(Tokens.T_ON).append(' ');
                            sb.append(Tokens.T_SEQUENCE).append(' ');
                            sb.append(
                                hsqlname.getSchemaQualifiedStatementName());
                        }
                        break;


                    case SchemaObject.DOMAIN :
                        Type domain =
                            (Type) granteeManager.database.schemaManager
                                .findSchemaObject(hsqlname.name,
                                                  hsqlname.schema.name,
                                                  SchemaObject.DOMAIN);


                        if (domain != null) {
                            sb.append(Tokens.T_GRANT).append(' ');
                            sb.append(Tokens.T_USAGE);
                            sb.append(' ').append(Tokens.T_ON).append(' ');
                            sb.append(Tokens.T_DOMAIN).append(' ');
                            sb.append(
                                hsqlname.getSchemaQualifiedStatementName());
                        }
                        break;


                    case SchemaObject.TYPE :
                        Type type =
                            (Type) granteeManager.database.schemaManager
                                .findSchemaObject(hsqlname.name,
                                                  hsqlname.schema.name,
                                                  SchemaObject.DOMAIN);


                        if (type != null) {
                            sb.append(Tokens.T_GRANT).append(' ');
                            sb.append(Tokens.T_USAGE);
                            sb.append(' ').append(Tokens.T_ON).append(' ');
                            sb.append(Tokens.T_TYPE).append(' ');
                            sb.append(
                                hsqlname.getSchemaQualifiedStatementName());
                        }
                        break;


                    case SchemaObject.PROCEDURE :
                    case SchemaObject.FUNCTION :
                    case SchemaObject.SPECIFIC_ROUTINE :
                        SchemaObject routine =
                            (SchemaObject) granteeManager.database
                                .schemaManager
                                .findSchemaObject(hsqlname.name,
                                                  hsqlname.schema.name,
                                                  hsqlname.type);


                        if (routine != null) {
                            sb.append(Tokens.T_GRANT).append(' ');
                            sb.append(Tokens.T_EXECUTE).append(' ');
                            sb.append(Tokens.T_ON).append(' ');
                            sb.append(Tokens.T_SPECIFIC).append(' ');


                            if (routine.getType() == SchemaObject.PROCEDURE) {
                                sb.append(Tokens.T_PROCEDURE);
                            } else {
                                sb.append(Tokens.T_FUNCTION);
                            }


                            sb.append(' ');
                            sb.append(
                                hsqlname.getSchemaQualifiedStatementName());
                        }
                        break;
                }


                if (sb.length() == 0) {
                    continue;
                }


                sb.append(' ').append(Tokens.T_TO).append(' ');
                sb.append(getStatementName());
                list.add(sb.toString());
            }
        }


        return list;
    }

View Full Code Here

    }


    public String[] getSQLArray(OrderedHashSet resolved,
                                OrderedHashSet unresolved) {


        HsqlArrayList list      = new HsqlArrayList();
        String        setSchema = getSetSchemaSQL(name);


        list.add(setSchema);


        //
        String[] subList;


        subList = sequenceLookup.getSQL(resolved, unresolved);


        list.addAll(subList);


        subList = tableLookup.getSQL(resolved, unresolved);


        list.addAll(subList);


        subList = functionLookup.getSQL(resolved, unresolved);


        list.addAll(subList);


        subList = procedureLookup.getSQL(resolved, unresolved);


        list.addAll(subList);


        subList = assertionLookup.getSQL(resolved, unresolved);


        list.addAll(subList);


//
        if (list.size() == 1) {
            return new String[]{};
        }


        String[] array = new String[list.size()];


        list.toArray(array);


        return array;
    }

View Full Code Here

        return array;
    }


    public String[] getSequenceRestartSQL() {


        HsqlArrayList list = new HsqlArrayList();
        Iterator      it   = sequenceLookup.map.values().iterator();


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


            list.add(ddl);
        }


        String[] array = new String[list.size()];


        list.toArray(array);


        return array;
    }

View Full Code Here

        return array;
    }


    public String[] getTriggerSQL() {


        HsqlArrayList list = new HsqlArrayList();
        Iterator      it   = tableLookup.map.values().iterator();


        while (it.hasNext()) {
            Table    table = (Table) it.next();
            String[] ddl   = table.getTriggerSQL();


            list.addAll(ddl);
        }


        String[] array = new String[list.size()];


        list.toArray(array);


        return array;
    }

View Full Code Here

                Tokens.T_SELECT, Tokens.T_INSERT, Tokens.T_UPDATE,
                Tokens.T_DELETE, Tokens.T_REFERENCES
            };
        }


        HsqlArrayList list  = new HsqlArrayList();
        String[]      array = new String[list.size()];


        if (isFullSelect) {
            list.add(Tokens.T_SELECT);
        }


        if (isFullInsert) {
            list.add(Tokens.T_INSERT);
        }


        if (isFullUpdate) {
            list.add(Tokens.T_UPDATE);
        }


        if (isFullDelete) {
            list.add(Tokens.T_DELETE);
        }


        if (isFullReferences) {
            list.add(Tokens.T_REFERENCES);
        }


        if (isFullTrigger) {
            list.add(Tokens.T_TRIGGER);
        }


        list.toArray(array);


        return array;
    }

View Full Code Here

     *         <code>session</code> argument.
     *
     */
    public HsqlArrayList listVisibleUsers(Session session) {


        HsqlArrayList list;
        User          user;
        boolean       isAdmin;
        String        sessionName;
        String        userName;


        list        = new HsqlArrayList();
        isAdmin     = session.isAdmin();
        sessionName = session.getUsername();


        if (userList == null || userList.size() == 0) {
            return list;
        }


        for (int i = 0; i < userList.size(); i++) {
            user = (User) userList.get(i);


            if (user == null) {
                continue;
            }


            userName = user.getNameString();


            if (isAdmin) {
                list.add(user);
            } else if (sessionName.equals(userName)) {
                list.add(user);
            }
        }


        return list;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.lib.HsqlArrayList

org.hsqldb.CompiledStatementExecutor

org.hsqldb.Database

org.hsqldb.DatabaseCommandInterpreter

org.hsqldb.DatabaseInformationFull

org.hsqldb.DatabaseInformationMain

org.hsqldb.DatabaseScript

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.DINameSpace

org.hsqldb.Expression

org.hsqldb.ExpressionArrayAggregate

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.