7 use DBIx::Class::DeploymentHandler;
12 use_ok 'DBICVersion_v1';
13 my $s = DBICVersion::Schema->connect('dbi:SQLite::memory:');
14 ok($s, 'DBICVersion::Schema 1.0 instantiates correctly');
15 my $handler = DBIx::Class::DeploymentHandler->new({
19 ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 instantiates correctly');
21 my $version = $s->schema_version();
22 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0);
23 ok(-e 't/sql/DBICVersion-Schema-1.0-SQLite.sql', 'DDL for 1.0 got created successfully');
27 use_ok 'DBICVersion_v2';
28 my $s = DBICVersion::Schema->connect('dbi:SQLite::memory:');
29 ok($s, 'DBICVersion::Schema 2.0 instantiates correctly');
30 my $handler = DBIx::Class::DeploymentHandler->new({
34 ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly');
36 $version = $s->schema_version();
37 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0);
38 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '1.0');
39 ok(-e 't/sql/DBICVersion-Schema-2.0-SQLite.sql', 'DDL for 2.0 got created successfully');
40 ok(-e 't/sql/DBICVersion-Schema-1.0-2.0-SQLite.sql', 'DDL for migration from 1.0 to 2.0 got created successfully');
44 use_ok 'DBICVersion_v3';
45 my $s = DBICVersion::Schema->connect('dbi:SQLite::memory:');
46 ok($s, 'DBICVersion::Schema 3.0 instantiates correctly');
47 my $handler = DBIx::Class::DeploymentHandler->new({
51 ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly');
53 $version = $s->schema_version();
54 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0);
55 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '1.0');
56 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '2.0');
57 ok(-e 't/sql/DBICVersion-Schema-3.0-SQLite.sql', 'DDL for 3.0 got created successfully');
58 ok(-e 't/sql/DBICVersion-Schema-1.0-3.0-SQLite.sql', 'DDL for migration from 1.0 to 3.0 got created successfully');
59 ok(-e 't/sql/DBICVersion-Schema-2.0-3.0-SQLite.sql', 'DDL for migration from 2.0 to 3.0 got created successfully');