Uses of Class
org.apache.empire.db.DBColumn
Packages that use DBColumn
Package
Description
This package contains the core Empire-DB implementation classes.
This package contains SQL-generator classes for column expressions.
This package contains SQL-generator classes for compare expressions used in the where and having clause.
This package contains SQL-generator classes for join expressions used in the from clause.
This package contains SQL-generator classes for set expressions used in the set clause.
This package contains classes necessary to support the Oracle database system.
This package contains classes necessary to support the PostgreSQL database system.
-
Uses of DBColumn in org.apache.empire.db
Subclasses of DBColumn in org.apache.empire.dbModifier and TypeClassDescriptionprotected static classThis class wraps a column of sql command in a special command column object.classclassThis class represent one column of a table.static classDBViewColumnFields in org.apache.empire.db declared as DBColumnModifier and TypeFieldDescriptionprotected final DBColumn[]DBQuery.keyColumnsprotected DBColumnDBRowSet.timestampColumnprotected final DBColumnDBView.DBViewColumn.updateColumnFields in org.apache.empire.db with type parameters of type DBColumnModifier and TypeFieldDescriptionDBRowSet.columnReferencesDBRowSet.columnReferencesDBRowSet.columnsMethods in org.apache.empire.db with type parameters of type DBColumnModifier and TypeMethodDescriptionfinal <T extends DBColumn>
TDBColumn.setCaseInsensitive()Sets the case sensitivity of the column to insensitive Text columns are case sensitive by default<T extends DBColumn>
TDBColumn.setCaseSensitive(Boolean caseSensitiv) Sets the case sensitivity of the columnExprfinal <T extends DBColumn>
TDBColumn.setNumberType(String numberType) Sets the number type to a given value<T extends DBColumn>
TDBColumn.setRegExPattern(String regex) Set the regular expression to validate the columnExpr value<T extends DBColumn>
TDBColumn.setSortExpr(String sortFunctionTemplate) Sets a sort function template for a given column<T extends DBColumn>
TDBColumn.setSortExpr(DBColumnExpr sortExpression) Sets a sort function expression for a given columnMethods in org.apache.empire.db that return DBColumnModifier and TypeMethodDescriptionprotected DBColumnDBCommandExpr.DBCmdQuery.cloneColumn(DBRowSet clone, DBColumn scourceColumn) throws ERR_NOTSUPPORTEDprotected DBColumnDBQuery.cloneColumn(DBRowSet clone, DBColumn scourceColumn) protected abstract DBColumnDBRowSet.cloneColumn(DBRowSet clone, DBColumn scourceColumn) Clones a RowSet columnprotected DBColumnDBTable.cloneColumn(DBRowSet clone, DBColumn sourceColumn) protected DBColumnDBView.cloneColumn(DBRowSet clone, DBColumn sourceColumn) DBColumn[]DBRowSet.getAllColumns()Returns an array of all columns of this rowsetDBIndex.getColumn(int index) Returns the columns belonging to this index.DBRecordBase.getColumn(int index) Implements the Record Interface getColumn method.
Internally calls getDBColumn()DBRowSet.getColumn(int iColumn) Returns a DBColumn object by a specified index value.Gets the column Expression with a particular name.DBColumn[]DBIndex.getColumns()Returns the columns belonging to this index.DBColumn[]DBCommandExpr.DBCmdQuery.getKeyColumns()Prints the error message: ERR_NOTSUPPORTED.DBColumn[]DBQuery.getKeyColumns()abstract DBColumn[]DBRowSet.getKeyColumns()DBColumn[]DBTable.getKeyColumns()Returns an array of all primary key columns.DBColumn[]DBView.getKeyColumns()Returns an array of all key columns.final DBColumnDBColumnExpr.getSourceColumn()Deprecated.DBRowSet.getTimestampColumn()DBColumn.getUpdateColumn()Returns itself as the underlying column.abstract DBColumnDBColumnExpr.getUpdateColumn()Returns the underlying physical column.static DBColumn[]varArgs to ArrayMethods in org.apache.empire.db that return types with arguments of type DBColumnModifier and TypeMethodDescriptionDBRowSet.getColumnReferences()Returns the a list of column references.DBRowSet.getColumnReferences()Returns the a list of column references.DBRowSet.getColumns()Returns a list of all columns of this rowset (e.g. for cmd.select()).Methods in org.apache.empire.db with parameters of type DBColumnModifier and TypeMethodDescriptionprotected voidDBDDLGenerator.addAlterTableStmt(DBColumn col, DBSQLBuilder sql, DBSQLScript script) protected voidDBRowSet.addColumnReference(DBColumn source, DBColumn target) Adds a column reference to the list of table references.final DBIndexAdds an index.final DBIndexDBTable.addIndex(String name, DBIndex.DBIndexType type, DBColumn... columns) Adds an index.protected booleanDBQuery.addJoinRestriction(DBCommand cmd, DBColumn updCol, DBColumn joinCol, Object[] key, DBRecordBase record) Adds join restrictions to the supplied command object.protected booleanDBRecordBase.allowFieldChange(DBColumn column) Checks whether or not this field can be changed at all.final DBAliasExprcreates a new DBAliasExpr which renames the current expression to the name of the supplied column.protected DBColumnDBCommandExpr.DBCmdQuery.cloneColumn(DBRowSet clone, DBColumn scourceColumn) throws ERR_NOTSUPPORTEDprotected DBColumnDBQuery.cloneColumn(DBRowSet clone, DBColumn scourceColumn) protected abstract DBColumnDBRowSet.cloneColumn(DBRowSet clone, DBColumn scourceColumn) Clones a RowSet columnprotected DBColumnDBTable.cloneColumn(DBRowSet clone, DBColumn sourceColumn) protected DBColumnDBView.cloneColumn(DBRowSet clone, DBColumn sourceColumn) booleanDBIndex.compareColumns(DBColumn[] columns) checks whether the columns of this index match the supplied columnsbooleanChecks if this index contains the column colbooleanChecks if this index contains the column colintDBQuery.getColumnIndex(DBColumn column) intDBRowSet.getColumnIndex(DBColumn column) Gets the index of a particular column expression.intDBExpressionIndex.getColumnPos(DBColumn col) Gets the position of a specified DBColumn object.intDBIndex.getColumnPos(DBColumn col) Gets the position of a specified DBColumn object.DBRecordBase.getFieldOptions(DBColumn column) Gets the possbile Options for a field in the context of the current record.booleanReturns true if the command has a join on the given column or false otherwise.protected booleanDBCommand.hasSetExprOn(DBColumn column) Checks whether a column is in the list of set expressionsprotected booleanhelper function to check if a given field index corresponds to one of the given columnsbooleanDBRowSet.isColumnReadOnly(DBColumn col) Checks whether a column is read only or writable.booleanDBRowSet.isKeyColumn(DBColumn column) Checks whether a given column is part of the primary key for this RowSetbooleanDBRelation.isOnColumns(DBColumn[] keyColumns) Checks if the relation references the given keyfinal DBCommandDBCommand.join(DBColumn[] left, DBColumn[] right, DBJoinType joinType, DBCompareExpr... addlConstraints) Multi-Column version of column based join expressionfinal DBCommandDBCommand.join(DBColumnExpr left, DBColumn right, DBJoinType joinType, DBCompareExpr... addlConstraints) Adds a join based on two columns to the list of join expressions.final DBCommandDBCommand.join(DBColumnExpr left, DBColumn right, DBCompareExpr... addlConstraints) Adds an inner join based on two columns to the list of join expressions.final DBCommandDBCommand.joinLeft(DBColumnExpr left, DBColumn right, DBCompareExpr... addlConstraints) Adds a left join based on two columns to the list of join expressions.final DBCommandDBCommand.joinRight(DBColumnExpr left, DBColumn right, DBCompareExpr... addlConstraints) Adds a right join based on two columns to the list of join expressions.static DBColumn[]varArgs to ArrayDBRecord.read(Object[] key, DBRowSet.PartialMode mode, DBColumn... columns) Reads a record partially i.e. not with all but just some selected fields There are two modes: 1.DBRecordBean.read(DBContext context, DBRowSet rowset, Object[] key, DBRowSet.PartialMode mode, DBColumn... columns) Reads a record partially i.e. not with all but just some selected fields There are two modes: 1.voidDBRowSet.readRecord(DBRecordBase record, DBCompareExpr whereConstraints, DBRowSet.PartialMode mode, DBColumn... columns) Reads the partial record for a given primary key from the databasebooleanDBCommand.removeJoinsOn(DBColumn column) removes all joins to a given columnvoidDBRecordBase.setParentRecord(DBColumn parentIdColumn, DBRecordBase record) For DBMS with IDENTITY-columns defer setting the parent-id until the record is inserted The parent record must have a one-column primary keyvoidDBTable.setPrimaryKey(DBColumn... columns) Sets the primary key.voidDBRowSet.setTimestampColumn(DBColumn timestampColumn) Method parameters in org.apache.empire.db with type arguments of type DBColumnModifier and TypeMethodDescriptionvoidDBCmdParam.addReferencedColumns(Set<DBColumn> list) voidDBColumn.addReferencedColumns(Set<DBColumn> list) voidDBCombinedCmd.addReferencedColumns(Set<DBColumn> list) voidDBCommand.addReferencedColumns(Set<DBColumn> list) Adds ColumnsvoidDBCommandExpr.DBCmdQuery.addReferencedColumns(Set<DBColumn> list) abstract voidDBExpr.addReferencedColumns(Set<DBColumn> list) Internal function to obtain all DBColumnExpr-objects used by this expression.voidDBGeneratedValue.DBFuncGeneratedValue.addReferencedColumns(Set<DBColumn> list) voidDBGeneratedValue.DBTriggerGeneratedValue.addReferencedColumns(Set<DBColumn> list) voidDBRowSet.addReferencedColumns(Set<DBColumn> list) Constructors in org.apache.empire.db with parameters of type DBColumnModifierConstructorDescriptionDBIndex(String name, DBIndex.DBIndexType type, DBColumn[] columns) Constructs a DBIndex object set the specified parameters to this object.DBQuery(DBCommandExpr cmd, DBColumn keyColumn) Constructs a new DBQuery object initialize the query object.DBQuery(DBCommandExpr cmd, DBColumn[] keyColumns) Constructor initializes the query object.DBQuery(DBCommandExpr cmd, DBColumn[] keyColumns, String alias) Constructor initializes the query object.DBQuery(DBCommandExpr cmd, DBColumn keyColumn, String alias) Constructs a new DBQuery object initialize the query object. -
Uses of DBColumn in org.apache.empire.db.expr.column
Methods in org.apache.empire.db.expr.column that return DBColumnModifier and TypeMethodDescriptionDBAbstractFuncExpr.getUpdateColumn()Returns the DBColunm object.DBAliasExpr.getUpdateColumn()Returns the DBColunm object.DBCalcExpr.getUpdateColumn()Returns the underlying columnDBCaseExpr.getUpdateColumn()DBCmdResultExpr.getUpdateColumn()DBConcatExpr.getUpdateColumn()Returns the underlying columnDBConcatFuncExpr.getUpdateColumn()DBCountExpr.getUpdateColumn()Returns the underlying columnDBDecodeExpr.getUpdateColumn()DBParenthesisExpr.getUpdateColumn()Returns the DBColunm object.DBScalarExpr.getUpdateColumn()Returns null.DBValueExpr.getUpdateColumn()Returns null.DBVarArgsFuncExpr.getUpdateColumn()Returns the underlying columnMethod parameters in org.apache.empire.db.expr.column with type arguments of type DBColumnModifier and TypeMethodDescriptionvoidDBAbstractFuncExpr.addReferencedColumns(Set<DBColumn> list) voidDBAliasExpr.addReferencedColumns(Set<DBColumn> list) voidDBCalcExpr.addReferencedColumns(Set<DBColumn> list) voidDBCaseMapExpr.addReferencedColumns(Set<DBColumn> list) voidDBCaseWhenExpr.addReferencedColumns(Set<DBColumn> list) voidDBCmdResultExpr.addReferencedColumns(Set<DBColumn> list) voidDBCoalesceExpr.addReferencedColumns(Set<DBColumn> list) voidDBConcatExpr.addReferencedColumns(Set<DBColumn> list) voidDBCountExpr.addReferencedColumns(Set<DBColumn> list) voidDBDecodeExpr.addReferencedColumns(Set<DBColumn> list) voidDBFuncExpr.addReferencedColumns(Set<DBColumn> list) voidDBParenthesisExpr.addReferencedColumns(Set<DBColumn> list) voidDBScalarExpr.addReferencedColumns(Set<DBColumn> list) voidDBValueExpr.addReferencedColumns(Set<DBColumn> list) voidDBVarArgsFuncExpr.addReferencedColumns(Set<DBColumn> list) -
Uses of DBColumn in org.apache.empire.db.expr.compare
Method parameters in org.apache.empire.db.expr.compare with type arguments of type DBColumnModifier and TypeMethodDescriptionvoidDBCompareAndOrExpr.addReferencedColumns(Set<DBColumn> list) voidDBCompareColExpr.addReferencedColumns(Set<DBColumn> list) voidDBCompareNotExpr.addReferencedColumns(Set<DBColumn> list) voidDBCompareParenthesisExpr.addReferencedColumns(Set<DBColumn> list) voidDBExistsExpr.addReferencedColumns(Set<DBColumn> list) -
Uses of DBColumn in org.apache.empire.db.expr.join
Methods in org.apache.empire.db.expr.join with parameters of type DBColumnModifier and TypeMethodDescriptionbooleanreturns true if this join is using the given column or false otherwisebooleanreturns true if this join is using the given column or false otherwiseabstract booleanreturns true if this join is using the given column or false otherwiseMethod parameters in org.apache.empire.db.expr.join with type arguments of type DBColumnModifier and TypeMethodDescriptionvoidDBColumnJoinExpr.addReferencedColumns(Set<DBColumn> list) voidDBCrossJoinExpr.addReferencedColumns(Set<DBColumn> list) -
Uses of DBColumn in org.apache.empire.db.expr.order
Method parameters in org.apache.empire.db.expr.order with type arguments of type DBColumn -
Uses of DBColumn in org.apache.empire.db.expr.set
Fields in org.apache.empire.db.expr.set declared as DBColumnMethods in org.apache.empire.db.expr.set that return DBColumnMethod parameters in org.apache.empire.db.expr.set with type arguments of type DBColumnConstructors in org.apache.empire.db.expr.set with parameters of type DBColumn -
Uses of DBColumn in org.apache.empire.db.validation
Methods in org.apache.empire.db.validation that return DBColumnMethods in org.apache.empire.db.validation with parameters of type DBColumnModifier and TypeMethodDescriptionprotected voidDBModelChecker.checkAutoIncColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkBlobColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkBoolColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkCharColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkClobColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkColumnNullable(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkColumnSize(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkColumnType(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkDateColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkDecimalColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkFloatColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkIntegerColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkTextColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkUniqueIdColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidDBModelChecker.checkUnknownColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) empire-db DataType-specific checkervoidDBModelErrorHandler.columnNullableMismatch(DBColumn col, boolean nullable) This method is called when a NOT NULL constraints of a column in the Empire-db definition does not match the database.voidDBModelErrorLogger.columnNullableMismatch(DBColumn col, boolean nullable) handle columnNullableMismatch errorsvoidDBModelErrorHandler.columnSizeMismatch(DBColumn col, int size, int scale) This method is called when the size of a column in the Empire-db definition does not match the database.voidDBModelErrorLogger.columnSizeMismatch(DBColumn col, int size, int scale) handle columnSizeMismatch errorsvoidDBModelErrorHandler.columnTypeMismatch(DBColumn col, DataType type) This method is called when the type of a column in the Empire-db definition does not match the database.voidDBModelErrorLogger.columnTypeMismatch(DBColumn col, DataType type) handle columnTypeMismatch errorsvoidDBModelErrorHandler.primaryKeyColumnMissing(DBIndex primaryKey, DBColumn column) This method is called when a column in a primary key of the Empire-db definition is missing in the databasevoidDBModelErrorLogger.primaryKeyColumnMissing(DBIndex primaryKey, DBColumn column) handle primaryKeyColumnMissing errorsvoidDBModelErrorHandler.primaryKeyMismatch(DBIndex primaryKey, DBColumn[] tableKey) This method is called when the primary key of the Empire-db definition does not match the primary key of the existing tablevoidDBModelErrorLogger.primaryKeyMismatch(DBIndex primaryKey, DBColumn[] tableKey) -
Uses of DBColumn in org.apache.empire.dbms
Fields in org.apache.empire.dbms declared as DBColumnModifier and TypeFieldDescriptionDBMSHandlerBase.DBSeqTable.C_SEQNAMEDBMSHandlerBase.DBSeqTable.C_SEQVALUEDBMSHandlerBase.DBSeqTable.C_TIMESTAMP -
Uses of DBColumn in org.apache.empire.dbms.oracle
Methods in org.apache.empire.dbms.oracle that return DBColumnMethods in org.apache.empire.dbms.oracle with parameters of type DBColumnModifier and TypeMethodDescriptionprotected voidOracleDBModelChecker.checkBoolColumn(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) protected voidOracleDBModelChecker.checkColumnType(DBColumn column, DBColumn remoteColumn, DBModelErrorHandler handler) Method parameters in org.apache.empire.dbms.oracle with type arguments of type DBColumn -
Uses of DBColumn in org.apache.empire.dbms.postgresql
Methods in org.apache.empire.dbms.postgresql that return DBColumnModifier and TypeMethodDescriptionPostgresBoolAndOrExpr.getUpdateColumn()PostgresIntervalExpr.getUpdateColumn()Method parameters in org.apache.empire.dbms.postgresql with type arguments of type DBColumnModifier and TypeMethodDescriptionvoidPostgresAtAt.addReferencedColumns(Set<DBColumn> list) voidPostgresBoolAndOrExpr.addReferencedColumns(Set<DBColumn> list) voidPostgresFuncExpr.addReferencedColumns(Set<DBColumn> list) voidPostgresIntervalExpr.addReferencedColumns(Set<DBColumn> list)