8 use DBIx::Class::DeploymentHandler;
9 my $db = 'dbi:SQLite:db.db';
10 my $sql_dir = 't/sql';
12 unlink 'db.db' if -e 'db.db';
13 mkdir 't/sql' unless -d 't/sql';
16 use_ok 'DBICVersion_v1';
17 my $s = DBICVersion::Schema->connect($db);
18 ok($s, 'DBICVersion::Schema 1.0 instantiates correctly');
19 my $handler = DBIx::Class::DeploymentHandler->new({
20 upgrade_directory => $sql_dir,
22 databases => 'SQLite',
25 ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 instantiates correctly');
27 my $version = $s->schema_version();
28 $handler->create_ddl_dir( $version, 0);
29 ok(-e 't/sql/DBICVersion-Schema-1.0-SQLite.sql', 'DDL for 1.0 got created successfully');
32 $s->resultset('Foo')->create({
35 } 'schema not deployed';
38 $s->resultset('Foo')->create({
41 } 'schema is deployed';
45 use_ok 'DBICVersion_v2';
46 my $s = DBICVersion::Schema->connect($db);
47 ok($s, 'DBICVersion::Schema 2.0 instantiates correctly');
48 my $handler = DBIx::Class::DeploymentHandler->new({
49 upgrade_directory => $sql_dir,
51 databases => 'SQLite',
54 ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly');
56 $version = $s->schema_version();
57 $handler->create_ddl_dir($version, 0);
58 $handler->create_ddl_dir($version, '1.0');
59 ok(-e 't/sql/DBICVersion-Schema-2.0-SQLite.sql', 'DDL for 2.0 got created successfully');
60 ok(-e 't/sql/DBICVersion-Schema-1.0-2.0-SQLite.sql', 'DDL for migration from 1.0 to 2.0 got created successfully');
62 $s->resultset('Foo')->create({
66 } 'schema not deployed';
67 #$handler->install('1.0');
69 $s->resultset('Foo')->create({
73 } 'schema not uppgrayyed';
74 $handler->upgrade_single_step('1.0', '2.0');
76 $s->resultset('Foo')->create({
80 } 'schema is deployed';
84 use_ok 'DBICVersion_v3';
85 my $s = DBICVersion::Schema->connect($db);
86 ok($s, 'DBICVersion::Schema 3.0 instantiates correctly');
87 my $handler = DBIx::Class::DeploymentHandler->new({
88 upgrade_directory => $sql_dir,
90 databases => 'SQLite',
93 ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly');
95 $version = $s->schema_version();
96 $handler->create_ddl_dir( $version, 0);
97 $handler->create_ddl_dir( $version, '1.0');
98 $handler->create_ddl_dir( $version, '2.0');
99 ok(-e 't/sql/DBICVersion-Schema-3.0-SQLite.sql', 'DDL for 3.0 got created successfully');
100 ok(-e 't/sql/DBICVersion-Schema-1.0-3.0-SQLite.sql', 'DDL for migration from 1.0 to 3.0 got created successfully');
101 ok(-e 't/sql/DBICVersion-Schema-2.0-3.0-SQLite.sql', 'DDL for migration from 2.0 to 3.0 got created successfully');
103 $s->resultset('Foo')->create({
108 } 'schema not deployed';
111 $s->resultset('Foo')->create({
116 } 'schema is deployed';
122 vim: ts=2,sw=2,expandtab