X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FNoBindVars.pm;h=349f658800b98a7554918851e11f86ab425b1ad3;hb=9901aad73ff9dc45b426534fe406c102fb9fb77c;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..349f658 100644 --- a/lib/DBIx/Class/Storage/DBI/NoBindVars.pm +++ b/lib/DBIx/Class/Storage/DBI/NoBindVars.pm @@ -25,7 +25,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 +38,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