Constants

COPY → String

Builtin name for special actions.

".copy."
COPY_1 → String

Builtin name for special actions.

"$COPY.1"
COPY_2 → String

Builtin name for special actions.

"$COPY.2"
DEFINE → String

Builtin name for special actions.

".define"
DEFINE_1 → String

Builtin name for special actions.

".define.1"
DEFINE_2 → String

Builtin name for special actions.

".define.2"
DEFINE_3 → String

Builtin name for special actions.

".define.3"
NOT_NULL → String

"not null"
NULL → String

"null"
ON_DELETE_CASCADE → String

"on delete cascade"
ON_DELETE_SET_NULL → String

"on delete set null"

Functions

AutoOid() SqlType

Bigint([String constraint = NOT_NULL]) SqlType

Bigserial([String constraint = NOT_NULL]) SqlType

Boolean([String constraint = NOT_NULL]) SqlType

Char(int length, [String constraint = NOT_NULL]) 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, String script) → Future

Creates the tables specified in version.

Define(String definition) SqlType

Defines definition, which is generated directly. For example,

Double([String constraint = NOT_NULL]) SqlType

Index(String table, List<String> columns, {bool unique: false, String using, String ops}) IndexInfo

Integer([String constraint = NOT_NULL]) SqlType

Json([String constraint = NOT_NULL]) SqlType

Jsonb([String constraint = NOT_NULL]) 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 = NOT_NULL]) SqlType

Reference(String otype, [String constraint = NOT_NULL, String cascade = ""]) SqlType

Rule(String table, String rule) RuleInfo

Serial([String constraint = NOT_NULL]) SqlType

Smallint([String constraint = NOT_NULL]) SqlType

Text([String constraint = NOT_NULL]) SqlType

Timestamptz([String constraint = NOT_NULL]) SqlType

Tsvector([String constraint = NOT_NULL]) SqlType

UnboundReference([String constraint = NOT_NULL]) SqlType

A reference that refers to a record from two ore more different tables.

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