Add options to omit the version and timestamp from the generated code (RT#92300)

[dbsrgits/DBIx-Class-Schema-Loader.git] / t / 10_03pg_common.t

diff --git a/t/10_03pg_common.t b/t/10_03pg_common.t
index ed1ed93..477ff0a 100644 (file)
--- a/t/10_03pg_common.t
+++ b/t/10_03pg_common.t
@@ -237,21 +237,25 @@ my $tester = dbixcsl_common_tests->new(
             q{
                 create table pg_loader_test10 (
                     id bigserial primary key,
-                    eleven_id int,
-                    foreign key (eleven_id) references pg_loader_test9(id)
+                    nine_id int,
+                    foreign key (nine_id) references pg_loader_test9(id)
                         on delete restrict on update set null deferrable
                 )
             },
-
+            q{
+                create view pg_loader_test11 as
+                    select * from pg_loader_test1
+            },
         ],
         pre_drop_ddl => [
             'DROP SCHEMA dbicsl_test CASCADE',
             'DROP SCHEMA "dbicsl-test" CASCADE',
             'DROP SCHEMA "dbicsl.test" CASCADE',
             'DROP TYPE pg_loader_test_enum',
+            'DROP VIEW pg_loader_test11',
         ],
         drop  => [ qw/pg_loader_test1 pg_loader_test2 pg_loader_test9 pg_loader_test10/ ],
-        count => 8 + 30 * 2,
+        count => 9 + 30 * 2,
         run   => sub {
             my ($schema, $monikers, $classes) = @_;
 
@@ -279,7 +283,7 @@ my $tester = dbixcsl_common_tests->new(
                 'long table comment is in DESCRIPTION';
 
             # test on delete/update fk clause introspection
-            ok ((my $rel_info = $schema->source('PgLoaderTest10')->relationship_info('eleven')),
+            ok ((my $rel_info = $schema->source('PgLoaderTest10')->relationship_info('nine')),
                 'got rel info');
 
             is $rel_info->{attrs}{on_delete}, 'RESTRICT',
@@ -441,6 +445,10 @@ my $tester = dbixcsl_common_tests->new(
                         ->has_relationship('pg_loader_test8s');
                 } 'cross-schema relationship in multi-db_schema';
             }
+
+            # test that views are marked as such
+            isa_ok $schema->resultset($monikers->{pg_loader_test11})->result_source, 'DBIx::Class::ResultSource::View',
+                'views have table_class set correctly';
         },
     },
 );