Top Description Fields Constructors Methods
org.hsqldb

public Class TextTable

extends Table
Class Inheritance
Imports
org.hsqldb.error.Error, .ErrorCode, org.hsqldb.lib.StringConverter, org.hsqldb.persist.PersistentStore, .TextCache, .TextFileReader, .TextFileSettings, org.hsqldb.rowio.RowInputInterface

Subclass of Table to handle TEXT data source.

Extends Table to provide the notion of an SQL base table object whose data is read from and written to a text format data file.

Authors
Bob Preston (sqlbob@users dot sourceforge.net), Fred Toussi (fredt@users dot sourceforge.net)
Version
2.6.0

Field Summary

Modifier and TypeField and Description
pack-priv String
pack-priv boolean
pack-priv boolean
Inherited from org.hsqldb.Table:
applicationPeriodcascadingDeleteschangeTimestampcheckConstraintscolDefaultscolGeneratedcolMainFKcolRefFKcolumnListcolUpdatedconstraintListdefaultColumnMapemptyArrayfkConstraintsfkMainConstraintsidentityColumnidentitySequenceisDroppedreferentialActionssystemPeriodsystemPeriodEndColumnsystemPeriodStartColumntableNametriggerListtriggerLists

Constructor Summary

AccessConstructor and Description
pack-priv
TextTable(Database
the owning database
db
,
HsqlNameManager.HsqlName
the table's HsqlName
name
,
int
code (normal or temp text table)
type
)

Constructs a new TextTable from the given arguments.

Method Summary

Modifier and TypeMethod and Description
public void
checkDataReadOnly()

Overrides org.hsqldb.Table.checkDataReadOnly.

Used by INSERT, DELETE, UPDATE operations.

public void
connect(Session session)

connects to the data source

private void
connect(Session session, boolean withReadOnlyData)

connects to the data source

public void
disconnect()

disconnects from the data source

public String
pack-priv String
pack-priv String
getDataSourceHeader()

Generates the SET TABLE <tablename> SOURCE HEADER <string> statement for a text table;

private String
public void
insertData(Session session, PersistentStore store, Object[] data, boolean enforceUnique)

Overrides org.hsqldb.Table.insertData.

Adds commitPersistence() call

public boolean
public boolean
public boolean
private void
openCache(Session session, String dataSourceNew, boolean isReversedNew, boolean isReadOnlyNew)

This method does some of the work involved with managing the creation and opening of the cache, the rest is done in Log.java and TextCache.java.

private void
public void
pack-priv void
setDataSource(Session session, String dataSourceNew, boolean isReversedNew, boolean createFile)

High level command to assign a data source to the table definition.

public void
setDataSource(String source, boolean desc)

public void
setHeader(String header)

