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

Interface Table

All Superinterfaces:
Serializable
All Known Implementing Classes:
TableAlias, TableImpl
public interface Table extends Serializable
A SQL table.

  • Method Details

    • isAlias

      boolean isAlias()

    • getRealTable

      Table getRealTable()

    • getDialect

      Dialect getDialect()

    • getKey

      String getKey()

    • getPhysicalName

      String getPhysicalName()

    • getQuotedName

      String getQuotedName()

    • getQuotedSuffixedName

      String getQuotedSuffixedName(String suffix)

    • getColumn

      Column getColumn(String name)

    • getPrimaryColumn

      Column getPrimaryColumn()

    • getColumns

      Collection<Column> getColumns()

    • addColumn

      Column addColumn(String name, ColumnType type, String key, Model model)
      Adds a Column to the table.

    • addIndex

      void addIndex(String... columnNames)
      Adds an index on one or several columns.
      Parameters:
      columnNames - the column names

    • addIndex

      void addIndex(String indexName, Table.IndexType indexType, String... columnNames)
      Adds an index of the given name and type on one or several columns.
      Parameters:
      indexName - the index name
      indexType - the index type
      columnNames - the column names

    • hasFulltextIndex

      boolean hasFulltextIndex()
      Checks if the table has some fulltext indexes.
      Returns:
      true if the table has some fulltext indexes

    • getCreateSql

      String getCreateSql()
      Computes the SQL statement to create the table.
      Returns:
      the SQL create string.

    • getAddColumnSql

      String getAddColumnSql(Column column)
      Computes the SQL statement to alter a table and add a column to it.
      Parameters:
      column - the column to add
      Returns:
      the SQL alter table string

    • getPostCreateSqls

      List<String> getPostCreateSqls(Model model)
      Computes the SQL statements to finish creating the table, usually some ALTER TABLE statements to add constraints or indexes.
      Returns:
      the SQL strings

    • getPostAddSqls

      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.
      Returns:
      the SQL strings

    • getDropSql

      String getDropSql()
      Computes the SQL statement to drop the table.

      TODO drop constraints and indexes

      Returns:
      the SQL drop string.