9 use Catalyst::Helper::Model::DBIC::Schema;
10 use Storable 'dclone';
11 eval "use Catalyst::Helper";
12 plan skip_all => 'Catalyst::Helper required for tests' if $@;
15 my $helper = Catalyst::Helper->new;
16 $helper->{base} = $Bin;
17 my $static = 'create=static';
18 my $dynamic = 'create=dynamic';
19 my $sqlite = 'dbi:SQLite:myapp.db';
20 my $pg = 'dbi:Pg:dbname=foo';
21 my $on_connect_do = 'on_connect_do=["select 1", "select 2"]';
22 my $quote_char = 'quote_char="';
23 my $name_sep = 'name_sep=.';
26 $i = instance(schema_class => 'ASchemaClass');
27 is $i->old_schema, 1, '->load_classes detected correctly';
29 $i = instance(args => ['traits=Caching']);
30 is_deeply $i->traits, ['Caching'], 'one trait';
31 is $i->helper->{traits}, "['Caching']", 'one trait as string';
33 $i = instance(args => ['traits=Caching,Replicated']);
34 is_deeply $i->traits, ['Caching', 'Replicated'], 'two traits';
35 is $i->helper->{traits}, "['Caching','Replicated']", 'two traits as string';
37 $i = instance(args => [$static]);
38 is $i->create, 'static', 'create=static';
40 $i = instance(args => [$static,
41 q{moniker_map={ authors => "AUTHORS", books => "BOOKS" }}]
43 is_deeply $i->loader_args->{moniker_map},
44 { authors => 'AUTHORS', books => 'BOOKS' },
46 is $i->helper->{loader_args}{moniker_map},
47 q{{authors => "AUTHORS",books => "BOOKS"}},
48 'loader hash arg as string';
50 $i = instance(args => [$static, q{foo=["bar","baz"]}]);
51 is_deeply $i->loader_args->{foo}, ['bar', 'baz'], 'loader array arg';
52 is $i->helper->{loader_args}{foo},
54 'loader array arg as string';
56 $i = instance(args => [$static, q{components=TimeStamp}]);
57 is_deeply $i->components, ['InflateColumn::DateTime', 'TimeStamp'],
59 is $i->helper->{loader_args}{components},
60 q{["InflateColumn::DateTime","TimeStamp"]},
61 'components as string';
64 schema_class => 'ASchemaClass',
65 args => [$static, q{components=TimeStamp}]
67 is_deeply $i->components, ['TimeStamp'],
68 'extra component with ->load_classes';
70 $i = instance(args => [$static, q{components=TimeStamp,Foo}]);
71 is_deeply $i->components, ['InflateColumn::DateTime', 'TimeStamp', 'Foo'],
72 'two extra components';
74 $i = instance(args => [$static, q{constraint=^(foo|bar)$}]);
75 is $i->loader_args->{constraint}, qr/^(foo|bar)$/,
76 'constraint loader arg';
77 is $i->helper->{loader_args}{constraint},
78 q{qr/(?-xism:^(foo|bar)$)/},
79 'constraint loader arg as string';
81 $i = instance(args => [$static, q{exclude=^(foo|bar)$}]);
82 is $i->loader_args->{exclude}, qr/^(foo|bar)$/,
85 $i = instance(args => [$static, q{db_schema=foo;bar::baz/quux}]);
86 is $i->loader_args->{db_schema}, q{foo;bar::baz/quux},
87 'simple value loader arg';
89 $i = instance(args => [
90 $static, 'components=TimeStamp', $sqlite, $on_connect_do,
91 $quote_char, $name_sep
94 is_deeply $i->components, ['InflateColumn::DateTime', 'TimeStamp'],
97 is $i->connect_info->{dsn}, $sqlite, 'connect_info dsn';
98 is $i->connect_info->{user}, '', 'sqlite omitted user';
99 is $i->connect_info->{password}, '', 'sqlite omitted password';
101 is_deeply $i->connect_info->{on_connect_do},
102 ['select 1', 'select 2'], 'connect_info data struct';
104 is $i->helper->{connect_info}{on_connect_do},
105 q{["select 1", "select 2"]}, 'connect_info data struct as string';
107 is $i->connect_info->{quote_char}, '"', 'connect_info quote_char';
109 is $i->helper->{connect_info}{quote_char}, 'q{"}',
110 'connect_info quote_char as string';
112 is $i->connect_info->{name_sep}, '.', 'connect_info name_sep';
114 is $i->helper->{connect_info}{name_sep}, 'q{.}',
115 'connect_info name_sep as string';
117 $i = instance(args => [
118 $static, 'components=TimeStamp', $sqlite, '', $on_connect_do,
119 $quote_char, $name_sep
122 is $i->connect_info->{dsn}, $sqlite, 'connect_info dsn';
123 is $i->connect_info->{user}, '', 'sqlite user';
124 is $i->connect_info->{password}, '', 'sqlite omitted password';
126 $i = instance(args => [
127 $static, 'components=TimeStamp', $pg, 'user', 'pass', $on_connect_do,
128 $quote_char, $name_sep
131 is $i->connect_info->{dsn}, $pg, 'connect_info dsn';
132 is $i->connect_info->{user}, 'user', 'user';
133 is $i->connect_info->{password}, 'pass', 'password';
135 $i = instance(args => [
136 $static, $pg, 'user', 'pass', 'quote_char=[]', $name_sep
139 is_deeply $i->connect_info->{quote_char}, ['[', ']'],
140 '2 character quote_char';
141 is $i->helper->{connect_info}{quote_char}, '["[","]"]',
142 '2 character quote_char as string';
144 $i = instance(args => [
145 $static, 'components=TimeStamp', $sqlite, $on_connect_do,
146 $quote_char, $name_sep, '{ auto_savepoint => 1, AutoCommit => 0 }'
149 is $i->connect_info->{auto_savepoint}, 1, 'connect_info arg from extra hash';
150 is $i->connect_info->{AutoCommit}, 0, 'connect_info arg from extra hash';
151 is $i->helper->{connect_info}{auto_savepoint}, 'q{1}',
152 'connect_info arg from extra hash as string';
153 is $i->helper->{connect_info}{AutoCommit}, 'q{0}',
154 'connect_info arg from extra hash as string';
157 Catalyst::Helper::Model::DBIC::Schema->new(
158 schema_class => 'AnotherSchemaClass',
159 helper => dclone($helper),
160 args => ['create=static'],