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


    public void writeUnlock() {}


    void dropIndexFromRows(Index primaryIndex, Index oldIndex) {


        RowIterator it       = primaryIndex.firstRow(this);
        int         position = oldIndex.getPosition() - 1;


        while (it.hasNext()) {
            Row     row      = it.getNextRow();
            int     i        = position - 1;
            NodeAVL backnode = ((RowAVL) row).getNode(0);


            while (i-- > 0) {
                backnode = backnode.nNext;
            }


            backnode.nNext = backnode.nNext.nNext;
        }


        it.release();
    }

View Full Code Here


    boolean insertIndexNodes(Session session, Index primaryIndex,
                             Index newIndex) {


        int           position = newIndex.getPosition();
        RowIterator   it       = primaryIndex.firstRow(this);
        int           rowCount = 0;
        HsqlException error    = null;


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


                ((RowAVL) row).insertNode(position);


                // count before inserting
                rowCount++;


                newIndex.insert(session, this, row);
            }


            it.release();


            return true;
        } catch (java.lang.OutOfMemoryError e) {
            error = Error.error(ErrorCode.OUT_OF_MEMORY);
        } catch (HsqlException e) {
            error = e;
        }


        // backtrack on error
        // rowCount rows have been modified
        it = primaryIndex.firstRow(this);


        for (int i = 0; i < rowCount; i++) {
            Row     row      = it.getNextRow();
            NodeAVL backnode = ((RowAVL) row).getNode(0);
            int     j        = position;


            while (--j > 0) {
                backnode = backnode.nNext;
            }


            backnode.nNext = backnode.nNext.nNext;
        }


        it.release();


        throw error;
    }

View Full Code Here

                }


                newAccessorList[i] = cache.get(pos, this, false);
            }


            RowIterator it = rowIterator();


            // todo - check this - must remove from old space, not new one
            while (it.hasNext()) {
                Row row = it.getNextRow();


                cache.remove(row);
                tableSpace.release(row.getPos(), row.getStorageSize());
            }

View Full Code Here

                                LongLookup pointerLookup) {


        int spaceId = table.getSpaceID();
        TableSpaceManager targetSpace =
            targetCache.spaceManager.getTableSpace(spaceId);
        RowIterator it = rowIterator();


        while (it.hasNext()) {
            CachedObject row = it.getNextRow();
            long newPos = targetSpace.getFilePosition(row.getStorageSize(),
                false);


            pointerLookup.addUnsorted(row.getPos(), newPos);
        }


        it = rowIterator();


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


            targetCache.rowOut.reset();
            row.write(targetCache.rowOut, pointerLookup);


            long pos = pointerLookup.lookup(row.getPos());

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

        return false;
    }


    public Object[] getValues(Session session) {


        RowIterator it = 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

     * 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

     * @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

    }


    Result executeDeleteTruncateStatement(Session session) {


        PersistentStore store   = targetTable.getRowStore(session);
        RowIterator     it = targetTable.getPrimaryIndex().firstRow(store);
        boolean         hasData = it.hasNext();


        for (int i = 0; i < targetTable.fkMainConstraints.length; i++) {
            if (targetTable.fkMainConstraints[i].getRef() != targetTable) {
                HsqlName tableName =
                    targetTable.fkMainConstraints[i].getRef().getName();
                Table refTable =
                    session.database.schemaManager.getUserTable(session,
                        tableName);


                if (!refTable.isEmpty(session)) {
                    throw Error.error(ErrorCode.X_23504,
                                      refTable.getName().name);
                }
            }
        }


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


                session.addDeleteAction((Table) row.getTable(), store, row,
                                        null);
            }


            if (restartIdentity && targetTable.identitySequence != null) {
                targetTable.identitySequence.reset();
            }
        } finally {
            it.release();
        }


        if (!hasData) {
            session.addWarning(HsqlException.noDataCondition);
        }

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.