6 use lib 't/no-component-lib';
8 use DBIx::Class::DeploymentHandler;
9 use aliased 'DBIx::Class::DeploymentHandler', 'DH';
11 use File::Path 'remove_tree';
17 my $dbh = DBICDHTest::dbh();
18 my @connection = (sub { $dbh }, { ignore_version => 1 });
19 my $sql_dir = 't/sql';
22 use_ok 'DBICVersion_v1';
23 my $s = DBICVersion::Schema->connect(@connection);
24 $DBICVersion::Schema::VERSION = 1;
25 ok($s, 'DBICVersion::Schema 1 instantiates correctly');
26 my $handler = DH->new({
27 script_directory => $sql_dir,
29 databases => 'SQLite',
30 sql_translator_args => { add_drop_table => 0 },
33 ok($handler, 'DBIx::Class::DeploymentHandler w/1 instantiates correctly');
35 my $version = $s->schema_version;
36 $handler->prepare_install;
39 $s->resultset('Foo')->create({
42 } 'schema not deployed';
43 $handler->install({ version => 1 });
46 } 'cannot install twice';
48 $s->resultset('Foo')->create({
51 } 'schema is deployed';
55 use_ok 'DBICVersion_v2';
56 my $s = DBICVersion::Schema->connect(@connection);
57 $DBICVersion::Schema::VERSION = 2;
58 subtest 'bug deploying first version' => sub {
59 my $dbh = DBICDHTest::dbh();
60 my @connection = (sub { $dbh }, { ignore_version => 1 });
61 my $s = DBICVersion::Schema->connect(@connection);
63 my $handler = DH->new({
64 script_directory => $sql_dir,
66 databases => 'SQLite',
68 $handler->install({ version => 1 });
69 is($handler->database_version, 1, 'correctly set version to 1');
72 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
73 my $handler = DH->new({
74 script_directory => $sql_dir,
76 databases => 'SQLite',
79 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
81 my $version = $s->schema_version();
82 $handler->prepare_install;
83 $handler->prepare_upgrade({ from_version => 1, to_version => $version });
85 $s->resultset('Foo')->create({
89 } 'schema not deployed';
91 $s->resultset('Foo')->create({
95 } 'schema not uppgrayyed';
98 $s->resultset('Foo')->create({
102 } 'schema is deployed';
106 use_ok 'DBICVersion_v3';
107 my $s = DBICVersion::Schema->connect(@connection);
108 $DBICVersion::Schema::VERSION = 3;
109 ok($s, 'DBICVersion::Schema 3 instantiates correctly');
110 my $handler = DH->new({
111 script_directory => $sql_dir,
113 databases => 'SQLite',
116 ok($handler, 'DBIx::Class::DeploymentHandler w/3 instantiates correctly');
118 my $version = $s->schema_version();
119 $handler->prepare_install;
120 $handler->prepare_upgrade({ from_version => 2, to_version => $version });
122 $s->resultset('Foo')->create({
127 } 'schema not deployed';
130 $s->resultset('Foo')->create({
135 } 'schema is deployed';
139 use_ok 'DBICVersion_v4';
140 my $s = DBICVersion::Schema->connect(@connection);
141 $DBICVersion::Schema::VERSION = 2;
142 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
143 my $handler = DH->new({
144 script_directory => $sql_dir,
146 databases => 'SQLite',
149 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
151 my $version = $s->schema_version();
152 $handler->prepare_downgrade({ from_version => 3, to_version => $version });
154 $s->resultset('Foo')->create({
159 } 'schema at version 3';
162 $s->resultset('Foo')->create({
167 } 'schema not at version 3';
169 $s->resultset('Foo')->create({
173 } 'schema is at version 2';