- Download pyPgSQL from the following website:
http://sourceforge.net/projects/mysql-python/?source=recommended
- Extract it into a file, and Install at current path:
$ sudo python setup.py install
- A nice introduction of twisted.internet.defer
http://ezyang.com/twisted/
- Test procedure:
I am first trying to still use the old API but with non-blocking mode.
cp = adbapi.ConnectionPool("pg", dbname="mydb", host="143.89.46.81",user="
dbcreator",passwd="nifti")
cp .connect()
self.conn=cp.connect()
self.conn=adbapi.
ConnectionPool("pg", dbname="mydb", host="143.89.46.81",user="
dbcreator",passwd="nifti")
self.conn.connect()
self.conn.query => self.conn.runQuery("SELECT age FROM users WHERE name = ?", user)
cp = adbapi.ConnectionPool("pg", dbname="mydb", host="143.89.46.81",user="
dbcreator",passwd="nifti")
c=cp.connect()
c.query()
cp.runQuery()
\lo_list
- PROBLEM: how to use pypgsql to operate large object!
TRIES:
you need to check how to use large object in PypgSQL,
search for "large".
you will get to the api,
then change all related APIs in topicdb_twist.py.
(the function names are the APIs.)
STILL NOT SOLVED:
"to implement the large object operation with postgresql under pypgsql."