9 'DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator::Deprecated';
11 use File::Spec::Functions qw(catfile splitdir);
12 use File::Temp 'tempdir';
14 my $dbh = DBICDHTest::dbh();
15 my @connection = (sub { $dbh }, { ignore_version => 1 });
16 my $sql_dir = tempdir( CLEANUP => 1 );
21 use_ok 'DBICVersion_v1';
22 my $s = DBICVersion::Schema->connect(@connection);
23 my $dm = Deprecated->new({
25 script_directory => $sql_dir,
26 databases => ['SQLite'],
27 sql_translator_args => { add_drop_table => 0 },
30 ok( $dm, 'DBIC::DH::DM::SQLT::Deprecated gets instantiated correctly' );
35 -f catfile(splitdir($sql_dir), qw(DBICVersion-Schema-1.0-SQLite.sql )),
36 '1.0 schema gets generated properly'
40 $s->resultset('Foo')->create({
43 } 'schema not deployed';
46 $s->resultset('Foo')->create({
49 } 'schema is deployed';
53 use_ok 'DBICVersion_v2';
54 my $s = DBICVersion::Schema->connect(@connection);
55 my $dm = Deprecated->new({
57 script_directory => $sql_dir,
58 databases => ['SQLite'],
63 'DBIC::DH::DM::SQLT::Deprecated gets instantiated correctly w/ version 2.0'
66 $version = $s->schema_version;
68 $dm->prepare_upgrade({
69 from_version => '1.0',
70 to_version => $version,
71 version_set => ['1.0', $version]
74 $s->resultset('Foo')->create({
78 } 'schema not deployed';
80 $s->resultset('Foo')->create({
84 } 'schema not uppgrayyed';
85 $dm->upgrade_single_step({ version_set => ['1.0', $version] });
87 $s->resultset('Foo')->create({
91 } 'schema is deployed';
94 #vim: ts=2 sw=2 expandtab