7 use Test::Fatal qw(lives_ok dies_ok);
11 use aliased 'DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator';
12 use Path::Class qw(dir file);
13 use File::Temp qw(tempfile tempdir);
15 my $dbh = DBICDHTest::dbh();
16 my @connection = (sub { $dbh }, { ignore_version => 1 });
17 my $sql_dir = tempdir( CLEANUP => 1 );
18 my (undef, $stuffthatran_fn) = tempfile(OPEN => 0);
20 for (qw(initialize upgrade downgrade deploy)) {
21 dir($sql_dir, '_common', $_, '_any')->mkpath;
23 file($sql_dir, '_common', $_, qw(_any 000-win.pl ));
24 print {$fh} qq^sub {open my \$fh, ">>", '$stuffthatran_fn'; use Data::Dumper::Concise; print {\$fh} join(",", \@{\$_[1]||[]}) . "\\n"; }^;
28 for (qw(initialize upgrade downgrade deploy)) {
29 dir($sql_dir, 'SQLite', $_, '_any')->mkpath;
31 file($sql_dir, 'SQLite', $_, qw(_any 000-win2.pl ));
32 print {$fh} qq^sub {open my \$fh, ">>", '$stuffthatran_fn'; use Data::Dumper::Concise; print {\$fh} join(",", \@{\$_[1]||[]}) . "\\n"; }^;
37 use_ok 'DBICVersion_v1';
38 my $s = DBICVersion::Schema->connect(@connection);
39 my $dm = Translator->new({
41 script_directory => $sql_dir,
42 databases => ['SQLite'],
43 sql_translator_args => { add_drop_table => 0 },
46 ok( $dm, 'DBIC::DH::DM::SQL::Translator gets instantiated correctly' );
50 dir($sql_dir, qw(SQLite initialize 1.0 ))->mkpath;
52 file($sql_dir, qw(SQLite initialize 1.0 003-semiautomatic.pl ));
53 my (undef, $fn) = tempfile(OPEN => 0);
54 print {$prerun} "sub { open my \$fh, '>', '$fn'}";
56 $dm->initialize({ version => '1.0' });
58 ok -e $fn, 'code got run in preinit';
60 dies_ok {$dm->prepare_deploy} 'prepare_deploy dies if you run it twice' ;
63 -f file($sql_dir, qw(SQLite deploy 1.0 001-auto.sql )),
64 '1.0 schema gets generated properly'
68 $s->resultset('Foo')->create({
71 } 'schema not deployed';
76 $s->resultset('Foo')->create({
79 } 'schema is deployed';
83 use_ok 'DBICVersion_v2';
84 my $s = DBICVersion::Schema->connect(@connection);
85 my $dm = Translator->new({
87 script_directory => $sql_dir,
88 databases => ['SQLite'],
89 sql_translator_args => { add_drop_table => 0 },
93 ok( $dm, 'DBIC::DH::SQL::Translator w/2.0 instantiates correctly');
95 my $version = $s->schema_version();
98 -f file($sql_dir, qw(SQLite deploy 2.0 001-auto.sql )),
99 '2.0 schema gets generated properly'
101 dir($sql_dir, qw(SQLite upgrade 1.0-2.0 ))->mkpath;
102 $dm->prepare_upgrade({
103 from_version => '1.0',
105 version_set => [qw(1.0 2.0)]
110 local $SIG{__WARN__} = sub{$warned = 1};
111 $dm->prepare_upgrade({
112 from_version => '0.0',
114 version_set => [qw(0.0 1.0)]
116 ok( $warned, 'prepare_upgrade with a bogus preversion warns' );
119 -f file($sql_dir, qw(SQLite upgrade 1.0-2.0 001-auto.sql )),
120 '1.0-2.0 diff gets generated properly and default start and end versions get set'
122 dir($sql_dir, qw(SQLite downgrade 2.0-1.0 ))->mkpath;
123 $dm->prepare_downgrade({
124 from_version => $version,
126 version_set => [$version, '1.0']
129 -f file($sql_dir, qw(SQLite downgrade 2.0-1.0 001-auto.sql )),
130 '2.0-1.0 diff gets generated properly'
133 $s->resultset('Foo')->create({
137 } 'schema not deployed';
139 $s->resultset('Foo')->create({
143 } 'schema not uppgrayyed';
145 dir($sql_dir, qw(_common upgrade 1.0-2.0 ))->mkpath;
146 open my $common, '>',
147 file($sql_dir, qw(_common upgrade 1.0-2.0 002-semiautomatic.sql ));
148 print {$common} qq<INSERT INTO Foo (bar, baz) VALUES ("hello", "world");\n\n>;
151 open my $common_pl, '>',
152 file($sql_dir, qw(_common upgrade 1.0-2.0 003-semiautomatic.pl ));
153 print {$common_pl} q|
156 $schema->resultset('Foo')->create({
164 $dm->upgrade_single_step({ version_set => [qw( 1.0 2.0 )] });
165 is( $s->resultset('Foo')->search({
168 })->count, 1, '_common migration got run');
169 is( $s->resultset('Foo')->search({
171 #baz => 'blue skies',
172 })->count, 1, '_common perl migration got run');
174 $s->resultset('Foo')->create({
178 } 'schema is deployed';
179 $dm->downgrade_single_step({ version_set => [qw( 2.0 1.0 )] });
181 $s->resultset('Foo')->create({
185 } 'schema is downgrayyed';
186 $dm->upgrade_single_step({ version_set => [qw( 1.0 2.0 )] });
190 use_ok 'DBICVersion_v3';
191 my $s = DBICVersion::Schema->connect(@connection);
192 my $dm = Translator->new({
194 script_directory => $sql_dir,
195 databases => ['SQLite'],
196 sql_translator_args => { add_drop_table => 0 },
200 ok( $dm, 'DBIC::DH::SQL::Translator w/3.0 instantiates correctly');
202 my $version = $s->schema_version();
205 -f file($sql_dir, qw(SQLite deploy 3.0 001-auto.sql )),
206 '2.0 schema gets generated properly'
208 $dm->prepare_downgrade({
209 from_version => $version,
211 version_set => [$version, '1.0']
214 -f file($sql_dir, qw(SQLite downgrade 3.0-1.0 001-auto.sql )),
215 '3.0-1.0 diff gets generated properly'
217 $dm->prepare_upgrade({
218 from_version => '1.0',
219 to_version => $version,
220 version_set => ['1.0', $version]
223 -f file($sql_dir, qw(SQLite upgrade 1.0-3.0 001-auto.sql )),
224 '1.0-3.0 diff gets generated properly'
226 $dm->prepare_upgrade({
227 from_version => '2.0',
228 to_version => $version,
229 version_set => ['2.0', $version]
232 $dm->prepare_upgrade({
233 from_version => '2.0',
234 to_version => $version,
235 version_set => ['2.0', $version]
238 'prepare_upgrade dies if you clobber an existing upgrade file' ;
240 -f file($sql_dir, qw(SQLite upgrade 1.0-2.0 001-auto.sql )),
241 '2.0-3.0 diff gets generated properly'
244 $s->resultset('Foo')->create({
249 } 'schema not deployed';
250 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
252 $s->resultset('Foo')->create({
257 } 'schema is deployed';
259 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
260 } 'dies when sql dir does not exist';
263 my $stuff_that_ran = do { local( @ARGV, $/ ) = $stuffthatran_fn; <> };
279 ', '_any got ran the right amount of times with the right args';
282 #vim: ts=2 sw=2 expandtab