X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fdeploy_methods%2Fsql_translator_deprecated.t;h=1b4f0b53324af9f42ccedeca1295a3ce3415b344;hb=d50f25217d0b10029e1fb5ea140eb5547df67592;hp=0e5eab2c2b4216cdaa6caaffe68ca63d928ee7ea;hpb=42c2fec3aa2d4bb0eeff20637a883538f2737c80;p=dbsrgits%2FDBIx-Class-DeploymentHandler.git diff --git a/t/deploy_methods/sql_translator_deprecated.t b/t/deploy_methods/sql_translator_deprecated.t index 0e5eab2..1b4f0b5 100644 --- a/t/deploy_methods/sql_translator_deprecated.t +++ b/t/deploy_methods/sql_translator_deprecated.t @@ -1,4 +1,3 @@ - #!perl use Test::More; @@ -6,6 +5,85 @@ use Test::Exception; use lib 't/lib'; use DBICDHTest; -use_ok 'DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator::Deprecated'; +use aliased + 'DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator::Deprecated'; + +use File::Spec::Functions; + +my $db = 'dbi:SQLite:db.db'; +my @connection = ($db, '', '', { ignore_version => 1 }); +my $sql_dir = 't/sql'; + +DBICDHTest::ready; + +VERSION1: { + use_ok 'DBICVersion_v1'; + my $s = DBICVersion::Schema->connect(@connection); + my $dm = Deprecated->new({ + schema => $s, + upgrade_directory => $sql_dir, + databases => ['SQLite'], + sqltargs => { add_drop_table => 0 }, + }); + + ok( $dm, 'DBIC::DH::DM::SQLT::Deprecated gets instantiated correctly' ); + + $dm->prepare_install(); + + ok( + -f catfile(qw( t sql DBICVersion-Schema-1.0-SQLite.sql )), + '1.0 schema gets generated properly' + ); + + dies_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + }) + } 'schema not deployed'; + $dm->_deploy; + lives_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + }) + } 'schema is deployed'; +} + +VERSION2: { + use_ok 'DBICVersion_v2'; + my $s = DBICVersion::Schema->connect(@connection); + my $dm = Deprecated->new({ + schema => $s, + upgrade_directory => $sql_dir, + databases => ['SQLite'], + }); + + ok( + $dm, + 'DBIC::DH::DM::SQLT::Deprecated gets instantiated correctly w/ version 2.0' + ); + $version = $s->schema_version(); + $dm->prepare_install(); + $dm->prepare_upgrade('1.0', $version); + dies_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + baz => 'frew', + }) + } 'schema not deployed'; + dies_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + baz => 'frew', + }) + } 'schema not uppgrayyed'; + $dm->_upgrade_single_step(['1.0', $version]); + lives_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + baz => 'frew', + }) + } 'schema is deployed'; +} done_testing; +#vim: ts=2 sw=2 expandtab