diff options
| author | Federico Di Gregorio <fog@initd.org> | 2005-10-25 15:35:11 +0000 |
|---|---|---|
| committer | Federico Di Gregorio <fog@initd.org> | 2005-10-25 15:35:11 +0000 |
| commit | ed23aeb37ca705c398078d5a40c1cddd7524811a (patch) | |
| tree | 3f9b89c3624b7138710704cf983cacb4d86a0924 /sandbox/named.py | |
| parent | ef3430d24f3a1580a994e6dec8b5926a752efaed (diff) | |
| download | psycopg2-ed23aeb37ca705c398078d5a40c1cddd7524811a.tar.gz | |
named cursors are working.
Diffstat (limited to 'sandbox/named.py')
| -rw-r--r-- | sandbox/named.py | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/sandbox/named.py b/sandbox/named.py new file mode 100644 index 0000000..d21a0cf --- /dev/null +++ b/sandbox/named.py @@ -0,0 +1,29 @@ +import psycopg2 +import psycopg2.extensions + +class Portal(psycopg2.extensions.cursor): + def __init__(self, name, curs): + name = '"'+name+'"' + psycopg2.extensions.cursor.__init__(self, curs.connection, name) + +CURSOR = psycopg2.extensions.new_type((1790,), "CURSOR", Portal) +psycopg2.extensions.register_type(CURSOR) + +conn = psycopg2.connect("dbname=test") + +curs = conn.cursor() +curs.execute("SELECT reffunc2()") +portal = curs.fetchone()[0] +print portal.fetchone() +portal.scroll(-1) +print portal.fetchall() + + +#print curs.rowcount +#print curs.statusmessage +#print curs.fetchone() +#print curs.rowcount +#print curs.statusmessage +#print curs.fetchone() +#print curs.rowcount +#print curs.statusmessage |