Uses of Interface
org.nuxeo.ecm.core.storage.sql.jdbc.db.Table
Package
Description
Internal API to deal with the database by generating SQL statements.
Database
Dialect
s implementations;
a Dialect encapsulates knowledge about database-specific behavior.-
Uses of Table in org.nuxeo.ecm.core.opencmis.impl.server
Modifier and TypeFieldDescriptionCMISQLQueryMaker.allTables
Map of qualifier -> fragment -> tableModifier and TypeMethodDescriptionprotected Table
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
Modifier and TypeFieldDescriptionprotected Table
NXQLQueryMaker.dataHierTable
protected Table
NXQLQueryMaker.hierTable
protected Table
NXQLQueryMaker.proxyTable
Modifier and TypeFieldDescriptionNXQLQueryMaker.propertyFragmentTables
NXQLQueryMaker.WhereBuilder.propertyHierTables
Modifier and TypeMethodDescriptionprotected 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.Modifier and TypeMethodDescriptionprotected 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.makeSelect
(Table table, String[] orderBys, String... freeColumns) Basic SELECT x, y, z FROM table WHERE a = ?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
Modifier and TypeClassDescriptionclass
An alias for an existing table.class
The basic implementation of a SQL table.Modifier and TypeFieldDescriptionprotected final Table
Column.table
protected final Table
Delete.table
protected final Table
TableAlias.table
The table this is an alias of.protected final Table
Update.table
Modifier and TypeMethodDescriptionColumn.getForeignTable()
Table.getRealTable()
TableAlias.getRealTable()
TableImpl.getRealTable()
Column.getTable()
Update.getTable()
Modifier and TypeMethodDescriptionvoid
Column.setReferences
(Table foreignTable, String foreignKey) ModifierConstructorDescriptionCreates 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.TableAlias
(Table table, String alias) Creates a table as an alias for another one. -
Uses of Table in org.nuxeo.ecm.core.storage.sql.jdbc.dialect
Modifier and TypeFieldDescriptionprotected Table
DialectPostgreSQL.ArraySubQueryPostgreSQL.fakeSubqueryTableAlias
Modifier and TypeMethodDescriptionDialect.getArrayIlikeSql
(Column arrayColumn, String refName, boolean positive, Table dataHierTable) Gets the SQL string for an array column ILIKE expression.DialectPostgreSQL.getArrayIlikeSql
(Column arrayColumn, String refName, boolean positive, Table dataHierTable) Dialect.getArrayLikeSql
(Column arrayColumn, String refName, boolean positive, Table dataHierTable) Gets the SQL string for an array column LIKE expression.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.DialectDB2.getCreateFulltextIndexSql
(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model) DialectH2.getCreateFulltextIndexSql
(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model) DialectMySQL.getCreateFulltextIndexSql
(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model) DialectOracle.getCreateFulltextIndexSql
(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model) DialectPostgreSQL.getCreateFulltextIndexSql
(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model) DialectSQLServer.getCreateFulltextIndexSql
(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model) Dialect.getCreateIndexSql
(String indexName, Table.IndexType indexType, Table table, List<Column> columns, Model model) Gets a CREATE INDEX statement for an index.Dialect.getCustomColumnDefinition
(Table table) Additional column definitions for CREATE TABLE.DialectSQLServer.getCustomColumnDefinition
(Table table) Dialect.getCustomPostCreateSqls
(Table table, Model model) Additional things to execute after CREATE TABLE.DialectPostgreSQL.getCustomPostCreateSqls
(Table table, Model model) DialectSQLServer.getCustomPostCreateSqls
(Table table, Model model) Dialect.getIgnoredColumns
(Table table) Columns ignored if we see them in existing tables.DialectSQLServer.getIgnoredColumns
(Table table) Dialect.getTableTypeString
(Table table) 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
Modifier and TypeMethodDescriptionstatic Column
SQLHelper.addColumn
(Table table, String fieldName, ColumnType type, boolean nativeCase) SQLStaticFilter.getDirectoryColumn
(Table table, boolean nativeCase) -
Uses of Table in org.nuxeo.ecm.platform.tag