Commit | Line | Data |
9f3849c3 |
1 | use strict; |
2 | use warnings; |
3 | |
34963a09 |
4 | use Test::More; |
9f3849c3 |
5 | use Test::Exception; |
34963a09 |
6 | use Test::Warn; |
9f3849c3 |
7 | |
6bceaca3 |
8 | BEGIN { |
ebcd0e4f |
9 | require DBIx::Class; |
10 | plan skip_all => 'Test needs ' . DBIx::Class::Optional::Dependencies->req_missing_for('admin') |
11 | unless DBIx::Class::Optional::Dependencies->req_ok_for('admin'); |
6bceaca3 |
12 | |
ebcd0e4f |
13 | plan skip_all => 'Test needs ' . DBIx::Class::Optional::Dependencies->req_missing_for('deploy') |
14 | unless DBIx::Class::Optional::Dependencies->req_ok_for('deploy'); |
15 | } |
34963a09 |
16 | |
17 | use lib qw(t/lib); |
18 | use DBICTest; |
19 | |
9f3849c3 |
20 | use Path::Class; |
9f3849c3 |
21 | |
c71d3367 |
22 | use_ok 'DBIx::Class::Admin'; |
9f3849c3 |
23 | |
9f3849c3 |
24 | |
34963a09 |
25 | my $sql_dir = dir(qw/t var/); |
038fd460 |
26 | my @connect_info = DBICTest->_database( |
1edd4ca6 |
27 | no_deploy=>1, |
28 | no_populate=>1, |
29 | sqlite_use_file => 1, |
038fd460 |
30 | ); |
f267b29d |
31 | |
9f3849c3 |
32 | { # create the schema |
33 | |
2ded40e7 |
34 | # make sure we are clean |
a705b175 |
35 | clean_dir($sql_dir); |
2ded40e7 |
36 | |
2ded40e7 |
37 | |
a705b175 |
38 | my $admin = DBIx::Class::Admin->new( |
1edd4ca6 |
39 | schema_class=> "DBICTest::Schema", |
40 | sql_dir=> $sql_dir, |
99ab62de |
41 | connect_info => \@connect_info, |
a705b175 |
42 | ); |
43 | isa_ok ($admin, 'DBIx::Class::Admin', 'create the admin object'); |
44 | lives_ok { $admin->create('MySQL'); } 'Can create MySQL sql'; |
45 | lives_ok { $admin->create('SQLite'); } 'Can Create SQLite sql'; |
f267b29d |
46 | lives_ok { |
47 | $SIG{__WARN__} = sub { warn @_ unless $_[0] =~ /no such table.+DROP TABLE/s }; |
48 | $admin->deploy() |
49 | } 'Can Deploy schema'; |
9f3849c3 |
50 | } |
51 | |
9f3849c3 |
52 | { # upgrade schema |
53 | |
a705b175 |
54 | clean_dir($sql_dir); |
ebcd0e4f |
55 | require DBICVersion_v1; |
9f3849c3 |
56 | |
a705b175 |
57 | my $admin = DBIx::Class::Admin->new( |
99ab62de |
58 | schema_class => 'DBICVersion::Schema', |
1edd4ca6 |
59 | sql_dir => $sql_dir, |
60 | connect_info => \@connect_info, |
a705b175 |
61 | ); |
038fd460 |
62 | |
a705b175 |
63 | my $schema = $admin->schema(); |
038fd460 |
64 | |
a705b175 |
65 | lives_ok { $admin->create($schema->storage->sqlt_type(), {add_drop_table=>0}); } 'Can create DBICVersionOrig sql in ' . $schema->storage->sqlt_type; |
66 | lives_ok { $admin->deploy( ) } 'Can Deploy schema'; |
2ded40e7 |
67 | |
68 | # connect to now deployed schema |
a705b175 |
69 | lives_ok { $schema = DBICVersion::Schema->connect(@{$schema->storage->connect_info()}); } 'Connect to deployed Database'; |
2ded40e7 |
70 | |
a705b175 |
71 | is($schema->get_db_version, $DBICVersion::Schema::VERSION, 'Schema deployed and versions match'); |
2ded40e7 |
72 | |
73 | |
ebcd0e4f |
74 | require DBICVersion_v2; |
23737393 |
75 | DBICVersion::Schema->upgrade_directory (undef); # so that we can test use of $sql_dir |
2ded40e7 |
76 | |
a705b175 |
77 | $admin = DBIx::Class::Admin->new( |
99ab62de |
78 | schema_class => 'DBICVersion::Schema', |
34963a09 |
79 | sql_dir => $sql_dir, |
1edd4ca6 |
80 | connect_info => \@connect_info |
a705b175 |
81 | ); |
2ded40e7 |
82 | |
a705b175 |
83 | lives_ok { $admin->create($schema->storage->sqlt_type(), {}, "1.0" ); } 'Can create diff for ' . $schema->storage->sqlt_type; |
34963a09 |
84 | { |
85 | local $SIG{__WARN__} = sub { warn $_[0] unless $_[0] =~ /DB version .+? is lower than the schema version/ }; |
86 | lives_ok {$admin->upgrade();} 'upgrade the schema'; |
99ab62de |
87 | dies_ok {$admin->deploy} 'cannot deploy installed schema, should upgrade instead'; |
34963a09 |
88 | } |
2ded40e7 |
89 | |
a705b175 |
90 | is($schema->get_db_version, $DBICVersion::Schema::VERSION, 'Schema and db versions match'); |
912e2d5a |
91 | |
92 | } |
93 | |
94 | { # install |
95 | |
a705b175 |
96 | clean_dir($sql_dir); |
97 | |
98 | my $admin = DBIx::Class::Admin->new( |
99ab62de |
99 | schema_class => 'DBICVersion::Schema', |
1edd4ca6 |
100 | sql_dir => $sql_dir, |
101 | _confirm => 1, |
102 | connect_info => \@connect_info, |
a705b175 |
103 | ); |
104 | |
105 | $admin->version("3.0"); |
106 | lives_ok { $admin->install(); } 'install schema version 3.0'; |
107 | is($admin->schema->get_db_version, "3.0", 'db thinks its version 3.0'); |
108 | dies_ok { $admin->install("4.0"); } 'cannot install to allready existing version'; |
ebcd0e4f |
109 | |
a705b175 |
110 | $admin->force(1); |
34963a09 |
111 | warnings_exist ( sub { |
112 | lives_ok { $admin->install("4.0") } 'can force install to allready existing version' |
113 | }, qr/Forcing install may not be a good idea/, 'Force warning emitted' ); |
a705b175 |
114 | is($admin->schema->get_db_version, "4.0", 'db thinks its version 4.0'); |
912e2d5a |
115 | #clean_dir($sql_dir); |
9f3849c3 |
116 | } |
117 | |
118 | sub clean_dir { |
34963a09 |
119 | my ($dir) = @_; |
1edd4ca6 |
120 | $dir = $dir->resolve; |
121 | if ( ! -d $dir ) { |
122 | $dir->mkpath(); |
123 | } |
124 | foreach my $file ($dir->children) { |
125 | # skip any hidden files |
99ab62de |
126 | next if ($file =~ /^\./); |
1edd4ca6 |
127 | unlink $file; |
128 | } |
9f3849c3 |
129 | } |
130 | |
131 | done_testing; |