Uses of Class
org.apache.empire.db.DBTableColumn
Packages that use DBTableColumn
Package
Description
This package contains the core Empire-DB implementation classes.
This package contains classes necessary to support the Apache Derby database system.
This package contains classes necessary to support the H2 database system.
This package contains classes necessary to support the HSQLDB database system.
This package contains classes necessary to support the MySQL database system.
This package contains classes necessary to support the Oracle database system.
This package contains classes necessary to support the PostgreSQL database system.
This package contains classes necessary to support the Microsoft SQL-Server database system.
-
Uses of DBTableColumn in org.apache.empire.db
Methods in org.apache.empire.db that return DBTableColumnModifier and TypeMethodDescriptionfinal DBTableColumnCreates a new table column and adds it to the table's column listfinal DBTableColumnDBTable.addColumn(String columnName, DataType type, double size, boolean required, Class<? extends Enum<?>> enumType) Creates a new table column with Enum-Options and adds it to the table's column list This overload should be used for column containing enum values which have no default value.final DBTableColumnDBTable.addColumn(String columnName, DataType type, double size, boolean required, Enum<?> enumValue) Creates a new table column with Enum-Options and adds it to the table's column list This overload should be used for column containing enum values which have a default value.final DBTableColumnCreates a new DBTableColumn object and adds it to the column collection.final DBTableColumnCreates a new table column with options and adds it to the table's column list This overload should be used for column containing enum values which have no default value.final DBTableColumnDBTable.addColumn(String columnName, DataType type, double size, boolean required, Options options, Object defValue) Creates a new table column with options and adds it to the table's column list This overload should be used for column containing enum values which have a default value.final DBTableColumnDBTable.addForeignKey(String name, DBTable target, boolean required) Adds a new ForgeinKey table column the column list The foreign table must have a single column foreign keyfinal DBTableColumnDBTable.addForeignKey(String name, DBTable target, boolean required, boolean cascade) Adds a new ForgeinKey table column the column list The foreign table must have a single column foreign keyDBTable.addForeignKey(String name, DBTable target, boolean required, Options options, DBRelation.DBCascadeAction cascadeAction) Adds a new ForgeinKey table column the column list The foreign table must have a single column foreign keyfinal DBTableColumnDBTable.addIdentity(String name) Adds an Identity column to the table which also serves as the PrimaryKey An Identity Column is always an auto-generated Integer(Long) valueDBTable.addIdentity(String name, String seqName) Adds an Identity column to the table which also serves as the PrimaryKey An Identity Column is always an auto-generated Integer(Long) valueDBTable.addTimestamp(String name) Adds a Timestamp column to the current table which will be used for optimistic locking.protected DBTableColumnDBTable.createAndAppendColumn(String columnName, DataType type, double size, boolean required, Object defValue) Creates a new Column object and appends it to the column listDBRelation.DBReference.getSourceColumn()DBRelation.DBReference.getTargetColumn()Methods in org.apache.empire.db with parameters of type DBTableColumnModifier and TypeMethodDescriptionprotected voidDBTable.addColumn(DBTableColumn column) Adds a column to this table's column list.protected final DBView.DBViewColumnDBView.addColumn(DBTableColumn sourceColumn) Adds a column to the view based on an existing column in another table.protected voidDBDDLGenerator.alterTable(DBTableColumn col, DBDDLGenerator.DDLActionType type, DBSQLScript script) Appends the DDL-Script for altering a table to an SQL-Scriptprotected booleanDBDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql) appends the data type of a columnprotected voidDBDDLGenerator.appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql) Appends a table column definition to a ddl statementstatic DBGeneratedValueDBGeneratedValue.byTrigger(DBTable table, String triggerName, DBTableColumn... columns) Returns a generated value for a triggerDBTableColumn.referenceOn(DBTableColumn target) Creates a foreign key relation for this column.protected NumberDBDatabase.validateNumber(DBTableColumn column, DataType type, Number n) protected StringDBDatabase.validateString(DBTableColumn column, String value) protected ObjectDBDatabase.validateValue(DBTableColumn column, Object value) Checks whether the supplied value is valid for the given column.protected ObjectDBTable.validateValue(DBTableColumn column, Object value) validates a column valueConstructors in org.apache.empire.db with parameters of type DBTableColumnModifierConstructorDescriptionDBReference(DBTableColumn sourceColumn, DBTableColumn targetColumn) protectedDBTableColumn(DBTable newTable, DBTableColumn other) Clone ConstructorDBTriggerGeneratedValue(DBRowSet table, String triggerName, DBTableColumn[] sourceColumns) -
Uses of DBTableColumn in org.apache.empire.dbms
Methods in org.apache.empire.dbms with parameters of type DBTableColumnModifier and TypeMethodDescriptionDBMSHandler.getColumnAutoValue(DBDatabase db, DBTableColumn column, Connection conn) Returns an auto-generated value for a particular columnDBMSHandlerBase.getColumnAutoValue(DBDatabase db, DBTableColumn column, Connection conn) Returns an auto-generated value for a particular columnDBMSHandlerBase.getColumnSequenceName(DBTableColumn column) Returns the sequence name of for a column of type AUTOINC The sequence name is usually provided as the default value If no Default value is provided the sequence name is generated from the table and the column nameabstract DBColumnExprDBMSHandlerBase.getNextSequenceValueExpr(DBTableColumn column) Returns an expression for creating a sequence value. -
Uses of DBTableColumn in org.apache.empire.dbms.derby
Methods in org.apache.empire.dbms.derby with parameters of type DBTableColumnModifier and TypeMethodDescriptionprotected booleanDerbyDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql) protected voidDerbyDDLGenerator.appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql) DBMSHandlerDerby.getNextSequenceValueExpr(DBTableColumn column) -
Uses of DBTableColumn in org.apache.empire.dbms.h2
Methods in org.apache.empire.dbms.h2 with parameters of type DBTableColumnModifier and TypeMethodDescriptionprotected booleanH2DDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql) DBMSHandlerH2.getNextSequenceValueExpr(DBTableColumn column) -
Uses of DBTableColumn in org.apache.empire.dbms.hsql
Methods in org.apache.empire.dbms.hsql with parameters of type DBTableColumnModifier and TypeMethodDescriptionprotected voidHSqlDDLGenerator.createSequence(DBDatabase db, DBTableColumn column, DBSQLScript script) Appends the DDL-Script for creating a sequence to an SQL-ScriptDBMSHandlerHSql.getNextSequenceValueExpr(DBTableColumn column) -
Uses of DBTableColumn in org.apache.empire.dbms.mysql
Methods in org.apache.empire.dbms.mysql with parameters of type DBTableColumnModifier and TypeMethodDescriptionprotected booleanMySQLDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql) DBMSHandlerMySQL.getNextSequenceValueExpr(DBTableColumn column) -
Uses of DBTableColumn in org.apache.empire.dbms.oracle
Fields in org.apache.empire.dbms.oracle declared as DBTableColumnModifier and TypeFieldDescriptionOracleSYSDatabase.DBColInfo.C_CHAR_LENGTHOracleSYSDatabase.DBColComments.C_COLUMN_NAMEOracleSYSDatabase.DBColInfo.C_COLUMN_NAMEOracleSYSDatabase.DBUserConCol.C_COLUMN_NAMEOracleSYSDatabase.DBColComments.C_COMMENTSOracleSYSDatabase.DBTabComments.C_COMMENTSOracleSYSDatabase.DBConstraints.C_CONSTRAINT_NAMEOracleSYSDatabase.DBUserConCol.C_CONSTRAINT_NAMEOracleSYSDatabase.DBConstraints.C_CONSTRAINT_TYPEOracleSYSDatabase.DBColInfo.C_DATA_LENGTHOracleSYSDatabase.DBColInfo.C_DATA_PRECISIONOracleSYSDatabase.DBColInfo.C_DATA_SCALEOracleSYSDatabase.DBColInfo.C_DATA_TYPEOracleSYSDatabase.DBColInfo.C_DATA_TYPE_MODOracleSYSDatabase.DBColInfo.C_DATA_TYPE_OWNEROracleSYSDatabase.DBColInfo.C_NULLABLEOracleSYSDatabase.DBColComments.C_OWNEROracleSYSDatabase.DBColInfo.C_OWNEROracleSYSDatabase.DBTabComments.C_OWNEROracleSYSDatabase.DBUserConCol.C_OWNEROracleSYSDatabase.DBConstraints.C_R_CONSTRAINT_NAMEOracleSYSDatabase.DBConstraints.C_STATUSOracleSYSDatabase.DBColComments.C_TABLE_NAMEOracleSYSDatabase.DBColInfo.C_TABLE_NAMEOracleSYSDatabase.DBConstraints.C_TABLE_NAMEOracleSYSDatabase.DBTabComments.C_TABLE_NAMEOracleSYSDatabase.DBUserConCol.C_TABLE_NAMEOracleSYSDatabase.DBTabComments.C_TABLE_TYPEMethods in org.apache.empire.dbms.oracle with parameters of type DBTableColumnModifier and TypeMethodDescriptionprotected booleanOracleDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql) protected voidOracleDDLGenerator.appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql) protected voidOracleDDLGenerator.createSequence(DBDatabase db, DBTableColumn column, DBSQLScript script) Returns true if the sequence has been created successfully.DBMSHandlerOracle.getNextSequenceValueExpr(DBTableColumn column) -
Uses of DBTableColumn in org.apache.empire.dbms.postgresql
Methods in org.apache.empire.dbms.postgresql with parameters of type DBTableColumnModifier and TypeMethodDescriptionprotected booleanPostgresDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql) protected voidPostgresDDLGenerator.appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql) protected voidPostgresDDLGenerator.createSequence(DBDatabase db, DBTableColumn column, DBSQLScript script) Appends the DDL-Script for creating a sequence to an SQL-ScriptDBMSHandlerPostgreSQL.getNextSequenceValueExpr(DBTableColumn column) -
Uses of DBTableColumn in org.apache.empire.dbms.sqlite
Methods in org.apache.empire.dbms.sqlite with parameters of type DBTableColumnModifier and TypeMethodDescriptionDBMSHandlerSQLite.getNextSequenceValueExpr(DBTableColumn column) -
Uses of DBTableColumn in org.apache.empire.dbms.sqlserver
Methods in org.apache.empire.dbms.sqlserver with parameters of type DBTableColumnModifier and TypeMethodDescriptionprotected booleanMSSqlDDLGenerator.appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql) DBMSHandlerMSSQL.getColumnAutoValue(DBDatabase db, DBTableColumn column, Connection conn) Returns an auto-generated value for a particular columnDBMSHandlerMSSQL.getNextSequenceValueExpr(DBTableColumn column)