6 use lib 't/no-component-lib';
8 use DBIx::Class::DeploymentHandler;
9 use aliased 'DBIx::Class::DeploymentHandler', 'DH';
12 use File::Temp 'tempdir';
13 use Test::Fatal qw(lives_ok dies_ok);
15 my $dbh = DBICDHTest::dbh();
16 my @connection = (sub { $dbh }, { ignore_version => 1 });
17 my $sql_dir = tempdir( CLEANUP => 1 );
20 use_ok 'DBICVersion_v1';
21 my $s = DBICVersion::Schema->connect(@connection);
22 $DBICVersion::Schema::VERSION = 1;
23 ok($s, 'DBICVersion::Schema 1 instantiates correctly');
24 my $handler = DH->new({
25 script_directory => $sql_dir,
27 databases => 'SQLite',
28 sql_translator_args => { add_drop_table => 0 },
31 ok($handler, 'DBIx::Class::DeploymentHandler w/1 instantiates correctly');
33 my $version = $s->schema_version;
34 $handler->prepare_install;
37 $s->resultset('Foo')->create({
40 } 'schema not deployed';
41 $handler->install({ version => 1 });
44 } 'cannot install twice';
46 $s->resultset('Foo')->create({
49 } 'schema is deployed';
53 use_ok 'DBICVersion_v2';
54 my $s = DBICVersion::Schema->connect(@connection);
55 $DBICVersion::Schema::VERSION = 2;
56 subtest 'bug deploying first version' => sub {
57 my $dbh = DBICDHTest::dbh();
58 my @connection = (sub { $dbh }, { ignore_version => 1 });
59 my $s = DBICVersion::Schema->connect(@connection);
61 my $handler = DH->new({
62 script_directory => $sql_dir,
64 databases => 'SQLite',
66 $handler->install({ version => 1 });
67 is($handler->database_version, 1, 'correctly set version to 1');
70 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
71 my $handler = DH->new({
72 script_directory => $sql_dir,
74 databases => 'SQLite',
77 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
79 my $version = $s->schema_version();
80 $handler->prepare_install;
81 $handler->prepare_upgrade({ from_version => 1, to_version => $version });
83 $s->resultset('Foo')->create({
87 } 'schema not deployed';
89 $s->resultset('Foo')->create({
93 } 'schema not uppgrayyed';
96 $s->resultset('Foo')->create({
100 } 'schema is deployed';
104 use_ok 'DBICVersion_v3';
105 my $s = DBICVersion::Schema->connect(@connection);
106 $DBICVersion::Schema::VERSION = 3;
107 ok($s, 'DBICVersion::Schema 3 instantiates correctly');
108 my $handler = DH->new({
109 script_directory => $sql_dir,
111 databases => 'SQLite',
114 ok($handler, 'DBIx::Class::DeploymentHandler w/3 instantiates correctly');
116 my $version = $s->schema_version();
117 $handler->prepare_install;
118 $handler->prepare_upgrade({ from_version => 2, to_version => $version });
120 $s->resultset('Foo')->create({
125 } 'schema not deployed';
128 $s->resultset('Foo')->create({
133 } 'schema is deployed';
137 use_ok 'DBICVersion_v4';
138 my $s = DBICVersion::Schema->connect(@connection);
139 $DBICVersion::Schema::VERSION = 2;
140 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
141 my $handler = DH->new({
142 script_directory => $sql_dir,
144 databases => 'SQLite',
147 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
149 my $version = $s->schema_version();
150 $handler->prepare_downgrade({ from_version => 3, to_version => $version });
152 $s->resultset('Foo')->create({
157 } 'schema at version 3';
160 $s->resultset('Foo')->create({
165 } 'schema not at version 3';
167 $s->resultset('Foo')->create({
171 } 'schema is at version 2';