X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F86sqlt.t;h=467fed330b021bf04a72eb11a24f2a9687a7b2ca;hb=65d08642518d29e1a0fa5a426a559558ec82a1a9;hp=531a8a32c88402b81fe1eb34498ca294500e64fd;hpb=553d61c42d75a595174a47d22c652ffe000efcd6;p=dbsrgits%2FDBIx-Class.git diff --git a/t/86sqlt.t b/t/86sqlt.t index 531a8a3..467fed3 100644 --- a/t/86sqlt.t +++ b/t/86sqlt.t @@ -10,7 +10,7 @@ plan skip_all => 'SQL::Translator required' if $@; my $schema = DBICTest->init_schema; -plan tests => 132; +plan tests => 133; my $translator = SQL::Translator->new( parser_args => { @@ -29,7 +29,7 @@ my $translator = SQL::Translator->new( $schema->source('Track')->sqlt_deploy_callback(sub { my ($self, $sqlt_table) = @_; - if ($sqlt_table->schema->translator->producer_type =~ /SQLite$/ ) { + if ($schema->storage->sqlt_type eq 'SQLite' ) { $sqlt_table->add_index( name => 'track_title', fields => ['title'] ) or die $sqlt_table->error; } @@ -45,7 +45,11 @@ my $translator = SQL::Translator->new( ok($output, "SQLT produced someoutput") or diag($translator->error); - like ($warn, qr/^SQLT attribute .+? was supplied for relationship/, 'Warn about dubious on_delete/on_update attributes'); + like ( + $warn, + qr/SQLT attribute .+? was supplied for relationship .+? which does not appear to be a foreign constraint/, + 'Warn about dubious on_delete/on_update attributes', + ); } # Note that the constraints listed here are the only ones that are tested -- if @@ -155,7 +159,7 @@ my %fk_constraints = ( 'name' => 'artist_undirected_map_fk_id2', 'index_name' => 'artist_undirected_map_idx_id2', 'selftable' => 'artist_undirected_map', 'foreigntable' => 'artist', 'selfcols' => ['id2'], 'foreigncols' => ['artistid'], - on_delete => '', on_update => 'CASCADE', deferrable => 1, + on_delete => '', on_update => '', deferrable => 1, }, ], @@ -210,7 +214,7 @@ my %fk_constraints = ( 'name' => 'bookmark_fk_link', 'index_name' => 'bookmark_idx_link', 'selftable' => 'bookmark', 'foreigntable' => 'link', 'selfcols' => ['link'], 'foreigncols' => ['id'], - on_delete => '', on_update => '', deferrable => 1, + on_delete => 'SET NULL', on_update => 'CASCADE', deferrable => 1, }, ], # ForceForeign