[DB-SIG] API suggestion: expose 'quote' method
chris at cogdon.org
Tue Jun 3 19:06:44 EDT 2003
On Tuesday, Jun 3, 2003, at 17:47 US/Pacific, David Rushby wrote:
> "If the DMBS client library is nice enough to supply a quoting function
> (either detecting or not detecting types)"? How would the quoting
> be of any value if it didn't detect types?
What I'm proposing DOES detect types. Ie, it works exactly the same way
the 'execute' function does (on a string-only DBMS), except it returns
the string, rather than passing it to the DBMS.
> Without support from the native database client library, the Python
> would have to fully parse the SQL statement, determine the internal
> types of
> all the fields its parameters refer to (by looking up metadata in the
> tables), and then perform the quoting.
> I say that's well outside "the python driver writer's JOB".
pyPgSQL and pgdb already do quoting, already parse the SQL statement
looking for the %s markers, and already do type detection, all without
support from the database client library.
("`-/")_.-'"``-._ Chris Cogdon <chris at cogdon.org>
. . `; -._ )-;-,_`)
(v_,)' _ )`-.\ ``-'
_.- _..-_/ / ((.'
((,.-' ((,/ fL
More information about the DB-SIG