X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F73oracle_hq.t;h=0dde66965f6195a05efbc816f76766962fe525a2;hb=09d2e66a5d5558ef9a19dc2ec510d5dafd2fb7d8;hp=0f887fab34c37a130bae8573cc1df1877d6fa428;hpb=ac0c08254241f41a5cb1b586fc1b24ce2d33b79b;p=dbsrgits%2FDBIx-Class.git diff --git a/t/73oracle_hq.t b/t/73oracle_hq.t index 0f887fa..0dde669 100644 --- a/t/73oracle_hq.t +++ b/t/73oracle_hq.t @@ -1,23 +1,15 @@ +BEGIN { do "./t/lib/ANFANG.pm" or die ( $@ || $! ) } +use DBIx::Class::Optional::Dependencies -skip_all_without => 'test_rdbms_oracle'; + use strict; use warnings; use Test::Exception; use Test::More; -use DBIx::Class::Optional::Dependencies (); -use lib qw(t/lib); -use DBICTest::RunMode; - -$ENV{NLS_SORT} = "BINARY"; -$ENV{NLS_COMP} = "BINARY"; -$ENV{NLS_LANG} = "AMERICAN"; - -my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_ORA_${_}" } qw/DSN USER PASS/}; -plan skip_all => 'Set $ENV{DBICTEST_ORA_DSN}, _USER and _PASS to run this test.' - unless ($dsn && $user && $pass); - -plan skip_all => 'Test needs ' . DBIx::Class::Optional::Dependencies->req_missing_for ('rdbms_oracle') - unless DBIx::Class::Optional::Dependencies->req_ok_for ('rdbms_oracle'); +# I *strongly* suspect Oracle has an implicit stable output order when +# dealing with HQs. So just punt on the entire shuffle thing. +BEGIN { $ENV{DBIC_SHUFFLE_UNORDERED_RESULTSETS} = 0 } use DBICTest::Schema::Artist; BEGIN { @@ -37,6 +29,11 @@ BEGIN { use DBICTest; use DBICTest::Schema; +$ENV{NLS_SORT} = "BINARY"; +$ENV{NLS_COMP} = "BINARY"; +$ENV{NLS_LANG} = "AMERICAN"; + +my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_ORA_${_}" } qw/DSN USER PASS/}; my $schema = DBICTest::Schema->connect($dsn, $user, $pass); note "Oracle Version: " . $schema->storage->_server_info->{dbms_version};