X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fhelperrels%2F26sqlt.t;h=1362252e4de5ddfdccd2de0f53e905b5372d565d;hb=de60a93dfda2e3384c2f6a00d55b352a4b4188c0;hp=66eea48e4aecf0e05cec88d2c1736da27af96b2a;hpb=7b90bb139d64454ea6ebae5876fcb181988c03c1;p=dbsrgits%2FDBIx-Class.git diff --git a/t/helperrels/26sqlt.t b/t/helperrels/26sqlt.t index 66eea48..1362252 100644 --- a/t/helperrels/26sqlt.t +++ b/t/helperrels/26sqlt.t @@ -32,11 +32,11 @@ my @fk_constraints = {'display' => 'twokeys->artist', 'selftable' => 'twokeys', 'foreigntable' => 'artist', 'selfcols' => ['artist'], 'foreigncols' => ['artistid'], - 'needed' => 1, on_delete => '', on_update => ''}, + 'needed' => 1, on_delete => 'CASCADE', on_update => 'CASCADE'}, {'display' => 'cd_to_producer->cd', 'selftable' => 'cd_to_producer', 'foreigntable' => 'cd', 'selfcols' => ['cd'], 'foreigncols' => ['cdid'], - 'needed' => 1, on_delete => '', on_update => ''}, + 'needed' => 1, on_delete => 'CASCADE', on_update => 'CASCADE'}, {'display' => 'cd_to_producer->producer', 'selftable' => 'cd_to_producer', 'foreigntable' => 'producer', 'selfcols' => ['producer'], 'foreigncols' => ['producerid'], @@ -44,7 +44,7 @@ my @fk_constraints = {'display' => 'self_ref_alias -> self_ref for self_ref', 'selftable' => 'self_ref_alias', 'foreigntable' => 'self_ref', 'selfcols' => ['self_ref'], 'foreigncols' => ['id'], - 'needed' => 1, on_delete => '', on_update => ''}, + 'needed' => 1, on_delete => 'CASCADE', on_update => 'CASCADE'}, {'display' => 'self_ref_alias -> self_ref for alias', 'selftable' => 'self_ref_alias', 'foreigntable' => 'self_ref', 'selfcols' => ['alias'], 'foreigncols' => ['id'], @@ -52,19 +52,19 @@ my @fk_constraints = {'display' => 'cd -> artist', 'selftable' => 'cd', 'foreigntable' => 'artist', 'selfcols' => ['artist'], 'foreigncols' => ['artistid'], - 'needed' => 1, on_delete => '', on_update => ''}, + 'needed' => 1, on_delete => 'CASCADE', on_update => 'CASCADE'}, {'display' => 'artist_undirected_map -> artist for id1', 'selftable' => 'artist_undirected_map', 'foreigntable' => 'artist', 'selfcols' => ['id1'], 'foreigncols' => ['artistid'], - 'needed' => 1, on_delete => '', on_update => ''}, + 'needed' => 1, on_delete => 'CASCADE', on_update => ''}, {'display' => 'artist_undirected_map -> artist for id2', 'selftable' => 'artist_undirected_map', 'foreigntable' => 'artist', 'selfcols' => ['id2'], 'foreigncols' => ['artistid'], - 'needed' => 1, on_delete => '', on_update => ''}, + 'needed' => 1, on_delete => 'CASCADE', on_update => ''}, {'display' => 'track->cd', 'selftable' => 'track', 'foreigntable' => 'cd', 'selfcols' => ['cd'], 'foreigncols' => ['cdid'], - 'needed' => 2, on_delete => '', on_update => ''}, + 'needed' => 2, on_delete => 'CASCADE', on_update => 'CASCADE'}, {'display' => 'treelike -> treelike for parent', 'selftable' => 'treelike', 'foreigntable' => 'treelike', 'selfcols' => ['parent'], 'foreigncols' => ['id'], @@ -76,7 +76,7 @@ my @fk_constraints = {'display' => 'tags -> cd', 'selftable' => 'tags', 'foreigntable' => 'cd', 'selfcols' => ['cd'], 'foreigncols' => ['cdid'], - 'needed' => 1, on_delete => '', on_update => ''}, + 'needed' => 1, on_delete => 'CASCADE', on_update => 'CASCADE'}, ); my @unique_constraints = (