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 | |
76 | $i = instance(args => [$static, q{constraint=^(foo|bar)$}]); |
77 | is $i->loader_args->{constraint}, qr/^(foo|bar)$/, |
78 | 'constraint loader arg'; |
79 | is $i->helper->{loader_args}{constraint}, |
80 | q{qr/(?-xism:^(foo|bar)$)/}, |
81 | 'constraint loader arg as string'; |
82 | |
83 | $i = instance(args => [$static, q{exclude=^(foo|bar)$}]); |
84 | is $i->loader_args->{exclude}, qr/^(foo|bar)$/, |
85 | 'exclude loader arg'; |
86 | |
5f9a34d7 |
87 | $i = instance(args => [$static, q{db_schema=foo;bar::baz/quux}]); |
88 | is $i->loader_args->{db_schema}, q{foo;bar::baz/quux}, |
89 | 'simple value loader arg'; |
90 | |
4cbe63e7 |
91 | $i = instance(args => [ |
92 | $static, 'components=TimeStamp', $sqlite, $on_connect_do, |
93 | $quote_char, $name_sep |
94 | ]); |
95 | |
96 | is_deeply $i->components, ['InflateColumn::DateTime', 'TimeStamp'], |
97 | 'extra component'; |
98 | |
99 | is $i->connect_info->{dsn}, $sqlite, 'connect_info dsn'; |
100 | is $i->connect_info->{user}, '', 'sqlite omitted user'; |
101 | is $i->connect_info->{password}, '', 'sqlite omitted password'; |
102 | |
103 | is_deeply $i->connect_info->{on_connect_do}, |
104 | ['select 1', 'select 2'], 'connect_info data struct'; |
105 | |
106 | is $i->helper->{connect_info}{on_connect_do}, |
107 | q{["select 1", "select 2"]}, 'connect_info data struct as string'; |
108 | |
109 | is $i->connect_info->{quote_char}, '"', 'connect_info quote_char'; |
110 | |
111 | is $i->helper->{connect_info}{quote_char}, 'q{"}', |
112 | 'connect_info quote_char as string'; |
113 | |
114 | is $i->connect_info->{name_sep}, '.', 'connect_info name_sep'; |
115 | |
116 | is $i->helper->{connect_info}{name_sep}, 'q{.}', |
117 | 'connect_info name_sep as string'; |
118 | |
119 | $i = instance(args => [ |
51062974 |
120 | $static, $sqlite, 'on_connect_do=PRAGMA foreign_keys = ON' |
121 | ]); |
122 | |
123 | is $i->connect_info->{on_connect_do}, |
124 | 'PRAGMA foreign_keys = ON', 'on_connect_do string'; |
125 | |
126 | is $i->helper->{connect_info}{on_connect_do}, |
127 | 'q{PRAGMA foreign_keys = ON}', 'on_connect_do string as string'; |
128 | |
129 | $i = instance(args => [ |
4cbe63e7 |
130 | $static, 'components=TimeStamp', $sqlite, '', $on_connect_do, |
131 | $quote_char, $name_sep |
132 | ]); |
133 | |
134 | is $i->connect_info->{dsn}, $sqlite, 'connect_info dsn'; |
135 | is $i->connect_info->{user}, '', 'sqlite user'; |
136 | is $i->connect_info->{password}, '', 'sqlite omitted password'; |
137 | |
138 | $i = instance(args => [ |
139 | $static, 'components=TimeStamp', $pg, 'user', 'pass', $on_connect_do, |
140 | $quote_char, $name_sep |
141 | ]); |
142 | |
143 | is $i->connect_info->{dsn}, $pg, 'connect_info dsn'; |
144 | is $i->connect_info->{user}, 'user', 'user'; |
145 | is $i->connect_info->{password}, 'pass', 'password'; |
146 | |
147 | $i = instance(args => [ |
c34bcab6 |
148 | $static, $pg, 'user', 'pass', 'quote_char=[]', $name_sep |
149 | ]); |
150 | |
151 | is_deeply $i->connect_info->{quote_char}, ['[', ']'], |
152 | '2 character quote_char'; |
153 | is $i->helper->{connect_info}{quote_char}, '["[","]"]', |
154 | '2 character quote_char as string'; |
155 | |
156 | $i = instance(args => [ |
4cbe63e7 |
157 | $static, 'components=TimeStamp', $sqlite, $on_connect_do, |
158 | $quote_char, $name_sep, '{ auto_savepoint => 1, AutoCommit => 0 }' |
159 | ]); |
160 | |
161 | is $i->connect_info->{auto_savepoint}, 1, 'connect_info arg from extra hash'; |
162 | is $i->connect_info->{AutoCommit}, 0, 'connect_info arg from extra hash'; |
163 | is $i->helper->{connect_info}{auto_savepoint}, 'q{1}', |
164 | 'connect_info arg from extra hash as string'; |
165 | is $i->helper->{connect_info}{AutoCommit}, 'q{0}', |
166 | 'connect_info arg from extra hash as string'; |
167 | |
51062974 |
168 | done_testing; |
169 | |
4cbe63e7 |
170 | sub instance { |
171 | Catalyst::Helper::Model::DBIC::Schema->new( |
172 | schema_class => 'AnotherSchemaClass', |
173 | helper => dclone($helper), |
174 | args => ['create=static'], |
175 | @_ |
176 | ) |
177 | } |