5 use File::Path 'remove_tree';
9 use DBIx::Class::DeploymentHandler;
10 my $db = 'dbi:SQLite:db.db';
11 my @connection = ($db, '', '', { ignore_version => 1 });
12 my $sql_dir = 't/sql';
17 use_ok 'DBICVersion_v1';
18 my $s = DBICVersion::Schema->connect(@connection);
19 ok($s, 'DBICVersion::Schema 1.0 instantiates correctly');
20 my $handler = DBIx::Class::DeploymentHandler->new({
21 upgrade_directory => $sql_dir,
23 databases => 'SQLite',
24 sqltargs => { add_drop_table => 0 },
27 ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 instantiates correctly');
29 my $version = $s->schema_version();
30 $handler->prepare_install();
31 #ok(-e 't/sql/DBICVersion-Schema-schema-1.0-SQLite.sql', 'DDL for 1.0 got created successfully');
34 $s->resultset('Foo')->create({
37 } 'schema not deployed';
41 } 'cannot install twice';
43 $s->resultset('Foo')->create({
46 } 'schema is deployed';
50 use_ok 'DBICVersion_v2';
51 my $s = DBICVersion::Schema->connect(@connection);
52 ok($s, 'DBICVersion::Schema 2.0 instantiates correctly');
53 my $handler = DBIx::Class::DeploymentHandler->new({
54 upgrade_directory => $sql_dir,
56 databases => 'SQLite',
59 ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly');
61 $version = $s->schema_version();
62 $handler->prepare_install();
63 $handler->prepare_upgrade('1.0', $version);
64 $handler->prepare_upgrade($version, '1.0');
65 #ok(-e 't/sql/DBICVersion-Schema-schema-2.0-SQLite.sql', 'DDL for 2.0 got created successfully');
66 #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');
68 $s->resultset('Foo')->create({
72 } 'schema not deployed';
73 #$handler->install('1.0');
75 $s->resultset('Foo')->create({
79 } 'schema not uppgrayyed';
82 $s->resultset('Foo')->create({
86 } 'schema is deployed';
90 use_ok 'DBICVersion_v3';
91 my $s = DBICVersion::Schema->connect(@connection);
92 ok($s, 'DBICVersion::Schema 3.0 instantiates correctly');
93 my $handler = DBIx::Class::DeploymentHandler->new({
94 upgrade_directory => $sql_dir,
96 databases => 'SQLite',
99 ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly');
101 $version = $s->schema_version();
102 $handler->prepare_install;
103 $handler->prepare_upgrade( '1.0', $version );
104 $handler->prepare_upgrade( '2.0', $version );
105 #ok(-e 't/sql/DBICVersion-Schema-schema-3.0-SQLite.sql', 'DDL for 3.0 got created successfully');
106 #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');
107 #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');
109 $s->resultset('Foo')->create({
114 } 'schema not deployed';
117 $s->resultset('Foo')->create({
122 } 'schema is deployed';
128 vim: ts=2 sw=2 expandtab