Examples of org.hsqldb.lib.OrderedHashSet

org.hsqldb.lib.OrderedHashSet
Implementation of an ordered Set which maintains the inserted order of elements and allows access by index. Iterators return the elements in the index order. This class does not store null elements. @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.9.0

        set.rename(name, newName);
    }


    public String[] getSQLArray() {


        OrderedHashSet resolved   = new OrderedHashSet();
        OrderedHashSet unresolved = new OrderedHashSet();
        HsqlArrayList  list       = new HsqlArrayList();
        Iterator       schemas    = schemaMap.values().iterator();


        schemas = schemaMap.values().iterator();


        while (schemas.hasNext()) {
            Schema schema = (Schema) schemas.next();


            if (SqlInvariants.isSystemSchemaName(schema.getName().name)) {
                continue;
            }


            if (SqlInvariants.isLobsSchemaName(schema.getName().name)) {
                continue;
            }


            list.add(schema.getSQL());
            schema.addSimpleObjects(unresolved);
        }


        while (true) {
            Iterator it = unresolved.iterator();


            if (!it.hasNext()) {
                break;
            }


            OrderedHashSet newResolved = new OrderedHashSet();


            SchemaObjectSet.addAllSQL(resolved, unresolved, list, it,
                                      newResolved);
            unresolved.removeAll(newResolved);


            if (newResolved.size() == 0) {
                break;
            }
        }


        schemas = schemaMap.values().iterator();


        while (schemas.hasNext()) {
            Schema schema = (Schema) schemas.next();


            if (SqlInvariants.isLobsSchemaName(schema.getName().name)) {
                continue;
            }


            if (SqlInvariants.isSystemSchemaName(schema.getName().name)) {
                continue;
            }


            list.addAll(schema.getSQLArray(resolved, unresolved));
        }


        while (true) {
            Iterator it = unresolved.iterator();


            if (!it.hasNext()) {
                break;
            }


            OrderedHashSet newResolved = new OrderedHashSet();


            SchemaObjectSet.addAllSQL(resolved, unresolved, list, it,
                                      newResolved);
            unresolved.removeAll(newResolved);


            if (newResolved.size() == 0) {
                break;
            }
        }


        schemas = schemaMap.values().iterator();

View Full Code Here

//            newRow.rowAction.updatedAction = row.rowAction;
        }


        navigator.beforeFirst();


        OrderedHashSet extraUpdateTables = null;
        boolean hasAfterRowTriggers =
            table.triggerLists[Trigger.UPDATE_AFTER_ROW].length > 0;


        for (int i = 0; i < navigator.getSize(); i++) {
            Row      row            = navigator.getNextRow();
            Table    currentTable   = ((Table) row.getTable());
            Object[] changedData    = navigator.getCurrentChangedData();
            int[]    changedColumns = navigator.getCurrentChangedColumns();


            performIntegrityChecks(session, currentTable, row.getData(),
                                   changedData, changedColumns);


            if (currentTable != table) {
                if (extraUpdateTables == null) {
                    extraUpdateTables = new OrderedHashSet();
                }


                extraUpdateTables.add(currentTable);


                if (currentTable.triggerLists[Trigger.UPDATE_AFTER_ROW].length
                        > 0) {
                    hasAfterRowTriggers = true;
                }
            }
        }


        navigator.beforeFirst();


        if (hasAfterRowTriggers) {
            for (int i = 0; i < navigator.getSize(); i++) {
                Row      row            = navigator.getNextRow();
                Object[] changedData    = navigator.getCurrentChangedData();
                int[]    changedColumns = navigator.getCurrentChangedColumns();
                Table    currentTable   = ((Table) row.getTable());


                currentTable.fireTriggers(session, Trigger.UPDATE_AFTER_ROW,
                                          row.getData(), changedData,
                                          changedColumns);
            }


            navigator.beforeFirst();
        }


        baseTable.fireTriggers(session, Trigger.UPDATE_AFTER, navigator);


        if (extraUpdateTables != null) {
            for (int i = 0; i < extraUpdateTables.size(); i++) {
                Table currentTable = (Table) extraUpdateTables.get(i);


                currentTable.fireTriggers(session, Trigger.UPDATE_AFTER,
                                          navigator);
            }
        }

