8 use aliased 'DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator';
9 use File::Spec::Functions;
10 use File::Path qw(rmtree mkpath);
12 my $dbh = DBI->connect('dbi:SQLite::memory:');
13 my @connection = (sub { $dbh }, { 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 script_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 initialize 1.0 )));
34 catfile(qw( t sql SQLite initialize 1.0 003-semiautomatic.pl ));
35 print {$prerun} "sub {use File::Touch; touch(q(foobar));}";
37 $dm->initialize({ version => '1.0' });
41 dies_ok {$dm->prepare_deploy} 'prepare_deploy dies if you run it twice' ;
44 -f catfile(qw( t sql SQLite deploy 1.0 001-auto.sql )),
45 '1.0 schema gets generated properly'
49 $s->resultset('Foo')->create({
52 } 'schema not deployed';
57 $s->resultset('Foo')->create({
60 } 'schema is deployed';
64 use_ok 'DBICVersion_v2';
65 my $s = DBICVersion::Schema->connect(@connection);
66 my $dm = Translator->new({
68 script_directory => $sql_dir,
69 databases => ['SQLite'],
70 sql_translator_args => { add_drop_table => 0 },
74 ok( $dm, 'DBIC::DH::SQL::Translator w/2.0 instantiates correctly');
76 $version = $s->schema_version();
79 -f catfile(qw( t sql SQLite deploy 2.0 001-auto.sql )),
80 '2.0 schema gets generated properly'
82 mkpath(catfile(qw( t sql SQLite upgrade 1.0-2.0 )));
83 $dm->prepare_upgrade({
84 from_version => '1.0',
86 version_set => [qw(1.0 2.0)]
91 local $SIG{__WARN__} = sub{$warned = 1};
92 $dm->prepare_upgrade({
93 from_version => '0.0',
95 version_set => [qw(0.0 1.0)]
97 ok( $warned, 'prepare_upgrade with a bogus preversion warns' );
100 -f catfile(qw( t sql SQLite upgrade 1.0-2.0 001-auto.sql )),
101 '1.0-2.0 diff gets generated properly and default start and end versions get set'
103 mkpath(catfile(qw( t sql SQLite downgrade 2.0-1.0 )));
104 $dm->prepare_downgrade({
105 from_version => $version,
107 version_set => [$version, '1.0']
110 -f catfile(qw( t sql SQLite downgrade 2.0-1.0 001-auto.sql )),
111 '2.0-1.0 diff gets generated properly'
114 $s->resultset('Foo')->create({
118 } 'schema not deployed';
120 $s->resultset('Foo')->create({
124 } 'schema not uppgrayyed';
126 mkpath catfile(qw( t sql _common upgrade 1.0-2.0 ));
127 open my $common, '>',
128 catfile(qw( t sql _common upgrade 1.0-2.0 002-semiautomatic.sql ));
129 print {$common} qq<INSERT INTO Foo (bar, baz) VALUES ("hello", "world");\n\n>;
132 open my $common_pl, '>',
133 catfile(qw( t sql _common upgrade 1.0-2.0 003-semiautomatic.pl ));
134 print {$common_pl} q|
137 $schema->resultset('Foo')->create({
145 $dm->upgrade_single_step({ version_set => [qw( 1.0 2.0 )] });
146 is( $s->resultset('Foo')->search({
149 })->count, 1, '_common migration got run');
150 is( $s->resultset('Foo')->search({
152 #baz => 'blue skies',
153 })->count, 1, '_common perl migration got run');
155 $s->resultset('Foo')->create({
159 } 'schema is deployed';
160 $dm->downgrade_single_step({ version_set => [qw( 2.0 1.0 )] });
162 $s->resultset('Foo')->create({
166 } 'schema is downgrayyed';
167 $dm->upgrade_single_step({ version_set => [qw( 1.0 2.0 )] });
171 use_ok 'DBICVersion_v3';
172 my $s = DBICVersion::Schema->connect(@connection);
173 my $dm = Translator->new({
175 script_directory => $sql_dir,
176 databases => ['SQLite'],
177 sql_translator_args => { add_drop_table => 0 },
181 ok( $dm, 'DBIC::DH::SQL::Translator w/3.0 instantiates correctly');
183 $version = $s->schema_version();
186 -f catfile(qw( t sql SQLite deploy 3.0 001-auto.sql )),
187 '2.0 schema gets generated properly'
189 $dm->prepare_downgrade({
190 from_version => $version,
192 version_set => [$version, '1.0']
195 -f catfile(qw( t sql SQLite downgrade 3.0-1.0 001-auto.sql )),
196 '3.0-1.0 diff gets generated properly'
198 $dm->prepare_upgrade({
199 from_version => '1.0',
200 to_version => $version,
201 version_set => ['1.0', $version]
204 -f catfile(qw( t sql SQLite upgrade 1.0-3.0 001-auto.sql )),
205 '1.0-3.0 diff gets generated properly'
207 $dm->prepare_upgrade({
208 from_version => '2.0',
209 to_version => $version,
210 version_set => ['2.0', $version]
213 $dm->prepare_upgrade({
214 from_version => '2.0',
215 to_version => $version,
216 version_set => ['2.0', $version]
219 'prepare_upgrade dies if you clobber an existing upgrade file' ;
221 -f catfile(qw( t sql SQLite upgrade 1.0-2.0 001-auto.sql )),
222 '2.0-3.0 diff gets generated properly'
225 $s->resultset('Foo')->create({
230 } 'schema not deployed';
231 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
233 $s->resultset('Foo')->create({
238 } 'schema is deployed';
240 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
241 } 'dies when sql dir does not exist';
244 #vim: ts=2 sw=2 expandtab