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.directory.sql.filter | |
org.nuxeo.ecm.platform.tag |
Modifier and Type | Field and Description |
---|---|
Column |
CMISQLQueryMaker.SqlColumn.column
Column used to get the value from the result set.
|
Modifier and Type | Method and Description |
---|---|
protected Column |
CMISQLQueryMaker.getColumn(org.apache.chemistry.opencmis.server.support.query.ColumnReference col)
Finds a database column from a CMIS reference.
|
protected Column |
CMISQLQueryMaker.getSystemColumn(String id) |
protected Column |
CMISQLQueryMaker.getSystemColumn(String qual,
String id) |
Column |
CMISQLQueryMaker.GeneratingWalker.resolveColumn(org.antlr.runtime.tree.Tree node) |
Modifier and Type | Method and Description |
---|---|
protected void |
CMISQLQueryMaker.recordColumnFragment(String qual,
Column column)
Records a database column's fragment (to know what to join).
|
Constructor and Description |
---|
SqlColumn(String sql,
Column column,
String key) |
Modifier and Type | Field and Description |
---|---|
Column |
NXQLQueryMaker.ColumnInfo.column |
protected Column |
SQLInfo.deleteClusterInvalsColumn |
protected Column |
SQLInfo.deleteClusterNodeColumn |
Column |
NXQLQueryMaker.ColumnInfo.posColumn |
Modifier and Type | Field and Description |
---|---|
protected List<Column> |
SQLInfo.clusterInvalidationsColumns |
List<Column> |
SQLInfo.ColumnMapMaker.columns |
protected List<Column> |
SQLInfo.createClusterNodeColumns |
protected List<Column> |
SQLInfo.getBinariesColumns |
List<Column> |
SQLInfo.SQLInfoSelect.opaqueColumns |
protected Map<String,Column> |
NXQLQueryMaker.WhereBuilder.posColumns |
protected List<Column> |
NXQLQueryMaker.WhereBuilder.posColumnsInOrderBy |
List<Column> |
SQLInfo.SQLInfoSelect.whatColumns |
LinkedList<Column> |
NXQLQueryMaker.WhereBuilder.whatColumns |
List<Column> |
SQLInfo.SQLInfoSelect.whereColumns |
Modifier and Type | Method and Description |
---|---|
Column |
SQLInfo.getCopyIdColumn(String tableName) |
Column |
SQLInfo.getDeleteClusterInvalsColumn() |
Column |
SQLInfo.getDeleteClusterNodeColumn() |
Column |
SQLInfo.getSelectRootIdWhatColumn() |
protected Column |
SQLInfo.TableMaker.newColumn(String columnName,
ColumnType type) |
Modifier and Type | Method and Description |
---|---|
List<Column> |
SQLInfo.getClusterInvalidationsColumns() |
List<Column> |
SQLInfo.getCreateClusterNodeColumns() |
List<Column> |
SQLInfo.getInsertColumns(String tableName)
Returns the list of columns to use for an statement
SQLInfo.getInsertSql(java.lang.String) . |
List<Column> |
SQLInfo.getInsertRootIdColumns() |
List<Column> |
SQLInfo.getSelectChildrenIdsAndTypesWhatColumns() |
List<Column> |
SQLInfo.getSelectDescendantsInfoWhatColumns() |
Modifier and Type | Method and Description |
---|---|
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 String |
NXQLQueryMaker.getSelectColName(Column col) |
protected String |
NXQLQueryMaker.getSelectColName(Column col,
String key)
key used to extract array index if needed
|
protected void |
NXQLQueryMaker.WhereBuilder.visitColumnExpression(Column column,
Operator op,
Operand rvalue,
String cast,
String lvalueName,
int arrayElementIndex) |
protected void |
NXQLQueryMaker.WhereBuilder.visitExpressionEqOrIn(Column column,
Operator op,
Operand rvalue,
String cast,
int arrayElementIndex) |
protected void |
NXQLQueryMaker.WhereBuilder.visitExpressionIlike(Column column,
Operator op,
Operand rvalue,
String lvalueName,
int arrayElementIndex) |
protected void |
NXQLQueryMaker.WhereBuilder.visitExpressionLike(Column column,
Operator op,
Operand rvalue,
String lvalueName,
int arrayElementIndex) |
protected void |
NXQLQueryMaker.WhereBuilder.visitReference(Column column) |
protected void |
NXQLQueryMaker.WhereBuilder.visitReference(Column column,
int arrayElementIndex) |
protected void |
NXQLQueryMaker.WhereBuilder.visitReference(Column column,
String cast) |
protected void |
NXQLQueryMaker.WhereBuilder.visitReference(Column column,
String cast,
int arrayElementIndex) |
protected void |
NXQLQueryMaker.WhereBuilder.visitSimpleExpression(Column column,
Operator op,
Operand rvalue,
String cast,
int arrayElementIndex) |
Modifier and Type | Method and Description |
---|---|
void |
ScalarCollectionIO.executeInserts(PreparedStatement ps,
List<RowMapper.RowUpdate> rowus,
List<Column> columns,
boolean supportsBatchUpdates,
String sql,
JDBCConnection connection) |
void |
CollectionIO.executeInserts(PreparedStatement ps,
List<RowMapper.RowUpdate> rowus,
List<Column> columns,
boolean supportsBatchUpdates,
String sql,
JDBCConnection connection)
Sets the values of a fragment to a SQL prepared statement, and executes the statement for each value.
|
void |
ACLCollectionIO.executeInserts(PreparedStatement ps,
List<RowMapper.RowUpdate> rowus,
List<Column> columns,
boolean supportsBatchUpdates,
String sql,
JDBCConnection connection) |
protected void |
NXQLQueryMaker.fixWhatColumns(List<Column> whatColumns) |
Serializable |
ScalarCollectionIO.getCurrentFromResultSet(ResultSet rs,
List<Column> columns,
Model model,
Serializable[] returnId,
int[] returnPos) |
Serializable |
CollectionIO.getCurrentFromResultSet(ResultSet rs,
List<Column> columns,
Model model,
Serializable[] returnId,
int[] returnPos)
Gets one value from the current position of the result set.
|
ACLRow |
ACLCollectionIO.getCurrentFromResultSet(ResultSet rs,
List<Column> columns,
Model model,
Serializable[] returnId,
int[] returnPos) |
void |
JDBCLogger.logResultSet(ResultSet rs,
List<Column> columns) |
void |
JDBCLogger.logSQL(String sql,
List<Column> columns,
Row row) |
void |
JDBCLogger.logSQL(String sql,
List<Column> columns,
Row row,
List<Column> whereColumns,
Map<String,Serializable> conditions) |
void |
JDBCLogger.logSQL(String sql,
List<Column> columns,
Row row,
List<Column> whereColumns,
Map<String,Serializable> conditions) |
void |
TableUpgrader.upgrade(String tableKey,
List<Column> addedColumns,
String ddlMode,
SQLStatement.ListCollector ddlCollector)
Check if there is an added column that match with a upgrade process.
|
protected void |
JDBCMapper.upgradeTable(String tableKey,
List<Column> addedColumns,
String ddlMode,
SQLStatement.ListCollector ddlCollector) |
Constructor and Description |
---|
ColumnInfo(Column column,
Column posColumn,
int arrayElementIndex,
boolean isArrayElement,
boolean isArray) |
Constructor and Description |
---|
ColumnMapMaker(List<Column> columns) |
ColumnMapMaker(List<Column> columns,
List<String> keys) |
SQLInfoSelect(String sql,
List<Column> whatColumns,
List<Column> whereColumns,
List<Column> opaqueColumns)
Standard select for given columns.
|
SQLInfoSelect(String sql,
List<Column> whatColumns,
List<Column> whereColumns,
List<Column> opaqueColumns)
Standard select for given columns.
|
SQLInfoSelect(String sql,
List<Column> whatColumns,
List<Column> whereColumns,
List<Column> opaqueColumns)
Standard select for given columns.
|
SQLInfoSelect(String sql,
List<Column> whatColumns,
SQLInfo.MapMaker mapMaker,
List<Column> whereColumns,
List<Column> opaqueColumns) |
SQLInfoSelect(String sql,
List<Column> whatColumns,
SQLInfo.MapMaker mapMaker,
List<Column> whereColumns,
List<Column> opaqueColumns) |
SQLInfoSelect(String sql,
List<Column> whatColumns,
SQLInfo.MapMaker mapMaker,
List<Column> whereColumns,
List<Column> opaqueColumns) |
Modifier and Type | Field and Description |
---|---|
Column |
Join.column1
Left part of equijoin.
|
Column |
Join.column2
Right part of equijoin.
|
Modifier and Type | Method and Description |
---|---|
Column |
TableImpl.addColumn(String name,
Column column)
Adds a column without dialect physical name canonicalization (for directories).
|
Column |
TableImpl.addColumn(String name,
ColumnType type,
String key,
Model model) |
Column |
TableAlias.addColumn(String name,
ColumnType type,
String key,
Model model) |
Column |
Table.addColumn(String name,
ColumnType type,
String key,
Model model)
Adds a
Column to the table. |
Column |
TableImpl.getColumn(String name) |
Column |
TableAlias.getColumn(String name) |
Column |
Table.getColumn(String name) |
Column |
TableImpl.getPrimaryColumn() |
Column |
TableAlias.getPrimaryColumn() |
Column |
Table.getPrimaryColumn() |
Modifier and Type | Method and Description |
---|---|
Collection<Column> |
TableImpl.getColumns() |
Collection<Column> |
TableAlias.getColumns() |
Collection<Column> |
Table.getColumns() |
Modifier and Type | Method and Description |
---|---|
void |
Insert.addColumn(Column column) |
Column |
TableImpl.addColumn(String name,
Column column)
Adds a column without dialect physical name canonicalization (for directories).
|
void |
Insert.addIdentityColumn(Column idColumn) |
protected void |
TableImpl.addOneColumn(StringBuilder buf,
Column column)
Adds to buf the column name and its type and constraints for create / alter.
|
String |
TableImpl.getAddColumnSql(Column column)
Computes the SQL statement to alter a table and add a column to it.
|
String |
TableAlias.getAddColumnSql(Column column) |
String |
Table.getAddColumnSql(Column column)
Computes the SQL statement to alter a table and add a column to it.
|
List<String> |
TableImpl.getPostAddSqls(Column column,
Model model) |
List<String> |
TableAlias.getPostAddSqls(Column column,
Model model) |
List<String> |
Table.getPostAddSqls(Column column,
Model model)
Computes the SQL statements to finish adding a column, usually some ALTER TABLE statements to add constraints or
indexes.
|
protected void |
TableImpl.postAddColumn(Column column,
List<String> sqls,
Model model) |
Modifier and Type | Method and Description |
---|---|
void |
Update.setUpdatedColumns(List<Column> columns)
Alternative to
Update.setNewValues(java.lang.String) |
void |
Update.setUpdatedColumns(List<Column> columns,
Set<String> deltas)
Alternative to
Update.setNewValues(java.lang.String) |
Constructor and Description |
---|
Column(Column column,
Table table)
Creates a column from an existing column and an aliased table.
|
Join(int kind,
String table,
String tableAlias,
String tableParam,
Column column1,
Column column2) |
Modifier and Type | Class and Description |
---|---|
class |
DialectPostgreSQL.ArraySubQueryPostgreSQL.ArraySubQueryPostgreSQLColumn |
Modifier and Type | Field and Description |
---|---|
protected Column |
Dialect.ArraySubQuery.arrayColumn |
Column |
Dialect.FulltextMatchInfo.scoreCol |
Modifier and Type | Method and Description |
---|---|
Column |
DialectPostgreSQL.ArraySubQueryPostgreSQL.getSubQueryIdColumn() |
abstract Column |
Dialect.ArraySubQuery.getSubQueryIdColumn() |
Column |
DialectPostgreSQL.ArraySubQueryPostgreSQL.getSubQueryValueColumn() |
abstract Column |
Dialect.ArraySubQuery.getSubQueryValueColumn() |
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.getArrayInSql(Column arrayColumn,
String cast,
boolean positive,
List<Serializable> params) |
String |
Dialect.getArrayInSql(Column arrayColumn,
String cast,
boolean positive,
List<Serializable> params)
Gets the SQL string for an array column IN 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) |
Dialect.ArraySubQuery |
DialectPostgreSQL.getArraySubQuery(Column arrayColumn,
String subQueryAlias) |
Dialect.ArraySubQuery |
Dialect.getArraySubQuery(Column arrayColumn,
String subQueryAlias)
Gets the dialect-specific subquery for an array column.
|
Serializable |
DialectSQLServer.getFromResultSet(ResultSet rs,
int index,
Column column) |
Serializable |
DialectPostgreSQL.getFromResultSet(ResultSet rs,
int index,
Column column) |
Serializable |
DialectOracle.getFromResultSet(ResultSet rs,
int index,
Column column) |
Serializable |
DialectMySQL.getFromResultSet(ResultSet rs,
int index,
Column column) |
Serializable |
DialectHSQLDB.getFromResultSet(ResultSet rs,
int index,
Column column) |
Serializable |
DialectH2.getFromResultSet(ResultSet rs,
int index,
Column column) |
Serializable |
DialectDerby.getFromResultSet(ResultSet rs,
int index,
Column column) |
Serializable |
DialectDB2.getFromResultSet(ResultSet rs,
int index,
Column column) |
abstract Serializable |
Dialect.getFromResultSet(ResultSet rs,
int index,
Column column) |
protected Serializable |
Dialect.getFromResultSetString(ResultSet rs,
int index,
Column column) |
protected Serializable |
Dialect.getFromResultSetTimestamp(ResultSet rs,
int index,
Column column) |
Dialect.FulltextMatchInfo |
DialectSQLServer.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database) |
Dialect.FulltextMatchInfo |
DialectPostgreSQL.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database) |
Dialect.FulltextMatchInfo |
DialectOracle.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database) |
Dialect.FulltextMatchInfo |
DialectMySQL.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database) |
Dialect.FulltextMatchInfo |
DialectHSQLDB.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database) |
Dialect.FulltextMatchInfo |
DialectH2.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database) |
Dialect.FulltextMatchInfo |
DialectDerby.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database) |
Dialect.FulltextMatchInfo |
DialectDB2.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database) |
abstract Dialect.FulltextMatchInfo |
Dialect.getFulltextScoredMatchInfo(String fulltextQuery,
String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database)
Gets the SQL information needed to do a a fulltext match, either with a direct expression in the WHERE clause, or
using a join with an additional table.
|
String |
DialectOracle.getIdentityGeneratedKeySql(Column column) |
String |
Dialect.getIdentityGeneratedKeySql(Column column)
Gets the SQL query to execute to retrieve the last generated identity key.
|
String |
DialectPostgreSQL.getMatchMixinType(Column mixinsColumn,
String mixin,
boolean positive,
String[] returnParam) |
String |
Dialect.getMatchMixinType(Column mixinsColumn,
String mixin,
boolean positive,
String[] returnParam)
Gets the SQL fragment to match a mixin type.
|
String |
DialectSQLServer.getNoColumnsInsertString(Column idColumn) |
String |
DialectPostgreSQL.getNoColumnsInsertString(Column idColumn) |
String |
DialectOracle.getNoColumnsInsertString(Column idColumn) |
String |
Dialect.getNoColumnsInsertString(Column idColumn) |
List<String> |
DialectOracle.getPostCreateIdentityColumnSql(Column column) |
List<String> |
Dialect.getPostCreateIdentityColumnSql(Column column)
Gets additional SQL statements to execute after the CREATE TABLE when creating an identity column.
|
void |
DialectSQLServer.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
void |
DialectPostgreSQL.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
void |
DialectOracle.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
void |
DialectMySQL.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
void |
DialectHSQLDB.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
void |
DialectH2.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
void |
DialectDerby.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
void |
DialectDB2.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
abstract void |
Dialect.setToPreparedStatement(PreparedStatement ps,
int index,
Serializable value,
Column column) |
protected void |
Dialect.setToPreparedStatementString(PreparedStatement ps,
int index,
Serializable value,
Column column) |
void |
Dialect.setToPreparedStatementTimestamp(PreparedStatement ps,
int index,
Serializable value,
Column column) |
Modifier and Type | Method and Description |
---|---|
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.
|
Constructor and Description |
---|
ArraySubQuery(Column arrayColumn,
String subqueryAlias) |
ArraySubQueryPostgreSQL(Column arrayColumn,
String alias) |
Modifier and Type | Field and Description |
---|---|
protected List<Column> |
SQLDirectory.readColumns |
protected List<Column> |
SQLDirectory.readColumnsAll |
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) |
Modifier and Type | Method and Description |
---|---|
Set<Column> |
SQLHelper.getMissingColumns(Boolean breakAtFirstMissing) |
protected List<Column> |
SQLSession.getReadColumns() |
Modifier and Type | Method and Description |
---|---|
protected Serializable |
SQLSession.fieldValueForWrite(Object value,
Column column) |
Modifier and Type | Method and Description |
---|---|
protected void |
SQLSession.fillPreparedStatementFields(Map<String,Object> filterMap,
List<Column> orderedColumns,
PreparedStatement ps) |
Modifier and Type | Method and Description |
---|---|
int |
SQLOperatorFilter.doSetFieldValue(PreparedStatement ps,
int index,
Column column) |
abstract int |
SQLComplexFilter.doSetFieldValue(PreparedStatement ps,
int index,
Column column) |
int |
SQLBetweenFilter.doSetFieldValue(PreparedStatement ps,
int index,
Column column) |
int |
SQLComplexFilter.setFieldValue(PreparedStatement ps,
int index,
Column column) |
Modifier and Type | Field and Description |
---|---|
protected Column |
TagQueryMaker.firstSelectedColumn |
Modifier and Type | Method and Description |
---|---|
protected String |
TagQueryMaker.getSelectColName(Column col) |
Modifier and Type | Method and Description |
---|---|
protected void |
TagQueryMaker.fixWhatColumns(List<Column> whatColumns) |
Copyright © 2017 Nuxeo. All rights reserved.