X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F74mssql.t;h=72e65525178e19e1254a2841c6299317068e19f8;hb=5b45001f9e0297da60a1ac4caa5a100ad6f374d3;hp=92b310311865a250efd837666c5d8866e809cb27;hpb=5432c6ae1a31569775574edd42cb3e3f6f79cfff;p=dbsrgits%2FDBIx-Class.git diff --git a/t/74mssql.t b/t/74mssql.t index 92b3103..72e6552 100644 --- a/t/74mssql.t +++ b/t/74mssql.t @@ -1,29 +1,31 @@ use strict; use warnings; +# use this if you keep a copy of DBD::Sybase linked to FreeTDS somewhere else +BEGIN { + if (my $lib_dirs = $ENV{DBICTEST_MSSQL_PERL5LIB}) { + unshift @INC, $_ for split /:/, $lib_dirs; + } +} + use Test::More; use lib qw(t/lib); use DBICTest; my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_MSSQL_${_}" } qw/DSN USER PASS/}; -#warn "$dsn $user $pass"; - plan skip_all => 'Set $ENV{DBICTEST_MSSQL_DSN}, _USER and _PASS to run this test' unless ($dsn); -plan tests => 5; - -my $storage_type = '::DBI::MSSQL'; -$storage_type = '::DBI::Sybase::MSSQL' if $dsn =~ /^dbi:Sybase:/; -# Add more for others in the future when they exist (ODBC? ADO? JDBC?) +plan tests => 6; my $schema = DBICTest::Schema->clone; -$schema->storage_type($storage_type); $schema->connection($dsn, $user, $pass); my $dbh = $schema->storage->dbh; +isa_ok($schema->storage, 'DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server'); + $dbh->do("IF OBJECT_ID('artist', 'U') IS NOT NULL DROP TABLE artist"); $dbh->do("IF OBJECT_ID('cd', 'U') IS NOT NULL