Improve trigger 'scope' attribute support (RT#119997)

[dbsrgits/SQL-Translator.git] / t / 23json.t

diff --git a/t/23json.t b/t/23json.t
index e0148ca..0f96e47 100644 (file)
--- a/t/23json.t
+++ b/t/23json.t
@@ -15,7 +15,8 @@ BEGIN {
 }
 
 my $sqlt_version = $SQL::Translator::VERSION;
-my $json = <<JSON;
+use JSON;
+my $json = to_json(from_json(<<JSON), { canonical => 1, pretty => 1 });
 {
    "schema" : {
       "procedures" : {},
@@ -103,6 +104,10 @@ my $json = <<JSON;
                   ]
                },
                "person_id" : {
+                  "comments" : [
+                    "field comment 1",
+                    "field comment 2"
+                  ],
                   "data_type" : "INTEGER",
                   "default_value" : null,
                   "is_auto_increment" : 1,
@@ -255,7 +260,8 @@ my $json = <<JSON;
             "name" : "pet_trig",
             "on_table" : "pet",
             "order" : "1",
-            "perform_action_when" : "after"
+            "perform_action_when" : "after",
+            "scope": "row"
          }
       },
       "views" : {