| java.lang.Object
 com.uwyn.rife.database.queries.AbstractQuery
com.uwyn.rife.database.queries.CreateTable
| CreateTable | | public class CreateTable extends AbstractQuery implements Cloneable(Code) | | Object representation of a SQL "CREATE TABLE" query.
This object may be used to dynamically construct a SQL statement in a
database-independent fashion. After it is finished, it may be executed using
com.uwyn.rife.database.DbQueryManager.executeUpdate(Query)DbQueryManager.executeUpdate() .
author:
Geert Bevin (gbevin[remove] at uwyn dot com)
author:
Steven Grimm (koreth[remove] at midwinter dot com)
version:
$Revision: 3750 $
since:
1.0 |
| Inner Class :public class PrimaryKey extends ColumnsConstraint implements Cloneable | |
| Inner Class :public class ForeignKey extends ColumnsConstraint implements Cloneable | |
| Inner Class :public class UniqueConstraint extends ColumnsConstraint implements Cloneable | |
| Inner Class :public class CheckConstraint extends Constraint implements Cloneable | |
| Inner Class :abstract public class ColumnsConstraint extends Constraint implements Cloneable | |
| Inner Class :abstract public class Constraint implements Cloneable | |
| Inner Class :public class Column implements Cloneable | |
| Inner Class :public static class ViolationAction extends EnumClass | |
| Inner Class :public static class Nullable extends EnumClass | |
| Field Summary | |
| final public static ViolationAction | CASCADE
| | final public static ViolationAction | NOACTION
| | final public static Nullable | NOTNULL
| | final public static Nullable | NULL
| | final public static ViolationAction | RESTRICT
| | final public static ViolationAction | SETDEFAULT
| | final public static ViolationAction | SETNULL
|
| Method Summary | |
| public CreateTable | check(String expression)
| | public CreateTable | check(String name, String expression)
| | public void | clear()
| | public CreateTable | clone()
| | public CreateTable | column(String name, Class type)
| | public CreateTable | column(String name, Class type, String typeAttribute)
| | public CreateTable | column(String name, Class type, int precision)
| | public CreateTable | column(String name, Class type, int precision, String typeAttribute)
| | public CreateTable | column(String name, Class type, int precision, int scale)
| | public CreateTable | column(String name, Class type, int precision, int scale, String typeAttribute)
| | public CreateTable | column(String name, Class type, Nullable nullable)
| | public CreateTable | column(String name, Class type, String typeAttribute, Nullable nullable)
| | public CreateTable | column(String name, Class type, int precision, Nullable nullable)
| | public CreateTable | column(String name, Class type, int precision, String typeAttribute, Nullable nullable)
| | public CreateTable | column(String name, Class type, int precision, int scale, Nullable nullable)
| | public CreateTable | column(String name, Class type, int precision, int scale, String typeAttribute, Nullable nullable)
| | public CreateTable | columns(Object[] keyValues)
| | public CreateTable | columns(Class beanClass)
| | public CreateTable | columnsExcluded(Class beanClass, String[] excludedFields)
| | public CreateTable | columnsFiltered(Class beanClass, String[] includedFields, String[] excludedFields)
| | public CreateTable | columnsIncluded(Class beanClass, String[] includedFields)
| | public CreateTable | customAttribute(String name, String attribute)
| | public CreateTable | defaultFunction(String name, String defaultFunction)
| | public CreateTable | defaultValue(String name, char value)
| | public CreateTable | defaultValue(String name, boolean value)
| | public CreateTable | defaultValue(String name, byte value)
| | public CreateTable | defaultValue(String name, double value)
| | public CreateTable | defaultValue(String name, float value)
| | public CreateTable | defaultValue(String name, int value)
| | public CreateTable | defaultValue(String name, long value)
| | public CreateTable | defaultValue(String name, short value)
| | public CreateTable | defaultValue(String name, Object value)
| | public CreateTable | foreignKey(String foreignTable, String localColumn, String foreignColumn)
| | public CreateTable | foreignKey(String foreignTable, String localColumn, String foreignColumn, ViolationAction onUpdate, ViolationAction onDelete)
| | public CreateTable | foreignKey(String foreignTable, String[] columnsMapping)
| | public CreateTable | foreignKey(String foreignTable, String[] columnsMapping, ViolationAction onUpdate, ViolationAction onDelete)
| | public CreateTable | foreignKey(String name, String foreignTable, String localColumn, String foreignColumn)
| | public CreateTable | foreignKey(String name, String foreignTable, String localColumn, String foreignColumn, ViolationAction onUpdate, ViolationAction onDelete)
| | public CreateTable | foreignKey(String name, String foreignTable, String[] columnsMapping)
| | public CreateTable | foreignKey(String name, String foreignTable, String[] columnsMapping, ViolationAction onUpdate, ViolationAction onDelete)
| | public Capabilities | getCapabilities()
| | public List<CheckConstraint> | getCheckConstraints()
| | public Map<String, Column> | getColumnMapping()
| | public List<ForeignKey> | getForeignKeys()
| | public List<PrimaryKey> | getPrimaryKeys()
| | public String | getSql()
| | public String | getTable()
| | public List<UniqueConstraint> | getUniqueConstraints()
| | public boolean | isTemporary()
| | public CreateTable | nullable(String name, Nullable nullable)
| | public CreateTable | precision(String name, int precision)
| | public CreateTable | precision(String name, int precision, int scale)
| | public CreateTable | primaryKey(String column)
| | public CreateTable | primaryKey(String[] columns)
| | public CreateTable | primaryKey(String name, String column)
| | public CreateTable | primaryKey(String name, String[] columns)
| | public CreateTable | table(String table)
| | public CreateTable | temporary(boolean temporary)
| | public CreateTable | unique(String column)
| | public CreateTable | unique(String[] columns)
| | public CreateTable | unique(String name, String column)
| | public CreateTable | unique(String name, String[] columns)
|
| CASCADE | | final public static ViolationAction CASCADE(Code) | | |
| NOACTION | | final public static ViolationAction NOACTION(Code) | | |
| NOTNULL | | final public static Nullable NOTNULL(Code) | | |
| NULL | | final public static Nullable NULL(Code) | | |
| RESTRICT | | final public static ViolationAction RESTRICT(Code) | | |
| SETDEFAULT | | final public static ViolationAction SETDEFAULT(Code) | | |
| SETNULL | | final public static ViolationAction SETNULL(Code) | | |
| clear | | public void clear()(Code) | | |
| getCheckConstraints | | public List<CheckConstraint> getCheckConstraints()(Code) | | |
| getForeignKeys | | public List<ForeignKey> getForeignKeys()(Code) | | |
| getPrimaryKeys | | public List<PrimaryKey> getPrimaryKeys()(Code) | | |
| getUniqueConstraints | | public List<UniqueConstraint> getUniqueConstraints()(Code) | | |
| isTemporary | | public boolean isTemporary()(Code) | | |
|
|