View Full Code Here

            }


            navigator.beforeFirst();
        }


        OrderedHashSet extraUpdateTables = null;
        OrderedHashSet extraDeleteTables = null;
        boolean hasAfterRowTriggers =
            table.triggerLists[Trigger.DELETE_AFTER_ROW].length > 0;


        if (rowCount != navigator.getSize()) {
            while (navigator.hasNext()) {
                navigator.next();


                Row      row            = navigator.getCurrentRow();
                Object[] changedData    = navigator.getCurrentChangedData();
                int[]    changedColumns = navigator.getCurrentChangedColumns();
                Table    currentTable   = ((Table) row.getTable());


                if (changedData != null) {
                    performIntegrityChecks(session, currentTable,
                                           row.getData(), changedData,
                                           changedColumns);
                }


                if (currentTable != table) {
                    if (changedData == null) {
                        if (currentTable.triggerLists[Trigger.DELETE_AFTER_ROW]
                                .length > 0) {
                            hasAfterRowTriggers = true;
                        }


                        if (extraDeleteTables == null) {
                            extraDeleteTables = new OrderedHashSet();
                        }


                        extraDeleteTables.add(currentTable);
                    } else {
                        if (currentTable.triggerLists[Trigger.UPDATE_AFTER_ROW]
                                .length > 0) {
                            hasAfterRowTriggers = true;
                        }


                        if (extraUpdateTables == null) {
                            extraUpdateTables = new OrderedHashSet();
                        }


                        extraUpdateTables.add(currentTable);
                    }
                }
            }


            navigator.beforeFirst();
        }


        if (hasAfterRowTriggers) {
            while (navigator.hasNext()) {
                navigator.next();


                Row      row          = navigator.getCurrentRow();
                Object[] changedData  = navigator.getCurrentChangedData();
                Table    currentTable = ((Table) row.getTable());


                if (changedData == null) {
                    currentTable.fireTriggers(session,
                                              Trigger.DELETE_AFTER_ROW,
                                              row.getData(), null, null);
                } else {
                    currentTable.fireTriggers(session,
                                              Trigger.UPDATE_AFTER_ROW,
                                              row.getData(), changedData,
                                              null);
                }
            }


            navigator.beforeFirst();
        }


        table.fireTriggers(session, Trigger.DELETE_AFTER, navigator);


        if (extraUpdateTables != null) {
            for (int i = 0; i < extraUpdateTables.size(); i++) {
                Table currentTable = (Table) extraUpdateTables.get(i);


                currentTable.fireTriggers(session, Trigger.UPDATE_AFTER,
                                          navigator);
            }
        }


        if (extraDeleteTables != null) {
            for (int i = 0; i < extraDeleteTables.size(); i++) {
                Table currentTable = (Table) extraDeleteTables.get(i);


                currentTable.fireTriggers(session, Trigger.DELETE_AFTER,
                                          navigator);
            }
        }

