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

Schema: [% schema.name %]
Database: [% schema.database %]

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