11 use aliased 'DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator';
12 use File::Spec::Functions;
13 use File::Path qw(rmtree mkpath);
15 my $dbh = DBI->connect('dbi:SQLite::memory:');
16 my @connection = (sub { $dbh }, { ignore_version => 1 });
17 my $sql_dir = 't/sql';
20 unlink 'stuffthatran';
22 for (qw(initialize upgrade downgrade deploy)) {
23 mkpath(catfile(qw( t sql _common), $_, '_any' ));
25 catfile(qw( t sql _common), $_, qw(_any 000-win.pl ));
26 print {$fh} 'sub {open my $fh, ">>", "stuffthatran"; use Data::Dumper::Concise; print {$fh} join(",", @{$_[1]||[]}) . "\n"; }';
30 for (qw(initialize upgrade downgrade deploy)) {
31 mkpath(catfile(qw( t sql SQLite), $_, '_any' ));
33 catfile(qw( t sql SQLite), $_, qw(_any 000-win2.pl ));
34 print {$fh} 'sub {open my $fh, ">>", "stuffthatran"; use Data::Dumper::Concise; print {$fh} join(",", @{$_[1]||[]}) . "\n"; }';
39 use_ok 'DBICVersion_v1';
40 my $s = DBICVersion::Schema->connect(@connection);
41 my $dm = Translator->new({
43 script_directory => $sql_dir,
44 databases => ['SQLite'],
45 sql_translator_args => { add_drop_table => 0 },
48 ok( $dm, 'DBIC::DH::DM::SQL::Translator gets instantiated correctly' );
52 mkpath(catfile(qw( t sql SQLite initialize 1.0 )));
54 catfile(qw( t sql SQLite initialize 1.0 003-semiautomatic.pl ));
55 print {$prerun} "sub {use File::Touch; touch(q(foobar));}";
57 $dm->initialize({ version => '1.0' });
59 ok -e 'foobar', 'code got run in preinit';
61 dies_ok {$dm->prepare_deploy} 'prepare_deploy dies if you run it twice' ;
64 -f catfile(qw( t sql SQLite deploy 1.0 001-auto.sql )),
65 '1.0 schema gets generated properly'
69 $s->resultset('Foo')->create({
72 } 'schema not deployed';
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 script_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 my $version = $s->schema_version();
99 -f catfile(qw( t sql SQLite deploy 2.0 001-auto.sql )),
100 '2.0 schema gets generated properly'
102 mkpath(catfile(qw( t sql SQLite upgrade 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 upgrade 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 downgrade 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 downgrade 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 upgrade 1.0-2.0 ));
147 open my $common, '>',
148 catfile(qw( t sql _common upgrade 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 upgrade 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 script_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 my $version = $s->schema_version();
206 -f catfile(qw( t sql SQLite deploy 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 downgrade 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 upgrade 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]
233 $dm->prepare_upgrade({
234 from_version => '2.0',
235 to_version => $version,
236 version_set => ['2.0', $version]
239 'prepare_upgrade dies if you clobber an existing upgrade file' ;
241 -f catfile(qw( t sql SQLite upgrade 1.0-2.0 001-auto.sql )),
242 '2.0-3.0 diff gets generated properly'
245 $s->resultset('Foo')->create({
250 } 'schema not deployed';
251 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
253 $s->resultset('Foo')->create({
258 } 'schema is deployed';
260 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
261 } 'dies when sql dir does not exist';
264 my $stuff_that_ran = do { local( @ARGV, $/ ) = 'stuffthatran'; <> };
280 ', '_any got ran the right amount of times with the right args';
283 #vim: ts=2 sw=2 expandtab