my $s = DBICVersion::Schema->connect(@connection);
my $dm = Translator->new({
schema => $s,
- upgrade_directory => $sql_dir,
+ script_directory => $sql_dir,
databases => ['SQLite'],
sql_translator_args => { add_drop_table => 0 },
});
$dm->prepare_deploy;
ok( $warned, 'prepare_deploy warns if you run it twice' );
}
- mkpath(catfile(qw( t sql _common schema 1.0 )));
- open my $common, '>',
- catfile(qw( t sql _common schema 1.0 002-error.sql ));
- print {$common} qq<syntax fail\n\n>;
- close $common;
ok(
- -f catfile(qw( t sql SQLite schema 1.0 001-auto.sql )),
+ -f catfile(qw( t sql SQLite deploy 1.0 001-auto.sql )),
'1.0 schema gets generated properly'
);
})
} 'schema not deployed';
- mkpath catfile(qw( t sql _common schema 1.0 ));
- open $common, '>',
- catfile(qw( t sql _common schema 1.0 001-auto.sql ));
- print {$common} qq<This will never get run>;
- close $common;
- {
- my $warned = 0;
- local $SIG{__WARN__} = sub{$warned = 1};
- $dm->deploy;
- ok( $warned, 'deploy warns on sql errors' );
- }
+ $dm->deploy;
lives_ok {
$s->resultset('Foo')->create({
my $s = DBICVersion::Schema->connect(@connection);
my $dm = Translator->new({
schema => $s,
- upgrade_directory => $sql_dir,
+ script_directory => $sql_dir,
databases => ['SQLite'],
sql_translator_args => { add_drop_table => 0 },
txn_wrap => 1,
$version = $s->schema_version();
$dm->prepare_deploy;
ok(
- -f catfile(qw( t sql SQLite schema 2.0 001-auto.sql )),
+ -f catfile(qw( t sql SQLite deploy 2.0 001-auto.sql )),
'2.0 schema gets generated properly'
);
- mkpath(catfile(qw( t sql SQLite up 1.0-2.0 )));
+ mkpath(catfile(qw( t sql SQLite upgrade 1.0-2.0 )));
$dm->prepare_upgrade({
from_version => '1.0',
to_version => '2.0',
ok( $warned, 'prepare_upgrade with a bogus preversion warns' );
}
ok(
- -f catfile(qw( t sql SQLite up 1.0-2.0 001-auto.sql )),
+ -f catfile(qw( t sql SQLite upgrade 1.0-2.0 001-auto.sql )),
'1.0-2.0 diff gets generated properly and default start and end versions get set'
);
- mkpath(catfile(qw( t sql SQLite down 2.0-1.0 )));
+ mkpath(catfile(qw( t sql SQLite downgrade 2.0-1.0 )));
$dm->prepare_downgrade({
from_version => $version,
to_version => '1.0',
version_set => [$version, '1.0']
});
ok(
- -f catfile(qw( t sql SQLite down 2.0-1.0 001-auto.sql )),
+ -f catfile(qw( t sql SQLite downgrade 2.0-1.0 001-auto.sql )),
'2.0-1.0 diff gets generated properly'
);
dies_ok {
})
} 'schema not uppgrayyed';
- mkpath catfile(qw( t sql _common up 1.0-2.0 ));
+ mkpath catfile(qw( t sql _common upgrade 1.0-2.0 ));
open my $common, '>',
- catfile(qw( t sql _common up 1.0-2.0 002-semiautomatic.sql ));
+ catfile(qw( t sql _common upgrade 1.0-2.0 002-semiautomatic.sql ));
print {$common} qq<INSERT INTO Foo (bar, baz) VALUES ("hello", "world");\n\n>;
close $common;
open my $common_pl, '>',
- catfile(qw( t sql _common up 1.0-2.0 003-semiautomatic.pl ));
+ catfile(qw( t sql _common upgrade 1.0-2.0 003-semiautomatic.pl ));
print {$common_pl} q|
sub {
my $schema = shift;
my $s = DBICVersion::Schema->connect(@connection);
my $dm = Translator->new({
schema => $s,
- upgrade_directory => $sql_dir,
+ script_directory => $sql_dir,
databases => ['SQLite'],
sql_translator_args => { add_drop_table => 0 },
txn_wrap => 0,
$version = $s->schema_version();
$dm->prepare_deploy;
ok(
- -f catfile(qw( t sql SQLite schema 3.0 001-auto.sql )),
+ -f catfile(qw( t sql SQLite deploy 3.0 001-auto.sql )),
'2.0 schema gets generated properly'
);
$dm->prepare_downgrade({
version_set => [$version, '1.0']
});
ok(
- -f catfile(qw( t sql SQLite down 3.0-1.0 001-auto.sql )),
+ -f catfile(qw( t sql SQLite downgrade 3.0-1.0 001-auto.sql )),
'3.0-1.0 diff gets generated properly'
);
$dm->prepare_upgrade({
version_set => ['1.0', $version]
});
ok(
- -f catfile(qw( t sql SQLite up 1.0-3.0 001-auto.sql )),
+ -f catfile(qw( t sql SQLite upgrade 1.0-3.0 001-auto.sql )),
'1.0-3.0 diff gets generated properly'
);
$dm->prepare_upgrade({
ok( $warned, 'prepare_upgrade warns if you clobber an existing upgrade file' );
}
ok(
- -f catfile(qw( t sql SQLite up 1.0-2.0 001-auto.sql )),
+ -f catfile(qw( t sql SQLite upgrade 1.0-2.0 001-auto.sql )),
'2.0-3.0 diff gets generated properly'
);
- mkpath catfile(qw( t sql _generic up 2.0-3.0 ));
- 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 ));
- rmtree(catfile(qw( t sql SQLite )));
- warn 'how can this be' if -d catfile(qw( t sql SQLite ));
dies_ok {
$s->resultset('Foo')->create({
bar => 'frew',
baz => 'frew',
biff => 'frew',
})
- } 'schema is deployed using _generic';
- rmtree(catfile(qw( t sql SQLite )));
- rmtree(catfile(qw( t sql _generic )));
+ } 'schema is deployed';
dies_ok {
$dm->upgrade_single_step({ version_set => [qw( 2.0 3.0 )] });
} 'dies when sql dir does not exist';