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 |
Database
Dialect s implementations;
a Dialect encapsulates knowledge about database-specific behavior. |
org.nuxeo.ecm.directory.sql | |
org.nuxeo.ecm.platform.tag |
Modifier and Type | Field and Description |
---|---|
protected Table |
CMISQLQueryMaker.hierTable |
Modifier and Type | Field and Description |
---|---|
protected Map<String,Map<String,Table>> |
CMISQLQueryMaker.allTables
Map of qualifier -> fragment -> table
|
Modifier and Type | Method and Description |
---|---|
protected Table |
CMISQLQueryMaker.getTable(Table table,
String qual) |
Modifier and Type | Method and 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).
|
Modifier and Type | Field and Description |
---|---|
protected Table |
NXQLQueryMaker.dataHierTable |
protected Table |
NXQLQueryMaker.hierTable |
protected Table |
NXQLQueryMaker.proxyTable |
Modifier and Type | Field and Description |
---|---|
protected Map<String,Table> |
NXQLQueryMaker.propertyFragmentTables |
protected Map<String,Table> |
NXQLQueryMaker.WhereBuilder.propertyHierTables |
Modifier and Type | Method and 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 contextKey,
String fragmentName,
int index,
boolean skipJoin)
Gets the table for the given fragmentName in the given contextKey, and maybe adds a join if one is not already
done.
|
Modifier and Type | Method and 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 buf,
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 contextKey,
String fragmentName,
int index,
boolean skipJoin)
Gets the table for the given fragmentName in the given contextKey, 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.
|
Modifier and Type | Class and Description |
---|---|
class |
TableAlias
An alias for an existing table.
|
class |
TableImpl
The basic implementation of a SQL table.
|
Modifier and Type | Field and Description |
---|---|
protected Table |
Update.table |
protected Table |
TableAlias.table
The table this is an alias of.
|
protected Table |
Delete.table |
protected Table |
Column.table |
Modifier and Type | Field and Description |
---|---|
protected Map<String,Table> |
Database.tables |
Modifier and Type | Method and Description |
---|---|
Table |
Database.addTable(String name) |
Table |
Column.getForeignTable() |
Table |
TableImpl.getRealTable() |
Table |
TableAlias.getRealTable() |
Table |
Table.getRealTable() |
Table |
Update.getTable() |
Table |
Column.getTable() |
Table |
Database.getTable(String name) |
Modifier and Type | Method and Description |
---|---|
Collection<Table> |
Database.getTables() |
Modifier and Type | Method and Description |
---|---|
void |
Column.setReferences(Table foreignTable,
String foreignKey) |
Constructor and 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) |
Modifier and Type | Field and Description |
---|---|
protected Table |
DialectPostgreSQL.ArraySubQueryPostgreSQL.fakeSubqueryTableAlias |
Modifier and Type | Method and Description |
---|---|
String |
DialectPostgreSQL.getArrayIlikeSql(Column arrayColumn,
String refName,
boolean positive,
Table dataHierTable) |
String |
Dialect.getArrayIlikeSql(Column arrayColumn,
String refName,
boolean positive,
Table dataHierTable)
Gets the SQL string for an array column ILIKE expression.
|
String |
DialectPostgreSQL.getArrayLikeSql(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.
|
protected String |
DialectPostgreSQL.getArrayOpSql(Column arrayColumn,
String refName,
boolean positive,
Table dataHierTable,
String op) |
String |
DialectSQLServer.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 |
DialectOracle.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 |
DialectHSQLDB.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 |
DialectDerby.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
String |
DialectDB2.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
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 |
Dialect.getCreateIndexSql(String indexName,
Table.IndexType indexType,
Table table,
List<Column> columns,
Model model)
Gets a CREATE INDEX statement for an index.
|
String |
DialectSQLServer.getCustomColumnDefinition(Table table) |
String |
Dialect.getCustomColumnDefinition(Table table)
Additional column definitions for CREATE TABLE.
|
List<String> |
DialectSQLServer.getCustomPostCreateSqls(Table table) |
List<String> |
Dialect.getCustomPostCreateSqls(Table table)
Additional things to execute after CREATE TABLE.
|
List<String> |
DialectSQLServer.getIgnoredColumns(Table table) |
List<String> |
Dialect.getIgnoredColumns(Table table)
Columns ignored if we see them in existing tables.
|
String |
DialectMySQL.getTableTypeString(Table table) |
String |
Dialect.getTableTypeString(Table table) |
protected boolean |
DialectSQLServer.needsClusteredColumn(Table table)
Tables created for directories don't need a clustered column automatically defined.
|
Modifier and Type | Method and Description |
---|---|
static Table |
SQLHelper.addTable(String name,
Dialect dialect,
boolean nativeCase) |
Table |
TableReference.getTable() |
Table |
SQLDirectory.getTable() |
Modifier and Type | Method and Description |
---|---|
static Column |
SQLHelper.addColumn(Table table,
String fieldName,
ColumnType type,
boolean nativeCase) |
Column |
SQLStaticFilter.getDirectoryColumn(Table table,
boolean nativeCase) |
Constructor and Description |
---|
SQLHelper(Connection connection,
Table table,
String policy) |
Modifier and Type | Field and Description |
---|---|
protected Table |
TagQueryMaker.relationTable |
Modifier and Type | Method and 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.
|
Copyright © 2016 Nuxeo SA. All rights reserved.