8 use DBIx::Class::DeploymentHandler;
9 use aliased 'DBIx::Class::DeploymentHandler', 'DH';
12 use File::Temp 'tempdir';
13 use Test::Fatal qw(lives_ok dies_ok);
15 my $dbh = DBICDHTest::dbh();
16 my @connection = (sub { $dbh }, { ignore_version => 1 });
17 my $sql_dir = tempdir( CLEANUP => 1 );
20 use_ok 'DBICVersion_v1';
21 my $s = DBICVersion::Schema->connect(@connection);
22 $DBICVersion::Schema::VERSION = 1;
23 ok($s, 'DBICVersion::Schema 1 instantiates correctly');
24 my $handler = DH->new({
25 script_directory => $sql_dir,
27 databases => 'SQLite',
28 sql_translator_args => { add_drop_table => 0 },
31 ok($handler, 'DBIx::Class::DeploymentHandler w/1 instantiates correctly');
33 my $version = $s->schema_version;
34 $handler->prepare_install;
37 $s->resultset('Foo')->create({
40 } 'schema not deployed';
44 } 'cannot install twice';
46 $s->resultset('Foo')->create({
49 } 'schema is deployed';
53 use_ok 'DBICVersion_v2';
54 my $s = DBICVersion::Schema->connect(@connection);
55 $DBICVersion::Schema::VERSION = 2;
56 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
57 my $handler = DH->new({
58 script_directory => $sql_dir,
60 databases => 'SQLite',
63 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
65 my $version = $s->schema_version();
66 $handler->prepare_install;
67 $handler->prepare_upgrade({ from_version => 1, to_version => $version} );
69 $s->resultset('Foo')->create({
73 } 'schema not deployed';
75 $s->resultset('Foo')->create({
79 } 'schema not uppgrayyed';
82 $s->resultset('Foo')->create({
86 } 'schema is deployed';
90 use_ok 'DBICVersion_v3';
91 my $s = DBICVersion::Schema->connect(@connection);
92 $DBICVersion::Schema::VERSION = 3;
93 ok($s, 'DBICVersion::Schema 3 instantiates correctly');
94 my $handler = DH->new({
95 script_directory => $sql_dir,
97 databases => 'SQLite',
100 ok($handler, 'DBIx::Class::DeploymentHandler w/3 instantiates correctly');
102 my $version = $s->schema_version();
103 $handler->prepare_install;
104 $handler->prepare_upgrade({ from_version => 2, to_version => $version });
106 $s->resultset('Foo')->create({
111 } 'schema not deployed';
114 $s->resultset('Foo')->create({
119 } 'schema is deployed';
123 use_ok 'DBICVersion_v4';
124 my $s = DBICVersion::Schema->connect(@connection);
125 $DBICVersion::Schema::VERSION = 2;
126 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
127 my $handler = DH->new({
128 script_directory => $sql_dir,
130 databases => 'SQLite',
133 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
135 my $version = $s->schema_version();
136 $handler->prepare_downgrade({ from_version => 3, to_version => $version });
138 $s->resultset('Foo')->create({
143 } 'schema at version 3';
146 $s->resultset('Foo')->create({
151 } 'schema not at version 3';
153 $s->resultset('Foo')->create({
157 } 'schema is at version 2';