Database bind variables?
Rene Pijlman
reply.in.the.newsgroup at my.address.is.invalid
Sat Nov 22 04:30:09 EST 2003
Andrew Fabbro:
>Python + Postgres. Finding good documentation on working with
>databases in python is proving more challenging than writing the code
After scanning this newsgroup and other sources I decided to use the
pyPgSQL database driver, instead of PyGreSQL in the PostgreSQL
distribution (DaMn CaPS). It appears to be better maintained.
http://pypgsql.sourceforge.net/
It supports DBAPI.
http://www.python.org/peps/pep-0249.html
With some additional notes in the README:
http://pypgsql.sourceforge.net/README.html
This is all the documentation I've needed so far.
[parameters]
>I haven't found a way to do this yet with pygresql
With pyPgSQL / DB-API it works like this.
from pyPgSQL import PgSQL
assert PgSQL.paramstyle == "pyformat"
db = PgSQL.connect(host=DB_HOST, database=DB_DATABASE,
user=DB_USERNAME, password=DB_PASSWORD,
# Enable Unicode support, which you may not need.
client_encoding="utf-8", unicode_results=1)
cursor.execute("set client_encoding to unicode")
get_cities = db.cursor()
def getCitiesInCountry(language, country):
get_cities.execute("select name, name_in_url, index "
"from location "
"where location.country = %(country)s and "
"location.location_type = 'cities' and "
"location.language = %(language)s "
"order by location.index",
{'language': language, 'country': country} )
# [...]
--
René Pijlman
More information about the Python-list
mailing list