Commit | Line | Data |
3885cff6 |
1 | package DBIx::Class::Storage::DBI::NoBindVars; |
2 | |
3 | use strict; |
4 | use warnings; |
5 | |
6 | use base 'DBIx::Class::Storage::DBI'; |
7 | |
b43345f2 |
8 | =head1 NAME |
9 | |
10 | DBIx::Class::Storage::DBI::NoBindVars - Sometime DBDs have poor to no support for bind variables |
11 | |
12 | =head1 DESCRIPTION |
13 | |
14 | This class allows queries to work when the DBD or underlying library does not |
15 | support the usual C<?> placeholders, or at least doesn't support them very |
16 | well, as is the case with L<DBD::Sybase> |
17 | |
18 | =head1 METHODS |
19 | |
b33697ef |
20 | =head2 connect_info |
b43345f2 |
21 | |
b33697ef |
22 | We can't cache very effectively without bind variables, so force the C<disable_sth_caching> setting to be turned on when the connect info is set. |
b43345f2 |
23 | |
24 | =cut |
25 | |
b33697ef |
26 | sub connect_info { |
27 | my $self = shift; |
d944c5ae |
28 | my $retval = $self->next::method(@_); |
b33697ef |
29 | $self->disable_sth_caching(1); |
30 | $retval; |
b43345f2 |
31 | } |
32 | |
d5130dd2 |
33 | =head2 _prep_for_execute |
b43345f2 |
34 | |
d5130dd2 |
35 | Manually subs in the values for the usual C<?> placeholders. |
b43345f2 |
36 | |
37 | =cut |
38 | |
d5130dd2 |
39 | sub _prep_for_execute { |
40 | my $self = shift; |
b50a5275 |
41 | |
42 | my ($op, $extra_bind, $ident) = @_; |
43 | |
d944c5ae |
44 | my ($sql, $bind) = $self->next::method(@_); |
45 | |
46 | # stringify args, quote via $dbh, and manually insert |
47 | |
b4474f31 |
48 | my @sql_part = split /\?/, $sql; |
49 | my $new_sql; |
50 | |
d944c5ae |
51 | foreach my $bound (@$bind) { |
b50a5275 |
52 | my $col = shift @$bound; |
53 | my $do_quote = $self->should_quote_data_type($col); |
d944c5ae |
54 | foreach my $data (@$bound) { |
55 | if(ref $data) { |
56 | $data = ''.$data; |
57 | } |
b50a5275 |
58 | $data = $self->_dbh->quote($data) if $do_quote; |
59 | $new_sql .= shift(@sql_part) . $data; |
d944c5ae |
60 | } |
61 | } |
b4474f31 |
62 | $new_sql .= join '', @sql_part; |
d5130dd2 |
63 | |
b4474f31 |
64 | return ($new_sql); |
3885cff6 |
65 | } |
66 | |
b50a5275 |
67 | sub should_quote_data_type { 1 } |
68 | |
3885cff6 |
69 | =head1 AUTHORS |
70 | |
71 | Brandon Black <blblack@gmail.com> |
b43345f2 |
72 | |
7762b22c |
73 | Trym Skaar <trym@tryms.no> |
3885cff6 |
74 | |
75 | =head1 LICENSE |
76 | |
77 | You may distribute this code under the same terms as Perl itself. |
78 | |
79 | =cut |
b43345f2 |
80 | |
81 | 1; |