Inherited from org.hsqldb.Table:
addColumnaddColumnNoCheckaddConstraintaddTriggerareColumnsNotNullcheckColumnInCheckConstraintcheckColumnInFKConstraintcheckColumnInFKConstraintcheckReferentialColumnsMatchcollectFKReadLockscollectFKWriteLockscompareRowscompilecreateIndexForColumnscreatePrimaryKeycreatePrimaryKeycreatePrimaryKeyConstraintenforceRowConstraintsenforceTypeLimitsfindColumnfindColumnIndexesfindIndexForColumnsfireTriggersfireTriggersfireTriggersgenerateAndCheckDatagenerateDefaultForNullgetApplicationPeriodgetBaseTablegetBaseTableColumnMapgetBestRowIdentifiersgetCatalogNamegetChangeTimestampgetClusteredIndexgetColumngetColumnCheckListgetColumnDefaultOrGeneratedValuegetColumnIndexgetColumnIndexesgetColumnLabelsgetColumnListSQLgetColumnListWithTypeSQLgetColumnMapgetColumnNamesgetColumnNameSetgetComponentsgetConstraintgetConstraintIndexgetConstraintsgetContainingConstraintsgetContainingIndexNamesgetDataExpressiongetDefaultRangesgetDeleteRowFromLoggetDependentConstraintsgetDependentConstraintsgetDependentExternalConstraintsgetFKConstraintForColumnsgetFKConstraintsgetFullIndexgetFullIndexForColumnsgetIdgetIdentityColumnIndexgetIndexgetIndexForAllColumnsgetIndexForColumngetIndexForColumnsgetIndexForColumnsgetIndexIndexgetIndexRootsArraygetIndexRootsSQLgetNamegetNewColumnMapgetNewRowDatagetNextConstraintIndexgetNotNullConstraintForColumngetOwnergetPrimaryConstraintgetQueryExpressiongetReferencesgetReferencesForDependentsgetReferencesForScriptgetRowStoregetSchemaNamegetSQLgetSQLgetSQLForClusteredgetSQLForReadOnlygetSQLForTableSpacegetSQLForTextSourcegetSystemIndexgetSystemPeriodgetSystemPeriodEndIndexgetSystemPeriodStartIndexgetTableTypeStringgetTriggergetTriggerIndexgetTriggersgetTriggerSQLArraygetTypegetUniqueConstraintForColumnsgetUniqueConstraintForIndexgetUniqueNotNullColumnGroupgetUniqueOrPKConstraintForIndexgetUniquePKConstraintNamesgetUpdatableColumnsgetUserIndexhasGeneratedColumnhasIdentityColumnhasLobColumnhasTriggerhasUpdatedColumnindexTypeForColumninsertFromScriptinsertIntoTableinsertNoCheckFromLoginsertResultinsertSingleRowinsertSysinsertSysinsertSystemVersionHistoryRowisBestRowIdentifiersStrictisCachedisDroppedisFileBasedisIndexedisIndexingMutableisInsertableisQueryBasedisReadOnlyisSchemaBaseTableisTempisTextisTriggerDeletableisTriggerInsertableisTriggerUpdatableisUpdatableisViewisWithDataSourceisWritablematerialisematerialiseCorrelatedmoveDefinitionprepareTablereleaseTriggersremoveConstraintremoveConstraintremoveTriggerrenameColumnrenameColumnresetDefaultFlagsrowIteratorClusteredrowIteratorForScriptsetColumnStructuressetColumnTypeVarssetForwardConstraintssetGeneratedColumnssetIdentityColumnsetIndexRootssetIndexRootssetNamesetUpdatedColumnssystemSetIdentityColumnsystemUpdateIdentityValueterminateTriggersupdateConstraintListsverifyConstraintsIntegrity

Field Detail

dataSourceback to summary
pack-priv String dataSource
isConnectedback to summary
pack-priv boolean isConnected
isReversedback to summary
pack-priv boolean isReversed

Constructor Detail

TextTableback to summary
pack-priv TextTable(Database db, HsqlNameManager.HsqlName name, int type)

Constructs a new TextTable from the given arguments.

Parameters
db:Database

the owning database

name:HsqlNameManager.HsqlName

the table's HsqlName

type:int

code (normal or temp text table)

Method Detail

checkDataReadOnlyback to summary
public void checkDataReadOnly()

Overrides org.hsqldb.Table.checkDataReadOnly.

Used by INSERT, DELETE, UPDATE operations. This class will return a more appropriate message when there is no data source.

connectback to summary
public void connect(Session session)

connects to the data source

connectback to summary
private void connect(Session session, boolean withReadOnlyData)

connects to the data source

disconnectback to summary
public void disconnect()

disconnects from the data source

getDataSourceback to summary
public String getDataSource()
getDataSourceDDLback to summary
pack-priv String getDataSourceDDL()
getDataSourceHeaderback to summary
pack-priv String getDataSourceHeader()

Generates the SET TABLE <tablename> SOURCE HEADER <string> statement for a text table;

getHeaderback to summary
private String getHeader()
insertDataback to summary
public void insertData(Session session, PersistentStore store, Object[] data, boolean enforceUnique)

Overrides org.hsqldb.Table.insertData.

Adds commitPersistence() call

isConnectedback to summary
public boolean isConnected()

Overrides org.hsqldb.Table.isConnected.

isDataReadOnlyback to summary
public boolean isDataReadOnly()

Overrides org.hsqldb.Table.isDataReadOnly.

isDescDataSourceback to summary
public boolean isDescDataSource()
openCacheback to summary
private void openCache(Session session, String dataSourceNew, boolean isReversedNew, boolean isReadOnlyNew)

This method does some of the work involved with managing the creation and opening of the cache, the rest is done in Log.java and TextCache.java. Better clarification of the role of the methods is needed.

readDataIntoTableback to summary
private void readDataIntoTable(Session session, PersistentStore store, TextFileReader reader, TextFileSettings settings)
setDataReadOnlyback to summary
public void setDataReadOnly(boolean readonly)

Overrides org.hsqldb.Table.setDataReadOnly.

setDataSourceback to summary
pack-priv void setDataSource(Session session, String dataSourceNew, boolean isReversedNew, boolean createFile)

High level command to assign a data source to the table definition. Reassigns only if the data source or direction has changed.

setDataSourceback to summary
public void setDataSource(String source, boolean desc)
setHeaderback to summary
public void setHeader(String header)