org.hsqldb.navigator

Class RowSetNavigatorDataTable

java.lang.Object

org.hsqldb.navigator.RowSetNavigator

org.hsqldb.navigator.RowSetNavigatorData

org.hsqldb.navigator.RowSetNavigatorDataTable

All Implemented Interfaces:

java.util.Comparator, RangeIterator, RowIterator

public class RowSetNavigatorDataTable
extends RowSetNavigatorData

Implementation of RowSetNavigator using a table as the data store.

Since:

1.9.0

Field Summary

Fields

Modifier and Type	Field and Description
PersistentStore	store
TableBase	table

Fields inherited from class org.hsqldb.navigator.RowSetNavigatorData

emptyTable

Constructor Summary

Constructors

Constructor and Description
RowSetNavigatorDataTable(Session session, QueryExpression queryExpression)
RowSetNavigatorDataTable(Session session, QuerySpecification select)
RowSetNavigatorDataTable(Session session, QuerySpecification select, RowSetNavigatorData navigator)
RowSetNavigatorDataTable(Session session, TableBase table)

Method Summary

Modifier and Type	Method and Description
boolean	absolute(int position) Uses similar semantics to java.sql.ResultSet except this is 0 based.
void	add(java.lang.Object[] data) Add data to the end
void	clear() Clear the contents
void	copy(RowSetNavigatorData other, int[] rightColumnIndexes)
void	except(Session session, RowSetNavigatorData other)
void	exceptAll(Session session, RowSetNavigatorData other)
java.lang.Object[]	getCurrent() Returns the current row object.
Row	getCurrentRow()
java.lang.Object[]	getData(java.lang.Long rowId)
java.lang.Object[]	getGroupData(java.lang.Object[] data) Special case for isSimpleAggregate cannot use index lookup.
boolean	hasUniqueNotNullRows(Session session)
void	intersect(Session session, RowSetNavigatorData other)
void	intersectAll(Session session, RowSetNavigatorData other)
boolean	isMemory()
boolean	next()
void	read(RowInputInterface in, ResultMetaData meta)
void	release() Remove any resourses and invalidate
void	removeCurrent() Remove current row
void	removeDuplicates(Session session)
void	reset() Reset to initial state
void	sortFull(Session session)
void	sortOrder(Session session)
void	sortOrderUnion(Session session, SortAndSlice sortAndSlice)
void	trim(int limitstart, int limitcount)
void	union(Session session, RowSetNavigatorData other)
void	update(java.lang.Object[] oldData, java.lang.Object[] newData)
void	write(RowOutputInterface out, ResultMetaData meta)

Methods inherited from class org.hsqldb.navigator.RowSetNavigatorData

addRow, compare, copy, getData, getNextRowData, unionAll

Methods inherited from class org.hsqldb.navigator.RowSetNavigator

afterLast, beforeFirst, first, getCurrent, getId, getNext, getNextRow, getRangePosition, getRowid, getRowId, getRowidObject, getRowNumber, getSession, getSize, hasNext, isAfterLast, isBeforeFirst, isEmpty, isFirst, isLast, last, previous, readSimple, relative, setCurrent, setId, setRowColumns, setSession, writeSimple

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.util.Comparator

comparing, comparing, comparingDouble, comparingInt, comparingLong, equals, naturalOrder, nullsFirst, nullsLast, reversed, reverseOrder, thenComparing, thenComparing, thenComparing, thenComparingDouble, thenComparingInt, thenComparingLong

Field Detail

table

public TableBase table

store

public PersistentStore store

Constructor Detail

RowSetNavigatorDataTable

public RowSetNavigatorDataTable(Session session,
                                QuerySpecification select)

RowSetNavigatorDataTable

public RowSetNavigatorDataTable(Session session,
                                QuerySpecification select,
                                RowSetNavigatorData navigator)

RowSetNavigatorDataTable

public RowSetNavigatorDataTable(Session session,
                                QueryExpression queryExpression)

RowSetNavigatorDataTable

public RowSetNavigatorDataTable(Session session,
                                TableBase table)

Method Detail

sortFull

