Commit | Line | Data |
5d11d759 |
1 | use strict; |
2 | use Test::More; |
3 | use FindBin; |
4 | use File::Spec; |
5 | use File::Find; |
6 | |
7 | plan skip_all => 'Enable this optional test with $ENV{C_M_DBIC_SCHEMA_TESTAPP}' |
8 | unless $ENV{C_M_DBIC_SCHEMA_TESTAPP}; |
9 | |
12ee1738 |
10 | # XXX this test needs a re-write to fully test the current set of capabilities... |
11 | |
5d11d759 |
12 | my $test_params = [ |
13 | [ 'TestSchema', 'DBIC::Schema', '' ], |
ce9e19dc |
14 | [ 'TestSchemaDSN', 'DBIC::Schema', qw/fakedsn fakeuser fakepass/, '{ AutoCommit => 1 }' ], |
15 | [ 'TestSchemaDSN', 'DBIC::Schema', 'create=static', 'traits=Caching', 'moniker_map={ roles => "ROLE" }', 'constraint=^users\z', 'dbi:SQLite:testdb.db' ], |
16 | [ 'TestSchemaDSN', 'DBIC::Schema', 'create=static', 'traits=Caching', 'moniker_map={ roles => "ROLE" }', 'constraint=^users\z', 'dbi:SQLite:testdb.db', '', '', 'on_connect_do=["select 1", "select 2"]', 'quote_char="' ], |
17 | [ 'TestSchemaDSN', 'DBIC::Schema', 'create=static', 'traits=Caching', 'moniker_map={ roles => "ROLE" }', 'dbi:SQLite:testdb.db', 'on_connect_do=["select 1", "select 2"]', 'quote_char="' ], |
18 | [ 'TestSchemaDSN', 'DBIC::Schema', 'create=static', 'traits=Caching', 'inflect_singular=sub { $_[0] =~ /\A(.+?)(_id)?\z/; $1 }', q{moniker_map=sub { return join('', map ucfirst, split(/[\W_]+/, lc $_[0])); }}, 'dbi:SQLite:testdb.db' ], |
5d11d759 |
19 | ]; |
20 | |
5d11d759 |
21 | my $test_dir = $FindBin::Bin; |
22 | my $blib_dir = File::Spec->catdir ($test_dir, '..', 'blib', 'lib'); |
23 | my $cat_dir = File::Spec->catdir ($test_dir, 'TestApp'); |
24 | my $catlib_dir = File::Spec->catdir ($cat_dir, 'lib'); |
a75b6e58 |
25 | my $schema_dir = File::Spec->catdir ($catlib_dir, 'TestSchemaDSN'); |
5d11d759 |
26 | my $creator = File::Spec->catfile($cat_dir, 'script', 'testapp_create.pl'); |
27 | my $model_dir = File::Spec->catdir ($catlib_dir, 'TestApp', 'Model'); |
a75b6e58 |
28 | my $db = File::Spec->catdir ($cat_dir, 'testdb.db'); |
5d11d759 |
29 | |
30 | chdir($test_dir); |
31 | system("catalyst.pl TestApp"); |
32 | chdir($cat_dir); |
33 | |
a75b6e58 |
34 | # create test db |
35 | open my $sql, '|-', 'sqlite3', $db or die $!; |
36 | print $sql <<'EOF'; |
37 | CREATE TABLE users ( |
38 | id INTEGER PRIMARY KEY, |
39 | username TEXT, |
40 | password TEXT, |
41 | email_address TEXT, |
42 | first_name TEXT, |
43 | last_name TEXT, |
44 | active INTEGER |
45 | ); |
46 | CREATE TABLE roles ( |
47 | id INTEGER PRIMARY KEY, |
48 | role TEXT |
49 | ); |
50 | EOF |
51 | close $sql; |
52 | |
5d11d759 |
53 | foreach my $tparam (@$test_params) { |
ce9e19dc |
54 | my ($model, $helper, @args) = @$tparam; |
55 | |
6b6abf77 |
56 | cleanup_schema(); |
ce9e19dc |
57 | |
58 | system($^X, "-I$blib_dir", $creator, 'model', $model, $helper, $model, @args); |
59 | |
5d11d759 |
60 | my $model_path = File::Spec->catfile($model_dir, $model . '.pm'); |
61 | ok( -f $model_path, "$model_path is a file" ); |
62 | my $compile_rv = system("$^X -I$blib_dir -I$catlib_dir -c $model_path"); |
63 | ok($compile_rv == 0, "perl -c $model_path"); |
a75b6e58 |
64 | |
ce9e19dc |
65 | if (grep /create=static/, @args) { |
6b6abf77 |
66 | my @result_files = result_files(); |
ce9e19dc |
67 | |
68 | if (grep /constraint/, @args) { |
6b6abf77 |
69 | is scalar @result_files, 1, 'constraint works'; |
a75b6e58 |
70 | } else { |
6b6abf77 |
71 | is scalar @result_files, 2, 'correct number of tables'; |
a75b6e58 |
72 | } |
6b6abf77 |
73 | |
74 | for my $file (@result_files) { |
75 | my $code = code_for($file); |
76 | |
77 | like $code, qr/use Moose;\n/, 'use_moose enabled'; |
78 | like $code, qr/__PACKAGE__->meta->make_immutable;\n/, 'use_moose enabled'; |
79 | } |
80 | } |
81 | } |
82 | |
83 | # Test that use_moose=1 is not applied to existing non-moose schemas (RT#60558) |
84 | { |
85 | cleanup_schema(); |
86 | |
87 | system($^X, "-I$blib_dir", $creator, 'model', |
88 | 'TestSchemaDSN', 'DBIC::Schema', 'TestSchemaDSN', |
89 | 'create=static', 'use_moose=0', 'dbi:SQLite:testdb.db' |
90 | ); |
91 | |
92 | my @result_files = result_files(); |
93 | |
94 | for my $file (@result_files) { |
95 | my $code = code_for($file); |
96 | |
97 | unlike $code, qr/use Moose;\n/, 'non use_moose=1 schema'; |
98 | unlike $code, qr/__PACKAGE__->meta->make_immutable;\n/, 'non use_moose=1 schema'; |
99 | } |
100 | |
101 | system($^X, "-I$blib_dir", $creator, 'model', |
102 | 'TestSchemaDSN', 'DBIC::Schema', 'TestSchemaDSN', |
103 | 'create=static', 'dbi:SQLite:testdb.db' |
104 | ); |
105 | |
106 | for my $file (@result_files) { |
107 | my $code = code_for($file); |
108 | |
109 | unlike $code, qr/use Moose;\n/, |
110 | 'non use_moose=1 schema not upgraded to use_moose=1'; |
111 | unlike $code, qr/__PACKAGE__->meta->make_immutable;\n/, |
112 | 'non use_moose=1 schema not upgraded to use_moose=1'; |
a75b6e58 |
113 | } |
5d11d759 |
114 | } |
115 | |
1fcd7804 |
116 | # Test that a moose schema is not detected as a non-moose schema due to an |
117 | # errant file. |
118 | { |
119 | cleanup_schema(); |
120 | |
121 | system($^X, "-I$blib_dir", $creator, 'model', |
122 | 'TestSchemaDSN', 'DBIC::Schema', 'TestSchemaDSN', |
123 | 'create=static', 'dbi:SQLite:testdb.db' |
124 | ); |
125 | |
126 | mkdir "$schema_dir/.svn"; |
127 | open my $fh, '>', "$schema_dir/.svn/foo" |
128 | or die "Could not open $schema_dir/.svn/foo for writing: $!"; |
129 | print $fh "gargle\n"; |
130 | close $fh; |
131 | |
132 | mkdir "$schema_dir/Result/.svn"; |
133 | open $fh, '>', "$schema_dir/Result/.svn/foo" |
134 | or die "Could not open $schema_dir/Result/.svn/foo for writing: $!"; |
135 | print $fh "hlagh\n"; |
136 | close $fh; |
137 | |
138 | system($^X, "-I$blib_dir", $creator, 'model', |
139 | 'TestSchemaDSN', 'DBIC::Schema', 'TestSchemaDSN', |
140 | 'create=static', 'dbi:SQLite:testdb.db' |
141 | ); |
142 | |
143 | for my $file (result_files()) { |
144 | my $code = code_for($file); |
145 | |
146 | like $code, qr/use Moose;\n/, |
147 | 'use_moose detection not confused by version control files'; |
148 | like $code, qr/__PACKAGE__->meta->make_immutable;\n/, |
149 | 'use_moose detection not confused by version control files'; |
150 | } |
151 | } |
152 | |
ce9e19dc |
153 | done_testing; |
5d11d759 |
154 | |
155 | sub rm_rf { |
156 | my $name = $File::Find::name; |
157 | if(-d $name) { rmdir $name or die "Cannot rmdir $name: $!" } |
158 | else { unlink $name or die "Cannot unlink $name: $!" } |
159 | } |
ce9e19dc |
160 | |
6b6abf77 |
161 | sub cleanup_schema { |
162 | return unless -d $schema_dir; |
163 | finddepth(\&rm_rf, $schema_dir); |
164 | unlink "${schema_dir}.pm"; |
165 | } |
166 | |
167 | sub code_for { |
168 | my $file = shift; |
169 | |
170 | open my $fh, '<', $file; |
171 | my $code = do { local $/; <$fh> }; |
172 | close $fh; |
173 | |
174 | return $code; |
175 | } |
176 | |
177 | sub result_files { |
178 | my $glob = File::Spec->catfile($schema_dir, 'Result', '*'); |
179 | |
180 | return glob($glob); |
181 | } |
182 | |
ce9e19dc |
183 | END { |
87145c6c |
184 | if ($ENV{C_M_DBIC_SCHEMA_TESTAPP}) { |
185 | chdir($test_dir); |
186 | finddepth(\&rm_rf, $cat_dir); |
187 | } |
ce9e19dc |
188 | } |
6b6abf77 |
189 | |
190 | # vim:sts=3 sw=3 et tw=80: |