TableImpl.NameImplTable.Name| Modifier | Constructor and Description |
|---|---|
protected |
ViewImpl(SelectStatement pSelectStatement,
Table.Name pName) |
| Modifier and Type | Method and Description |
|---|---|
Column |
getColumn(Column.Name pName)
Returns the column with the given name or null,
if no such column exists.
|
java.util.Iterator |
getColumns()
Returns the table columns.
|
DeleteStatement |
getDeleteStatement()
Returns an UPDATE statement for updating a column in the table.
|
java.util.Iterator |
getForeignKeys()
Returns an
Iterator to the foreign keys defined on the
table. |
java.util.Iterator |
getIndexes()
Returns an
Iterator to the indexes defined on the table. |
InsertStatement |
getInsertStatement()
Returns an INSERT statement for filling all the values.
|
Index |
getPrimaryKey()
Returns the tables primary key, if any, or null, if the table
doesn't have a primary key.
|
UpdateStatement |
getUpdateStatement()
Returns an UPDATE statement for updating a column in the table.
|
SelectStatement |
getViewStatement() |
Column |
newColumn(Column.Name pName,
Column.Type pType)
Creates a new column.
|
Column |
newColumn(java.lang.String pName,
Column.Type pType)
Creates a new column.
|
ForeignKey |
newForeignKey(Table pReferencedTable)
Creates a new foreign key referencing the given table.
|
Index |
newIndex()
Creates a new, non-unique index on the table.
|
Index |
newKey()
Creates a new, unique index on the table.
|
Index |
newPrimaryKey()
Creates a new primary key on the table.
|
protected ViewImpl(SelectStatement pSelectStatement, Table.Name pName)
public java.util.Iterator getColumns()
TableReturns the table columns.
getColumns in interface TablegetColumns in class TableImplpublic Column newColumn(Column.Name pName, Column.Type pType)
TableCreates a new column.
public Column newColumn(java.lang.String pName, Column.Type pType)
TableCreates a new column.
public Column getColumn(Column.Name pName)
TableReturns the column with the given name or null, if no such column exists.
public Index newKey()
TableCreates a new, unique index on the table.
public Index newIndex()
TableCreates a new, non-unique index on the table.
public Index newPrimaryKey()
TableCreates a new primary key on the table.
newPrimaryKey in interface TablenewPrimaryKey in class TableImplpublic ForeignKey newForeignKey(Table pReferencedTable)
TableCreates a new foreign key referencing the given table.
newForeignKey in interface TablenewForeignKey in class TableImplpublic InsertStatement getInsertStatement()
TableReturns an INSERT statement for filling all the values. In
other words: If the table FOO has the columns A, B, and C,
then the statement INSERT INTO FOO (A,B,C) VALUES (?, ?, ?)
will be returned.
getInsertStatement in interface TablegetInsertStatement in class TableImplSQLFactory.newInsertStatement()public UpdateStatement getUpdateStatement()
TableReturns an UPDATE statement for updating a column in the table.
In other words: If the table FOO has the columns A, B, C and D
with the primary key columns A and B, then the statement
UPDATE FOO SET C = ?, D = ? WHERE A = ? AND B = ?
will be returned.
getUpdateStatement in interface TablegetUpdateStatement in class TableImplSQLFactory.newUpdateStatement()public DeleteStatement getDeleteStatement()
TableReturns an UPDATE statement for updating a column in the table.
In other words: If the table FOO has the primary key columns A and B,
then the statement DELETE FROM FOO WHERE A = ? AND B = ?
will be returned.
getDeleteStatement in interface TablegetDeleteStatement in class TableImplSQLFactory.newDeleteStatement()public Index getPrimaryKey()
TableReturns the tables primary key, if any, or null, if the table doesn't have a primary key.
getPrimaryKey in interface TablegetPrimaryKey in class TableImplpublic java.util.Iterator getIndexes()
TableReturns an Iterator to the indexes defined on the table.
This iterator includes the primary key, if any.
getIndexes in interface TablegetIndexes in class TableImplpublic java.util.Iterator getForeignKeys()
TableReturns an Iterator to the foreign keys defined on the
table.
getForeignKeys in interface TablegetForeignKeys in class TableImplpublic SelectStatement getViewStatement()