5 use File::Path 'remove_tree';
10 use DBIx::Class::DeploymentHandler;
11 my $db = 'dbi:SQLite:db.db';
12 my @connection = ($db, '', '', { ignore_version => 1 });
13 my $sql_dir = 't/sql';
18 use_ok 'DBICVersion_v1';
19 my $s = DBICVersion::Schema->connect(@connection);
20 ok($s, 'DBICVersion::Schema 1.0 instantiates correctly');
21 my $handler = DBIx::Class::DeploymentHandler->new({
22 upgrade_directory => $sql_dir,
24 databases => 'SQLite',
25 sqltargs => { add_drop_table => 0 },
28 ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 instantiates correctly');
30 my $version = $s->schema_version();
31 $handler->prepare_install();
32 #ok(-e 't/sql/DBICVersion-Schema-schema-1.0-SQLite.sql', 'DDL for 1.0 got created successfully');
35 $s->resultset('Foo')->create({
38 } 'schema not deployed';
41 $s->resultset('Foo')->create({
44 } 'schema is deployed';
48 use_ok 'DBICVersion_v2';
49 my $s = DBICVersion::Schema->connect(@connection);
50 ok($s, 'DBICVersion::Schema 2.0 instantiates correctly');
51 my $handler = DBIx::Class::DeploymentHandler->new({
52 upgrade_directory => $sql_dir,
54 databases => 'SQLite',
57 ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly');
59 $version = $s->schema_version();
60 $handler->prepare_install();
61 $handler->prepare_upgrade('1.0', $version);
62 $handler->prepare_upgrade($version, '1.0');
63 #ok(-e 't/sql/DBICVersion-Schema-schema-2.0-SQLite.sql', 'DDL for 2.0 got created successfully');
64 #ok(-e 't/sql/DBICVersion-Schema-diff-1.0-2.0-SQLite.sql', 'DDL for migration from 1.0 to 2.0 got created successfully');
66 $s->resultset('Foo')->create({
70 } 'schema not deployed';
71 #$handler->install('1.0');
73 $s->resultset('Foo')->create({
77 } 'schema not uppgrayyed';
80 $s->resultset('Foo')->create({
84 } 'schema is deployed';
88 use_ok 'DBICVersion_v3';
89 my $s = DBICVersion::Schema->connect(@connection);
90 ok($s, 'DBICVersion::Schema 3.0 instantiates correctly');
91 my $handler = DBIx::Class::DeploymentHandler->new({
92 upgrade_directory => $sql_dir,
94 databases => 'SQLite',
97 ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly');
99 $version = $s->schema_version();
100 $handler->prepare_install;
101 $handler->prepare_upgrade( '1.0', $version );
102 $handler->prepare_upgrade( '2.0', $version );
103 #ok(-e 't/sql/DBICVersion-Schema-schema-3.0-SQLite.sql', 'DDL for 3.0 got created successfully');
104 #ok(-e 't/sql/DBICVersion-Schema-diff-1.0-3.0-SQLite.sql', 'DDL for migration from 1.0 to 3.0 got created successfully');
105 #ok(-e 't/sql/DBICVersion-Schema-diff-2.0-3.0-SQLite.sql', 'DDL for migration from 2.0 to 3.0 got created successfully');
107 $s->resultset('Foo')->create({
112 } 'schema not deployed';
115 $s->resultset('Foo')->create({
120 } 'schema is deployed';
126 vim: ts=2 sw=2 expandtab