dbic helper - make user/pass optional for sqlite, add a couple more tests

[catagits/Catalyst-Model-DBIC-Schema.git] / t / 05testapp.t

diff --git a/t/05testapp.t b/t/05testapp.t
index d820518..5d71ce7 100644 (file)
--- a/t/05testapp.t
+++ b/t/05testapp.t
@@ -12,21 +12,44 @@ plan skip_all => 'Enable this optional test with $ENV{C_M_DBIC_SCHEMA_TESTAPP}'
 my $test_params = [
     [ 'TestSchema', 'DBIC::Schema', '' ],
     [ 'TestSchemaDSN', 'DBIC::Schema', q{fakedsn fakeuser fakepass "{ AutoCommit => 1 }"} ],
+    [ 'TestSchemaDSN', 'DBIC::Schema', q{create=static roles=Caching moniker_map="{ roles => \"ROLE\" }" constraint="^users\z" dbi:SQLite:testdb.db "" "" on_connect_do="[\"select 1\", \"select 2\"]" quote_char="\""} ],
+    [ 'TestSchemaDSN', 'DBIC::Schema', q{create=static roles=Caching moniker_map="{ roles => \"ROLE\" }" dbi:SQLite:testdb.db on_connect_do="[\"select 1\", \"select 2\"]" quote_char="\""} ],
 ];
 
-plan tests => (2 * @$test_params);
+plan tests => (2 * @$test_params + 2);
 
 my $test_dir   = $FindBin::Bin;
 my $blib_dir   = File::Spec->catdir ($test_dir, '..', 'blib', 'lib');
 my $cat_dir    = File::Spec->catdir ($test_dir, 'TestApp');
 my $catlib_dir = File::Spec->catdir ($cat_dir, 'lib');
+my $schema_dir = File::Spec->catdir ($catlib_dir, 'TestSchemaDSN');
 my $creator    = File::Spec->catfile($cat_dir, 'script', 'testapp_create.pl');
 my $model_dir  = File::Spec->catdir ($catlib_dir, 'TestApp', 'Model');
+my $db         = File::Spec->catdir ($cat_dir, 'testdb.db');
 
 chdir($test_dir);
 system("catalyst.pl TestApp");
 chdir($cat_dir);
 
+# create test db
+open my $sql, '|-', 'sqlite3', $db or die $!;
+print $sql <<'EOF';
+CREATE TABLE users (                       
+        id            INTEGER PRIMARY KEY, 
+        username      TEXT,                
+        password      TEXT,                
+        email_address TEXT,                
+        first_name    TEXT,                
+        last_name     TEXT,                
+        active        INTEGER              
+);
+CREATE TABLE roles (
+        id   INTEGER PRIMARY KEY,
+        role TEXT
+);
+EOF
+close $sql;
+
 foreach my $tparam (@$test_params) {
    my ($model, $helper, $args) = @$tparam;
    system("$^X -I$blib_dir $creator model $model $helper $model $args");
@@ -34,6 +57,16 @@ foreach my $tparam (@$test_params) {
    ok( -f $model_path, "$model_path is a file" );
    my $compile_rv = system("$^X -I$blib_dir -I$catlib_dir -c $model_path");
    ok($compile_rv == 0, "perl -c $model_path");
+
+   if ($args =~ /create=static/) {
+      my $glob = File::Spec->catfile($schema_dir, 'Result', '*');
+      my $tables =()= glob($glob);
+      if ($args =~ /constraint/) {
+         is $tables, 1, 'constraint works';
+      } else {
+         is $tables, 2, 'correct number of tables';
+      }
+   }
 }
 
 chdir($test_dir);