Examples of org.hsqldb.navigator.RowIterator

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

                        session, row.getData(), data, c.core.mainCols) == 0) {
                    continue;
                }
            }


            RowIterator refiterator = c.findFkRef(session, row.getData());


            if (!refiterator.hasNext()) {
                refiterator.release();


                continue;
            }


            while (refiterator.hasNext()) {
                Row      refRow  = refiterator.getNextRow();
                Object[] refData = null;


                /** @todo use MATCH */
                if (c.core.refIndex.compareRowNonUnique(
                        session, refRow.getData(), row.getData(),
                        c.core.mainCols) != 0) {
                    break;
                }


                if (delete && refRow.getId() == row.getId()) {
                    continue;
                }


                switch (action) {


                    case SchemaObject.ReferentialAction.CASCADE : {
                        if (delete) {
                            boolean result;


                            try {
                                result = navigator.addRow(refRow);
                            } catch (HsqlException e) {
                                String[] info = getConstraintInfo(c);


                                refiterator.release();


                                throw Error.error(null, ErrorCode.X_27000,
                                                  ErrorCode.CONSTRAINT, info);
                            }


                            if (result) {
                                performReferentialActions(session,
                                                          c.core.refTable,
                                                          navigator, refRow,
                                                          null, null, path);
                            }


                            continue;
                        }


                        refData = c.core.refTable.getEmptyRowData();


                        System.arraycopy(refRow.getData(), 0, refData, 0,
                                         refData.length);


                        for (int j = 0; j < c.core.refCols.length; j++) {
                            refData[c.core.refCols[j]] =
                                data[c.core.mainCols[j]];
                        }


                        break;
                    }
                    case SchemaObject.ReferentialAction.SET_NULL : {
                        refData = c.core.refTable.getEmptyRowData();


                        System.arraycopy(refRow.getData(), 0, refData, 0,
                                         refData.length);


                        for (int j = 0; j < c.core.refCols.length; j++) {
                            refData[c.core.refCols[j]] = null;
                        }


                        break;
                    }
                    case SchemaObject.ReferentialAction.SET_DEFAULT : {
                        refData = c.core.refTable.getEmptyRowData();


                        System.arraycopy(refRow.getData(), 0, refData, 0,
                                         refData.length);


                        for (int j = 0; j < c.core.refCols.length; j++) {
                            ColumnSchema col =
                                c.core.refTable.getColumn(c.core.refCols[j]);


                            refData[c.core.refCols[j]] =
                                col.getDefaultValue(session);
                        }


                        break;
                    }
                    case SchemaObject.ReferentialAction.NO_ACTION :
                        if (navigator.containsDeletedRow(refRow)) {
                            continue;
                        }


                    // fall through
                    case SchemaObject.ReferentialAction.RESTRICT : {
                        int errorCode = c.core.deleteAction
                                        == SchemaObject.ReferentialAction
                                            .NO_ACTION ? ErrorCode.X_23504
                                                       : ErrorCode.X_23001;
                        String[] info = getConstraintInfo(c);


                        refiterator.release();


                        throw Error.error(null, errorCode,
                                          ErrorCode.CONSTRAINT, info);
                    }
                    default :
                        continue;
                }


                try {
                    refData =
                        navigator.addRow(session, refRow, refData,
                                         c.core.refTable.getColumnTypes(),
                                         c.core.refCols);
                } catch (HsqlException e) {
                    String[] info = getConstraintInfo(c);


                    refiterator.release();


                    throw Error.error(null, ErrorCode.X_27000,
                                      ErrorCode.CONSTRAINT, info);
                }


                if (refData == null) {


                    // happens only with enforceDeleteOrUpdate=false and updated row is already deleted
                    continue;
                }


                if (!path.add(c)) {
                    continue;
                }


                performReferentialActions(session, c.core.refTable, navigator,
                                          refRow, refData, c.core.refCols,
                                          path);
                path.remove(c);
            }


            refiterator.release();
        }
    }

View Full Code Here


        database.getGranteeManager().removeDbObject(table.getName());
        table.releaseTriggers();


        if (!table.isView() && table.hasLobColumn()) {
            RowIterator it = table.rowIterator(session);


            while (it.hasNext()) {
                Row      row  = it.getNextRow();
                Object[] data = row.getData();


                session.sessionData.adjustLobUsageCount(table, data, -1);
            }
        }

