diff options
Diffstat (limited to 'sandbox/named.py')
-rw-r--r-- | sandbox/named.py | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/sandbox/named.py b/sandbox/named.py deleted file mode 100644 index 4780a24..0000000 --- a/sandbox/named.py +++ /dev/null @@ -1,31 +0,0 @@ -import psycopg2 -import psycopg2.extensions - -class Portal(psycopg2.extensions.cursor): - def __init__(self, name, curs): - 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()) -print(portal.fetchmany(2)) -portal.scroll(0, 'absolute') -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 |