X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Finflate%2Fdatetime_firebird.t;h=613dfe31786b2eeeb1784580ed9e9b5665ff8ae1;hb=cd1228209f685767668163c2510723959951641b;hp=6d52d064b2b3ef0ae02495dff56de4814be5d57c;hpb=b0a4cf8eb18957ad8076d2b3d68bcdd787aedd18;p=dbsrgits%2FDBIx-Class.git diff --git a/t/inflate/datetime_firebird.t b/t/inflate/datetime_firebird.t index 6d52d06..613dfe3 100644 --- a/t/inflate/datetime_firebird.t +++ b/t/inflate/datetime_firebird.t @@ -1,31 +1,46 @@ use strict; -use warnings; +use warnings; use Test::More; use Test::Exception; +use DBIx::Class::Optional::Dependencies (); use lib qw(t/lib); use DBICTest; use Scope::Guard (); my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_FIREBIRD_${_}" } qw/DSN USER PASS/}; -my ($dsn2, $user2, $pass2) = @ENV{map { "DBICTEST_FIREBIRD_ODBC_${_}" } qw/DSN USER PASS/}; +my ($dsn2, $user2, $pass2) = @ENV{map { "DBICTEST_FIREBIRD_INTERBASE_${_}" } qw/DSN USER PASS/}; +my ($dsn3, $user3, $pass3) = @ENV{map { "DBICTEST_FIREBIRD_ODBC_${_}" } qw/DSN USER PASS/}; + +plan skip_all => 'Test needs ' . + (join ' and ', map { $_ ? $_ : () } + DBIx::Class::Optional::Dependencies->req_missing_for('test_dt'), + (join ' or ', map { $_ ? $_ : () } + DBIx::Class::Optional::Dependencies->req_missing_for('test_rdbms_firebird'), + DBIx::Class::Optional::Dependencies->req_missing_for('test_rdbms_firebird_interbase'), + DBIx::Class::Optional::Dependencies->req_missing_for('test_rdbms_firebird_odbc'))) + unless + DBIx::Class::Optional::Dependencies->req_ok_for ('test_dt') && ( + $dsn && DBIx::Class::Optional::Dependencies->req_ok_for('test_rdbms_firebird') + or + $dsn2 && DBIx::Class::Optional::Dependencies->req_ok_for('test_rdbms_firebird_interbase') + or + $dsn3 && DBIx::Class::Optional::Dependencies->req_ok_for('test_rdbms_firebird_odbc')) + or (not $dsn || $dsn2 || $dsn3); if (not ($dsn || $dsn2)) { plan skip_all => <<'EOF'; -Set $ENV{DBICTEST_FIREBIRD_DSN} and/or $ENV{DBICTEST_FIREBIRD_ODBC_DSN} +Set $ENV{DBICTEST_FIREBIRD_DSN} and/or $ENV{DBICTEST_FIREBIRD_INTERBASE_DSN} +and/or $ENV{DBICTEST_FIREBIRD_ODBC_DSN} _USER and _PASS to run this test'. Warning: This test drops and creates a table called 'event'"; EOF -} else { - eval "use DateTime; use DateTime::Format::Strptime;"; - if ($@) { - plan skip_all => 'needs DateTime and DateTime::Format::Strptime for testing'; - } } my @info = ( [ $dsn, $user, $pass ], [ $dsn2, $user2, $pass2 ], + [ $dsn3, $user3, $pass3 ], ); my $schema; @@ -51,10 +66,10 @@ foreach my $conn_idx (0..$#info) { "created_on" TIMESTAMP ) SQL - my $rs = $schema->resultset('Event'); + my $rs = $schema->resultset('Event'); my $dt = DateTime->now; - $dt->set_nanosecond($dsn =~ /odbc/i ? 0 : 555600000); + $dt->set_nanosecond(555600000); my $date_only = DateTime->new( year => $dt->year, month => $dt->month, day => $dt->day @@ -72,7 +87,7 @@ SQL is $row->created_on, $dt, 'TIMESTAMP as DateTime roundtrip'; cmp_ok $row->created_on->nanosecond, '==', $dt->nanosecond, - 'fractional part of a second survived' if 0+$dt->nanosecond; + 'fractional part of a second survived'; is $row->starts_at, $date_only, 'DATE as DateTime roundtrip'; }