diff options
author | Federico Di Gregorio <fog@initd.org> | 2005-06-13 06:25:06 +0000 |
---|---|---|
committer | Federico Di Gregorio <fog@initd.org> | 2005-06-13 06:25:06 +0000 |
commit | 9c284f457042cad50beb5730ac7f8c4a36eacae2 (patch) | |
tree | 7edea4fb77fc0986e89d408ed37085e60a357691 /examples/encoding.py | |
parent | 0c56bc95df1cb34343e1866cf2a671c61076cb81 (diff) | |
download | psycopg2-9c284f457042cad50beb5730ac7f8c4a36eacae2.tar.gz |
psycopg->psycopg2 switch in the examples.
Diffstat (limited to 'examples/encoding.py')
-rw-r--r-- | examples/encoding.py | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/examples/encoding.py b/examples/encoding.py index 1506252..d29a050 100644 --- a/examples/encoding.py +++ b/examples/encoding.py @@ -19,63 +19,63 @@ DSN = 'dbname=test' ## don't modify anything below this line (except for experimenting) -import sys, psycopg +import sys, psycopg2 import psycopg.extensions if len(sys.argv) > 1: DSN = sys.argv[1] print "Opening connection using dns:", DSN -conn = psycopg.connect(DSN) +conn = psycopg2.connect(DSN) print "Initial encoding for this connection is", conn.encoding print "\n** This example is supposed to be run in a UNICODE terminal! **\n" print "Available encodings:" -for a, b in psycopg.extensions.encodings.items(): +for a, b in psycopg2.extensions.encodings.items(): print " ", a, "<->", b print "Using STRING typecaster" print "Setting backend encoding to LATIN1 and executing queries:" conn.set_client_encoding('LATIN1') curs = conn.cursor() -curs.execute("SELECT %s::TEXT AS foo", ('àèìòù',)) +curs.execute("SELECT %s::TEXT AS foo", ('�����',)) x = curs.fetchone()[0] print " ->", unicode(x, 'latin-1').encode('utf-8'), type(x) -curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù',)) +curs.execute("SELECT %s::TEXT AS foo", (u'�����',)) x = curs.fetchone()[0] print " ->", unicode(x, 'latin-1').encode('utf-8'), type(x) print "Setting backend encoding to UTF8 and executing queries:" conn.set_client_encoding('UNICODE') curs = conn.cursor() -curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù'.encode('utf-8'),)) +curs.execute("SELECT %s::TEXT AS foo", (u'�����'.encode('utf-8'),)) x = curs.fetchone()[0] print " ->", x, type(x) -curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù',)) +curs.execute("SELECT %s::TEXT AS foo", (u'�����',)) x = curs.fetchone()[0] print " ->", x, type(x) print "Using UNICODE typecaster" -psycopg.extensions.register_type(psycopg.extensions.UNICODE) +psycopg2.extensions.register_type(psycopg2.extensions.UNICODE) print "Setting backend encoding to LATIN1 and executing queries:" conn.set_client_encoding('LATIN1') curs = conn.cursor() -curs.execute("SELECT %s::TEXT AS foo", ('àèìòù',)) +curs.execute("SELECT %s::TEXT AS foo", ('�����',)) x = curs.fetchone()[0] print " ->", x.encode('utf-8'), ":", type(x) -curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù',)) +curs.execute("SELECT %s::TEXT AS foo", (u'�����',)) x = curs.fetchone()[0] print " ->", x.encode('utf-8'), ":", type(x) print "Setting backend encoding to UTF8 and executing queries:" conn.set_client_encoding('UNICODE') curs = conn.cursor() -curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù'.encode('utf-8'),)) +curs.execute("SELECT %s::TEXT AS foo", (u'�����'.encode('utf-8'),)) x = curs.fetchone()[0] print " ->", x.encode('utf-8'), ":", type(x) -curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù',)) +curs.execute("SELECT %s::TEXT AS foo", (u'�����',)) x = curs.fetchone()[0] print " ->", x.encode('utf-8'), ":", type(x) @@ -84,19 +84,19 @@ print "Executing full UNICODE queries" print "Setting backend encoding to LATIN1 and executing queries:" conn.set_client_encoding('LATIN1') curs = conn.cursor() -curs.execute(u"SELECT %s::TEXT AS foo", ('àèìòù',)) +curs.execute(u"SELECT %s::TEXT AS foo", ('�����',)) x = curs.fetchone()[0] print " ->", x.encode('utf-8'), ":", type(x) -curs.execute(u"SELECT %s::TEXT AS foo", (u'àèìòù',)) +curs.execute(u"SELECT %s::TEXT AS foo", (u'�����',)) x = curs.fetchone()[0] print " ->", x.encode('utf-8'), ":", type(x) print "Setting backend encoding to UTF8 and executing queries:" conn.set_client_encoding('UNICODE') curs = conn.cursor() -curs.execute(u"SELECT %s::TEXT AS foo", (u'àèìòù'.encode('utf-8'),)) +curs.execute(u"SELECT %s::TEXT AS foo", (u'�����'.encode('utf-8'),)) x = curs.fetchone()[0] print " ->", x.encode('utf-8'), ":", type(x) -curs.execute(u"SELECT %s::TEXT AS foo", (u'àèìòù',)) +curs.execute(u"SELECT %s::TEXT AS foo", (u'�����',)) x = curs.fetchone()[0] print " ->", x.encode('utf-8'), ":", type(x) |