X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F02-instantiation.t;h=b4da432dd6a532fdec6bc2f60438c3603d41fb92;hb=4ea147c61b35f316efb6482e4becf4b5bfcff312;hp=4943e3c199fe2ab47233df9a4035dc6033585228;hpb=b974984a4aa4db356fe2ebe90fb7e039da71197c;p=dbsrgits%2FDBIx-Class-DeploymentHandler.git diff --git a/t/02-instantiation.t b/t/02-instantiation.t index 4943e3c..b4da432 100644 --- a/t/02-instantiation.t +++ b/t/02-instantiation.t @@ -1,15 +1,116 @@ #!perl use Test::More; +use Test::Exception; use lib 't/lib'; use DBICTest; use DBIx::Class::DeploymentHandler; +my $db = 'dbi:SQLite:db.db'; +my $sql_dir = 't/sql'; -my $handler = DBIx::Class::DeploymentHandler->new({ - schema => DBICTest->init_schema() -}); +VERSION1: { + use_ok 'DBICVersion_v1'; + my $s = DBICVersion::Schema->connect($db); + ok($s, 'DBICVersion::Schema 1.0 instantiates correctly'); + my $handler = DBIx::Class::DeploymentHandler->new({ + upgrade_directory => $sql_dir, + schema => $s, + }); -ok($handler, 'DBIx::Class::DeploymentHandler instantiates correctly'); + ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 instantiates correctly'); + + my $version = $s->schema_version(); + $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0); + ok(-e 't/sql/DBICVersion-Schema-1.0-SQLite.sql', 'DDL for 1.0 got created successfully'); + + dies_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + }) + } 'schema not deployed'; + $handler->install; + lives_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + }) + } 'schema is deployed'; +} + +VERSION2: { + use_ok 'DBICVersion_v2'; + my $s = DBICVersion::Schema->connect($db); + ok($s, 'DBICVersion::Schema 2.0 instantiates correctly'); + my $handler = DBIx::Class::DeploymentHandler->new({ + upgrade_directory => $sql_dir, + schema => $s, + }); + + ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly'); + + $version = $s->schema_version(); + $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0); + $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '1.0'); + ok(-e 't/sql/DBICVersion-Schema-2.0-SQLite.sql', 'DDL for 2.0 got created successfully'); + ok(-e 't/sql/DBICVersion-Schema-1.0-2.0-SQLite.sql', 'DDL for migration from 1.0 to 2.0 got created successfully'); + dies_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + baz => 'frew', + }) + } 'schema not deployed'; + #$handler->install('1.0'); + dies_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + baz => 'frew', + }) + } 'schema not uppgrayyed'; + $handler->upgrade_single_step('1.0', '2.0'); + lives_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + baz => 'frew', + }) + } 'schema is deployed'; +} + +VERSION3: { + use_ok 'DBICVersion_v3'; + my $s = DBICVersion::Schema->connect($db); + ok($s, 'DBICVersion::Schema 3.0 instantiates correctly'); + my $handler = DBIx::Class::DeploymentHandler->new({ + upgrade_directory => $sql_dir, + schema => $s, + }); + + ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly'); + + $version = $s->schema_version(); + $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0); + $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '1.0'); + $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '2.0'); + ok(-e 't/sql/DBICVersion-Schema-3.0-SQLite.sql', 'DDL for 3.0 got created successfully'); + ok(-e 't/sql/DBICVersion-Schema-1.0-3.0-SQLite.sql', 'DDL for migration from 1.0 to 3.0 got created successfully'); + ok(-e 't/sql/DBICVersion-Schema-2.0-3.0-SQLite.sql', 'DDL for migration from 2.0 to 3.0 got created successfully'); + dies_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + baz => 'frew', + biff => 'frew', + }) + } 'schema not deployed'; + $handler->upgrade_single_step('2.0', '3.0'); + lives_ok { + $s->resultset('Foo')->create({ + bar => 'frew', + baz => 'frew', + biff => 'frew', + }) + } 'schema is deployed'; +} done_testing; +__END__ + +vim: ts=2,sw=2,expandtab