Commit | Line | Data |
4cbe63e7 |
1 | use strict; |
2 | use warnings; |
3 | |
4 | use FindBin '$Bin'; |
5 | use lib "$Bin/lib"; |
6 | |
2a969b06 |
7 | use Test::More; |
4cbe63e7 |
8 | use Test::Exception; |
9 | use Catalyst::Helper::Model::DBIC::Schema; |
4cbe63e7 |
10 | use Storable 'dclone'; |
2a969b06 |
11 | eval "use Catalyst::Helper"; |
12 | plan skip_all => 'Catalyst::Helper required for tests' if $@; |
4cbe63e7 |
13 | |
14 | my $helper = Catalyst::Helper->new; |
15 | $helper->{base} = $Bin; |
16 | my $static = 'create=static'; |
17 | my $dynamic = 'create=dynamic'; |
18 | my $sqlite = 'dbi:SQLite:myapp.db'; |
19 | my $pg = 'dbi:Pg:dbname=foo'; |
20 | my $on_connect_do = 'on_connect_do=["select 1", "select 2"]'; |
21 | my $quote_char = 'quote_char="'; |
22 | my $name_sep = 'name_sep=.'; |
23 | my $i; |
24 | |
25 | $i = instance(schema_class => 'ASchemaClass'); |
26 | is $i->old_schema, 1, '->load_classes detected correctly'; |
27 | |
a4803ca6 |
28 | throws_ok { $i = instance(args => [$static, 'DbI:SQLite:myapp.db']) } |
29 | qr/case matters/i, "wrong case for 'dbi:' DSN part"; |
30 | |
c34bcab6 |
31 | $i = instance(args => ['traits=Caching']); |
32 | is_deeply $i->traits, ['Caching'], 'one trait'; |
33 | is $i->helper->{traits}, "['Caching']", 'one trait as string'; |
4cbe63e7 |
34 | |
c34bcab6 |
35 | $i = instance(args => ['traits=Caching,Replicated']); |
36 | is_deeply $i->traits, ['Caching', 'Replicated'], 'two traits'; |
37 | is $i->helper->{traits}, "['Caching','Replicated']", 'two traits as string'; |
4cbe63e7 |
38 | |
39 | $i = instance(args => [$static]); |
40 | is $i->create, 'static', 'create=static'; |
41 | |
42 | $i = instance(args => [$static, |
43 | q{moniker_map={ authors => "AUTHORS", books => "BOOKS" }}] |
44 | ); |
45 | is_deeply $i->loader_args->{moniker_map}, |
46 | { authors => 'AUTHORS', books => 'BOOKS' }, |
47 | 'loader hash arg'; |
48 | is $i->helper->{loader_args}{moniker_map}, |
49 | q{{authors => "AUTHORS",books => "BOOKS"}}, |
50 | 'loader hash arg as string'; |
51 | |
52 | $i = instance(args => [$static, q{foo=["bar","baz"]}]); |
53 | is_deeply $i->loader_args->{foo}, ['bar', 'baz'], 'loader array arg'; |
54 | is $i->helper->{loader_args}{foo}, |
55 | q{["bar","baz"]}, |
56 | 'loader array arg as string'; |
57 | |
58 | $i = instance(args => [$static, q{components=TimeStamp}]); |
59 | is_deeply $i->components, ['InflateColumn::DateTime', 'TimeStamp'], |
60 | 'extra component'; |
61 | is $i->helper->{loader_args}{components}, |
62 | q{["InflateColumn::DateTime","TimeStamp"]}, |
63 | 'components as string'; |
64 | |
65 | $i = instance( |
66 | schema_class => 'ASchemaClass', |
67 | args => [$static, q{components=TimeStamp}] |
68 | ); |
69 | is_deeply $i->components, ['TimeStamp'], |
70 | 'extra component with ->load_classes'; |
71 | |
72 | $i = instance(args => [$static, q{components=TimeStamp,Foo}]); |
73 | is_deeply $i->components, ['InflateColumn::DateTime', 'TimeStamp', 'Foo'], |
74 | 'two extra components'; |
75 | |
170e2971 |
76 | my $flags = qr// =~ /\^/ ? '^' : "-xism"; |
4cbe63e7 |
77 | $i = instance(args => [$static, q{constraint=^(foo|bar)$}]); |
78 | is $i->loader_args->{constraint}, qr/^(foo|bar)$/, |
79 | 'constraint loader arg'; |
80 | is $i->helper->{loader_args}{constraint}, |
170e2971 |
81 | qq{qr/(?$flags:^(foo|bar)\$)/}, |
4cbe63e7 |
82 | 'constraint loader arg as string'; |
83 | |
84 | $i = instance(args => [$static, q{exclude=^(foo|bar)$}]); |
85 | is $i->loader_args->{exclude}, qr/^(foo|bar)$/, |
86 | 'exclude loader arg'; |
87 | |
5f9a34d7 |
88 | $i = instance(args => [$static, q{db_schema=foo;bar::baz/quux}]); |
89 | is $i->loader_args->{db_schema}, q{foo;bar::baz/quux}, |
90 | 'simple value loader arg'; |
91 | |
4cbe63e7 |
92 | $i = instance(args => [ |
93 | $static, 'components=TimeStamp', $sqlite, $on_connect_do, |
94 | $quote_char, $name_sep |
95 | ]); |
96 | |
97 | is_deeply $i->components, ['InflateColumn::DateTime', 'TimeStamp'], |
98 | 'extra component'; |
99 | |
100 | is $i->connect_info->{dsn}, $sqlite, 'connect_info dsn'; |
101 | is $i->connect_info->{user}, '', 'sqlite omitted user'; |
102 | is $i->connect_info->{password}, '', 'sqlite omitted password'; |
103 | |
104 | is_deeply $i->connect_info->{on_connect_do}, |
105 | ['select 1', 'select 2'], 'connect_info data struct'; |
106 | |
107 | is $i->helper->{connect_info}{on_connect_do}, |
108 | q{["select 1", "select 2"]}, 'connect_info data struct as string'; |
109 | |
110 | is $i->connect_info->{quote_char}, '"', 'connect_info quote_char'; |
111 | |
112 | is $i->helper->{connect_info}{quote_char}, 'q{"}', |
113 | 'connect_info quote_char as string'; |
114 | |
115 | is $i->connect_info->{name_sep}, '.', 'connect_info name_sep'; |
116 | |
117 | is $i->helper->{connect_info}{name_sep}, 'q{.}', |
118 | 'connect_info name_sep as string'; |
119 | |
120 | $i = instance(args => [ |
51062974 |
121 | $static, $sqlite, 'on_connect_do=PRAGMA foreign_keys = ON' |
122 | ]); |
123 | |
124 | is $i->connect_info->{on_connect_do}, |
125 | 'PRAGMA foreign_keys = ON', 'on_connect_do string'; |
126 | |
127 | is $i->helper->{connect_info}{on_connect_do}, |
128 | 'q{PRAGMA foreign_keys = ON}', 'on_connect_do string as string'; |
129 | |
130 | $i = instance(args => [ |
4cbe63e7 |
131 | $static, 'components=TimeStamp', $sqlite, '', $on_connect_do, |
132 | $quote_char, $name_sep |
133 | ]); |
134 | |
135 | is $i->connect_info->{dsn}, $sqlite, 'connect_info dsn'; |
136 | is $i->connect_info->{user}, '', 'sqlite user'; |
137 | is $i->connect_info->{password}, '', 'sqlite omitted password'; |
138 | |
139 | $i = instance(args => [ |
140 | $static, 'components=TimeStamp', $pg, 'user', 'pass', $on_connect_do, |
141 | $quote_char, $name_sep |
142 | ]); |
143 | |
144 | is $i->connect_info->{dsn}, $pg, 'connect_info dsn'; |
145 | is $i->connect_info->{user}, 'user', 'user'; |
146 | is $i->connect_info->{password}, 'pass', 'password'; |
147 | |
148 | $i = instance(args => [ |
c34bcab6 |
149 | $static, $pg, 'user', 'pass', 'quote_char=[]', $name_sep |
150 | ]); |
151 | |
152 | is_deeply $i->connect_info->{quote_char}, ['[', ']'], |
153 | '2 character quote_char'; |
154 | is $i->helper->{connect_info}{quote_char}, '["[","]"]', |
155 | '2 character quote_char as string'; |
156 | |
157 | $i = instance(args => [ |
4cbe63e7 |
158 | $static, 'components=TimeStamp', $sqlite, $on_connect_do, |
159 | $quote_char, $name_sep, '{ auto_savepoint => 1, AutoCommit => 0 }' |
160 | ]); |
161 | |
162 | is $i->connect_info->{auto_savepoint}, 1, 'connect_info arg from extra hash'; |
163 | is $i->connect_info->{AutoCommit}, 0, 'connect_info arg from extra hash'; |
164 | is $i->helper->{connect_info}{auto_savepoint}, 'q{1}', |
165 | 'connect_info arg from extra hash as string'; |
166 | is $i->helper->{connect_info}{AutoCommit}, 'q{0}', |
167 | 'connect_info arg from extra hash as string'; |
168 | |
51062974 |
169 | done_testing; |
170 | |
4cbe63e7 |
171 | sub instance { |
172 | Catalyst::Helper::Model::DBIC::Schema->new( |
173 | schema_class => 'AnotherSchemaClass', |
174 | helper => dclone($helper), |
175 | args => ['create=static'], |
176 | @_ |
177 | ) |
178 | } |