HyperSQL Database 2.7.4 · org.hsqldb.Table · APIdia, the JavaDoc alternative

Modifier and Type	Field and Description
pack-priv PeriodDefinition	applicationPeriod
pack-priv int	cascadingDeletes
protected long	changeTimestamp
pack-priv Constraint[]	checkConstraints
pack-priv Expression[]	colDefaults
pack-priv boolean[]	colGenerated
pack-priv boolean[]	colMainFK
pack-priv boolean[]	colRefFK
public OrderedHashMap<String, ColumnSchema>	columnList
pack-priv boolean[]	colUpdated
pack-priv Constraint[]	constraintList
protected int[]	defaultColumnMap
private RangeVariable[]	defaultRanges
public static final Table[]	emptyArray Hides org.hsqldb.SchemaObject.emptyArray.
pack-priv Constraint[]	fkConstraints
pack-priv Constraint[]	fkMainConstraints
private boolean	hasDefaultValues
private boolean	hasDomainColumns
private boolean	hasGeneratedValues
private boolean	hasNotNullColumns
private boolean	hasUpdatedValues
pack-priv int	identityColumn
pack-priv NumberSequence	identitySequence
pack-priv boolean	isDropped
pack-priv int	referentialActions
pack-priv PeriodDefinition	systemPeriod
pack-priv int	systemPeriodEndColumn
pack-priv int	systemPeriodStartColumn
protected HsqlNameManager.HsqlName	tableName
pack-priv TriggerDef[]	triggerList
pack-priv TriggerDef[][]	triggerLists

Access	Constructor and Description
public	Table(Database database, HsqlNameManager.HsqlName name, int type)
public	Table(Table table, HsqlNameManager.HsqlName name) trigger transition table

Method Summary

