Examples of org.hsqldb_voltpatches.lib.HsqlArrayList

org.hsqldb_voltpatches.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[]         baseUpdateColumnMap;
        Table         table;
        RangeVariable targetRange;
        RangeVariable sourceRange;
        Expression    mergeCondition;
        HsqlArrayList updateList        = new HsqlArrayList();
        Expression[]  updateExpressions = null;
        HsqlArrayList insertList        = new HsqlArrayList();
        Expression    insertExpression  = null;


        read();
        readThis(Tokens.INTO);


        targetRange = readSimpleRangeVariable(StatementTypes.MERGE);
        table       = targetRange.rangeTable;


        readThis(Tokens.USING);


        sourceRange = readTableOrSubquery();


        // parse ON search conditions
        readThis(Tokens.ON);


        mergeCondition = XreadBooleanValueExpression();


        if (mergeCondition.getDataType() != Type.SQL_BOOLEAN) {
            throw Error.error(ErrorCode.X_42568);
        }


        RangeVariable[] fullRangeVars   = new RangeVariable[] {
            sourceRange, targetRange
        };
        RangeVariable[] sourceRangeVars = new RangeVariable[]{ sourceRange };
        RangeVariable[] targetRangeVars = new RangeVariable[]{ targetRange };


        // parse WHEN clause(s) and convert lists to arrays
        insertColumnMap       = table.getColumnMap();
        insertColumnCheckList = table.getNewColumnCheckList();


        OrderedHashSet updateColNames = new OrderedHashSet();
        OrderedHashSet insertColNames = new OrderedHashSet();


        readMergeWhen(insertColNames, updateColNames, insertList, updateList,
                      targetRangeVars, sourceRange);


        if (insertList.size() > 0) {
            int colCount = insertColNames.size();


            if (colCount != 0) {
                insertColumnMap = table.getColumnIndexes(insertColNames);
                insertColumnCheckList =
                    table.getColumnCheckList(insertColumnMap);
            }


            insertExpression = (Expression) insertList.get(0);


            setParameterTypes(insertExpression, table, insertColumnMap);
        }


        if (updateList.size() > 0) {

View Full Code Here

                    SchemaObject.PROCEDURE);


            if (routineSchema != null) {
                read();


                HsqlArrayList list = new HsqlArrayList();


                readThis(Tokens.OPENBRACKET);


                if (token.tokenType == Tokens.CLOSEBRACKET) {
                    read();
                } else {
                    while (true) {
                        Expression e = XreadValueExpression();


                        list.add(e);


                        if (token.tokenType == Tokens.COMMA) {
                            read();
                        } else {
                            readThis(Tokens.CLOSEBRACKET);


                            break;
                        }
                    }
                }


                Expression[] arguments = new Expression[list.size()];


                list.toArray(arguments);


                Routine routine =
                    routineSchema.getSpecificRoutine(arguments.length);
                HsqlList unresolved = null;

View Full Code Here

    }


    private HsqlArrayList readCaseWhen(Routine routine,
                                       StatementCompound context) {


        HsqlArrayList list = new HsqlArrayList();
        RangeVariable[] rangeVariables = context == null
                                         ? routine.getParameterRangeVariables()
                                         : context.getRangeVariables();
        HsqlList    unresolved = null;
        Expression  condition  = null;
        Statement   statement;
        Statement[] statements;


        do {
            readThis(Tokens.WHEN);


            condition = XreadBooleanValueExpression();
            unresolved = condition.resolveColumnReferences(rangeVariables,
                    rangeVariables.length, unresolved, false);


            ExpressionColumn.checkColumnsResolved(unresolved);


            unresolved = null;


            condition.resolveTypes(session, null);


            statement = new StatementSimple(StatementTypes.CONDITION,
                                            condition);


            list.add(statement);
            readThis(Tokens.THEN);


            statements = readSQLProcedureStatementList(routine, context);


            for (int i = 0; i < statements.length; i++) {
                list.add(statements[i]);
            }


            if (token.tokenType != Tokens.WHEN) {
                break;
            }

View Full Code Here

        return false;
    }


    public HsqlArrayList getRightsSQL() {


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


        if (roleString.length() != 0) {
            list.add("GRANT " + roleString + " TO " + getStatementName());
        }


        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("TABLE ").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("SEQUENCE ").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("DOMAIN ").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("TYPE ").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


        super(compileContext);


        this.compileContext = compileContext;
        resultRangePosition = compileContext.getNextRangeVarIndex();
        rangeVariableList   = new HsqlArrayList();
        exprColumnList      = new HsqlArrayList();
        sortAndSlice        = SortAndSlice.noSort;
    }

View Full Code Here

        return result;
    }


    private void addAllJoinedColumns(Expression e) {


        HsqlArrayList list = new HsqlArrayList();


        for (int i = 0; i < rangeVariables.length; i++) {
            rangeVariables[i].addTableColumns(list);
        }


        Expression[] nodes = new Expression[list.size()];


        list.toArray(nodes);


        e.nodes = nodes;
    }

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

        }
    }


    public String[] getInitialSchemaSQL() {


        HsqlArrayList list = new HsqlArrayList(userList.size());


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


            if (user.isSystem) {
                continue;
            }


            HsqlName name = user.getInitialSchema();


            if (name == null) {
                continue;
            }


            list.add(user.getInitialSchemaSQL());
        }


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


        list.toArray(array);


        return array;
    }

View Full Code Here

    }


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


        HsqlArrayList list = new HsqlArrayList();
        StringBuffer  sb   = new StringBuffer(128);


        sb.append(Tokens.T_CREATE).append(' ');
        sb.append(Tokens.T_SCHEMA).append(' ');
        sb.append(name.statementName).append(' ');
        sb.append(Tokens.T_AUTHORIZATION).append(' ');
        sb.append(owner.getStatementName());
        list.add(sb.toString());
        sb.setLength(0);
        sb.append(Tokens.T_SET).append(' ');
        sb.append(Tokens.T_SCHEMA).append(' ');
        sb.append(name.statementName);
        list.add(sb.toString());


        //
        String[] subList;


        subList = charsetLookup.getSQL(resolved, unresolved);


        list.addAll(subList);


        subList = collationLookup.getSQL(resolved, unresolved);


        list.addAll(subList);


        subList = typeLookup.getSQL(resolved, unresolved);


        list.addAll(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);


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


        list.toArray(array);


        return array;
    }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of org.hsqldb_voltpatches.lib.HsqlArrayList

org.hsqldb_voltpatches.Database

org.hsqldb_voltpatches.dbinfo.DatabaseInformationMain

org.hsqldb_voltpatches.Expression

org.hsqldb_voltpatches.ParserBase

org.hsqldb_voltpatches.ParserCommand

org.hsqldb_voltpatches.ParserDDL

org.hsqldb_voltpatches.ParserDML

org.hsqldb_voltpatches.ParserDQL

org.hsqldb_voltpatches.ParserRoutine

org.hsqldb_voltpatches.persist.DataFileDefrag

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.