8 use DBIx::Class::DeploymentHandler;
9 use aliased 'DBIx::Class::DeploymentHandler', 'DH';
11 use File::Path 'remove_tree';
17 my $db = 'dbi:SQLite:db.db';
18 my @connection = ($db, '', '', { ignore_version => 1 });
19 my $sql_dir = 't/sql';
22 use_ok 'DBICVersion_v1';
23 my $s = DBICVersion::Schema->connect(@connection);
24 $DBICVersion::Schema::VERSION = 1;
25 ok($s, 'DBICVersion::Schema 1 instantiates correctly');
26 my $handler = DH->new({
27 script_directory => $sql_dir,
29 databases => 'SQLite',
30 sql_translator_args => { add_drop_table => 0 },
33 ok($handler, 'DBIx::Class::DeploymentHandler w/1 instantiates correctly');
35 my $version = $s->schema_version;
36 $handler->prepare_install;
39 $s->resultset('Foo')->create({
42 } 'schema not deployed';
46 } 'cannot install twice';
48 $s->resultset('Foo')->create({
51 } 'schema is deployed';
55 use_ok 'DBICVersion_v2';
56 my $s = DBICVersion::Schema->connect(@connection);
57 $DBICVersion::Schema::VERSION = 2;
58 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
59 my $handler = DH->new({
60 script_directory => $sql_dir,
62 databases => 'SQLite',
65 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
67 my $version = $s->schema_version();
68 $handler->prepare_install;
69 $handler->prepare_upgrade({ from_version => 1, to_version => $version} );
71 $s->resultset('Foo')->create({
75 } 'schema not deployed';
77 $s->resultset('Foo')->create({
81 } 'schema not uppgrayyed';
84 $s->resultset('Foo')->create({
88 } 'schema is deployed';
92 use_ok 'DBICVersion_v3';
93 my $s = DBICVersion::Schema->connect(@connection);
94 $DBICVersion::Schema::VERSION = 3;
95 ok($s, 'DBICVersion::Schema 3 instantiates correctly');
96 my $handler = DH->new({
97 script_directory => $sql_dir,
99 databases => 'SQLite',
102 ok($handler, 'DBIx::Class::DeploymentHandler w/3 instantiates correctly');
104 my $version = $s->schema_version();
105 $handler->prepare_install;
106 $handler->prepare_upgrade({ from_version => 2, to_version => $version });
108 $s->resultset('Foo')->create({
113 } 'schema not deployed';
116 $s->resultset('Foo')->create({
121 } 'schema is deployed';
125 use_ok 'DBICVersion_v4';
126 my $s = DBICVersion::Schema->connect(@connection);
127 $DBICVersion::Schema::VERSION = 2;
128 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
129 my $handler = DH->new({
130 script_directory => $sql_dir,
132 databases => 'SQLite',
135 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
137 my $version = $s->schema_version();
138 $handler->prepare_downgrade({ from_version => 3, to_version => $version });
140 $s->resultset('Foo')->create({
145 } 'schema at version 3';
148 $s->resultset('Foo')->create({
153 } 'schema not at version 3';
155 $s->resultset('Foo')->create({
159 } 'schema is at version 2';