8 use DBIx::Class::DeploymentHandler;
9 my $db = 'dbi:SQLite:db.db';
10 my $sql_dir = 't/sql';
13 use_ok 'DBICVersion_v1';
14 my $s = DBICVersion::Schema->connect($db);
15 ok($s, 'DBICVersion::Schema 1.0 instantiates correctly');
16 my $handler = DBIx::Class::DeploymentHandler->new({
17 upgrade_directory => $sql_dir,
21 ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 instantiates correctly');
23 my $version = $s->schema_version();
24 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0);
25 ok(-e 't/sql/DBICVersion-Schema-1.0-SQLite.sql', 'DDL for 1.0 got created successfully');
28 $s->resultset('Foo')->create({
31 } 'schema not deployed';
34 $s->resultset('Foo')->create({
37 } 'schema is deployed';
41 use_ok 'DBICVersion_v2';
42 my $s = DBICVersion::Schema->connect($db);
43 ok($s, 'DBICVersion::Schema 2.0 instantiates correctly');
44 my $handler = DBIx::Class::DeploymentHandler->new({
45 upgrade_directory => $sql_dir,
49 ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly');
51 $version = $s->schema_version();
52 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0);
53 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '1.0');
54 ok(-e 't/sql/DBICVersion-Schema-2.0-SQLite.sql', 'DDL for 2.0 got created successfully');
55 ok(-e 't/sql/DBICVersion-Schema-1.0-2.0-SQLite.sql', 'DDL for migration from 1.0 to 2.0 got created successfully');
57 $s->resultset('Foo')->create({
61 } 'schema not deployed';
62 #$handler->install('1.0');
64 $s->resultset('Foo')->create({
68 } 'schema not uppgrayyed';
69 $handler->upgrade_single_step('1.0', '2.0');
71 $s->resultset('Foo')->create({
75 } 'schema is deployed';
79 use_ok 'DBICVersion_v3';
80 my $s = DBICVersion::Schema->connect($db);
81 ok($s, 'DBICVersion::Schema 3.0 instantiates correctly');
82 my $handler = DBIx::Class::DeploymentHandler->new({
83 upgrade_directory => $sql_dir,
87 ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly');
89 $version = $s->schema_version();
90 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, 0);
91 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '1.0');
92 $handler->create_ddl_dir( 'SQLite', $version, $sql_dir, '2.0');
93 ok(-e 't/sql/DBICVersion-Schema-3.0-SQLite.sql', 'DDL for 3.0 got created successfully');
94 ok(-e 't/sql/DBICVersion-Schema-1.0-3.0-SQLite.sql', 'DDL for migration from 1.0 to 3.0 got created successfully');
95 ok(-e 't/sql/DBICVersion-Schema-2.0-3.0-SQLite.sql', 'DDL for migration from 2.0 to 3.0 got created successfully');
97 $s->resultset('Foo')->create({
102 } 'schema not deployed';
105 $s->resultset('Foo')->create({
110 } 'schema is deployed';
116 vim: ts=2,sw=2,expandtab