Handbook
Glossary
persistent-table ( -- hash )
Vocabulary
db
.
types
Inputs
None
Outputs
hash
an
object
Definition
USING:
db
;
IN:
db.types
HOOK:
persistent-table
db-connection
( -- hash )
Methods
USING:
db.postgresql.private
db.types
random
;
M:
postgresql-db-connection
persistent-table
H{
{
+unique+
{
f
f
"unique"
}
}
{
system-random-generator
{
f
f
f
}
}
{
+null+
{
f
f
"null"
}
}
{
+cascade+
{
f
f
"cascade"
}
}
{
SIGNED-BIG-INTEGER
{
"bigint"
"bigint"
f
}
}
{
TIMESTAMP
{
"timestamp"
"timestamp"
f
}
}
{
+restrict+
{
f
f
"restrict"
}
}
{
BIG-INTEGER
{
"bigint"
"bigint"
f
}
}
{
DATETIME
{
"timestamp"
"timestamp"
f
}
}
{
+user-assigned-id+
{
f
f
f
}
}
{
TIME
{
"time"
"time"
f
}
}
{
VARCHAR
{
"varchar"
"varchar"
f
}
}
{
INTEGER
{
"integer"
"integer"
f
}
}
{
+on-delete+
{
f
f
"on delete"
}
}
{
+db-assigned-id+
{
"integer"
"serial"
f
}
}
{
BLOB
{
"bytea"
"bytea"
f
}
}
{
DOUBLE
{
"real"
"real"
f
}
}
{
URL
{
"varchar"
"varchar"
f
}
}
{
TEXT
{
"text"
"text"
f
}
}
{
+random-id+
{
"bigint"
"bigint"
f
}
}
{
secure-random-generator
{
f
f
f
}
}
{
+not-null+
{
f
f
"not null"
}
}
{
+set-null+
{
f
f
"set null"
}
}
{
DATE
{
"date"
"date"
f
}
}
{
+on-update+
{
f
f
"on update"
}
}
{
+autoincrement+
{
f
f
"autoincrement"
}
}
{
random-generator
{
f
f
f
}
}
{
+foreign-id+
{
f
f
"references"
}
}
{
+set-default+
{
f
f
"set default"
}
}
{
UNSIGNED-BIG-INTEGER
{
"bigint"
"bigint"
f
}
}
{
+default+
{
f
f
"default"
}
}
{
FACTOR-BLOB
{
"bytea"
"bytea"
f
}
}
}
;
USING:
db.sqlite.private
db.types
random
;
M:
sqlite-db-connection
persistent-table
H{
{
+unique+
{
f
f
"unique"
}
}
{
system-random-generator
{
f
f
f
}
}
{
+null+
{
f
f
"null"
}
}
{
+cascade+
{
f
f
"cascade"
}
}
{
SIGNED-BIG-INTEGER
{
"bigint"
"bigint"
f
}
}
{
TIMESTAMP
{
"timestamp"
"timestamp"
f
}
}
{
+restrict+
{
f
f
"restrict"
}
}
{
BIG-INTEGER
{
"bigint"
"bigint"
f
}
}
{
DATETIME
{
"datetime"
"datetime"
f
}
}
{
+user-assigned-id+
{
f
f
f
}
}
{
TIME
{
"time"
"time"
f
}
}
{
INTEGER
{
"integer"
"integer"
f
}
}
{
VARCHAR
{
"text"
"text"
f
}
}
{
+on-delete+
{
f
f
"on delete"
}
}
{
+db-assigned-id+
{
"integer"
"integer"
f
}
}
{
BLOB
{
"blob"
"blob"
f
}
}
{
DOUBLE
{
"real"
"real"
f
}
}
{
+primary-key+
{
f
f
"primary key"
}
}
{
TEXT
{
"text"
"text"
f
}
}
{
+random-id+
{
"integer"
"integer"
f
}
}
{
BOOLEAN
{
"boolean"
"boolean"
f
}
}
{
URL
{
"text"
"text"
f
}
}
{
secure-random-generator
{
f
f
f
}
}
{
+not-null+
{
f
f
"not null"
}
}
{
+set-null+
{
f
f
"set null"
}
}
{
DATE
{
"date"
"date"
f
}
}
{
+on-update+
{
f
f
"on update"
}
}
{
+autoincrement+
{
f
f
"autoincrement"
}
}
{
random-generator
{
f
f
f
}
}
{
+foreign-id+
{
"integer"
"integer"
"references"
}
}
{
+set-default+
{
f
f
"set default"
}
}
{
UNSIGNED-BIG-INTEGER
{
"bigint"
"bigint"
f
}
}
{
+default+
{
f
f
"default"
}
}
{
FACTOR-BLOB
{
"blob"
"blob"
f
}
}
}
;