5 use File::Path 'remove_tree';
9 use DBIx::Class::DeploymentHandler;
10 my $db = 'dbi:SQLite:db.db';
11 my @connection = ($db, '', '', { ignore_version => 1 });
12 my $sql_dir = 't/sql';
17 use_ok 'DBICVersion_v1';
18 my $s = DBICVersion::Schema->connect(@connection);
19 ok($s, 'DBICVersion::Schema 1.0 instantiates correctly');
20 my $handler = DBIx::Class::DeploymentHandler->new({
21 upgrade_directory => $sql_dir,
23 databases => 'SQLite',
24 sqltargs => { add_drop_table => 0 },
27 ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 instantiates correctly');
29 my $version = $s->schema_version();
30 $handler->prepare_install();
33 $s->resultset('Foo')->create({
36 } 'schema not deployed';
40 } 'cannot install twice';
42 $s->resultset('Foo')->create({
45 } 'schema is deployed';
49 use_ok 'DBICVersion_v2';
50 my $s = DBICVersion::Schema->connect(@connection);
51 ok($s, 'DBICVersion::Schema 2.0 instantiates correctly');
52 my $handler = DBIx::Class::DeploymentHandler->new({
53 upgrade_directory => $sql_dir,
55 databases => 'SQLite',
58 ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly');
60 $version = $s->schema_version();
61 $handler->prepare_install();
62 $handler->prepare_upgrade('1.0', $version);
63 $handler->prepare_upgrade($version, '1.0');
65 $s->resultset('Foo')->create({
69 } 'schema not deployed';
71 $s->resultset('Foo')->create({
75 } 'schema not uppgrayyed';
78 $s->resultset('Foo')->create({
82 } 'schema is deployed';
86 use_ok 'DBICVersion_v3';
87 my $s = DBICVersion::Schema->connect(@connection);
88 ok($s, 'DBICVersion::Schema 3.0 instantiates correctly');
89 my $handler = DBIx::Class::DeploymentHandler->new({
90 upgrade_directory => $sql_dir,
92 databases => 'SQLite',
95 ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly');
97 $version = $s->schema_version();
98 $handler->prepare_install;
99 $handler->prepare_upgrade( '1.0', $version );
100 $handler->prepare_upgrade( '2.0', $version );
102 $s->resultset('Foo')->create({
107 } 'schema not deployed';
110 $s->resultset('Foo')->create({
115 } 'schema is deployed';
121 vim: ts=2 sw=2 expandtab