1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
Schema: [% schema.name %]
Database: [% schema.database %]
Foo: [% foo %]
Hello: [% hello %]
[%- FOREACH table = schema.get_tables %]
Table: [% table %]
==========================================================================
Fields
[%- FOREACH field = table.get_fields %]
[% field %]
data_type: [% field.data_type %]
size: [% field.size.join(',') %]
is_nullable: [% field.is_nullable %]
default_value: [% field.default_value %]
is_primary_key: [% field.is_primary_key %]
is_unique: [% field.is_unique %]
is_auto_increment: [% field.is_auto_increment %]
is_foreign_key: [% field.is_foreign_key %]
foreign_key_reference: [% field.foreign_key_reference.reference_table %]
is_valid: [% field.is_valid %]
order: [% field.order %]
table: [% field.table %]
[% END %]
Indices
[%- FOREACH index = table.get_indices %]
[% index.name %]
table: [% index.table %]
fields: [% index.fields.join(', ') %]
type: [% index.type %]
options: [% index.options %]
is_valid: [% index.is_valid %]
[% END %]
Constraints
[%- FOREACH constraint = table.get_constraints %]
[% constraint.name OR "?" %]
type: [% constraint.type %]
fields: [% constraint.fields.join(', ') %]
expression: [% constraint.expression %]
match_type: [% constraint.match_type %]
reference_fields: [% constraint.reference_fields.join(', ') %]
reference_table: [% constraint.reference_table.join(', ') %]
deferrable: [% constraint.deferrable %]
on_delete: [% constraint.on_delete %]
on_update: [% constraint.on_update %]
options: [% constraint.options %]
is_valid: [% constraint.is_valid %]
[% END -%]
[% END %]
|
