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