Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBIx::Class::Storage::User:ContributedDPIx::Class::Storage::DBI::NoBindVars(3)

NAME
       DBIx::Class::Storage::DBI::NoBindVars - Sometime	DBDs have poor to no
       support for bind	variables

DESCRIPTION
       This class allows queries to work when the DBD or underlying library
       does not	support	the usual "?" placeholders, or at least	doesn't
       support them very well, as is the case with DBD::Sybase

METHODS
   connect_info
       We can't	cache very effectively without bind variables, so force	the
       "disable_sth_caching" setting to	be turned on when the connect info is
       set.

   _prep_for_execute
       Manually	subs in	the values for the usual "?" placeholders.

   interpolate_unquoted
       This method is called by	"_prep_for_execute" 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 not quote, false - do	quote. You
       should override this in you Storage::DBI::<database> subclass, if your
       RDBMS does not like quotes around certain datatypes (e.g. Sybase	and
       integer columns). The default method returns false, except for integer
       datatypes paired	with values containing nothing but digits.

	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.

   _prep_interpolated_value
       Given a datatype	and the	value to be inserted directly into a SQL
       query, returns the necessary string to represent	that value (by e.g.
       adding a	'$' sign)

FURTHER	QUESTIONS?
       Check the list of additional DBIC resources.

COPYRIGHT AND LICENSE
       This module is free software copyright by the DBIx::Class (DBIC)
       authors.	You can	redistribute it	and/or modify it under the same	terms
       as the DBIx::Class library.

perl v5.32.1			  2020DBIx::Class::Storage::DBI::NoBindVars(3)

NAME | DESCRIPTION | METHODS | FURTHER QUESTIONS? | COPYRIGHT AND LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DBIx::Class::Storage::DBI::NoBindVars&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help