8 use aliased 'DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator';
9 use File::Spec::Functions;
10 use File::Path qw(rmtree mkpath);
12 my $db = 'dbi:SQLite:db.db';
13 my @connection = ($db, '', '', { ignore_version => 1 });
14 my $sql_dir = 't/sql';
19 use_ok 'DBICVersion_v1';
20 my $s = DBICVersion::Schema->connect(@connection);
21 my $dm = Translator->new({
23 upgrade_directory => $sql_dir,
24 databases => ['SQLite'],
25 sql_translator_args => { add_drop_table => 0 },
28 ok( $dm, 'DBIC::DH::DM::SQL::Translator gets instantiated correctly' );
32 mkpath(catfile(qw( t sql SQLite preinstall 1.0 )));
34 catfile(qw( t sql SQLite preinstall 1.0 003-semiautomatic.pl ));
35 print {$prerun} "sub {use File::Touch; touch(q(foobar));}";
37 $dm->preinstall({ version => '1.0' });
43 local $SIG{__WARN__} = sub{$warned = 1};
45 ok( $warned, 'prepare_deploy warns if you run it twice' );
47 mkpath(catfile(qw( t sql _common schema 1.0 )));
49 catfile(qw( t sql _common schema 1.0 002-error.sql ));
50 print {$common} qq<syntax fail\n\n>;
54 -f catfile(qw( t sql SQLite schema 1.0 001-auto.sql )),
55 '1.0 schema gets generated properly'
59 $s->resultset('Foo')->create({
62 } 'schema not deployed';
64 mkpath catfile(qw( t sql _common schema 1.0 ));
66 catfile(qw( t sql _common schema 1.0 001-auto.sql ));
67 print {$common} qq<This will never get run>;
71 local $SIG{__WARN__} = sub{$warned = 1};
73 ok( $warned, 'deploy warns on sql errors' );
77 $s->resultset('Foo')->create({
80 } 'schema is deployed';
84 use_ok 'DBICVersion_v2';
85 my $s = DBICVersion::Schema->connect(@connection);
86 my $dm = Translator->new({
88 upgrade_directory => $sql_dir,
89 databases => ['SQLite'],
90 sql_translator_args => { add_drop_table => 0 },
94 ok( $dm, 'DBIC::DH::SQL::Translator w/2.0 instantiates correctly');
96 $version = $s->schema_version();
99 -f catfile(qw( t sql SQLite schema 2.0 001-auto.sql )),
100 '2.0 schema gets generated properly'
102 mkpath(catfile(qw( t sql SQLite up 1.0-2.0 )));
103 $dm->prepare_upgrade({
104 from_version => '1.0',
106 version_set => [qw(1.0 2.0)]
111 local $SIG{__WARN__} = sub{$warned = 1};
112 $dm->prepare_upgrade({
113 from_version => '0.0',
115 version_set => [qw(0.0 1.0)]
117 ok( $warned, 'prepare_upgrade with a bogus preversion warns' );
120 -f catfile(qw( t sql SQLite up 1.0-2.0 001-auto.sql )),
121 '1.0-2.0 diff gets generated properly and default start and end versions get set'
123 mkpath(catfile(qw( t sql SQLite down 2.0-1.0 )));
124 $dm->prepare_downgrade({
125 from_version => $version,
127 version_set => [$version, '1.0']
130 -f catfile(qw( t sql SQLite down 2.0-1.0 001-auto.sql )),
131 '2.0-1.0 diff gets generated properly'
134 $s->resultset('Foo')->create({
138 } 'schema not deployed';
140 $s->resultset('Foo')->create({
144 } 'schema not uppgrayyed';
146 mkpath catfile(qw( t sql _common up 1.0-2.0 ));
147 open my $common, '>',
148 catfile(qw( t sql _common up 1.0-2.0 002-semiautomatic.sql ));
149 print {$common} qq<INSERT INTO Foo (bar, baz) VALUES ("hello", "world");\n\n>;
152 open my $common_pl, '>',
153 catfile(qw( t sql _common up 1.0-2.0 003-semiautomatic.pl ));
154 print {$common_pl} q|
157 $schema->resultset('Foo')->create({
165 $dm->upgrade_single_step({ version_set => [qw( 1.0 2.0 )] });
166 is( $s->resultset('Foo')->search({
169 })->count, 1, '_common migration got run');
170 is( $s->resultset('Foo')->search({
172 #baz => 'blue skies',
173 })->count, 1, '_common perl migration got run');
175 $s->resultset('Foo')->create({
179 } 'schema is deployed';
180 $dm->downgrade_single_step({ version_set => [qw( 2.0 1.0 )] });
182 $s->resultset('Foo')->create({
186 } 'schema is downgrayyed';
187 $dm->upgrade_single_step({ version_set => [qw( 1.0 2.0 )] });
191 use_ok 'DBICVersion_v3';
192 my $s = DBICVersion::Schema->connect(@connection);
193 my $dm = Translator->new({
195 upgrade_directory => $sql_dir,
196 databases => ['SQLite'],
197 sql_translator_args => { add_drop_table => 0 },
201 ok( $dm, 'DBIC::DH::SQL::Translator w/3.0 instantiates correctly');
203 $version = $s->schema_version();
206 -f catfile(qw( t sql SQLite schema 3.0 001-auto.sql )),
207 '2.0 schema gets generated properly'
209 $dm->prepare_downgrade({
210 from_version => $version,
212 version_set => [$version, '1.0']
215 -f catfile(qw( t sql SQLite down 3.0-1.0 001-auto.sql )),
216 '3.0-1.0 diff gets generated properly'
218 $dm->prepare_upgrade({
219 from_version => '1.0',
220 to_version => $version,
221 version_set => ['1.0', $version]
224 -f catfile(qw( t sql SQLite up 1.0-3.0 001-auto.sql )),
225 '1.0-3.0 diff gets generated properly'
227 $dm->prepare_upgrade({
228 from_version => '2.0',
229 to_version => $version,
230 version_set => ['2.0', $version]
234 local $SIG{__WARN__} = sub{$warned = 1};
235 $dm->prepare_upgrade({
236 from_version => '2.0',
237 to_version => $version,
238 version_set => ['2.0', $version]
240 ok( $warned, 'prepare_upgrade warns if you clobber an existing upgrade file' );
243 -f catfile(qw( t sql SQLite up 1.0-2.0 001-auto.sql )),
244 '2.0-3.0 diff gets generated properly'
246 mkpath catfile(qw( t sql _generic up 2.0-3.0 ));
247 rename catfile(qw( t sql SQLite up 2.0-3.0 001-auto.sql )), catfile(qw( t sql _generic up 2.0-3.0 001-auto.sql ));
248 rmtree(catfile(qw( t sql SQLite )));
249 warn 'how can this be' if -d catfile(qw( t sql SQLite ));
251 $s->resultset('Foo')->create({
256 } 'schema not deployed';
257 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
259 $s->resultset('Foo')->create({
264 } 'schema is deployed using _generic';
265 rmtree(catfile(qw( t sql SQLite )));
266 rmtree(catfile(qw( t sql _generic )));
268 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
269 } 'dies when sql dir does not exist';
272 #vim: ts=2 sw=2 expandtab