|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectorg.h2.engine.DbObjectBase
org.h2.schema.SchemaObjectBase
org.h2.table.Table
org.h2.table.RangeTable
public class RangeTable
The table SYSTEM_RANGE is a virtual table that generates incrementing numbers with a given start end end point.
| Field Summary | |
|---|---|
static java.lang.String |
NAME
The name of the range table. |
| Fields inherited from class org.h2.table.Table |
|---|
columns, compareMode, EXTERNAL_TABLE_ENGINE, isHidden, SYSTEM_TABLE, TABLE, TABLE_LINK, TYPE_CACHED, TYPE_MEMORY, VIEW |
| Fields inherited from class org.h2.engine.DbObjectBase |
|---|
comment, database, trace |
| Fields inherited from interface org.h2.engine.DbObject |
|---|
AGGREGATE, COMMENT, CONSTANT, CONSTRAINT, FUNCTION_ALIAS, INDEX, RIGHT, ROLE, SCHEMA, SEQUENCE, SETTING, TABLE_OR_VIEW, TRIGGER, USER, USER_DATATYPE |
| Constructor Summary | |
|---|---|
RangeTable(Schema schema,
Expression min,
Expression max,
boolean noColumns)
Create a new range with the given start and end expressions. |
|
| Method Summary | |
|---|---|
Index |
addIndex(Session session,
java.lang.String indexName,
int indexId,
IndexColumn[] cols,
IndexType indexType,
boolean create,
java.lang.String indexComment)
Create an index for this table |
void |
addRow(Session session,
Row row)
Add a row to the table and all indexes. |
boolean |
canDrop()
Check if this table can be dropped. |
boolean |
canGetRowCount()
Check if the row count can be retrieved quickly. |
boolean |
canReference()
Check if this table can be referenced. |
void |
checkRename()
Check if this object can be renamed. |
void |
checkSupportAlter()
Check if this table supports ALTER TABLE. |
void |
close(Session session)
Close the table object and flush changes. |
java.lang.String |
getCreateSQL()
Build a SQL statement to re-create this object. |
java.lang.String |
getDropSQL()
Build a SQL statement to drop this object. |
java.util.ArrayList<Index> |
getIndexes()
Get all indexes for this table. |
long |
getMax(Session session)
Calculate and get the end value of this range. |
long |
getMaxDataModificationId()
Get the last data modification id. |
long |
getMin(Session session)
Calculate and get the start value of this range. |
long |
getRowCount(Session session)
Get the row count for this table. |
long |
getRowCountApproximation()
Get the approximated row count for this table. |
Index |
getScanIndex(Session session)
Get the scan index to iterate through all rows. |
java.lang.String |
getSQL()
Get the SQL name of this object (may be quoted). |
java.lang.String |
getTableType()
Get the table type name |
Index |
getUniqueIndex()
Get any unique index for this table if one exists. |
boolean |
isDeterministic()
Check if the table is deterministic. |
boolean |
isLockedExclusively()
Check if this table is locked exclusively. |
void |
lock(Session session,
boolean exclusive,
boolean force)
Lock the table for the given session. |
void |
removeRow(Session session,
Row row)
Remove a row from the table and all indexes. |
void |
truncate(Session session)
Remove all rows from the table and indexes. |
void |
unlock(Session s)
Release the lock for this session. |
| Methods inherited from class org.h2.schema.SchemaObjectBase |
|---|
getSchema, initSchemaObjectBase |
| Methods inherited from class org.h2.engine.DbObjectBase |
|---|
getComment, getDatabase, getId, getModificationId, getName, initDbObjectBase, invalidate, isTemporary, setComment, setModified, setObjectName, setTemporary, toString |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Methods inherited from interface org.h2.engine.DbObject |
|---|
getComment, getDatabase, getId, getName, isTemporary, setComment, setTemporary |
| Field Detail |
|---|
public static final java.lang.String NAME
| Constructor Detail |
|---|
public RangeTable(Schema schema,
Expression min,
Expression max,
boolean noColumns)
schema - the schema (always the main schema)min - the start expressionmax - the end expressionnoColumns - whether this table has no columns| Method Detail |
|---|
public java.lang.String getDropSQL()
DbObjectBase
getDropSQL in interface DbObjectgetDropSQL in class DbObjectBasepublic java.lang.String getCreateSQL()
DbObjectBase
getCreateSQL in interface DbObjectgetCreateSQL in class DbObjectBasepublic java.lang.String getSQL()
DbObject
getSQL in interface DbObjectgetSQL in class SchemaObjectBase
public void lock(Session session,
boolean exclusive,
boolean force)
Table
lock in class Tablesession - the sessionexclusive - true for write locks, false for read locksforce - lock even in the MVCC modepublic void close(Session session)
Table
close in class Tablesession - the sessionpublic void unlock(Session s)
Table
unlock in class Tables - the sessionpublic boolean isLockedExclusively()
Table
isLockedExclusively in class Table
public Index addIndex(Session session,
java.lang.String indexName,
int indexId,
IndexColumn[] cols,
IndexType indexType,
boolean create,
java.lang.String indexComment)
Table
addIndex in class Tablesession - the sessionindexName - the name of the indexindexId - the idcols - the index columnsindexType - the index typecreate - whether this is a new indexindexComment - the comment
public void removeRow(Session session,
Row row)
Table
removeRow in class Tablesession - the sessionrow - the row
public void addRow(Session session,
Row row)
Table
addRow in class Tablesession - the sessionrow - the rowpublic void checkSupportAlter()
Table
checkSupportAlter in class Tablepublic void checkRename()
DbObjectBase
checkRename in interface DbObjectcheckRename in class DbObjectBasepublic boolean canGetRowCount()
Table
canGetRowCount in class Tablepublic boolean canDrop()
Table
canDrop in class Tablepublic long getRowCount(Session session)
Table
getRowCount in class Tablesession - the session
public java.lang.String getTableType()
Table
getTableType in class Tablepublic Index getScanIndex(Session session)
Table
getScanIndex in class Tablesession - the session
public long getMin(Session session)
session - the session
public long getMax(Session session)
session - the session
public java.util.ArrayList<Index> getIndexes()
Table
getIndexes in class Tablepublic void truncate(Session session)
Table
truncate in class Tablesession - the sessionpublic long getMaxDataModificationId()
Table
getMaxDataModificationId in class Tablepublic Index getUniqueIndex()
Table
getUniqueIndex in class Tablepublic long getRowCountApproximation()
Table
getRowCountApproximation in class Tablepublic boolean isDeterministic()
Table
isDeterministic in class Tablepublic boolean canReference()
Table
canReference in class Table
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||