diff options
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 |