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';
22 use_ok 'DBICVersion_v1';
23 my $s = DBICVersion::Schema->connect(@connection);
24 my $dm = Translator->new({
26 script_directory => $sql_dir,
27 databases => ['SQLite'],
28 sql_translator_args => { add_drop_table => 0 },
31 ok( $dm, 'DBIC::DH::DM::SQL::Translator gets instantiated correctly' );
35 mkpath(catfile(qw( t sql SQLite initialize 1.0 )));
37 catfile(qw( t sql SQLite initialize 1.0 003-semiautomatic.pl ));
38 print {$prerun} "sub {use File::Touch; touch(q(foobar));}";
40 $dm->initialize({ version => '1.0' });
44 dies_ok {$dm->prepare_deploy} 'prepare_deploy dies if you run it twice' ;
47 -f catfile(qw( t sql SQLite deploy 1.0 001-auto.sql )),
48 '1.0 schema gets generated properly'
52 $s->resultset('Foo')->create({
55 } 'schema not deployed';
60 $s->resultset('Foo')->create({
63 } 'schema is deployed';
67 use_ok 'DBICVersion_v2';
68 my $s = DBICVersion::Schema->connect(@connection);
69 my $dm = Translator->new({
71 script_directory => $sql_dir,
72 databases => ['SQLite'],
73 sql_translator_args => { add_drop_table => 0 },
77 ok( $dm, 'DBIC::DH::SQL::Translator w/2.0 instantiates correctly');
79 my $version = $s->schema_version();
82 -f catfile(qw( t sql SQLite deploy 2.0 001-auto.sql )),
83 '2.0 schema gets generated properly'
85 mkpath(catfile(qw( t sql SQLite upgrade 1.0-2.0 )));
86 $dm->prepare_upgrade({
87 from_version => '1.0',
89 version_set => [qw(1.0 2.0)]
94 local $SIG{__WARN__} = sub{$warned = 1};
95 $dm->prepare_upgrade({
96 from_version => '0.0',
98 version_set => [qw(0.0 1.0)]
100 ok( $warned, 'prepare_upgrade with a bogus preversion warns' );
103 -f catfile(qw( t sql SQLite upgrade 1.0-2.0 001-auto.sql )),
104 '1.0-2.0 diff gets generated properly and default start and end versions get set'
106 mkpath(catfile(qw( t sql SQLite downgrade 2.0-1.0 )));
107 $dm->prepare_downgrade({
108 from_version => $version,
110 version_set => [$version, '1.0']
113 -f catfile(qw( t sql SQLite downgrade 2.0-1.0 001-auto.sql )),
114 '2.0-1.0 diff gets generated properly'
117 $s->resultset('Foo')->create({
121 } 'schema not deployed';
123 $s->resultset('Foo')->create({
127 } 'schema not uppgrayyed';
129 mkpath catfile(qw( t sql _common upgrade 1.0-2.0 ));
130 open my $common, '>',
131 catfile(qw( t sql _common upgrade 1.0-2.0 002-semiautomatic.sql ));
132 print {$common} qq<INSERT INTO Foo (bar, baz) VALUES ("hello", "world");\n\n>;
135 open my $common_pl, '>',
136 catfile(qw( t sql _common upgrade 1.0-2.0 003-semiautomatic.pl ));
137 print {$common_pl} q|
140 $schema->resultset('Foo')->create({
148 $dm->upgrade_single_step({ version_set => [qw( 1.0 2.0 )] });
149 is( $s->resultset('Foo')->search({
152 })->count, 1, '_common migration got run');
153 is( $s->resultset('Foo')->search({
155 #baz => 'blue skies',
156 })->count, 1, '_common perl migration got run');
158 $s->resultset('Foo')->create({
162 } 'schema is deployed';
163 $dm->downgrade_single_step({ version_set => [qw( 2.0 1.0 )] });
165 $s->resultset('Foo')->create({
169 } 'schema is downgrayyed';
170 $dm->upgrade_single_step({ version_set => [qw( 1.0 2.0 )] });
174 use_ok 'DBICVersion_v3';
175 my $s = DBICVersion::Schema->connect(@connection);
176 my $dm = Translator->new({
178 script_directory => $sql_dir,
179 databases => ['SQLite'],
180 sql_translator_args => { add_drop_table => 0 },
184 ok( $dm, 'DBIC::DH::SQL::Translator w/3.0 instantiates correctly');
186 my $version = $s->schema_version();
189 -f catfile(qw( t sql SQLite deploy 3.0 001-auto.sql )),
190 '2.0 schema gets generated properly'
192 $dm->prepare_downgrade({
193 from_version => $version,
195 version_set => [$version, '1.0']
198 -f catfile(qw( t sql SQLite downgrade 3.0-1.0 001-auto.sql )),
199 '3.0-1.0 diff gets generated properly'
201 $dm->prepare_upgrade({
202 from_version => '1.0',
203 to_version => $version,
204 version_set => ['1.0', $version]
207 -f catfile(qw( t sql SQLite upgrade 1.0-3.0 001-auto.sql )),
208 '1.0-3.0 diff gets generated properly'
210 $dm->prepare_upgrade({
211 from_version => '2.0',
212 to_version => $version,
213 version_set => ['2.0', $version]
216 $dm->prepare_upgrade({
217 from_version => '2.0',
218 to_version => $version,
219 version_set => ['2.0', $version]
222 'prepare_upgrade dies if you clobber an existing upgrade file' ;
224 -f catfile(qw( t sql SQLite upgrade 1.0-2.0 001-auto.sql )),
225 '2.0-3.0 diff gets generated properly'
228 $s->resultset('Foo')->create({
233 } 'schema not deployed';
234 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
236 $s->resultset('Foo')->create({
241 } 'schema is deployed';
243 $dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
244 } 'dies when sql dir does not exist';
247 #vim: ts=2 sw=2 expandtab