access.dbtool library Null safety

Classes

CopyType
A special type used with copy to copy fields from another map
IndexInfo
Information of an index
PrimaryKeyType
A special type used with primaryKey to define a primary key with multiple columns
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"
primaryKey → const String
Builtin name for special actions.
".primary."

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
PrimaryKey(Iterable<String> columns) SqlType
A multi-column primary key.
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. [...]