Package | Description |
---|---|
org.kepler.util.sql |
Modifier and Type | Field and Description |
---|---|
static Column |
Column.AUTOINCID
An auto-incrementing integer column.
|
static Column |
Column.BLOB
A BLOB column.
|
static Column |
Column.BOOLEAN
A boolean column.
|
static Column |
Column.INTEGER
An integer column.
|
static Column |
Column.MD5_BINARY
An MD5 binary column.
|
static Column |
Column.MD5_TEXT
An MD5 text column.
|
static Column |
Column.NULLABLE_INTEGER
An integer column that can be null.
|
static Column |
Column.NULLABLE_MD5_TEXT
An MD5 text column that can be null.
|
static Column |
Column.NULLABLE_TEXT
A text column that can be null.
|
static Column |
Column.PK_INTEGER
A primary key integer column.
|
static Column |
Column.PK_MD5_BINARY |
static Column |
Column.PK_MD5_TEXT
A primary key MD5 text column.
|
static Column |
Column.PK_TEXT
A primary key text column.
|
static Column |
Column.PK_UUID_TEXT
A column for text UUIDs that are primary keys.
|
static Column |
Column.TEXT
A text column.
|
static Column |
Column.TEXT_UNLIMITED
A text column with no maximum length.
|
static Column |
Column.TIMESTAMP
A timestamp column.
|
static Column |
Column.UUID_TEXT
A column for text UUIDs.
|
Modifier and Type | Method and Description |
---|---|
Column |
Table.getColumn(java.lang.String name)
Get a specific column.
|
Modifier and Type | Method and Description |
---|---|
java.util.Set<Column> |
Table.columns()
Get the columns.
|
Modifier and Type | Method and Description |
---|---|
protected java.lang.String |
Oracle._getTypeString(Column column)
Get the SQL string of a column type.
|
protected java.lang.String |
PostgreSQL._getTypeString(Column column)
Get the SQL string of a column type.
|
protected java.lang.String |
MySQL._getTypeString(Column column)
Get the SQL string of a column type.
|
protected abstract java.lang.String |
DatabaseType._getTypeString(Column column)
Get the SQL string of a column type.
|
protected java.lang.String |
HSQL._getTypeString(Column column)
Get the SQL string of a column type.
|
void |
DatabaseType.changeColumnType(Column newColumn,
Column oldColumn)
Change the type of a column.
|
void |
DatabaseType.createColumn(Column column,
boolean allowNullable)
Adds a column to an existing table in the database.
|
void |
DatabaseType.createColumn(Column column,
java.sql.Statement statement)
Adds a column to an existing table in the database.
|
void |
DatabaseType.createColumn(Column column,
java.sql.Statement statement,
boolean allowNullable)
Adds a column to an existing table in the database.
|
java.lang.StringBuilder |
DatabaseType.getColumnDefinition(Column column)
Get the SQL definition of a column.
|
java.lang.StringBuilder |
DatabaseType.getColumnDefinition(Column column,
boolean allowNullable)
Get the SQL definition of a column.
|
void |
Table.putColumn(java.lang.String name,
Column column)
Add a new or replace an existing column with no foreign key or index.
|
void |
Table.putColumn(java.lang.String name,
Column column,
java.lang.String defaultValue)
Add a new or replace an existing column with a default value.
|
void |
Table.putColumn(java.lang.String columnName,
Column column,
java.lang.String fkTable,
java.lang.String fkColumn)
Add a new or replace an existing column.
|
void |
Table.putColumn(java.lang.String columnName,
Column column,
java.lang.String fkTable,
java.lang.String fkColumn,
java.lang.String defaultValue)
Add a new or replace an existing column.
|
void |
Oracle.renameColumn(java.lang.String oldName,
Column newColumn,
java.lang.String tableName)
Rename a column.
|
void |
PostgreSQL.renameColumn(java.lang.String oldName,
Column newColumn,
java.lang.String tableName)
Rename a column.
|
void |
MySQL.renameColumn(java.lang.String oldName,
Column newColumn,
java.lang.String tableName)
Rename a column.
|
abstract void |
DatabaseType.renameColumn(java.lang.String oldName,
Column newColumn,
java.lang.String tableName)
Rename a column.
|
void |
HSQL.renameColumn(java.lang.String oldName,
Column newColumn,
java.lang.String tableName)
Rename a column.
|
void |
Oracle.setColumnNotNull(Column column,
java.lang.String tableName)
Set not null constraint to a column.
|
void |
PostgreSQL.setColumnNotNull(Column column,
java.lang.String tableName)
Set not null constraint to a column.
|
void |
MySQL.setColumnNotNull(Column column,
java.lang.String tableName)
Set not null constraint to a column.
|
abstract void |
DatabaseType.setColumnNotNull(Column column,
java.lang.String tableName)
Set not null constraint to a column.
|
void |
HSQL.setColumnNotNull(Column column,
java.lang.String tableName)
Set not null constraint to a column.
|
void |
Oracle.setColumnNull(Column column,
java.lang.String tableName)
Change a column to allow null values.
|
void |
PostgreSQL.setColumnNull(Column column,
java.lang.String tableName)
Change a column to allow null values.
|
void |
MySQL.setColumnNull(Column column,
java.lang.String tableName)
Change a column to allow null values.
|
abstract void |
DatabaseType.setColumnNull(Column column,
java.lang.String tableName)
Change a column to allow null values.
|
void |
HSQL.setColumnNull(Column column,
java.lang.String tableName)
Change a column to allow null values.
|