X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F24yaml.t;h=1c4e9cb0c57dcf0202f5d7c3fdadb9cbea9f2324;hb=9a96648f006e57816543756a548303d55397010e;hp=661b64d57af77f44429c2adeb9b42c2f3d9cd693;hpb=0d1ceb5635087ddb4e72efeb413d9435552c43cf;p=dbsrgits%2FSQL-Translator.git diff --git a/t/24yaml.t b/t/24yaml.t index 661b64d..1c4e9cb 100644 --- a/t/24yaml.t +++ b/t/24yaml.t @@ -21,7 +21,6 @@ schema: procedures: {} tables: person: - comments: '' constraints: - deferrable: 1 expression: '' @@ -49,7 +48,6 @@ schema: type: UNIQUE fields: age: - comments: '' data_type: integer default_value: ~ extra: {} @@ -61,7 +59,6 @@ schema: size: - 0 description: - comments: '' data_type: text default_value: ~ extra: {} @@ -73,7 +70,6 @@ schema: size: - 0 iq: - comments: '' data_type: tinyint default_value: 0 extra: {} @@ -85,7 +81,6 @@ schema: size: - 0 name: - comments: '' data_type: varchar default_value: ~ extra: {} @@ -97,7 +92,6 @@ schema: size: - 20 person_id: - comments: '' data_type: INTEGER default_value: ~ extra: {} @@ -109,7 +103,6 @@ schema: size: - 0 weight: - comments: '' data_type: double default_value: ~ extra: {} @@ -126,11 +119,10 @@ schema: options: [] order: 1 pet: - comments: '' constraints: - deferrable: 1 expression: '' - fields: ~ + fields: [] match_type: '' name: '' on_delete: '' @@ -154,7 +146,6 @@ schema: type: PRIMARY KEY fields: age: - comments: '' data_type: int default_value: ~ extra: {} @@ -166,7 +157,6 @@ schema: size: - 0 name: - comments: '' data_type: varchar default_value: ~ extra: {} @@ -178,7 +168,6 @@ schema: size: - 30 person_id: - comments: '' data_type: int default_value: ~ extra: {} @@ -190,7 +179,6 @@ schema: size: - 0 pet_id: - comments: '' data_type: int default_value: ~ extra: {} @@ -206,21 +194,21 @@ schema: options: [] order: 2 triggers: - after: + pet_trig: action: for_each: ~ steps: - - update name=name + - update pet set name=name when: ~ database_event: insert fields: ~ - name: after - on_table: ~ + name: pet_trig + on_table: pet order: 1 - perform_action_when: ~ + perform_action_when: after views: person_pet: - fields: ~ + fields: '' name: person_pet order: 1 sql: | @@ -248,6 +236,8 @@ my $tr = SQL::Translator->new( parser => 'SQLite', producer => 'YAML', data => $data, +# debug => 1, +# trace => 1, ); my $out;