X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FNoBindVars.pm;h=9f8470263b7c7f2e4ec30b0eabf080cb25f22d84;hb=282a9a4fb1a740c3500c158d7d6ebb29a86f0f78;hp=126b9de2bd28327ee1ceefa19f04626dd7906d54;hpb=e06ad5d5eca3cad12045953e06fd6b6c72c1027d;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/NoBindVars.pm b/lib/DBIx/Class/Storage/DBI/NoBindVars.pm index 126b9de..9f84702 100644 --- a/lib/DBIx/Class/Storage/DBI/NoBindVars.pm +++ b/lib/DBIx/Class/Storage/DBI/NoBindVars.pm @@ -40,11 +40,11 @@ Manually subs in the values for the usual C placeholders. sub _prep_for_execute { my $self = shift; - my ($op, $extra_bind, $ident, $args) = @_; - my ($sql, $bind) = $self->next::method(@_); - # stringify args, quote via $dbh, and manually insert + # stringify bind args, quote via $dbh, and manually insert + #my ($op, $extra_bind, $ident, $args) = @_; + my $ident = $_[2]; my @sql_part = split /\?/, $sql; my $new_sql; @@ -59,11 +59,11 @@ sub _prep_for_execute { foreach my $data (@$bound) { $data = ''.$data if ref $data; - $data = $self->transform_unbound_value($datatype, $data) + $data = $self->_prep_interpolated_value($datatype, $data) if $datatype; $data = $self->_dbh->quote($data) - if (!$datatype || $self->should_quote_value($datatype, $data)); + unless $self->interpolate_unquoted($datatype, $data); $new_sql .= shift(@sql_part) . $data; } @@ -73,39 +73,43 @@ sub _prep_for_execute { return ($new_sql, []); } -=head2 should_quote_value +=head2 interpolate_unquoted This method is called by L for every column in order to determine if its value should be quoted or not. The arguments are the current column data type and the actual bind value. The return -value is interpreted as: true - do quote, false - do not quote. You should +value is interpreted as: true - do not quote, false - do quote. You should override this in you Storage::DBI:: subclass, if your RDBMS does not like quotes around certain datatypes (e.g. Sybase and integer -columns). The default method always returns true (do quote). +columns). The default method always returns false (do quote). - WARNING!!! + WARNING!!! Always validate that the bind-value is valid for the current datatype. Otherwise you may very well open the door to SQL injection attacks. -=cut +=cut -sub should_quote_value { 1 } +sub interpolate_unquoted { + #my ($self, $datatype, $value) = @_; + return 0; +} -=head2 transform_unbound_value +=head2 _prep_interpolated_value Given a datatype and the value to be inserted directly into a SQL query, returns -the necessary SQL fragment to represent that value. +the necessary string to represent that value (by e.g. adding a '$' sign) =cut -sub transform_unbound_value { $_[2] } +sub _prep_interpolated_value { + #my ($self, $datatype, $value) = @_; + return $_[2]; +} =head1 AUTHORS -Brandon Black - -Trym Skaar +See L =head1 LICENSE