View Full Code Here

    public Expression getEquiJoinExpressions(OrderedHashSet nameSet,
            RangeVariable rightRange, boolean fullList) {


        HashSet        set             = new HashSet();
        Expression     result          = null;
        OrderedHashSet joinColumnNames = new OrderedHashSet();


        for (int i = 0; i < rangeVariableList.size(); i++) {
            RangeVariable  range = (RangeVariable) rangeVariableList.get(i);
            HashMappedList columnList = range.rangeTable.columnList;


            for (int j = 0; j < columnList.size(); j++) {
                ColumnSchema column       = (ColumnSchema) columnList.get(j);
                String       name         = range.getColumnAlias(j);
                boolean      columnInList = nameSet.contains(name);
                boolean namedJoin = range.namedJoinColumns != null
                                    && range.namedJoinColumns.contains(name);
                boolean repeated = !namedJoin && !set.add(name);


                if (repeated && (!fullList || columnInList)) {
                    throw Error.error(ErrorCode.X_42578, name);
                }


                if (!columnInList) {
                    continue;
                }


                joinColumnNames.add(name);


                int leftPosition =
                    range.rangeTable.getColumnIndex(column.getNameString());
                int rightPosition = rightRange.rangeTable.getColumnIndex(name);
                Expression e = new ExpressionLogical(range, leftPosition,
                                                     rightRange,
                                                     rightPosition);


                result = ExpressionLogical.andExpressions(result, e);


                ExpressionColumn col = range.getColumnExpression(name);


                if (col == null) {
                    col = new ExpressionColumn(new Expression[] {
                        e.getLeftNode(), e.getRightNode()
                    }, name);


                    range.addNamedJoinColumnExpression(name, col);
                } else {
                    col.nodes = (Expression[]) ArrayUtil.resizeArray(col.nodes,
                            col.nodes.length + 1);
                    col.nodes[col.nodes.length - 1] = e.getRightNode();
                }


                rightRange.addNamedJoinColumnExpression(name, col);
            }
        }


        if (fullList && !joinColumnNames.containsAll(nameSet)) {
            throw Error.error(ErrorCode.X_42501);
        }


        rightRange.addNamedJoinColumns(joinColumnNames);

View Full Code Here


        if (!isAggregated) {
            return;
        }


        OrderedHashSet expressions       = new OrderedHashSet();
        OrderedHashSet columnExpressions = new OrderedHashSet();


        for (int i = indexStartAggregates; i < indexLimitExpressions; i++) {
            Expression e = exprColumns[i];
            Expression c = new ExpressionColumn(e, i, resultRangePosition);


            expressions.add(e);
            columnExpressions.add(c);
        }


        for (int i = 0; i < indexStartHaving; i++) {
            if (exprColumns[i].isAggregate()) {
                continue;
            }


            Expression e = exprColumns[i];


            if (expressions.add(e)) {
                Expression c = new ExpressionColumn(e, i, resultRangePosition);


                columnExpressions.add(c);
            }
        }


        // order by with aggregate
        int orderCount = sortAndSlice.getOrderLength();

View Full Code Here

            range.hasKeyedColumnInGroupBy =
                range.rangeTable.getUniqueNotNullColumnGroup(
                    range.columnsInGroupBy) != null;
        }


        OrderedHashSet set = null;


        for (int i = 0; i < unresolvedSet.size(); i++) {
            Expression e = (Expression) unresolvedSet.get(i);


            set = e.getUnkeyedColumns(set);

View Full Code Here

        }
    }


    public OrderedHashSet getSubqueries() {


        OrderedHashSet set = null;


        for (int i = 0; i < indexStartAggregates; i++) {
            set = exprColumns[i].collectAllSubqueries(set);
        }


        if (queryCondition != null) {
            set = queryCondition.collectAllSubqueries(set);
        }


        if (havingCondition != null) {
            set = havingCondition.collectAllSubqueries(set);
        }


        for (int i = 0; i < rangeVariables.length; i++) {
            OrderedHashSet temp = rangeVariables[i].getSubqueries();


            set = OrderedHashSet.addAll(set, temp);
        }


        return set;

View Full Code Here

        checkAccessRights(session);
    }


    SubQuery[] getSubqueries(Session session) {


        OrderedHashSet subQueries = null;


        if (expression != null) {
            subQueries = expression.collectAllSubqueries(subQueries);
        }


        if (subQueries == null || subQueries.size() == 0) {
            return SubQuery.emptySubqueryArray;
        }


        SubQuery[] subQueryArray = new SubQuery[subQueries.size()];


        subQueries.toArray(subQueryArray);
        ArraySort.sort(subQueryArray, 0, subQueryArray.length,
                       subQueryArray[0]);


        for (int i = 0; i < subqueries.length; i++) {
            subQueryArray[i].prepareTable(session);

View Full Code Here

        return result;
    }


    public void resolve(Session session) {


        references = new OrderedHashSet();


        switch (operationType) {


            case StatementSet.TRIGGER_SET :
                for (int i = 0; i < updateExpressions.length; i++) {

View Full Code Here


                    if (isQuery) {
                        break;
                    }


                    OrderedHashSet columnNames = new OrderedHashSet();


                    readSimpleColumnNames(columnNames, table);
                    readThis(Tokens.CLOSEBRACKET);


                    colCount  = columnNames.size();
                    columnMap = table.getColumnIndexes(columnNames);


                    if (token.tokenType != Tokens.VALUES
                            && token.tokenType != Tokens.OVERRIDING) {
                        break;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.lib.OrderedHashSet

org.hsqldb.Collation

org.hsqldb.ColumnSchema

org.hsqldb.Constraint

org.hsqldb.Database$TimeoutRunner

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.Expression

org.hsqldb.ExpressionColumn

org.hsqldb.ExpressionLogical

org.hsqldb.index.IndexAVL

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.