8 use DBIx::Class::DeploymentHandler;
9 use aliased 'DBIx::Class::DeploymentHandler', 'DH';
11 use File::Path 'remove_tree';
17 my $dbh = DBI->connect('dbi:SQLite::memory:');
18 my @connection = (sub { $dbh }, { 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({
28 script_directory => $sql_dir,
31 sql_translator_args => { add_drop_table => 0 },
34 ok($handler, 'DBIx::Class::DeploymentHandler w/1 instantiates correctly');
36 my $version = $s->schema_version;
37 $handler->prepare_install;
40 $s->resultset('Foo')->create({
43 } 'schema not deployed';
47 } 'cannot install twice';
49 $s->resultset('Foo')->create({
52 } 'schema is deployed';
56 use_ok 'DBICVersion_v2';
57 my $s = DBICVersion::Schema->connect(@connection);
58 $DBICVersion::Schema::VERSION = 2;
59 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
60 my $handler = DH->new({
62 script_directory => $sql_dir,
67 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
69 my $version = $s->schema_version();
70 $handler->prepare_install;
72 $s->resultset('Foo')->create({
76 } 'schema not deployed';
78 $s->resultset('Foo')->create({
82 } 'schema not uppgrayyed';
85 $s->resultset('Foo')->create({
89 } 'schema is deployed';
93 use_ok 'DBICVersion_v3';
94 my $s = DBICVersion::Schema->connect(@connection);
95 $DBICVersion::Schema::VERSION = 3;
96 ok($s, 'DBICVersion::Schema 3 instantiates correctly');
97 my $handler = DH->new({
99 script_directory => $sql_dir,
104 ok($handler, 'DBIx::Class::DeploymentHandler w/3 instantiates correctly');
106 my $version = $s->schema_version();
107 $handler->prepare_install;
109 $s->resultset('Foo')->create({
114 } 'schema not deployed';
117 $s->resultset('Foo')->create({
122 } 'schema is deployed';
126 use_ok 'DBICVersion_v4';
127 my $s = DBICVersion::Schema->connect(@connection);
128 $DBICVersion::Schema::VERSION = 2;
129 ok($s, 'DBICVersion::Schema 2 instantiates correctly');
130 my $handler = DH->new({
132 script_directory => $sql_dir,
137 ok($handler, 'DBIx::Class::DeploymentHandler w/2 instantiates correctly');
139 my $version = $s->schema_version();
141 $s->resultset('Foo')->create({
146 } 'schema at version 3';
149 $s->resultset('Foo')->create({
154 } 'schema not at version 3';
156 $s->resultset('Foo')->create({
160 } 'schema is at version 2';