X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F76joins.t;h=88749b432c1413f0a08f8f6a38268659738af40e;hb=4e0a89e400d865458081bc5af9e0eedf349f60de;hp=c6e795c42c4ef2af916fa73eabd9b5b1a96de564;hpb=1cc3ce1eef3deb794a2b2dd4cff166b91145e7c4;p=dbsrgits%2FDBIx-Class.git diff --git a/t/76joins.t b/t/76joins.t index c6e795c..88749b4 100644 --- a/t/76joins.t +++ b/t/76joins.t @@ -4,24 +4,14 @@ use warnings; use Test::More; use lib qw(t/lib); use DBICTest; -use Data::Dumper; use DBIC::SqlMakerTest; my $schema = DBICTest->init_schema(); my $orig_debug = $schema->storage->debug; -use IO::File; - -BEGIN { - eval "use DBD::SQLite"; - plan $@ - ? ( skip_all => 'needs DBD::SQLite for testing' ) - : ( tests => 33 ); -} - # test the abstract join => SQL generator -my $sa = new DBIx::Class::SQLAHacks; +my $sa = new DBIx::Class::SQLMaker; my @j = ( { child => 'person' }, @@ -32,9 +22,9 @@ my $match = 'person child JOIN person father ON ( father.person_id = ' . 'child.father_id ) JOIN person mother ON ( mother.person_id ' . '= child.mother_id )' ; -is_same_sql_bind( - $sa->_recurse_from(@j), [], - $match, [], +is_same_sql( + $sa->_recurse_from(@j), + $match, 'join 1 ok' ); @@ -52,9 +42,9 @@ $match = 'person mother JOIN (person child JOIN person father ON (' . ' father.person_id = child.father_id )) ON ( mother.person_id = ' . 'child.mother_id )' ; -is_same_sql_bind( - $sa->_recurse_from(@j2), [], - $match, [], +is_same_sql( + $sa->_recurse_from(@j2), + $match, 'join 2 ok' ); @@ -69,9 +59,9 @@ $match = 'person child INNER JOIN person father ON ( father.person_id = ' . '= child.mother_id )' ; -is_same_sql_bind( - $sa->_recurse_from(@j3), [], - $match, [], +is_same_sql( + $sa->_recurse_from(@j3), + $match, 'join 3 (inner join) ok' ); @@ -89,9 +79,9 @@ $match = 'person mother LEFT JOIN (person child RIGHT JOIN person father ON (' . ' father.person_id = child.father_id )) ON ( mother.person_id = ' . 'child.mother_id )' ; -is_same_sql_bind( - $sa->_recurse_from(@j4), [], - $match, [], +is_same_sql( + $sa->_recurse_from(@j4), + $match, 'join 4 (nested joins + join types) ok' ); @@ -104,9 +94,9 @@ $match = 'person child JOIN person father ON ( father.person_id != ' . 'child.father_id ) JOIN person mother ON ( mother.person_id ' . '= child.mother_id )' ; -is_same_sql_bind( - $sa->_recurse_from(@j5), [], - $match, [], +is_same_sql( + $sa->_recurse_from(@j5), + $match, 'join 5 (SCALAR reference for ON statement) ok' ); @@ -243,3 +233,5 @@ is($rs->first->name, 'We Are Goth', 'Correct record returned'); is(cd_count(), 5, '5 rows in table cd'); is(tk_count(), 3, '3 rows in table twokeys'); } + +done_testing;