public void sortFull(Session session)

Overrides:

sortFull in class RowSetNavigatorData

sortOrder

public void sortOrder(Session session)

Overrides:

sortOrder in class RowSetNavigatorData

sortOrderUnion

public void sortOrderUnion(Session session,
                           SortAndSlice sortAndSlice)

Overrides:

sortOrderUnion in class RowSetNavigatorData

add

public void add(java.lang.Object[] data)

Description copied from class: RowSetNavigator

Add data to the end

Overrides:

add in class RowSetNavigatorData

update

public void update(java.lang.Object[] oldData,
                   java.lang.Object[] newData)

Overrides:

update in class RowSetNavigatorData

absolute

public boolean absolute(int position)

Description copied from class: RowSetNavigator

Uses similar semantics to java.sql.ResultSet except this is 0 based. When position is 0 or positive, it is from the start; when negative, it is from end

Overrides:

absolute in class RowSetNavigatorData

getCurrent

public java.lang.Object[] getCurrent()

Description copied from class: RowSetNavigator

Returns the current row object. Type of object is implementation defined.

Specified by:

getCurrent in interface RangeIterator

Overrides:

getCurrent in class RowSetNavigatorData

getCurrentRow

public Row getCurrentRow()

Specified by:

getCurrentRow in interface RangeIterator

Overrides:

getCurrentRow in class RowSetNavigatorData

next

public boolean next()

Specified by:

next in interface RangeIterator

Overrides:

next in class RowSetNavigatorData

removeCurrent

public void removeCurrent()

Description copied from class: RowSetNavigator

Remove current row

Specified by:

removeCurrent in interface RowIterator

Overrides:

removeCurrent in class RowSetNavigatorData

reset

public void reset()

Description copied from class: RowSetNavigator

Reset to initial state

Specified by:

reset in interface RangeIterator

Overrides:

reset in class RowSetNavigatorData

release

public void release()

Description copied from class: RowSetNavigator

Remove any resourses and invalidate

Specified by:

release in interface RowIterator

Overrides:

release in class RowSetNavigatorData

clear

public void clear()

Description copied from class: RowSetNavigator

Clear the contents

Overrides:

clear in class RowSetNavigatorData

isMemory

public boolean isMemory()

Overrides:

isMemory in class RowSetNavigatorData

read

public void read(RowInputInterface in,
                 ResultMetaData meta)
          throws java.io.IOException

Overrides:

read in class RowSetNavigatorData

Throws:

java.io.IOException

write

public void write(RowOutputInterface out,
                  ResultMetaData meta)
           throws java.io.IOException

Overrides:

write in class RowSetNavigatorData

Throws:

java.io.IOException

getData

public java.lang.Object[] getData(java.lang.Long rowId)

copy

public void copy(RowSetNavigatorData other,
                 int[] rightColumnIndexes)

union

public void union(Session session,
                  RowSetNavigatorData other)

Overrides:

union in class RowSetNavigatorData

intersect

public void intersect(Session session,
                      RowSetNavigatorData other)

Overrides:

intersect in class RowSetNavigatorData

intersectAll

public void intersectAll(Session session,
                         RowSetNavigatorData other)

Overrides:

intersectAll in class RowSetNavigatorData

except

public void except(Session session,
                   RowSetNavigatorData other)

Overrides:

except in class RowSetNavigatorData

exceptAll

public void exceptAll(Session session,
                      RowSetNavigatorData other)

Overrides:

exceptAll in class RowSetNavigatorData

hasUniqueNotNullRows

public boolean hasUniqueNotNullRows(Session session)

Overrides:

hasUniqueNotNullRows in class RowSetNavigatorData

removeDuplicates

public void removeDuplicates(Session session)

Overrides:

removeDuplicates in class RowSetNavigatorData

trim

public void trim(int limitstart,
                 int limitcount)

Overrides:

trim in class RowSetNavigatorData

getGroupData

public java.lang.Object[] getGroupData(java.lang.Object[] data)

Special case for isSimpleAggregate cannot use index lookup.

Overrides:

getGroupData in class RowSetNavigatorData