Package org.nuxeo.ecm.core.storage.sql.jdbc.db

Class TableImpl

java.lang.Object

org.nuxeo.ecm.core.storage.sql.jdbc.db.TableImpl

All Implemented Interfaces:

Serializable, Table

public class TableImpl
extends Object
implements Table

The basic implementation of a SQL table.

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface org.nuxeo.ecm.core.storage.sql.jdbc.db.Table

Table.IndexType

Field Summary

Fields

Modifier and Type	Field	Description
protected Dialect	dialect
protected String	key
protected String	name

Constructor Summary

Constructors

Constructor	Description
TableImpl(Dialect dialect, String name, String key)	Creates a new empty table.

Method Summary

Modifier and Type	Method	Description
Column	addColumn(String name, ColumnType type, String key, Model model)	Adds a Column to the table.
Column	addColumn(String name, Column column)	Adds a column without dialect physical name canonicalization (for directories).
void	addIndex(String... columnNames)	Adds an index on one or several columns.
void	addIndex(String indexName, Table.IndexType indexType, String... columnNames)	Adds an index of the given name and type on one or several columns.
protected void	addOneColumn(StringBuilder sb, Column column)	Adds to buf the column name and its type and constraints for create / alter.
String	getAddColumnSql(Column column)	Computes the SQL statement to alter a table and add a column to it.
Column	getColumn(String name)
Collection<Column>	getColumns()
String	getCreateSql()	Computes the SQL statement to create the table.
Dialect	getDialect()
String	getDropSql()	Computes the SQL statement to drop the table.
String	getKey()
String	getPhysicalName()
List<String>	getPostAddSqls(Column column, Model model)	Computes the SQL statements to finish adding a column, usually some ALTER TABLE statements to add constraints or indexes.
List<String>	getPostCreateSqls(Model model)	Computes the SQL statements to finish creating the table, usually some ALTER TABLE statements to add constraints or indexes.
Column	getPrimaryColumn()
String	getQuotedName()
String	getQuotedSuffixedName(String suffix)
Table	getRealTable()
boolean	hasFulltextIndex()	Checks if the table has some fulltext indexes.
boolean	isAlias()
protected void	postAddColumn(Column column, List<String> sqls, Model model)
String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

dialect

protected final Dialect dialect

key

protected final String key

name

protected final String name

Constructor Detail

TableImpl

public TableImpl(Dialect dialect,
                 String name,
                 String key)

Creates a new empty table.

Method Detail

isAlias

public boolean isAlias()

Specified by:

isAlias in interface Table

getRealTable

public Table getRealTable()

Specified by:

getRealTable in interface Table

getDialect

public Dialect getDialect()

Specified by:

getDialect in interface Table

getKey

public String getKey()

Specified by:

getKey in interface Table

getPhysicalName

public String getPhysicalName()

Specified by:

getPhysicalName in interface Table

getQuotedName

public String getQuotedName()

Specified by:

getQuotedName in interface Table

getQuotedSuffixedName

public String getQuotedSuffixedName(String suffix)

Specified by:

getQuotedSuffixedName in interface Table

getColumn

public Column getColumn(String name)

Specified by:

getColumn in interface Table

getPrimaryColumn

public Column getPrimaryColumn()

Specified by:

getPrimaryColumn in interface Table

getColumns

public Collection<Column> getColumns()

Specified by:

getColumns in interface Table

addColumn

public Column addColumn(String name,
                        Column column)

Adds a column without dialect physical name canonicalization (for directories).

addColumn

public Column addColumn(String name,
                        ColumnType type,
                        String key,
                        Model model)

Description copied from interface: Table

Adds a Column to the table.

Specified by:

addColumn in interface Table

addIndex

public void addIndex(String... columnNames)

Adds an index on one or several columns.

Specified by:

addIndex in interface Table

Parameters:

columnNames - the column names

addIndex

public void addIndex(String indexName,
                     Table.IndexType indexType,
                     String... columnNames)

Description copied from interface: Table

Adds an index of the given name and type on one or several columns.

Specified by:

addIndex in interface Table

Parameters:

indexName - the index name

indexType - the index type

columnNames - the column names

hasFulltextIndex

public boolean hasFulltextIndex()

Description copied from interface: Table

Checks if the table has some fulltext indexes.

Specified by:

hasFulltextIndex in interface Table

Returns:

true if the table has some fulltext indexes

getCreateSql

public String getCreateSql()

Computes the SQL statement to create the table.

Specified by:

getCreateSql in interface Table

Returns:

the SQL create string.

getAddColumnSql

public String getAddColumnSql(Column column)

Computes the SQL statement to alter a table and add a column to it.

Specified by:

getAddColumnSql in interface Table

Parameters:

column - the column to add

Returns:

the SQL alter table string

addOneColumn

protected void addOneColumn(StringBuilder sb,
                            Column column)

Adds to buf the column name and its type and constraints for create / alter.

getPostCreateSqls

public List<String> getPostCreateSqls(Model model)

Description copied from interface: Table

Computes the SQL statements to finish creating the table, usually some ALTER TABLE statements to add constraints or indexes.

Specified by:

getPostCreateSqls in interface Table

Returns:

the SQL strings

getPostAddSqls

public List<String> getPostAddSqls(Column column,
                                   Model model)

Description copied from interface: Table

Computes the SQL statements to finish adding a column, usually some ALTER TABLE statements to add constraints or indexes.

Specified by:

getPostAddSqls in interface Table

Returns:

the SQL strings

postAddColumn

protected void postAddColumn(Column column,
                             List<String> sqls,
                             Model model)

getDropSql

public String getDropSql()

Computes the SQL statement to drop the table.

TODO drop constraints and indexes

Specified by:

getDropSql in interface Table

Returns:

the SQL drop string.

toString

public String toString()

Overrides:

toString in class Object