X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F73oracle.t;h=c81f0fb01e0bf132aceba7b067b20cb6f6aa6935;hb=4e803ec9430d2876f4e0e3345ce148a8b9b47c7f;hp=540ce4e739ad7d468ba8f5b7d83c9bc234d3cd1c;hpb=606b30c3da4f8df001c824586d38da8838713f78;p=dbsrgits%2FDBIx-Class.git diff --git a/t/73oracle.t b/t/73oracle.t index 540ce4e..c81f0fb 100644 --- a/t/73oracle.t +++ b/t/73oracle.t @@ -361,13 +361,13 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { ); $schema->resultset('Artist')->find({ name => 'cycle-root' }) - ->update({ parentid => \'artistid' }); + ->update({ parentid => { -ident => 'artistid' } }); # select the whole tree { my $rs = $schema->resultset('Artist')->search({}, { start_with => { name => 'root' }, - connect_by => { parentid => { -prior => \ 'artistid' } }, + connect_by => { parentid => { -prior => { -ident => 'artistid' } } }, }); is_same_sql_bind ( @@ -409,7 +409,7 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { my $rs = $schema->resultset('Artist')->search({}, { start_with => { name => 'root' }, - connect_by => { parentid => { -prior => \ 'artistid' } }, + connect_by => { parentid => { -prior => { -ident => 'artistid' } } }, order_siblings_by => { -desc => 'name' }, }); @@ -436,7 +436,7 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { { my $rs = $schema->resultset('Artist')->search({ parentid => undef }, { start_with => { name => 'root' }, - connect_by => { parentid => { -prior => \ 'artistid' } }, + connect_by => { parentid => { -prior => { -ident => 'artistid' } } }, }); is_same_sql_bind ( @@ -469,7 +469,7 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { { join => 'cds', start_with => { 'me.name' => 'root' }, - connect_by => { parentid => { -prior => \ 'artistid' } }, + connect_by => { parentid => { -prior => { -ident => 'artistid' } } }, } ); @@ -513,7 +513,7 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { { my $rs = $schema->resultset('Artist')->search({}, { start_with => { name => 'root' }, - connect_by => { parentid => { -prior => \ 'artistid' } }, + connect_by => { parentid => { -prior => { -ident => 'artistid' } } }, order_by => { -asc => [ 'LEVEL', 'name' ] }, }); @@ -558,7 +558,7 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { my $rs = $schema->resultset('Artist')->search({}, { start_with => { name => 'root' }, - connect_by => { parentid => { -prior => \ 'artistid' } }, + connect_by => { parentid => { -prior => { -ident => 'artistid' } } }, order_by => { -asc => 'name' }, rows => 2, }); @@ -615,7 +615,7 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { my $rs = $schema->resultset('Artist')->search({}, { select => ['count(rank)'], start_with => { name => 'root' }, - connect_by => { parentid => { -prior => \ 'artistid' } }, + connect_by => { parentid => { -prior => { -ident => 'artistid' } } }, group_by => ['rank'], having => { 'count(rank)' => { '<', 2 } }, }); @@ -644,7 +644,7 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { { my $rs = $schema->resultset('Artist')->search({}, { start_with => { name => 'cycle-root' }, - connect_by => { parentid => { -prior => \ 'artistid' } }, + connect_by => { parentid => { -prior => { -ident => 'artistid' } } }, }); eval { $rs->get_column ('name')->all }; if ( $@ =~ /ORA-01436/ ){ # ORA-01436: CONNECT BY loop in user data @@ -663,7 +663,7 @@ if ( $schema->storage->isa('DBIx::Class::Storage::DBI::Oracle::Generic') ) { my $rs = $schema->resultset('Artist')->search({}, { start_with => { name => 'cycle-root' }, '+select' => [ \ 'CONNECT_BY_ISCYCLE' ], - connect_by_nocycle => { parentid => { -prior => \ 'artistid' } }, + connect_by_nocycle => { parentid => { -prior => { -ident => 'artistid' } } }, }); is_same_sql_bind (