Modifier and Type	Method and Description
public void	addColumn(ColumnSchema column) Performs the table level checks and adds a column to the table at the DDL level.
public void	addColumnNoCheck(ColumnSchema column)
public void	addConstraint(Constraint c) Adds a constraint.
pack-priv void	addTrigger(TriggerDef td, HsqlNameManager.HsqlName otherName) Adds a trigger.
pack-priv boolean	areColumnsNotNull(int[] indexes)
pack-priv void	checkColumnInCheckConstraint(int colIndex) Used for drop / retype column.
pack-priv void	checkColumnInFKConstraint(int index colIndex) Used for retype column.
pack-priv void	checkColumnInFKConstraint(int index of column colIndex, int referential action of the FK actionType) Used for column defaults and nullability.
public void	checkDataReadOnly() Used by INSERT, DELETE, UPDATE operations
pack-priv void	checkReferentialColumnsMatch(int[] column array from this Table col, Table the other Table object other, int[] column array from the other Table othercol) Match two valid, equal length, columns arrays for type of columns for referential constraints
pack-priv void	collectFKReadLocks(int[] columnMap, OrderedHashSet<HsqlNameManager.HsqlName> set) columnMap is null for deletes
pack-priv void	collectFKWriteLocks(int[] columnMap, OrderedHashSet<HsqlNameManager.HsqlName> set) columnMap is null for deletes
public static int	Returns: comparison result, -1,0,+1 compareRows(Session session, Object[] a full row a, Object[] a full row b, int[] array of column indexes to compare cols, Type[] array of column types for the full row coltypes) compares two full table rows based on a set of columns
public void	compile(Session session, SchemaObject parentObject) Overrides default org.hsqldb.SchemaObject.compile.
pack-priv Index	createIndexForColumns(Session session, int[] columns) Used to create an index automatically for system and temp tables.
public void	createPrimaryKey() Shortcut for creating default PK's.
public void	createPrimaryKey(HsqlNameManager.HsqlName indexName, int[] columns, boolean columnsNotNull) Creates a single or multi-column primary key and index.
public void	createPrimaryKeyConstraint(HsqlNameManager.HsqlName indexName, int[] columns, boolean columnsNotNull)
public void	enforceRowConstraints(Session session, Object[] data) Enforce not null and domain size constraints
public void	enforceTypeLimits(Session session, Object[] data) Enforce max field sizes according to SQL column definition.
public int	findColumn(String name) Returns the index of given column name or -1 if not found.
pack-priv int[]	findColumnIndexes(String[] list)
pack-priv Index.IndexUse[]	findIndexForColumns(Session session, OrderedIntHashSet set, int opType, boolean ordered)
pack-priv void	fireTriggers(Session session, int trigVecIndex, RowSetNavigatorDataChange rowSet)
pack-priv void	fireTriggers(Session session, int trigVecIndex, RowSetNavigator rowSet)
pack-priv void	fireTriggers(Session session, int trigVecIndex, Object[] oldData, Object[] newData, int[] cols) Fires all row-level triggers of the given set (trigger type)
public void	generateAndCheckData(Session session, Object[] data)
public void	generateDefaultForNull(Object[] data) for default values (not expressions)
public PeriodDefinition	getApplicationPeriod()
public Table	getBaseTable()
public int[]	getBaseTableColumnMap()
public int[]	getBestRowIdentifiers()
public HsqlNameManager.HsqlName	getCatalogName() Implements org.hsqldb.SchemaObject.getCatalogName. Returns the catalog name
public long	getChangeTimestamp() Implements org.hsqldb.SchemaObject.getChangeTimestamp.
public Index	getClusteredIndex()
public ColumnSchema	getColumn(int i) Returns the Column object at the given index
pack-priv boolean[]	getColumnCheckList(int[] columnIndexes)
public Object	getColumnDefaultOrGeneratedValue(Session session, ColumnSchema column, Object[] data)
public int	getColumnIndex(String name) Returns the index of given column name or throws if not found
pack-priv int[]	getColumnIndexes(OrderedHashSet<String> set)
public String[]	getColumnLabels()
public String	getColumnListSQL(int[] col, int len)
public String	getColumnListWithTypeSQL()
public int[]	getColumnMap() Returns direct mapping array.
public void	getColumnNames(boolean[] columnCheckList, Set<HsqlNameManager.HsqlName> set)
public OrderedHashSet<HsqlNameManager.HsqlName>	getColumnNameSet()
public OrderedHashSet<SchemaObject>	getComponents() Overrides default org.hsqldb.SchemaObject.getComponents.
public Constraint	getConstraint(String constraintName) return the named constraint
pack-priv int	getConstraintIndex(String constraintName) Return the position of the constraint within the list
public Constraint[]	getConstraints() Returns the list of constraints.
pack-priv OrderedHashSet<Constraint>	getContainingConstraints(int colIndex) Returns list of constraints dependent on more than one column
pack-priv OrderedHashSet<HsqlNameManager.HsqlName>	getContainingIndexNames(int colIndex)
public Expression	getDataExpression()
public RangeVariable[]	getDefaultRanges()
public Row	getDeleteRowFromLog(Session session, Object[] data) For log statements.
pack-priv OrderedHashSet<Constraint>	getDependentConstraints(int colIndex) Returns list of constraints dependent only on one column
pack-priv OrderedHashSet<Constraint>	getDependentConstraints(Constraint constraint) Returns list of MAIN constraints dependent on this PK or UNIQUE constraint
public OrderedHashSet<Constraint>	getDependentExternalConstraints()
pack-priv Constraint	getFKConstraintForColumns(Table tableMain, int[] mainCols, int[] refCols) Returns any foreign key constraint equivalent to the column sets
public Constraint[]	getFKConstraints() Returns the list of FK constraints.
public Index	getFullIndex(Session session) Returns an index on all the columns
pack-priv Index	getFullIndexForColumns(int[] cols) Finds an existing index for an ordered full column group
public long	getId() Overrides org.hsqldb.TableBase.getId. Used to create row id's
public int	getIdentityColumnIndex() Returns the identity column index.
pack-priv Index	getIndex(String indexName) Returns the Index object of the given name or null if not found.
pack-priv Index	getIndexForAllColumns(int[] cols) Finds an existing index for an unordered full column group
pack-priv synchronized Index	getIndexForColumn(Session session, int col) Finds an existing index for a column
pack-priv synchronized Index	getIndexForColumns(int[] cols) Finds an existing index for a column group - for persistent tables
pack-priv synchronized Index.IndexUse[]	getIndexForColumns(Session session, OrderedIntHashSet set, int opType, boolean ordered) Finds an existing index for a column set or create one for temporary tables.
pack-priv int	getIndexIndex(String indexName) Returns the index of the Index object of the given name or -1 if not found.
public final long[]	getIndexRootsArray() Return the list of file pointers to root nodes for this table's indexes.
public String	getIndexRootsSQL(long[] roots)
public final HsqlNameManager.HsqlName	getName() Implements org.hsqldb.SchemaObject.getName. Returns the HsqlName object fo the table
pack-priv int[]	getNewColumnMap() Returns empty mapping array.
public Object[]	getNewRowData(Session session) Returns array for a new row with SQL DEFAULT value for each column n where exists[n] is false.
pack-priv int	getNextConstraintIndex(int from, int type) Returns the next constraint of a given type
pack-priv Constraint	getNotNullConstraintForColumn(int colIndex)
public Grantee	getOwner() Implements org.hsqldb.SchemaObject.getOwner.
public Constraint	getPrimaryConstraint() Returns the primary constraint.
public QueryExpression	getQueryExpression()
public OrderedHashSet<HsqlNameManager.HsqlName>	getReferences() Overrides default org.hsqldb.SchemaObject.getReferences.
public OrderedHashSet<HsqlNameManager.HsqlName>	getReferencesForDependents()
public OrderedHashSet<HsqlNameManager.HsqlName>	getReferencesForScript()
public PersistentStore	getRowStore(Session session) Overrides org.hsqldb.TableBase.getRowStore. Path used for all stores
public HsqlNameManager.HsqlName	getSchemaName() Implements org.hsqldb.SchemaObject.getSchemaName. Returns the schema name.
public String	getSQL() Implements org.hsqldb.SchemaObject.getSQL.
pack-priv HsqlArrayList<String>	getSQL(OrderedHashSet<HsqlNameManager.HsqlName> resolved, OrderedHashSet<SchemaObject> unresolved)
public String	getSQLForClustered()
public String	getSQLForReadOnly()
public String	getSQLForTableSpace()
public String[]	getSQLForTextSource(boolean withHeader)
pack-priv Index	getSystemIndex(String indexName) Returns the Index object of the given name or null if not found.
public PeriodDefinition	getSystemPeriod()
public int	getSystemPeriodEndIndex()
public int	getSystemPeriodStartIndex()
public String	getTableTypeString()
pack-priv TriggerDef	getTrigger(String name) Returns a trigger.
public int	getTriggerIndex(String name)
public TriggerDef[]	getTriggers()
public HsqlArrayList<String>	getTriggerSQLArray()
public int	getType() Implements org.hsqldb.SchemaObject.getType.
pack-priv Constraint	getUniqueConstraintForColumns(int[] cols) Returns the UNIQUE or PK constraint with the given column signature.
public Constraint	getUniqueConstraintForIndex(Index index) Returns any unique Constraint using this index
pack-priv int[]	getUniqueNotNullColumnGroup(boolean[] usedColumns)
public Constraint	getUniqueOrPKConstraintForIndex(Index index) Returns any unique Constraint using this index
public OrderedHashSet<HsqlNameManager.HsqlName>	getUniquePKConstraintNames()
public int[]	getUpdatableColumns()
pack-priv Index	getUserIndex(String indexName) Returns the Index object of the given name or null if not found.
public boolean	hasGeneratedColumn()
public boolean	hasIdentityColumn()
public boolean	hasLobColumn()
pack-priv boolean	hasTrigger(int trigVecIndex)
public boolean	hasUpdatedColumn()
pack-priv int	indexTypeForColumn(Session session, int col)
public void	insertData(Session session, PersistentStore store, Object[] data, boolean enforceUnique) For system operations outside transaction control
public void	insertFromScript(Session session, PersistentStore store, Object[] data) Not for general use.
pack-priv void	insertIntoTable(Session session, Result result) Multi-row insert method.
public void	insertNoCheckFromLog(Session session, Object[] data)
pack-priv void	insertResult(Session session, PersistentStore store, Result ins) Used for subquery inserts.
pack-priv Row	insertSingleRow(Session session, PersistentStore store, Object[] data, int[] changedCols) Mid level method for inserting single rows.
public int	insertSys(Session session, PersistentStore store, Result ins) Used for system table inserts.
public void	insertSys(Session session, PersistentStore store, Object[] data) Used by the system tables only
pack-priv Row	insertSystemVersionHistoryRow(Session session, PersistentStore store, Object[] data) Method for inserting system version history row
public boolean	isBestRowIdentifiersStrict()
public boolean	isCached()
public boolean	isConnected()
public boolean	isDataReadOnly()
public boolean	isDropped()
public boolean	isFileBased() Text or Cached Tables are normally file based
pack-priv boolean	isIndexed(int colIndex)
pack-priv final boolean	isIndexingMutable() returns false if the table has to be recreated in order to add / drop indexes.
public boolean	isInsertable()
public boolean	isQueryBased()
public final boolean	isReadOnly()
public final boolean	isSchemaBaseTable()
public final boolean	isTemp()
public final boolean	isText()
public boolean	isTriggerDeletable()
public boolean	isTriggerInsertable()
public boolean	isTriggerUpdatable()
public boolean	isUpdatable()
public final boolean	isView()
public final boolean	isWithDataSource()
public boolean	isWritable()
public void	materialise(Session session)
public void	materialiseCorrelated(Session session)
pack-priv Table	moveDefinition(Session session, int newType, ColumnSchema[] columns, Constraint constraint, Index index, int[] colIndex, int adjust, OrderedHashSet<HsqlNameManager.HsqlName> dropConstraints, OrderedHashSet<HsqlNameManager.HsqlName> dropIndexes) For removal or addition of columns, constraints and indexes HsqlName objects are used from the old tables but no object is reused.
public void	prepareTable(Session session)
pack-priv void	releaseTriggers() Used when dropping all triggers.
pack-priv void	removeConstraint(String name) remove a named constraint
pack-priv void	removeConstraint(int index)
pack-priv void	removeTrigger(TriggerDef trigger) Drops a trigger.
pack-priv void	renameColumn(ColumnSchema column, String newName, boolean isquoted)
pack-priv void	renameColumn(ColumnSchema column, HsqlNameManager.HsqlName newName)
pack-priv void	resetDefaultFlags() recreates various flags based on column properties
public RowIterator	rowIteratorClustered(Session session)
public RowIterator	rowIteratorForScript(PersistentStore store)
pack-priv void	setColumnStructures()
pack-priv void	setColumnTypeVars(int i)
public void	setDataReadOnly(boolean value)
public void	setForwardConstraints(OrderedHashSet<HsqlNameManager.HsqlName> resolved)
public void	setGeneratedColumns(Session session, Object[] data)
protected void	setIdentityColumn(Session session, Object[] data) If there is an identity column in the table, sets the value and/or adjusts the identity value for the table.
public void	setIndexRoots(long[] roots)
pack-priv void	setIndexRoots(Session session, String s) Sets the index roots.
public final void	setName(HsqlNameManager.HsqlName name)
private void	setSingleColumnTypeVars(int i)
public void	setUpdatedColumns(Session session, Object[] data, int[] colMap)
public void	systemSetIdentityColumn(Session session, Object[] data)
public void	systemUpdateIdentityValue(Object[] data) If there is an identity column in the table, sets the max identity value.
pack-priv void	terminateTriggers()
pack-priv void	updateConstraintLists()
pack-priv void	verifyConstraintsIntegrity()

public Class Table

Field Summary

Constructor Summary

Method Summary