[dbsrgits/SQL-Translator.git] / t / data / template / basic.tt

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 %]
        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 %]
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 %]
b08b5416	22	foreign_key_reference: [% field.foreign_key_reference.reference_table %]
2b2601b5	23	is_valid: [% field.is_valid %]
2b2601b5	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 %]