Uses of Class
com.gengoai.sql.object.Column
-
Packages that use Column Package Description com.gengoai.sql com.gengoai.sql.object com.gengoai.sql.statement -
-
Uses of Column in com.gengoai.sql
Methods in com.gengoai.sql that return Column Modifier and Type Method Description static Column
SQL. column(String name, String type)
Static method for constructing a new Column given its name and type.Column
SQL.TableDef. column(String name, String type)
Methods in com.gengoai.sql that return types with arguments of type Column Modifier and Type Method Description List<Column>
SQLProber. getStoredColumns(@NonNull Table table)
Gets the list of columns (non-virtual) for the given table.List<Column>
SQLProber. getStoredColumns(@NonNull String table)
Gets the list of columns (non-virtual) for the given table.List<Column>
SQLProber. getVirtualColumns(@NonNull Table table)
Attempts to the get the virtual columns for a given table.List<Column>
SQLProber. getVirtualColumns(@NonNull String table)
Attempts to the get the virtual columns for a given table.Methods in com.gengoai.sql with parameters of type Column Modifier and Type Method Description protected void
PostgreSQLDialect. defineColumn(Column column, StringBuilder builder)
protected abstract void
SQLDialect. defineColumn(Column column, StringBuilder builder)
Generates the SQL needed to define a column for creating or altering a table.protected void
SQLiteDialect. defineColumn(Column column, StringBuilder builder)
-
Uses of Column in com.gengoai.sql.object
Methods in com.gengoai.sql.object that return Column Modifier and Type Method Description Column
Column. asStored(SQLElement element)
Sets a value that is auto generated for the column on insertion time and is stored in the database.Column
Column. asVirtual(SQLElement element)
Sets a value that is auto generated for the column on query time and not stored in the database.Column
Column. autoIncrement()
Sets this column as having its value auto incremented on assertion.Column
Column. autoIncrement(boolean isAutoIncrement)
Sets whether or not the column has an auto incremented valueColumn
Column. check(@NonNull SQLElement element)
Adds a Check constraint on this column.Column
Column. check(String name, @NonNull SQLElement element)
Adds a Check constraint with the given name on this column.Column
Column. collate(String collate)
Sets the collation used for this columnColumn
Table. column(String name)
Column column.Column
Column. defaultValue(SQLElement defaultValue)
Sets the default value to be assigned to the column when no value is given on an insert.Column
Column. notNull()
Sets the column to not allow null values.Column
Column. notNull(ConflictClause conflictClause)
Sets the column to not allow null values optionally specifying what happens when insertion of a null value is attempted.Column
Column. primaryKey()
Sets this column as the primary key of the table.Column
Column. unique()
Sets the column to have a uniqueness constraintColumn
Column. unique(@NonNull String name, ConflictClause conflictClause)
Sets the column to have a uniqueness constraint optionally specifying what happens when insertion of a duplicate value is attempted.Column
Column. unique(ConflictClause conflictClause)
Sets the column to have a uniqueness constraint optionally specifying what happens when insertion of a duplicate value is attempted.Column
Column. unique(String name)
Sets the column to have a uniqueness constraintMethods in com.gengoai.sql.object with parameters of type Column Modifier and Type Method Description AlterTable
Table. addColumn(@NonNull Column column)
Adds the given column to the table definition generating anAlterTable
statement to perform on the database.SQLOperable
Table. qualifiedColumnName(@NonNull Column column)
Gets the qualified column name, i.e.Method parameters in com.gengoai.sql.object with type arguments of type Column Modifier and Type Method Description AlterTable
Table. alterColumn(@NonNull String name, @NonNull Consumer<Column> consumer)
Alters the definition of the given column generating anAlterTable
statement to perform on the database.Constructor parameters in com.gengoai.sql.object with type arguments of type Column Constructor Description Table(String name, SQLElement tableType, @NonNull List<Column> columns, @NonNull List<Constraint> constraints)
Instantiates a new Table. -
Uses of Column in com.gengoai.sql.statement
Methods in com.gengoai.sql.statement with parameters of type Column Modifier and Type Method Description AlterTable
AlterTable. addColumn(@NonNull Column column)
Adds anAlterTableAction.AddColumn
action which will add the givenColumn
to the table.AlterTable
AlterTable. alterColumn(@NonNull Column column)
Adds an alter column action which updates the column based on the given column definition.Constructors in com.gengoai.sql.statement with parameters of type Column Constructor Description AddColumn(@NonNull Column newDefinition)
AlterColumn(@NonNull Column newDefinition)
-