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('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(qw(1.0 2.0), [qw(1.0 2.0)]);
107 local $SIG{__WARN__} = sub{$warned = 1};
108 $dm->prepare_upgrade(qw(0.0 1.0), [qw(0.0 1.0)]);
109 ok( $warned, 'prepare_upgrade with a bogus preversion warns' );
112 -f catfile(qw( t sql SQLite up 1.0-2.0 001-auto.sql )),
113 '1.0-2.0 diff gets generated properly and default start and end versions get set'
115 mkpath(catfile(qw( t sql SQLite down 2.0-1.0 )));
116 $dm->prepare_downgrade($version, '1.0', [$version, '1.0']);
118 -f catfile(qw( t sql SQLite down 2.0-1.0 001-auto.sql )),
119 '2.0-1.0 diff gets generated properly'
122 $s->resultset('Foo')->create({
126 } 'schema not deployed';
128 $s->resultset('Foo')->create({
132 } 'schema not uppgrayyed';
134 mkpath catfile(qw( t sql _common up 1.0-2.0 ));
135 open my $common, '>',
136 catfile(qw( t sql _common up 1.0-2.0 002-semiautomatic.sql ));
137 print {$common} qq<INSERT INTO Foo (bar, baz) VALUES ("hello", "world");\n\n>;
140 open my $common_pl, '>',
141 catfile(qw( t sql _common up 1.0-2.0 003-semiautomatic.pl ));
142 print {$common_pl} q|
145 $schema->resultset('Foo')->create({
153 $dm->upgrade_single_step([qw( 1.0 2.0 )]);
154 is( $s->resultset('Foo')->search({
157 })->count, 1, '_common migration got run');
158 is( $s->resultset('Foo')->search({
160 #baz => 'blue skies',
161 })->count, 1, '_common perl migration got run');
163 $s->resultset('Foo')->create({
167 } 'schema is deployed';
168 $dm->downgrade_single_step([qw( 2.0 1.0 )]);
170 $s->resultset('Foo')->create({
174 } 'schema is downgrayyed';
175 $dm->upgrade_single_step([qw( 1.0 2.0 )]);
179 use_ok 'DBICVersion_v3';
180 my $s = DBICVersion::Schema->connect(@connection);
181 my $dm = Translator->new({
183 upgrade_directory => $sql_dir,
184 databases => ['SQLite'],
185 sql_translator_args => { add_drop_table => 0 },
189 ok( $dm, 'DBIC::DH::SQL::Translator w/3.0 instantiates correctly');
191 $version = $s->schema_version();
194 -f catfile(qw( t sql SQLite schema 3.0 001-auto.sql )),
195 '2.0 schema gets generated properly'
197 $dm->prepare_downgrade($version, '1.0', [$version, '1.0']);
199 -f catfile(qw( t sql SQLite down 3.0-1.0 001-auto.sql )),
200 '3.0-1.0 diff gets generated properly'
202 $dm->prepare_upgrade( '1.0', $version, ['1.0', $version] );
204 -f catfile(qw( t sql SQLite up 1.0-3.0 001-auto.sql )),
205 '1.0-3.0 diff gets generated properly'
207 $dm->prepare_upgrade( '2.0', $version, ['2.0', $version]);
210 local $SIG{__WARN__} = sub{$warned = 1};
211 $dm->prepare_upgrade( '2.0', $version, ['2.0', $version] );
212 ok( $warned, 'prepare_upgrade warns if you clobber an existing upgrade file' );
215 -f catfile(qw( t sql SQLite up 1.0-2.0 001-auto.sql )),
216 '2.0-3.0 diff gets generated properly'
218 mkpath catfile(qw( t sql _generic up 2.0-3.0 ));
219 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 ));
220 rmtree(catfile(qw( t sql SQLite )));
221 warn 'how can this be' if -d catfile(qw( t sql SQLite ));
223 $s->resultset('Foo')->create({
228 } 'schema not deployed';
229 $dm->upgrade_single_step([qw( 2.0 3.0 )]);
231 $s->resultset('Foo')->create({
236 } 'schema is deployed using _generic';
237 rmtree(catfile(qw( t sql SQLite )));
238 rmtree(catfile(qw( t sql _generic )));
240 $dm->upgrade_single_step([qw( 2.0 3.0 )]);
241 } 'dies when sql dir does not exist';
244 #vim: ts=2 sw=2 expandtab