Commit | Line | Data |
70350518 |
1 | use strict; |
55087b99 |
2 | use warnings; |
e59c17fe |
3 | |
70350518 |
4 | use Test::More; |
d38cd95c |
5 | use Test::Warn; |
70350518 |
6 | use lib qw(t/lib); |
7 | use DBICTest; |
5cfb131d |
8 | use DBIC::DebugObj; |
e59c17fe |
9 | |
72ae8e40 |
10 | { |
11 | package A::Comp; |
12 | use base 'DBIx::Class'; |
13 | sub store_column { shift->next::method (@_) }; |
14 | 1; |
15 | } |
16 | |
17 | { |
18 | package A::SubComp; |
19 | use base 'A::Comp'; |
1415f198 |
20 | |
72ae8e40 |
21 | 1; |
22 | } |
7146f619 |
23 | |
72ae8e40 |
24 | warnings_are ( |
25 | sub { |
3c2a505c |
26 | local $ENV{DBIC_UTF8COLUMNS_OK} = 1; |
1415f198 |
27 | package A::Test1; |
72ae8e40 |
28 | use base 'DBIx::Class::Core'; |
29 | __PACKAGE__->load_components(qw(Core +A::Comp Ordered UTF8Columns)); |
1415f198 |
30 | __PACKAGE__->load_components(qw(Ordered +A::SubComp Row UTF8Columns Core)); |
31 | sub store_column { shift->next::method (@_) }; |
72ae8e40 |
32 | 1; |
33 | }, |
34 | [], |
35 | 'no spurious warnings issued', |
36 | ); |
37 | |
70c28808 |
38 | warnings_like ( |
39 | sub { |
40 | package A::Test1Loud; |
41 | use base 'DBIx::Class::Core'; |
42 | __PACKAGE__->load_components(qw(Core +A::Comp Ordered UTF8Columns)); |
43 | __PACKAGE__->load_components(qw(Ordered +A::SubComp Row UTF8Columns Core)); |
44 | sub store_column { shift->next::method (@_) }; |
45 | 1; |
46 | }, |
47 | [qr/Use of DBIx::Class::UTF8Columns is strongly discouraged/], |
48 | 'issued deprecation warning', |
49 | ); |
50 | |
51 | |
1415f198 |
52 | my $test1_mro; |
72ae8e40 |
53 | my $idx = 0; |
1415f198 |
54 | for (@{mro::get_linear_isa ('A::Test1')} ) { |
55 | $test1_mro->{$_} = $idx++; |
72ae8e40 |
56 | } |
57 | |
1415f198 |
58 | cmp_ok ($test1_mro->{'A::SubComp'}, '<', $test1_mro->{'A::Comp'}, 'mro of Test1 correct (A::SubComp before A::Comp)' ); |
59 | cmp_ok ($test1_mro->{'A::Comp'}, '<', $test1_mro->{'DBIx::Class::UTF8Columns'}, 'mro of Test1 correct (A::Comp before UTF8Col)' ); |
60 | cmp_ok ($test1_mro->{'DBIx::Class::UTF8Columns'}, '<', $test1_mro->{'DBIx::Class::Core'}, 'mro of Test1 correct (UTF8Col before Core)' ); |
61 | cmp_ok ($test1_mro->{'DBIx::Class::Core'}, '<', $test1_mro->{'DBIx::Class::Row'}, 'mro of Test1 correct (Core before Row)' ); |
62 | |
1415f198 |
63 | warnings_like ( |
64 | sub { |
65 | package A::Test2; |
66 | use base 'DBIx::Class::Core'; |
67 | __PACKAGE__->load_components(qw(UTF8Columns +A::Comp)); |
68 | sub store_column { shift->next::method (@_) }; |
69 | 1; |
70 | }, |
71 | [qr/Incorrect loading order of DBIx::Class::UTF8Columns.+affect other components overriding 'store_column' \(A::Comp\)/], |
72 | 'incorrect order warning issued (violator defines)', |
73 | ); |
74 | |
75 | warnings_like ( |
76 | sub { |
77 | package A::Test3; |
78 | use base 'DBIx::Class::Core'; |
79 | __PACKAGE__->load_components(qw(UTF8Columns +A::SubComp)); |
80 | sub store_column { shift->next::method (@_) }; |
81 | 1; |
82 | }, |
83 | [qr/Incorrect loading order of DBIx::Class::UTF8Columns.+affect other components overriding 'store_column' \(A::SubComp \(via A::Comp\)\)/], |
84 | 'incorrect order warning issued (violator inherits)', |
85 | ); |
72ae8e40 |
86 | |
a47e1233 |
87 | my $schema = DBICTest->init_schema(); |
404939a4 |
88 | DBICTest::Schema::CD->load_components('UTF8Columns'); |
89 | DBICTest::Schema::CD->utf8_columns('title'); |
70350518 |
90 | Class::C3->reinitialize(); |
91 | |
fed2c7d7 |
92 | # as per http://search.cpan.org/dist/Test-Simple/lib/Test/More.pm#utf8 |
93 | binmode (Test::More->builder->$_, ':utf8') for qw/output failure_output todo_output/; |
cdd254a5 |
94 | |
95 | my $bytestream_title = my $utf8_title = "weird \x{466} stuff"; |
96 | utf8::encode($bytestream_title); |
97 | cmp_ok ($bytestream_title, 'ne', $utf8_title, 'unicode/raw differ (sanity check)'); |
98 | |
99 | my $storage = $schema->storage; |
5cfb131d |
100 | my ($sql, @bind); |
101 | my $debugobj = DBIC::DebugObj->new (\$sql, \@bind); |
102 | my ($orig_debug, $orig_debugobj) = ($storage->debug, $storage->debugobj); |
103 | $storage->debugobj ($debugobj); |
cdd254a5 |
104 | $storage->debug (1); |
337c98ef |
105 | |
cdd254a5 |
106 | my $cd = $schema->resultset('CD')->create( { artist => 1, title => $utf8_title, year => '2048' } ); |
1d0057bd |
107 | |
5cfb131d |
108 | $storage->debugobj ($orig_debugobj); |
109 | $storage->debug ($orig_debug); |
110 | |
111 | # bind values are always alphabetically ordered by column, thus [1] |
112 | # the single quotes are an artefact of the debug-system |
cdd254a5 |
113 | TODO: { |
114 | local $TODO = "This has been broken since rev 1191, Mar 2006"; |
5cfb131d |
115 | is ($bind[1], "'$bytestream_title'", 'INSERT: raw bytes sent to the database'); |
cdd254a5 |
116 | } |
117 | |
118 | # this should be using the cursor directly, no inflation/processing of any sort |
119 | my ($raw_db_title) = $schema->resultset('CD') |
120 | ->search ($cd->ident_condition) |
121 | ->get_column('title') |
122 | ->_resultset |
123 | ->cursor |
124 | ->next; |
125 | |
126 | is ($raw_db_title, $bytestream_title, 'INSERT: raw bytes retrieved from database'); |
127 | |
128 | for my $reloaded (0, 1) { |
129 | my $test = $reloaded ? 'reloaded' : 'stored'; |
130 | $cd->discard_changes if $reloaded; |
1d0057bd |
131 | |
cdd254a5 |
132 | ok( utf8::is_utf8( $cd->title ), "got $test title with utf8 flag" ); |
133 | ok(! utf8::is_utf8( $cd->{_column_data}{title} ), "in-object $test title without utf8" ); |
134 | |
135 | ok(! utf8::is_utf8( $cd->year ), "got $test year without utf8 flag" ); |
136 | ok(! utf8::is_utf8( $cd->{_column_data}{year} ), "in-object $test year without utf8" ); |
137 | } |
138 | |
139 | $cd->title('nonunicode'); |
140 | ok(! utf8::is_utf8( $cd->title ), 'update title without utf8 flag' ); |
141 | ok(! utf8::is_utf8( $cd->{_column_data}{title} ), 'store utf8-less title' ); |
142 | |
143 | $cd->update; |
144 | $cd->discard_changes; |
145 | ok(! utf8::is_utf8( $cd->title ), 'reloaded title without utf8 flag' ); |
146 | ok(! utf8::is_utf8( $cd->{_column_data}{title} ), 'reloaded utf8-less title' ); |
147 | |
148 | $bytestream_title = $utf8_title = "something \x{219} else"; |
149 | utf8::encode($bytestream_title); |
150 | |
5cfb131d |
151 | |
152 | $storage->debugobj ($debugobj); |
153 | $storage->debug (1); |
154 | |
cdd254a5 |
155 | $cd->update ({ title => $utf8_title }); |
5cfb131d |
156 | |
157 | $storage->debugobj ($orig_debugobj); |
158 | $storage->debug ($orig_debug); |
159 | |
160 | is ($bind[0], "'$bytestream_title'", 'UPDATE: raw bytes sent to the database'); |
cdd254a5 |
161 | ($raw_db_title) = $schema->resultset('CD') |
162 | ->search ($cd->ident_condition) |
163 | ->get_column('title') |
164 | ->_resultset |
165 | ->cursor |
166 | ->next; |
167 | is ($raw_db_title, $bytestream_title, 'UPDATE: raw bytes retrieved from database'); |
168 | |
169 | $cd->discard_changes; |
170 | $cd->title($utf8_title); |
1d0057bd |
171 | ok( !$cd->is_column_changed('title'), 'column is not dirty after setting the same unicode value' ); |
172 | |
cdd254a5 |
173 | $cd->update ({ title => $utf8_title }); |
1d0057bd |
174 | $cd->title('something_else'); |
175 | ok( $cd->is_column_changed('title'), 'column is dirty after setting to something completely different'); |
db087eb1 |
176 | |
177 | TODO: { |
178 | local $TODO = 'There is currently no way to propagate aliases to inflate_result()'; |
cdd254a5 |
179 | $cd = $schema->resultset('CD')->find ({ title => $utf8_title }, { select => 'title', as => 'name' }); |
55087b99 |
180 | ok (utf8::is_utf8( $cd->get_column ('name') ), 'utf8 flag propagates via as'); |
db087eb1 |
181 | } |
182 | |
55087b99 |
183 | done_testing; |