5 use aliased 'DBIx::Class::DeploymentHandler::Deprecated';
7 use File::Path 'remove_tree';
13 my $db = 'dbi:SQLite:db.db';
14 my @connection = ($db, '', '', { ignore_version => 1 });
15 my $sql_dir = 't/sql';
20 use_ok 'DBICVersion_v1';
21 my $s = DBICVersion::Schema->connect(@connection);
22 is $s->schema_version, '1.0', 'schema version is at 1.0';
23 ok($s, 'DBICVersion::Schema 1.0 instantiates correctly');
24 my $handler = Deprecated->new({
25 upgrade_directory => $sql_dir,
27 databases => 'SQLite',
28 sqltargs => { add_drop_table => 0 },
31 ok($handler, 'DBIx::Class::DeploymentHandler w/1.0 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 is $s->schema_version, '2.0', 'schema version is at 2.0';
56 ok($s, 'DBICVersion::Schema 2.0 instantiates correctly');
57 my $handler = Deprecated->new({
58 upgrade_directory => $sql_dir,
60 databases => 'SQLite',
63 ok($handler, 'DBIx::Class::DeploymentHandler w/2.0 instantiates correctly');
65 my $version = $s->schema_version();
66 $handler->prepare_install();
67 $handler->prepare_upgrade('1.0', $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 is $s->schema_version, '3.0', 'schema version is at 3.0';
93 ok($s, 'DBICVersion::Schema 3.0 instantiates correctly');
94 my $handler = Deprecated->new({
95 upgrade_directory => $sql_dir,
97 databases => 'SQLite',
100 ok($handler, 'DBIx::Class::DeploymentHandler w/3.0 instantiates correctly');
102 my $version = $s->schema_version();
103 $handler->prepare_install;
104 $handler->prepare_upgrade( '2.0', $version );
106 $s->resultset('Foo')->create({
111 } 'schema not deployed';
114 $s->resultset('Foo')->create({
119 } 'schema is deployed';