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', '' ], |
8dab1b04 |
14 | [ 'TestSchemaDSN', 'DBIC::Schema', q{fakedsn fakeuser fakepass "{ AutoCommit => 1 }"} ], |
657d2094 |
15 | [ 'TestSchemaDSN', 'DBIC::Schema', q{create=static traits=Caching moniker_map="{ roles => \"ROLE\" }" constraint="^users\z" dbi:SQLite:testdb.db} ], |
c34bcab6 |
16 | [ 'TestSchemaDSN', 'DBIC::Schema', q{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', q{create=static traits=Caching moniker_map="{ roles => \"ROLE\" }" dbi:SQLite:testdb.db on_connect_do="[\"select 1\", \"select 2\"]" quote_char="\""} ], |
5d11d759 |
18 | ]; |
19 | |
657d2094 |
20 | plan tests => (2 * @$test_params + 3); |
5d11d759 |
21 | |
22 | my $test_dir = $FindBin::Bin; |
23 | my $blib_dir = File::Spec->catdir ($test_dir, '..', 'blib', 'lib'); |
24 | my $cat_dir = File::Spec->catdir ($test_dir, 'TestApp'); |
25 | my $catlib_dir = File::Spec->catdir ($cat_dir, 'lib'); |
a75b6e58 |
26 | my $schema_dir = File::Spec->catdir ($catlib_dir, 'TestSchemaDSN'); |
5d11d759 |
27 | my $creator = File::Spec->catfile($cat_dir, 'script', 'testapp_create.pl'); |
28 | my $model_dir = File::Spec->catdir ($catlib_dir, 'TestApp', 'Model'); |
a75b6e58 |
29 | my $db = File::Spec->catdir ($cat_dir, 'testdb.db'); |
5d11d759 |
30 | |
31 | chdir($test_dir); |
32 | system("catalyst.pl TestApp"); |
33 | chdir($cat_dir); |
34 | |
a75b6e58 |
35 | # create test db |
36 | open my $sql, '|-', 'sqlite3', $db or die $!; |
37 | print $sql <<'EOF'; |
38 | CREATE TABLE users ( |
39 | id INTEGER PRIMARY KEY, |
40 | username TEXT, |
41 | password TEXT, |
42 | email_address TEXT, |
43 | first_name TEXT, |
44 | last_name TEXT, |
45 | active INTEGER |
46 | ); |
47 | CREATE TABLE roles ( |
48 | id INTEGER PRIMARY KEY, |
49 | role TEXT |
50 | ); |
51 | EOF |
52 | close $sql; |
53 | |
5d11d759 |
54 | foreach my $tparam (@$test_params) { |
55 | my ($model, $helper, $args) = @$tparam; |
12ee1738 |
56 | system("$^X -I$blib_dir $creator model $model $helper $model $args"); |
5d11d759 |
57 | my $model_path = File::Spec->catfile($model_dir, $model . '.pm'); |
58 | ok( -f $model_path, "$model_path is a file" ); |
59 | my $compile_rv = system("$^X -I$blib_dir -I$catlib_dir -c $model_path"); |
60 | ok($compile_rv == 0, "perl -c $model_path"); |
a75b6e58 |
61 | |
62 | if ($args =~ /create=static/) { |
63 | my $glob = File::Spec->catfile($schema_dir, 'Result', '*'); |
64 | my $tables =()= glob($glob); |
65 | if ($args =~ /constraint/) { |
66 | is $tables, 1, 'constraint works'; |
67 | } else { |
68 | is $tables, 2, 'correct number of tables'; |
69 | } |
70 | } |
5d11d759 |
71 | } |
72 | |
73 | chdir($test_dir); |
74 | |
75 | sub rm_rf { |
76 | my $name = $File::Find::name; |
77 | if(-d $name) { rmdir $name or die "Cannot rmdir $name: $!" } |
78 | else { unlink $name or die "Cannot unlink $name: $!" } |
79 | } |
80 | finddepth(\&rm_rf, $cat_dir); |