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,
19 databases => ['SQLite'],
22 ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 instantiates correctly');
24 my $version = $s->schema_version();
25 $handler->create_ddl_dir( $version, 0);
26 ok(-e 't/sql/DBICVersion-Schema-1.0-SQLite.sql', 'DDL for 1.0 got created successfully');
29 $s->resultset('Foo')->create({
32 } 'schema not deployed';
35 $s->resultset('Foo')->create({
38 } 'schema is deployed';
42 use_ok 'DBICVersion_v2';
43 my $s = DBICVersion::Schema->connect($db);
44 ok($s, 'DBICVersion::Schema 2.0 instantiates correctly');
45 my $handler = DBIx::Class::DeploymentHandler->new({
46 upgrade_directory => $sql_dir,
48 databases => ['SQLite'],
51 ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly');
53 $version = $s->schema_version();
54 $handler->create_ddl_dir($version, 0);
55 $handler->create_ddl_dir($version, '1.0');
56 ok(-e 't/sql/DBICVersion-Schema-2.0-SQLite.sql', 'DDL for 2.0 got created successfully');
57 ok(-e 't/sql/DBICVersion-Schema-1.0-2.0-SQLite.sql', 'DDL for migration from 1.0 to 2.0 got created successfully');
59 $s->resultset('Foo')->create({
63 } 'schema not deployed';
64 #$handler->install('1.0');
66 $s->resultset('Foo')->create({
70 } 'schema not uppgrayyed';
71 $handler->upgrade_single_step('1.0', '2.0');
73 $s->resultset('Foo')->create({
77 } 'schema is deployed';
81 use_ok 'DBICVersion_v3';
82 my $s = DBICVersion::Schema->connect($db);
83 ok($s, 'DBICVersion::Schema 3.0 instantiates correctly');
84 my $handler = DBIx::Class::DeploymentHandler->new({
85 upgrade_directory => $sql_dir,
87 databases => ['SQLite'],
90 ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly');
92 $version = $s->schema_version();
93 $handler->create_ddl_dir( $version, 0);
94 $handler->create_ddl_dir( $version, '1.0');
95 $handler->create_ddl_dir( $version, '2.0');
96 ok(-e 't/sql/DBICVersion-Schema-3.0-SQLite.sql', 'DDL for 3.0 got created successfully');
97 ok(-e 't/sql/DBICVersion-Schema-1.0-3.0-SQLite.sql', 'DDL for migration from 1.0 to 3.0 got created successfully');
98 ok(-e 't/sql/DBICVersion-Schema-2.0-3.0-SQLite.sql', 'DDL for migration from 2.0 to 3.0 got created successfully');
100 $s->resultset('Foo')->create({
105 } 'schema not deployed';
108 $s->resultset('Foo')->create({
113 } 'schema is deployed';
119 vim: ts=2,sw=2,expandtab