access.dbtool library

Classes

CopyType
A special type used with copy to copy fields from another map
IndexInfo
Information of an index
ReferenceType
RuleInfo
The rule info
SqlType
Represents a SQL type

Constants

copy → const String
Builtin name for special actions.
".copy."
copy1 → const String
Builtin name for special actions.
"$copy.1"
copy2 → const String
Builtin name for special actions.
"$copy.2"
define → const String
Builtin name for special actions.
".define"
define1 → const String
Builtin name for special actions.
".define.1"
define2 → const String
Builtin name for special actions.
".define.2"
define3 → const String
Builtin name for special actions.
".define.3"
notNull → const String
"not null"
nullable → const String
"null"
onDeleteCascade → const String
"on delete cascade"
onDeleteSetNull → const String
"on delete set null"

Functions

AutoOid() SqlType
Bigint({String constraint: notNull }) SqlType
Bigserial({String constraint: notNull }) SqlType
Boolean({String constraint: notNull }) SqlType
Char(int length, { String constraint: notNull }) SqlType
Citext({String constraint: notNull }) SqlType
Copy(Map<String, SqlType> source) SqlType
Copyies the definition from another source. For example, [...]
create(Connection conn, double version, Map<String, Map<String, SqlType>> tables, Map<String, IndexInfo> indexes, Map<String, RuleInfo> rules) → Future
Creates the tables specified in version.
Define(String definition) SqlType
Defines definition, which is generated directly. For example, [...]
Double({String constraint: notNull }) SqlType
Index(String table, List<String> columns, { bool unique: false, String using, String ops, String where }) IndexInfo
Integer({String constraint: notNull }) SqlType
Json({String constraint: notNull }) SqlType
Jsonb({String constraint: notNull }) SqlType
Oid() SqlType
purge(Connection conn, Map<String, Map<String, SqlType>> tables, Map<String, IndexInfo> indexes, Map<String, RuleInfo> rules) → Future
Purges all data and schemas.
Real({String constraint: notNull }) SqlType
Reference(String otype, { String constraint: notNull, String cascade: "", String column: fdOid }) SqlType
A reference that refers to a record from another table. It creates a foreign-key constraint to ensure the relationship.
Rule(String table, String rule) RuleInfo
Serial({String constraint: notNull }) SqlType
Smallint({String constraint: notNull }) SqlType
Text({String constraint: notNull }) SqlType
Timestamptz({String constraint: notNull }) SqlType
Tsvector({String constraint: notNull }) SqlType
UnboundReference({String otype, String constraint: notNull }) SqlType
A reference that refers to a record from another table. [...]