Understand Postgres enumerated types

[dbsrgits/DBIx-Class-Schema-Loader.git] / t / 12pg_common.t

diff --git a/t/12pg_common.t b/t/12pg_common.t
index e40cbd6..bdac57a 100644 (file)
--- a/t/12pg_common.t
+++ b/t/12pg_common.t
@@ -15,6 +15,9 @@ my $tester = dbixcsl_common_tests->new(
     user        => $user,
     password    => $password,
     loader_options  => { preserve_case => 1 },
+    connect_info_opts => {
+        on_connect_do => [ 'SET client_min_messages=WARNING' ],
+    },
     quote_char  => '"',
     data_types  => {
         # http://www.postgresql.org/docs/7.4/interactive/datatype.html
@@ -109,7 +112,17 @@ my $tester = dbixcsl_common_tests->new(
 
         # Blob Types
        bytea => { data_type => 'bytea' },
+
+        # Enum Types
+        pg_loader_test_enum => { data_type => 'enum', extra => { list => [ qw/foo bar baz/] }, size => 4 },
     },
+    pre_create => [
+        q{
+            CREATE TYPE pg_loader_test_enum AS ENUM (
+                'foo', 'bar', 'baz'
+            )
+        },
+    ],
     extra       => {
         create => [
             q{
@@ -142,6 +155,7 @@ my $tester = dbixcsl_common_tests->new(
         ],
         pre_drop_ddl => [
             'DROP SCHEMA dbicsl_test CASCADE',
+            'DROP TYPE pg_loader_test_enum',
         ],
         drop  => [ qw/ pg_loader_test1 pg_loader_test2 / ],
         count => 4,