X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FNoBindVars.pm;h=95f1cac94222b9df12a10dc429e7ae156c701326;hb=f66e15f39f65384d95c4a254b9aefe14f32e49e3;hp=2877ee270b41d4afac88389bceb1be5615890c14;hpb=672c8df5fcf20b4c0894ccd3763702522a9f829d;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/NoBindVars.pm b/lib/DBIx/Class/Storage/DBI/NoBindVars.pm index 2877ee2..95f1cac 100644 --- a/lib/DBIx/Class/Storage/DBI/NoBindVars.pm +++ b/lib/DBIx/Class/Storage/DBI/NoBindVars.pm @@ -4,6 +4,7 @@ use strict; use warnings; use base 'DBIx::Class::Storage::DBI'; +use mro 'c3'; =head1 NAME @@ -25,7 +26,7 @@ We can't cache very effectively without bind variables, so force the Cnext::method(@_); + my $retval = $self->next::method(@_); $self->disable_sth_caching(1); $retval; } @@ -38,11 +39,30 @@ Manually subs in the values for the usual C placeholders. sub _prep_for_execute { my $self = shift; - my ($sql, @bind) = $self->next::method(@_); - $sql =~ s/\?/$self->_dbh->quote(shift(@bind))/eg; + my ($op, $extra_bind, $ident) = @_; - return ($sql); + my ($sql, $bind) = $self->next::method(@_); + + # stringify args, quote via $dbh, and manually insert + + my @sql_part = split /\?/, $sql; + my $new_sql; + + foreach my $bound (@$bind) { + my $col = shift @$bound; + my $datatype = 'FIXME!!!'; + foreach my $data (@$bound) { + if(ref $data) { + $data = ''.$data; + } + $data = $self->_dbh->quote($data); + $new_sql .= shift(@sql_part) . $data; + } + } + $new_sql .= join '', @sql_part; + + return ($new_sql, []); } =head1 AUTHORS