X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F86sqlt.t;h=1b80e21b9096ff633457433f0ca3fe9ed51ac69c;hb=368a5228b107faaef1af5d09b0a25ea8bb603421;hp=eeb0ca925100907bdfc55e64ef89b126ad163dbb;hpb=58d387fec14d2f92723ab0db1d64a18ee449639c;p=dbsrgits%2FDBIx-Class.git diff --git a/t/86sqlt.t b/t/86sqlt.t index eeb0ca9..1b80e21 100644 --- a/t/86sqlt.t +++ b/t/86sqlt.t @@ -73,10 +73,14 @@ my @fk_constraints = 'selftable' => 'treelike', 'foreigntable' => 'treelike', 'selfcols' => ['parent'], 'foreigncols' => ['id'], 'needed' => 1, on_delete => '', on_update => ''}, - {'display' => 'twokeytreelike -> twokeytreelike for parent1,parent2', - 'selftable' => 'twokeytreelike', 'foreigntable' => 'twokeytreelike', - 'selfcols' => ['parent1', 'parent2'], 'foreigncols' => ['id1','id2'], - 'needed' => 1, on_delete => '', on_update => ''}, + + # shouldn't this be generated? + # + #{'display' => 'twokeytreelike -> twokeytreelike for parent1,parent2', + # 'selftable' => 'twokeytreelike', 'foreigntable' => 'twokeytreelike', + # 'selfcols' => ['parent1', 'parent2'], 'foreigncols' => ['id1','id2'], + # 'needed' => 1, on_delete => '', on_update => ''}, + {'display' => 'tags -> cd', 'selftable' => 'tags', 'foreigntable' => 'cd', 'selfcols' => ['cd'], 'foreigncols' => ['cdid'], @@ -91,6 +95,9 @@ my @unique_constraints = ( {'display' => 'cd artist and title unique', 'table' => 'cd', 'cols' => ['artist', 'title'], 'needed' => 1}, + {'display' => 'producer name unique', + 'table' => 'producer', 'cols' => ['name'], + 'needed' => 1}, {'display' => 'twokeytreelike name unique', 'table' => 'twokeytreelike', 'cols' => ['name'], 'needed' => 1},