########################################################################
# $Header: /var/local/cvsroot/4Suite/Ft/Lib/DbUtil.py,v 1.5 2005/10/16 20:50:51 jkloth Exp $
"""
Utilities for database connections
Copyright 2005 Fourthought, Inc. (USA).
Detailed license and copyright information: http://4suite.org/COPYRIGHT
Project home, documentation, distributions: http://4suite.org/
"""
__all__ = ['EscapeQuotes']
try:
from EscapeQuotesc import escape
except ImportError:
def EscapeQuotes(qstr):
"""
Postgres uses single quotes for string marker, so put a
backslash before single quotes for insertion into a database.
Also escape backslashes.
pre: qstr = string to be escaped
post: return the string with all single quotes escaped
"""
if qstr is None:
return u''
tmp = qstr.replace("\\","\\\\")
tmp = tmp.replace("'", "\\'")
return unicode(tmp)
|