plan skip_all => 'Enable this optional test with $ENV{C_M_DBIC_SCHEMA_TESTAPP}'
unless $ENV{C_M_DBIC_SCHEMA_TESTAPP};
+# XXX this test needs a re-write to fully test the current set of capabilities...
+
my $test_params = [
[ 'TestSchema', 'DBIC::Schema', '' ],
- [ 'TestSchemaDSN', 'DBIC::Schema', q{fakedsn fakeuser fakepass '{ AutoCommit => 1 }'} ],
- [ 'TestSchemaLoader', 'DBIC::SchemaLoader', q{fakedsn fakeuser fakepass '{ AutoCommit => 1 }'} ],
+ [ 'TestSchemaDSN', 'DBIC::Schema', q{fakedsn fakeuser fakepass "{ AutoCommit => 1 }"} ],
+ [ 'TestSchemaDSN', 'DBIC::Schema', q{create=static traits=Caching moniker_map="{ roles => \"ROLE\" }" constraint="^users\z" dbi:SQLite:testdb.db} ],
+ [ '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="\""} ],
+ [ '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="\""} ],
];
-plan tests => (2 * @$test_params);
+plan tests => (2 * @$test_params + 3);
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;
- my $model_two = $model;
- if($helper =~ /Loader/) {
- $model_two = '';
- }
- system("$^X -I$blib_dir $creator model $model $helper $model_two $args");
+ system("$^X -I$blib_dir $creator model $model $helper $model $args");
my $model_path = File::Spec->catfile($model_dir, $model . '.pm');
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);