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