Uses of Class
org.nuxeo.ecm.core.storage.sql.jdbc.db.Column
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 Column in org.nuxeo.ecm.core.opencmis.impl.server
Modifier and TypeFieldDescriptionfinal Column
CMISQLQueryMaker.SqlColumn.column
Column used to get the value from the result set.Modifier and TypeMethodDescriptionprotected 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) CMISQLQueryMaker.GeneratingWalker.resolveColumn
(org.antlr.runtime.tree.Tree node) Modifier and TypeMethodDescriptionprotected void
CMISQLQueryMaker.recordColumnFragment
(String qual, Column column) Records a database column's fragment (to know what to join). -
Uses of Column in org.nuxeo.ecm.core.storage.sql.jdbc
Modifier and TypeFieldDescriptionfinal Column
NXQLQueryMaker.ColumnInfo.column
protected Column
SQLInfo.deleteClusterInvalsColumn
protected Column
SQLInfo.deleteClusterNodeColumn
final Column
NXQLQueryMaker.ColumnInfo.posColumn
Modifier and TypeFieldDescriptionSQLInfo.clusterInvalidationsColumns
SQLInfo.ColumnMapMaker.columns
SQLInfo.createClusterNodeColumns
SQLInfo.getBinariesColumns
SQLInfo.SQLInfoSelect.opaqueColumns
NXQLQueryMaker.WhereBuilder.posColumns
NXQLQueryMaker.WhereBuilder.posColumnsInOrderBy
final LinkedList<Column>
NXQLQueryMaker.WhereBuilder.whatColumns
SQLInfo.SQLInfoSelect.whatColumns
SQLInfo.SQLInfoSelect.whereColumns
Modifier and TypeMethodDescriptionSQLInfo.getCopyIdColumn
(String tableName) SQLInfo.getDeleteClusterInvalsColumn()
SQLInfo.getDeleteClusterNodeColumn()
SQLInfo.getSelectRootIdWhatColumn()
protected Column
SQLInfo.TableMaker.newColumn
(String columnName, ColumnType type) Modifier and TypeMethodDescriptionSQLInfo.getClusterInvalidationsColumns()
SQLInfo.getCreateClusterNodeColumns()
SQLInfo.getInsertColumns
(String tableName) Returns the list of columns to use for anINSERT
statementSQLInfo.getInsertSql(java.lang.String)
.SQLInfo.getInsertRootIdColumns()
SQLInfo.getSelectChildrenIdsAndTypesWhatColumns()
SQLInfo.getSelectDescendantsInfoWhatColumns()
Modifier and TypeMethodDescriptionprotected 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 neededprotected 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 TypeMethodDescriptionprotected void
NXQLQueryMaker.fixWhatColumns
(List<Column> whatColumns) ACLCollectionIO.getCurrentFromResultSet
(ResultSet rs, List<Column> columns, Model model, Serializable[] returnId, int[] returnPos) CollectionIO.getCurrentFromResultSet
(ResultSet rs, List<Column> columns, Model model, Serializable[] returnId, int[] returnPos) Gets one value from the current position of the result set.ScalarCollectionIO.getCurrentFromResultSet
(ResultSet rs, List<Column> columns, Model model, Serializable[] returnId, int[] returnPos) protected RowMapper.NodeInfo
JDBCRowMapper.getNodeInfo
(ResultSet rs, List<Column> columns) void
JDBCLogger.logResultSet
(ResultSet rs, List<Column> columns) void
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.ModifierConstructorDescriptionColumnInfo
(Column column, Column posColumn, int arrayElementIndex, boolean isArrayElement, boolean isArray) ModifierConstructorDescriptionColumnMapMaker
(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, SQLInfo.MapMaker mapMaker, List<Column> whereColumns, List<Column> opaqueColumns) -
Uses of Column in org.nuxeo.ecm.core.storage.sql.jdbc.db
Modifier and TypeFieldDescriptionJoin.column1
Left part of equijoin.Join.column2
Right part of equijoin.Modifier and TypeMethodDescriptionTable.addColumn
(String name, ColumnType type, String key, Model model) Adds aColumn
to the table.TableAlias.addColumn
(String name, ColumnType type, String key, Model model) TableImpl.addColumn
(String name, ColumnType type, String key, Model model) Adds a column without dialect physical name canonicalization (for directories).Table.getPrimaryColumn()
TableAlias.getPrimaryColumn()
TableImpl.getPrimaryColumn()
Modifier and TypeMethodDescriptionTable.getColumns()
TableAlias.getColumns()
TableImpl.getColumns()
Modifier and TypeMethodDescriptionvoid
Adds a column without dialect physical name canonicalization (for directories).void
Insert.addIdentityColumn
(Column idColumn) protected void
TableImpl.addOneColumn
(StringBuilder sb, Column column) Adds to buf the column name and its type and constraints for create / alter.Table.getAddColumnSql
(Column column) Computes the SQL statement to alter a table and add a column to it.TableAlias.getAddColumnSql
(Column column) TableImpl.getAddColumnSql
(Column column) Computes the SQL statement to alter a table and add a column to it.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.TableAlias.getPostAddSqls
(Column column, Model model) TableImpl.getPostAddSqls
(Column column, Model model) protected void
TableImpl.postAddColumn
(Column column, List<String> sqls, Model model) Modifier and TypeMethodDescriptionvoid
Update.setUpdatedColumns
(List<Column> columns) Alternative toUpdate.setNewValues(java.lang.String)
void
Update.setUpdatedColumns
(List<Column> columns, Set<String> deltas) Alternative toUpdate.setNewValues(java.lang.String)
-
Uses of Column in org.nuxeo.ecm.core.storage.sql.jdbc.dialect
Modifier and TypeClassDescriptionclass
Modifier and TypeFieldDescriptionprotected Column
Dialect.ArraySubQuery.arrayColumn
Dialect.FulltextMatchInfo.scoreCol
Modifier and TypeMethodDescriptionabstract Column
Dialect.ArraySubQuery.getSubQueryIdColumn()
DialectPostgreSQL.ArraySubQueryPostgreSQL.getSubQueryIdColumn()
abstract Column
Dialect.ArraySubQuery.getSubQueryValueColumn()
DialectPostgreSQL.ArraySubQueryPostgreSQL.getSubQueryValueColumn()
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.getArrayInSql
(Column arrayColumn, String cast, boolean positive, List<Serializable> params) Gets the SQL string for an array column IN expression.DialectPostgreSQL.getArrayInSql
(Column arrayColumn, String cast, boolean positive, List<Serializable> params) 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) Dialect.getArraySubQuery
(Column arrayColumn, String subQueryAlias) Gets the dialect-specific subquery for an array column.DialectPostgreSQL.getArraySubQuery
(Column arrayColumn, String subQueryAlias) abstract Serializable
Dialect.getFromResultSet
(ResultSet rs, int index, Column column) DialectDB2.getFromResultSet
(ResultSet rs, int index, Column column) DialectH2.getFromResultSet
(ResultSet rs, int index, Column column) DialectMySQL.getFromResultSet
(ResultSet rs, int index, Column column) DialectOracle.getFromResultSet
(ResultSet rs, int index, Column column) DialectPostgreSQL.getFromResultSet
(ResultSet rs, int index, Column column) DialectSQLServer.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) 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.DialectDB2.getFulltextScoredMatchInfo
(String fulltextQuery, String indexName, int nthMatch, Column mainColumn, Model model, Database database) DialectH2.getFulltextScoredMatchInfo
(String fulltextQuery, String indexName, int nthMatch, Column mainColumn, Model model, Database database) DialectMySQL.getFulltextScoredMatchInfo
(String fulltextQuery, String indexName, int nthMatch, Column mainColumn, Model model, Database database) DialectOracle.getFulltextScoredMatchInfo
(String fulltextQuery, String indexName, int nthMatch, Column mainColumn, Model model, Database database) DialectPostgreSQL.getFulltextScoredMatchInfo
(String fulltextQuery, String indexName, int nthMatch, Column mainColumn, Model model, Database database) DialectSQLServer.getFulltextScoredMatchInfo
(String fulltextQuery, String indexName, int nthMatch, Column mainColumn, Model model, Database database) Dialect.getIdentityGeneratedKeySql
(Column column) Gets the SQL query to execute to retrieve the last generated identity key.DialectOracle.getIdentityGeneratedKeySql
(Column column) Dialect.getMatchMixinType
(Column mixinsColumn, String mixin, boolean positive, String[] returnParam) Gets the SQL fragment to match a mixin type.DialectPostgreSQL.getMatchMixinType
(Column mixinsColumn, String mixin, boolean positive, String[] returnParam) Dialect.getNoColumnsInsertString
(Column idColumn) DialectOracle.getNoColumnsInsertString
(Column idColumn) DialectPostgreSQL.getNoColumnsInsertString
(Column idColumn) DialectSQLServer.getNoColumnsInsertString
(Column idColumn) Dialect.getPostCreateIdentityColumnSql
(Column column) Gets additional SQL statements to execute after the CREATE TABLE when creating an identity column.DialectOracle.getPostCreateIdentityColumnSql
(Column column) Dialect.getQuotedNameForExpression
(Column column) Gets the SQL to use to refer to a column in an expression.DialectOracle.getQuotedNameForExpression
(Column column) abstract void
Dialect.setToPreparedStatement
(PreparedStatement ps, int index, Serializable value, Column column) void
DialectDB2.setToPreparedStatement
(PreparedStatement ps, int index, Serializable value, Column column) void
DialectH2.setToPreparedStatement
(PreparedStatement ps, int index, Serializable value, Column column) void
DialectMySQL.setToPreparedStatement
(PreparedStatement ps, int index, Serializable value, Column column) void
DialectOracle.setToPreparedStatement
(PreparedStatement ps, int index, Serializable value, Column column) void
DialectPostgreSQL.setToPreparedStatement
(PreparedStatement ps, int index, Serializable value, Column column) void
DialectSQLServer.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 TypeMethodDescriptionabstract 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.getInsertOnConflictDoNothingSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) Gets the SQL string for an INSERT ...DialectMySQL.getInsertOnConflictDoNothingSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) DialectOracle.getInsertOnConflictDoNothingSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) DialectPostgreSQL.getInsertOnConflictDoNothingSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) DialectSQLServer.getInsertOnConflictDoNothingSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) protected String
DialectOracle.getMergeSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues, boolean updateWhenMatched) protected String
DialectSQLServer.getMergeSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues, boolean updateWhenMatched) abstract String
Dialect.getUpsertSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) Gets the SQL string for an UPSERT expression.DialectDB2.getUpsertSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) DialectH2.getUpsertSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) DialectMySQL.getUpsertSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) DialectOracle.getUpsertSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) DialectPostgreSQL.getUpsertSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) DialectSQLServer.getUpsertSql
(List<Column> columns, List<Serializable> values, List<Column> outColumns, List<Serializable> outValues) ModifierConstructorDescriptionArraySubQuery
(Column arrayColumn, String subqueryAlias) ArraySubQueryPostgreSQL
(Column arrayColumn, String alias) -
Uses of Column in org.nuxeo.ecm.core.storage.sql.kv
Modifier and TypeFieldDescriptionprotected Column
SQLKeyValueStore.bytesCol
protected Column
SQLKeyValueStore.keyCol
protected Column
SQLKeyValueStore.longCol
protected Column
SQLKeyValueStore.stringCol
protected Column
SQLKeyValueStore.ttlCol
Modifier and TypeMethodDescriptionprotected Column
SQLKeyValueStore.addColumn
(String columnName, ColumnType type) Modifier and TypeMethodDescriptionprotected void
SQLKeyValueStore.setToPreparedStatement
(String sql, PreparedStatement ps, Column column, Serializable value) protected void
SQLKeyValueStore.setToPreparedStatement
(String sql, PreparedStatement ps, Column column1, Serializable value1, Column column2, Serializable value2) protected void
SQLKeyValueStore.setToPreparedStatement
(String sql, PreparedStatement ps, Column column1, Serializable value1, Column column2, Serializable value2, Column column3, Serializable value3) Modifier and TypeMethodDescriptionprotected void
SQLKeyValueStore.setToPreparedStatement
(String sql, PreparedStatement ps, List<Column> columns, List<? extends Serializable> values) -
Uses of Column in org.nuxeo.ecm.directory.sql
Modifier and TypeFieldDescriptionfinal Column
SQLQueryBuilder.ColumnAndValue.column
protected Column
SQLDirectory.idColumn
protected Column
SQLQueryBuilder.visitedColumn
Modifier and TypeMethodDescriptionstatic Column
SQLHelper.addColumn
(Table table, String fieldName, ColumnType type, boolean nativeCase) SQLQueryBuilder.ColumnAndValue.getColumn()
protected Column
SQLStaticFilter.getDirectoryColumn
(Table table, boolean nativeCase) protected Column
SQLSession.getIdColumn()
Modifier and TypeMethodDescriptionSQLHelper.getMissingColumns
(Boolean breakAtFirstMissing) SQLSession.getReadColumns()
Modifier and TypeMethodDescriptionprotected Serializable
SQLSession.fieldValueForWrite
(Object value, Column column) protected void
SQLSession.setIdFieldInMap
(ResultSet rs, Column column, String idFieldName, Map<String, Object> fieldMap) protected void
SQLQueryBuilder.visitColumn
(Column column) protected void
SQLQueryBuilder.visitExpression
(Column column, Operator op, Operand rvalue) protected void
SQLQueryBuilder.visitExpressionBetween
(Column column, Operator op, LiteralList list) protected void
SQLQueryBuilder.visitExpressionILike
(Column column, Operator op, Operand rvalue) protected void
SQLQueryBuilder.visitExpressionLike
(Column column, Operator op, Operand rvalue) Modifier and TypeMethodDescriptionprotected void
SQLSession.fillPreparedStatementFields
(Map<String, Object> filterMap, List<Column> orderedColumns, PreparedStatement ps) -
Uses of Column in org.nuxeo.ecm.directory.sql.filter
Modifier and TypeMethodDescriptionint
SQLBetweenFilter.doSetFieldValue
(PreparedStatement ps, int index, Column column) Deprecated.abstract int
SQLComplexFilter.doSetFieldValue
(PreparedStatement ps, int index, Column column) Deprecated.int
SQLOperatorFilter.doSetFieldValue
(PreparedStatement ps, int index, Column column) Deprecated.int
SQLComplexFilter.setFieldValue
(PreparedStatement ps, int index, Column column) Deprecated. -
Uses of Column in org.nuxeo.ecm.platform.tag
Modifier and TypeMethodDescriptionprotected void
TagQueryMaker.fixWhatColumns
(List<Column> whatColumns)