Uses of Interface
org.nuxeo.ecm.core.storage.sql.jdbc.db.Table
-
Packages that use Table Package Description org.nuxeo.ecm.core.opencmis.impl.server org.nuxeo.ecm.core.storage.sql.jdbc org.nuxeo.ecm.core.storage.sql.jdbc.db Internal API to deal with the database by generating SQL statements.org.nuxeo.ecm.core.storage.sql.jdbc.dialect DatabaseDialect
s implementations; a Dialect encapsulates knowledge about database-specific behavior.org.nuxeo.ecm.directory.sql org.nuxeo.ecm.platform.tag -
-
Uses of Table in org.nuxeo.ecm.core.opencmis.impl.server
Fields in org.nuxeo.ecm.core.opencmis.impl.server declared as Table Modifier and Type Field Description protected Table
CMISQLQueryMaker. hierTable
Fields in org.nuxeo.ecm.core.opencmis.impl.server with type parameters of type Table Modifier and Type Field Description protected Map<String,Map<String,Table>>
CMISQLQueryMaker. allTables
Map of qualifier -> fragment -> tableMethods in org.nuxeo.ecm.core.opencmis.impl.server that return Table Modifier and Type Method Description protected Table
CMISQLQueryMaker. getTable(Table table, String qual)
Methods in org.nuxeo.ecm.core.opencmis.impl.server with parameters of type Table Modifier and Type Method Description protected Table
CMISQLQueryMaker. getTable(Table table, String qual)
protected String
CMISQLQueryMaker. getTableAlias(Table table, String qual)
protected void
CMISQLQueryMaker. recordFragment(String qual, Table table)
Records a database table and qualifier (to know what to join). -
Uses of Table in org.nuxeo.ecm.core.storage.sql.jdbc
Fields in org.nuxeo.ecm.core.storage.sql.jdbc declared as Table Modifier and Type Field Description protected Table
NXQLQueryMaker. dataHierTable
protected Table
NXQLQueryMaker. hierTable
protected Table
NXQLQueryMaker. proxyTable
Fields in org.nuxeo.ecm.core.storage.sql.jdbc with type parameters of type Table Modifier and Type Field Description protected Map<String,Table>
NXQLQueryMaker. propertyFragmentTables
protected Map<String,Table>
NXQLQueryMaker.WhereBuilder. propertyHierTables
Methods in org.nuxeo.ecm.core.storage.sql.jdbc that return Table Modifier and Type Method Description protected Table
NXQLQueryMaker. getFragmentTable(int joinKind, Table contextTable, String contextKey, String fragmentName, String fragmentColumn, int index, boolean skipJoin, String primaryType)
Adds a more general JOIN:protected Table
NXQLQueryMaker. getFragmentTable(Table contextHier, String fragmentName)
Gets the table for the given fragmentName, and maybe adds a join if one is not already done.Methods in org.nuxeo.ecm.core.storage.sql.jdbc with parameters of type Table Modifier and Type Method Description protected void
NXQLQueryMaker. addJoin(int kind, String alias, Table table, String column, Table contextTable, String contextColumn, String name, int index, String primaryType)
protected void
NXQLQueryMaker.WhereBuilder. generateExistsStart(StringBuilder sb, Table table)
protected Dialect.ArraySubQuery
NXQLQueryMaker.WhereBuilder. getArraySubQuery(Table contextHier, String contextKey, Column arrayColumn, boolean skipJoin)
Gets the arraySubquery for the given arrayColumn in the given contextKey, and maybe adds a JOIN if one is not already done.protected Table
NXQLQueryMaker. getFragmentTable(int joinKind, Table contextTable, String contextKey, String fragmentName, String fragmentColumn, int index, boolean skipJoin, String primaryType)
Adds a more general JOIN:protected Table
NXQLQueryMaker. getFragmentTable(Table contextHier, String fragmentName)
Gets the table for the given fragmentName, and maybe adds a join if one is not already done.SQLInfo.SQLInfoSelect
SQLInfo. makeSelect(Table table, String[] orderBys, String... freeColumns)
Basic SELECT x, y, z FROM table WHERE a = ? AND b = ?SQLInfo.SQLInfoSelect
SQLInfo. makeSelect(Table table, String from, List<String> clauses, String[] orderBys, String... freeColumns)
Same as above but the FROM can be passed in, to allow JOINs. -
Uses of Table in org.nuxeo.ecm.core.storage.sql.jdbc.db
Classes in org.nuxeo.ecm.core.storage.sql.jdbc.db that implement Table Modifier and Type Class Description class
TableAlias
An alias for an existing table.class
TableImpl
The basic implementation of a SQL table.Fields in org.nuxeo.ecm.core.storage.sql.jdbc.db declared as Table Modifier and Type Field Description protected Table
Column. table
protected Table
Delete. table
protected Table
TableAlias. table
The table this is an alias of.protected Table
Update. table
Fields in org.nuxeo.ecm.core.storage.sql.jdbc.db with type parameters of type Table Modifier and Type Field Description protected Map<String,Table>
Database. tables
Methods in org.nuxeo.ecm.core.storage.sql.jdbc.db that return Table Modifier and Type Method Description Table
Database. addTable(String name)
Table
Column. getForeignTable()
Table
Table. getRealTable()
Table
TableAlias. getRealTable()
Table
TableImpl. getRealTable()
Table
Column. getTable()
Table
Database. getTable(String name)
Table
Update. getTable()
Methods in org.nuxeo.ecm.core.storage.sql.jdbc.db that return types with arguments of type Table Modifier and Type Method Description Collection<Table>
Database. getTables()
Methods in org.nuxeo.ecm.core.storage.sql.jdbc.db with parameters of type Table Modifier and Type Method Description void
Column. setReferences(Table foreignTable, String foreignKey)
Constructors in org.nuxeo.ecm.core.storage.sql.jdbc.db with parameters of type Table Constructor Description Column(Column column, Table table)
Creates a column from an existing column and an aliased table.Column(Table table, String physicalName, ColumnType type, String key)
Creates a new column with the given name and type.Delete(Table table)
Insert(Table table)
Select(Table table)
TableAlias(Table table, String alias)
Creates a table as an alias for another one.Update(Table table)
-
Uses of Table in org.nuxeo.ecm.core.storage.sql.jdbc.dialect
Fields in org.nuxeo.ecm.core.storage.sql.jdbc.dialect declared as Table Modifier and Type Field Description protected Table
DialectPostgreSQL.ArraySubQueryPostgreSQL. fakeSubqueryTableAlias
Methods in org.nuxeo.ecm.core.storage.sql.jdbc.dialect with parameters of type Table Modifier and Type Method Description String
Dialect. getArrayIlikeSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable)
Gets the SQL string for an array column ILIKE expression.String
DialectPostgreSQL. getArrayIlikeSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable)
String
Dialect. getArrayLikeSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable)
Gets the SQL string for an array column LIKE expression.String
DialectPostgreSQL. getArrayLikeSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable)
protected String
DialectPostgreSQL. getArrayOpSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable, String op)
abstract String
Dialect. getCreateFulltextIndexSql(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model)
Gets a CREATE INDEX statement for a fulltext index.String
DialectDB2. getCreateFulltextIndexSql(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model)
String
DialectH2. getCreateFulltextIndexSql(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model)
String
DialectMySQL. getCreateFulltextIndexSql(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model)
String
DialectOracle. getCreateFulltextIndexSql(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model)
String
DialectPostgreSQL. getCreateFulltextIndexSql(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model)
String
DialectSQLServer. getCreateFulltextIndexSql(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model)
String
Dialect. getCreateIndexSql(String indexName, Table.IndexType indexType, Table table, List<Column> columns, Model model)
Gets a CREATE INDEX statement for an index.String
Dialect. getCustomColumnDefinition(Table table)
Additional column definitions for CREATE TABLE.String
DialectSQLServer. getCustomColumnDefinition(Table table)
List<String>
Dialect. getCustomPostCreateSqls(Table table, Model model)
Additional things to execute after CREATE TABLE.List<String>
DialectPostgreSQL. getCustomPostCreateSqls(Table table, Model model)
List<String>
DialectSQLServer. getCustomPostCreateSqls(Table table, Model model)
List<String>
Dialect. getIgnoredColumns(Table table)
Columns ignored if we see them in existing tables.List<String>
DialectSQLServer. getIgnoredColumns(Table table)
String
Dialect. getTableTypeString(Table table)
String
DialectMySQL. getTableTypeString(Table table)
protected boolean
DialectSQLServer. needsClusteredColumn(Table table)
Tables created for directories don't need a clustered column automatically defined. -
Uses of Table in org.nuxeo.ecm.directory.sql
Methods in org.nuxeo.ecm.directory.sql that return Table Modifier and Type Method Description static Table
SQLHelper. addTable(String name, Dialect dialect, boolean nativeCase)
Table
SQLDirectory. getTable()
Methods in org.nuxeo.ecm.directory.sql with parameters of type Table Modifier and Type Method Description static Column
SQLHelper. addColumn(Table table, String fieldName, ColumnType type, boolean nativeCase)
Column
SQLStaticFilter. getDirectoryColumn(Table table, boolean nativeCase)
Constructors in org.nuxeo.ecm.directory.sql with parameters of type Table Constructor Description SQLHelper(Connection connection, Table table, String policy)
-
Uses of Table in org.nuxeo.ecm.platform.tag
Fields in org.nuxeo.ecm.platform.tag declared as Table Modifier and Type Field Description protected Table
TagQueryMaker. relationTable
Methods in org.nuxeo.ecm.platform.tag with parameters of type Table Modifier and Type Method Description protected void
TagQueryMaker. addJoin(int kind, String alias, Table table, String column, Table contextTable, String contextColumn, String name, int index, String primaryType)
Patches the Tag join to join on the relation target instead of the hierarchy id.
-