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

                    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

        pointerLookup.setKeysSearchTarget();
        database.logger.logDetailEvent("lookup begins " + table.getName().name
                                       + " " + stopw.elapsedTime());


        // all rows
        RowIterator it = table.rowIteratorClustered(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            pointerLookup.addUnsorted(row.getPos(), (int) (pos / scale));


            if (count != 0 && count % 100000 == 0) {
                database.logger.logDetailEvent("pointer pair for row " + count
                                               + " " + row.getPos() + " "
                                               + pos);
            }


            pos += row.getStorageSize();
        }


        database.logger.logDetailEvent("table read " + table.getName().name
                                       + " " + stopw.elapsedTime());


        count = 0;
        it    = table.rowIteratorClustered(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            rowOut.reset();
            row.write(rowOut, pointerLookup);
            randomAccessOut.write(rowOut.getOutputStream().getBuffer(), 0,
                                  rowOut.size());

View Full Code Here

        for (int i = 0, tSize = allTables.size(); i < tSize; i++) {
            Table t     = (Table) allTables.get(i);
            int   count = 0;


            if (t.getTableType() == TableBase.CACHED_TABLE) {
                RowIterator it = t.rowIterator(session);


                for (; it.hasNext(); count++) {
                    CachedObject row = it.getNextRow();
                }


                System.out.println("table " + t.getName().name + " " + count);
            }
        }

View Full Code Here


    private void resetAccessorKeysForCached() {


        RowStoreAVLHybrid tempStore = new RowStoreAVLHybridExtended(session,
            table);
        RowIterator iterator = table.rowIterator(this);


        while (iterator.hasNext()) {
            Row row = iterator.getNextRow();
            Row newRow = (Row) tempStore.getNewCachedObject(session,
                row.getData(), false);


            tempStore.indexRow(session, newRow);
        }

View Full Code Here


        for (int i = 1; i < indexList.length; i++) {
            setAccessor(indexList[i], null);
        }


        RowIterator it = rowIterator();


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


            ((RowAVL) row).clearNonPrimaryNodes();


            for (int i = 1; i < indexList.length; i++) {
                indexList[i].insert(session, this, row);

View Full Code Here

            oldtype = ((Table) other.getTable()).getColumnTypes()[colindex];
        }


        try {
            Table       table = (Table) this.table;
            RowIterator it    = other.rowIterator();


            while (it.hasNext()) {
                Row      row      = it.getNextRow();
                Object[] olddata  = row.getData();
                Object[] data     = table.getEmptyRowData();
                Object   oldvalue = null;


                if (adjust == 0 && colindex != -1) {
                    oldvalue = olddata[colindex];
                    colvalue = newtype.convertToType(session, oldvalue,
                                                     oldtype);
                }


                ArrayUtil.copyAdjustArray(olddata, data, colvalue, colindex,
                                          adjust);
                table.systemSetIdentityColumn(session, data);


                if (table.hasGeneratedColumn()) {
                    ((Table) table).setGeneratedColumns(session, data);
                }


                table.enforceTypeLimits(session, data);
                table.enforceRowConstraints(session, data);


                // get object without RowAction
                Row newrow = (Row) getNewCachedObject(session, data, false);


                indexRow(session, newrow);
            }


            if (table.isTemp()) {
                return;
            }


            if (oldtype != null && oldtype.isLobType()) {
                it = other.rowIterator();


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


                    if (oldvalue != null) {
                        session.sessionData.adjustLobUsageCount(oldvalue, -1);
                    }
                }
            }


            if (newtype != null && newtype.isLobType()) {
                it = rowIterator();


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


                    if (value != null) {
                        session.sessionData.adjustLobUsageCount(value, +1);

View Full Code Here


    public void reindex(Session session, Index index) {


        setAccessor(index, null);


        RowIterator it = table.rowIterator(this);


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


            row.getNode(index.getPosition()).delete();
            index.insert(session, this, row);
        }
    }

View Full Code Here


    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;

View Full Code Here

    }


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


            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;

View Full Code Here

    }


    Result executeDeleteTruncateStatement(Session session) {


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


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


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


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


        return Result.updateOneResult;
    }

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.