Examples of org.hsqldb.Row

org.hsqldb.Row
Base class for a database row object. @author Fred Toussi (fredt@users dot sourceforge dot net) @version 1.9.0

            }


            nodeData = c.getData(store);


            if (compareRow(session, data, nodeData) == 0) {
                Row row = c.getRow(store);


                if (session.database.txManager.canRead(
                        session, row, TransactionManager.ACTION_DUP, null)) {
                    return true;
                }


                continue;
            }


            break;
        }


        while (true) {
            c = next(session, store, node);


            if (c == null) {
                break;
            }


            nodeData = c.getData(store);


            if (compareRow(session, data, nodeData) == 0) {
                Row row = c.getRow(store);


                if (session.database.txManager.canRead(
                        session, row, TransactionManager.ACTION_DUP, null)) {
                    return true;
                }

View Full Code Here


        try {
            NodeAVL x          = getAccessor(store);
            NodeAVL n          = null;
            NodeAVL result     = null;
            Row     currentRow = null;


            if (compareType != OpTypes.EQUAL
                    && compareType != OpTypes.IS_NULL) {
                fieldCount--;
            }


            while (x != null) {
                currentRow = x.getRow(store);


                int i = 0;


                if (fieldCount > 0) {
                    i = compareRowNonUnique(session, currentRow.getData(),
                                            rowdata, rowColMap, fieldCount);
                }


                if (i == 0) {
                    switch (compareType) {


                        case OpTypes.IS_NULL :
                        case OpTypes.EQUAL : {
                            result = x;
                            n      = x.getLeft(store);


                            break;
                        }
                        case OpTypes.NOT :
                        case OpTypes.GREATER : {
                            i = compareObject(session, currentRow.getData(),
                                              rowdata, rowColMap, fieldCount);


                            if (i <= 0) {
                                n = x.getRight(store);
                            } else {
                                result = x;
                                n      = x.getLeft(store);
                            }


                            break;
                        }
                        case OpTypes.GREATER_EQUAL : {
                            i = compareObject(session, currentRow.getData(),
                                              rowdata, rowColMap, fieldCount);


                            if (i < 0) {
                                n = x.getRight(store);
                            } else {
                                result = x;
                                n      = x.getLeft(store);
                            }


                            break;
                        }
                        case OpTypes.SMALLER : {
                            i = compareObject(session, currentRow.getData(),
                                              rowdata, rowColMap, fieldCount);


                            if (i < 0) {
                                result = x;
                                n      = x.getRight(store);
                            } else {
                                n = x.getLeft(store);
                            }


                            break;
                        }
                        case OpTypes.SMALLER_EQUAL : {
                            i = compareObject(session, currentRow.getData(),
                                              rowdata, rowColMap, fieldCount);


                            if (i <= 0) {
                                result = x;
                                n      = x.getRight(store);
                            } else {
                                n = x.getLeft(store);
                            }


                            break;
                        }
                        default :
                            Error.runtimeError(ErrorCode.U_S0500, "Index");
                    }
                } else if (i < 0) {
                    n = x.getRight(store);
                } else if (i > 0) {
                    n = x.getLeft(store);
                }


                if (n == null) {
                    break;
                }


                x = n;
            }


            // MVCC 190
            if (session == null) {
                return result;
            }


            while (result != null) {
                currentRow = result.getRow(store);


                if (session.database.txManager.canRead(session, currentRow,
                                                       readMode, colIndex)) {
                    break;
                }


                result = reversed ? last(store, result)
                                  : next(store, result);


                if (result == null) {
                    break;
                }


                currentRow = result.getRow(store);


                if (fieldCount > 0
                        && compareRowNonUnique(
                            session, currentRow.getData(), rowdata, rowColMap,
                            fieldCount) != 0) {
                    result = null;


                    break;
                }

View Full Code Here


        try {
            NodeAVL x          = getAccessor(store);
            NodeAVL n          = null;
            NodeAVL result     = null;
            Row     currentRow = null;


            while (x != null) {
                currentRow = x.getRow(store);


                int i = colTypes[0].compare(session, data,
                                            currentRow.getData()[colIndex[0]]);


                switch (compareType) {


                    case OpTypes.IS_NULL :
                    case OpTypes.EQUAL : {
                        if (i == 0) {
                            result = x;
                            n      = x.getLeft(store);


                            break;
                        } else if (i > 0) {
                            n = x.getRight(store);
                        } else if (i < 0) {
                            n = x.getLeft(store);
                        }


                        break;
                    }
                    case OpTypes.NOT :
                    case OpTypes.GREATER : {
                        if (i >= 0) {
                            n = x.getRight(store);
                        } else {
                            result = x;
                            n      = x.getLeft(store);
                        }


                        break;
                    }
                    case OpTypes.GREATER_EQUAL : {
                        if (i > 0) {
                            n = x.getRight(store);
                        } else {
                            result = x;
                            n      = x.getLeft(store);
                        }


                        break;
                    }
                    default :
                        Error.runtimeError(ErrorCode.U_S0500, "Index");
                }


                if (n == null) {
                    break;
                }


                x = n;
            }


            // MVCC 190
            if (session == null) {
                return result;
            }


            while (result != null) {
                currentRow = result.getRow(store);


                if (session.database.txManager.canRead(session, currentRow,
                                                       readMode, colIndex)) {
                    break;
                }


                result = next(store, result);


                if (compareType == OpTypes.EQUAL) {
                    if (colTypes[0].compare(
                            session, data,
                            currentRow.getData()[colIndex[0]]) != 0) {
                        result = null;


                        break;
                    }
                }

View Full Code Here

            return lastrow;
        }


        public Object[] getNext() {


            Row row = getNextRow();


            return row == null ? null
                               : row.getData();
        }

View Full Code Here

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


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


            ((RowAVL) row).clearNonPrimaryNodes();


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

View Full Code Here

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


        try {
            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);
                }


                if (colvalue != null && newtype.isLobType()) {
                    session.sessionData.adjustLobUsageCount(colvalue, +1);
                }


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


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


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


                indexRow(null, newrow);
            }
        } catch (java.lang.OutOfMemoryError e) {
            throw Error.error(ErrorCode.OUT_OF_MEMORY);

View Full Code Here


        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

        int           rowCount = 0;
        HsqlException error    = null;


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


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


                // count before inserting
                rowCount++;


                newIndex.insert(null, 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

        setAccessor(index, null);


        RowIterator it = table.rowIterator(this);


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


            // may need to clear the node before insert
            index.insert(session, this, row);
        }
    }

View Full Code Here

    }


    public void add(Object[] data) {


        try {
            Row row = (Row) store.getNewCachedObject(session, data);


            store.indexRow(null, row);


            size++;
        } catch (HsqlException e) {}

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.Row

org.hsqldb.index.IndexAVL

org.hsqldb.index.IndexAVL$IndexRowIterator

org.hsqldb.index.IndexAVLMemory

org.hsqldb.navigator.RowSetNavigatorData

org.hsqldb.navigator.RowSetNavigatorDataTable

org.hsqldb.persist.DataFileCacheSession

org.hsqldb.persist.DataFileDefrag

org.hsqldb.persist.RowStoreAVL

org.hsqldb.persist.RowStoreAVLDisk

org.hsqldb.persist.RowStoreAVLDiskData

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.