1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
use strict;
use warnings;
use Test::More;
use Test::Exception;
use Path::Class qw/dir/;
use lib qw(t/lib);
use DBICTest;
BEGIN {
require DBIx::Class;
plan skip_all =>
'Test needs ' . DBIx::Class::Optional::Dependencies->req_missing_for ('deploy')
unless DBIx::Class::Optional::Dependencies->req_ok_for ('deploy')
}
local $ENV{DBI_DSN};
# this is how maint/gen_schema did it (connect() to force a storage
# instance, but no conninfo)
# there ought to be more code like this in the wild
like(
DBICTest::Schema->connect->deployment_statements('SQLite'),
qr/\bCREATE TABLE artist\b/i # ensure quoting *is* disabled
);
lives_ok( sub {
my $parse_schema = DBICTest->init_schema(no_deploy => 1);
$parse_schema->deploy({},'t/lib/test_deploy');
$parse_schema->resultset("Artist")->all();
}, 'artist table deployed correctly' );
my $schema = DBICTest->init_schema( quote_names => 1 );
my $var = dir ("t/var/ddl_dir-$$");
$var->mkpath unless -d $var;
my $test_dir_1 = $var->subdir ('test1', 'foo', 'bar' );
$test_dir_1->rmtree if -d $test_dir_1;
$schema->create_ddl_dir( [qw(SQLite MySQL)], 1, $test_dir_1 );
ok( -d $test_dir_1, 'create_ddl_dir did a make_path on its target dir' );
ok( scalar( glob $test_dir_1.'/*.sql' ), 'there are sql files in there' );
my $less = $schema->clone;
$less->unregister_source('BindType');
$less->create_ddl_dir( [qw(SQLite MySQL)], 2, $test_dir_1, 1 );
for (
[ SQLite => '"' ],
[ MySQL => '`' ],
) {
my $type = $_->[0];
my $q = quotemeta($_->[1]);
for my $f (map { $test_dir_1->file("DBICTest-Schema-${_}-$type.sql") } qw(1 2) ) {
like scalar $f->slurp, qr/CREATE TABLE ${q}track${q}/, "Proper quoting in $f";
}
{
local $TODO = 'SQLT::Producer::MySQL has no knowledge of the mythical beast of quoting...'
if $type eq 'MySQL';
my $f = $test_dir_1->file("DBICTest-Schema-1-2-$type.sql");
like scalar $f->slurp, qr/DROP TABLE ${q}bindtype_test${q}/, "Proper quoting in diff $f";
}
}
{
local $TODO = 'we should probably add some tests here for actual deployability of the DDL?';
ok( 0 );
}
END {
$var->rmtree;
}
done_testing;
|
