Top Description Fields Constructors Methods
org.hsqldb

public Class View

extends TableDerived
Class Inheritance
Imports
org.hsqldb.HsqlNameManager.HsqlName, .ParserDQL.CompileContext, org.hsqldb.error.Error, .ErrorCode, org.hsqldb.lib.OrderedHashSet

Represents an SQL VIEW based on a query expression
Authors
leptipre@users, Fred Toussi (fredt@users dot sourceforge.net)
Since
1.7.0
Version
2.7.3

Field Summary

Modifier and TypeField and Description
private Table
private int
checkOption

check option

private HsqlNameManager.HsqlName[]
pack-priv boolean
pack-priv boolean
pack-priv boolean
private OrderedHashSet<HsqlNameManager.HsqlName>
schemaObjectNames

Names of SCHEMA objects referenced in VIEW

private String
Inherited from org.hsqldb.TableDerived:
canRecompiledataExpressiondepthemptyArrayqueryExpressionsqluniquePredicateuniqueRowsview

Constructor Summary

AccessConstructor and Description
pack-priv
View(Database db, HsqlNameManager.HsqlName name, HsqlNameManager.HsqlName[] columnNames, int check)

Method Summary

Modifier and TypeMethod and Description
pack-priv void
public void
compile(Session session, SchemaObject parentObject)

Overrides org.hsqldb.Table.compile.

Overrides default org.hsqldb.SchemaObject.compile.

Compiles the query expression and sets up the columns.

public int
public OrderedHashSet<HsqlNameManager.HsqlName>
public String
public String
getStatement()

Returns the query expression for the view.

public int
public int[]
public boolean
public boolean
public boolean
public boolean
public boolean
public TableDerived
pack-priv void
public void
setDataReadOnly(boolean value)

Overrides org.hsqldb.Table.setDataReadOnly.

Overridden to disable SET TABLE READONLY DDL for View objects.

public void
Inherited from org.hsqldb.TableDerived:
getBaseTablegetBaseTableColumnMapgetDataExpressiongetIdgetNavigatorgetQueryExpressiongetValuegetValueshasUniqueNotNullRowsisCorrelatedisQueryBasedisRecompiledisWritablematerialisematerialiseCorrelatedprepareTableprepareTableresetToViewsetCorrelatedsetSQL

Field Detail

baseTableback to summary
private Table baseTable
checkOptionback to summary
private int checkOption

check option

columnNamesback to summary
private HsqlNameManager.HsqlName[] columnNames
isTriggerDeletableback to summary
pack-priv boolean isTriggerDeletable
isTriggerInsertableback to summary
pack-priv boolean isTriggerInsertable
isTriggerUpdatableback to summary
pack-priv boolean isTriggerUpdatable
schemaObjectNamesback to summary
private OrderedHashSet<HsqlNameManager.HsqlName> schemaObjectNames

Names of SCHEMA objects referenced in VIEW

statementback to summary
private String statement

Constructor Detail

Viewback to summary
pack-priv View(Database db, HsqlNameManager.HsqlName name, HsqlNameManager.HsqlName[] columnNames, int check)

Method Detail

addTriggerback to summary
pack-priv void addTrigger(TriggerDef td, HsqlNameManager.HsqlName otherName)

Overrides org.hsqldb.Table.addTrigger.

Doc from org.hsqldb.Table.addTrigger.

Adds a trigger.

compileback to summary
public void compile(Session session, SchemaObject parentObject)

Overrides org.hsqldb.Table.compile.

Overrides default org.hsqldb.SchemaObject.compile.

Compiles the query expression and sets up the columns.

getCheckOptionback to summary
public int getCheckOption()
getReferencesback to summary
public OrderedHashSet<HsqlNameManager.HsqlName> getReferences()

Overrides org.hsqldb.Table.getReferences.

Overrides default org.hsqldb.SchemaObject.getReferences.

getSQLback to summary
public String getSQL()

Overrides org.hsqldb.Table.getSQL.

Implements org.hsqldb.SchemaObject.getSQL.

getStatementback to summary
public String getStatement()

Returns the query expression for the view.

getTypeback to summary
public int getType()

Overrides org.hsqldb.Table.getType.

Implements org.hsqldb.SchemaObject.getType.

getUpdatableColumnsback to summary
public int[] getUpdatableColumns()

Overrides org.hsqldb.TableDerived.getUpdatableColumns.

isInsertableback to summary
public boolean isInsertable()

Overrides org.hsqldb.TableDerived.isInsertable.

isTriggerDeletableback to summary
public boolean isTriggerDeletable()

Overrides org.hsqldb.TableDerived.isTriggerDeletable.

isTriggerInsertableback to summary
public boolean isTriggerInsertable()

Overrides org.hsqldb.TableDerived.isTriggerInsertable.

isTriggerUpdatableback to summary
public boolean isTriggerUpdatable()

Overrides org.hsqldb.TableDerived.isTriggerUpdatable.

isUpdatableback to summary
public boolean isUpdatable()

Overrides org.hsqldb.TableDerived.isUpdatable.

newDerivedTableback to summary
public TableDerived newDerivedTable(Session session, ParserDQL.CompileContext baseContext)

Overrides org.hsqldb.TableDerived.newDerivedTable.

removeTriggerback to summary
pack-priv void removeTrigger(TriggerDef td)

Overrides org.hsqldb.Table.removeTrigger.

Doc from org.hsqldb.Table.removeTrigger.

Drops a trigger.

setDataReadOnlyback to summary
public void setDataReadOnly(boolean value)

Overrides org.hsqldb.Table.setDataReadOnly.

Overridden to disable SET TABLE READONLY DDL for View objects.

setStatementback to summary
public void setStatement(String sql)