View Full Code Here

        return result;
    }


    public Object[] getValues(Session session) {


        RowIterator it = table.rowIterator(session);


        if (it.hasNext()) {
            Row row = it.getNextRow();


            if (it.hasNext()) {
                throw Error.error(ErrorCode.X_21000);
            }


            return row.getData();
        } else {

View Full Code Here

        int count = 0;


        readLock.lock();


        try {
            RowIterator it = firstRow(session, store);


            while (it.hasNext()) {
                it.getNextRow();


                count++;
            }


            return count;

View Full Code Here

     * @param newCol Column
     */
    void checkConvertColDataType(ColumnSchema oldCol, ColumnSchema newCol) {


        int         colIndex = table.getColumnIndex(oldCol.getName().name);
        RowIterator it       = table.rowIterator(session);


        while (it.hasNext()) {
            Row    row = it.getNextRow();
            Object o   = row.getData()[colIndex];


            if (!newCol.isNullable() && o == null) {
                throw Error.error(ErrorCode.X_23502);
            }

View Full Code Here


        Row             row   = null;
        PersistentStore store = getRowStore(session);


        if (hasPrimaryKey()) {
            RowIterator it = getPrimaryIndex().findFirstRow(session, store,
                data, primaryKeyColsSequence);


            row = it.getNextRow();


            it.release();
        } else if (bestIndex == null) {
            RowIterator it = rowIterator(session);


            while (true) {
                row = it.getNextRow();


                if (row == null) {
                    break;
                }


                if (Table.compareRows(
                        session, row.getData(), data, defaultColumnMap,
                        colTypes) == 0) {
                    break;
                }
            }


            it.release();
        } else {
            RowIterator it = bestIndex.findFirstRow(session, store, data);


            while (true) {
                row = it.getNextRow();


                if (row == null) {
                    break;
                }


                Object[] rowdata = row.getData();


                // reached end of range
                if (bestIndex.compareRowNonUnique(
                        session, rowdata, data, bestIndex.getColumns()) != 0) {
                    row = null;


                    break;
                }


                if (Table.compareRows(
                        session, rowdata, data, defaultColumnMap,
                        colTypes) == 0) {
                    break;
                }
            }


            it.release();
        }


        if (row == null) {
            return;
        }

View Full Code Here


                        table.insertIntoTable(session, result);
                    }


                    if (table.hasLobColumn) {
                        RowIterator it = table.rowIterator(session);


                        while (it.hasNext()) {
                            Row      row  = it.getNextRow();
                            Object[] data = row.getData();


                            session.sessionData.adjustLobUsageCount(table,
                                    data, 1);
                        }

View Full Code Here

                    if (script) {
                        schemaToLog = t.getName().schema;


                        writeTableInit(t);


                        RowIterator it =
                            t.rowIteratorClustered(currentSession);


                        while (it.hasNext()) {
                            Row row = it.getNextRow();


                            writeRow(currentSession, row, t);
                        }


                        writeTableTerm(t);

View Full Code Here


        database.getGranteeManager().removeDbObject(table.getName());
        table.releaseTriggers();


        if (table.hasLobColumn()) {
            RowIterator it = table.rowIterator(session);


            while (it.hasNext()) {
                Row      row  = it.getNextRow();
                Object[] data = row.getData();


                session.sessionData.adjustLobUsageCount(table, data, -1);
            }
        }

View Full Code Here

     * checks all rows of a table to ensure they all have a corresponding
     * row in the main table.
     */
    void checkReferencedRows(Session session, Table table) {


        RowIterator it = table.rowIterator(session);


        while (true) {
            Row row = it.getNextRow();


            if (row == null) {
                break;
            }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.navigator.RowIterator

org.hsqldb.Constraint

org.hsqldb.ExpressionLogical

org.hsqldb.index.IndexAVL

org.hsqldb.persist.DataFileDefrag

org.hsqldb.persist.RowStoreAVL

org.hsqldb.persist.RowStoreAVLDisk

org.hsqldb.persist.RowStoreAVLHybrid

org.hsqldb.persist.RowStoreAVLHybridExtended

org.hsqldb.persist.RowStoreAVLMemory

org.hsqldb.RangeVariable$FullRangeIterator

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.