X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F10_01sqlite_common.t;h=c0b74341afbb30bc2f1f3180cdb03a448e4901d2;hb=add8bcf0aabf53cddb452eda4d3b25a35bf57d25;hp=93a499c028c69925441bff53d77d78bb3898c2f8;hpb=7b6a8d73e16b9b33bc8feb216b7bc8428cd7518b;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/t/10_01sqlite_common.t b/t/10_01sqlite_common.t index 93a499c..c0b7434 100644 --- a/t/10_01sqlite_common.t +++ b/t/10_01sqlite_common.t @@ -127,12 +127,19 @@ my $tester = dbixcsl_common_tests->new( on delete restrict on update set null deferrable ) }, + # test inline constraint + q{ + create table extra_loader_test10 ( + id integer primary key, + eight_id int references extra_loader_test8(id) on delete restrict on update set null deferrable + ) + }, ], pre_drop_ddl => [ 'DROP VIEW extra_loader_test5' ], drop => [ qw/extra_loader_test1 extra_loader_test2 extra_loader_test3 extra_loader_test4 extra_loader_test6 extra_loader_test7 - extra_loader_test8 extra_loader_test9 / ], - count => 15, + extra_loader_test8 extra_loader_test9 extra_loader_test10 / ], + count => 19, run => sub { my ($schema, $monikers, $classes) = @_; @@ -181,6 +188,18 @@ my $tester = dbixcsl_common_tests->new( is $rel_info->{attrs}{is_deferrable}, 1, 'DEFERRABLE clause introspected correctly'; + + ok (($rel_info = $schema->source('ExtraLoaderTest10')->relationship_info('eight')), + 'got rel info'); + + is $rel_info->{attrs}{on_delete}, 'RESTRICT', + 'ON DELETE clause introspected correctly for inline FK'; + + is $rel_info->{attrs}{on_update}, 'SET NULL', + 'ON UPDATE clause introspected correctly for inline FK'; + + is $rel_info->{attrs}{is_deferrable}, 1, + 'DEFERRABLE clause introspected correctly for inline FK'; }, }, );