Hi,
I am in the process of creating a small script for filling the
sqlite3 database with data from rather large XML-RPC query (list
of many bugs from the Red Hat Bugzilla) and I would love to use
adaptors and converters for some data types which I am missing.
I have this test script (made hopefully pretty faithfully from the
documentation):
#!/usr/bin/python
import sqlite3
def adapt_boolean(bol):
if bol:
return "True"
else:
return "False"
def convert_boolean(bolStr):
if str(bolStr) == "True":
return bool(True)
elif str(bolStr) == "False":
return bool(False)
else:
raise ValueError, "Unknown value of bool attribute '%s'" \
% bolStr
sqlite3.register_adapter(bool,adapt_boolean)
sqlite3.register_converter("boolean",convert_boolean)
db = sqlite3.connect("test.db")
cur=db.cursor()
cur.execute("create table test(p boolean)")
p=False
cur.execute("insert into test(p) values (?)", (p,))
p=True
cur.execute("insert into test(p) values (?)", (p,))
cur.execute("select p from test")
print cur.fetchall()
And I would expect to print on output representation of bool values, i.e.,
something like
[False,True]
However, when running this program it seems converter doesn’t seem to work,
because I get:
[EMAIL PROTECTED] dumpBugzilla]$ rm test.db ; python testAdaptors.py
[(u'False',), (u'True',)]
[EMAIL PROTECTED] dumpBugzilla]$
There is probably something quite obvious what I do incorrectly, but I just
don't see it. Could somebody kick me in the right direction, please?
Thanks a lot,
Matěj Cepl
--
http://mail.python.org/mailman/listinfo/python-list
