Bear with me, this is CentOS related. :)
I have a python CGI that's behaving weirldy on Whitebox systems that've been switched over to CentOS 4 (ages ago, no other problems to speak of aside from this one).
I've broken the problem down to a minimal test case...
1. Create a small database
# sqlite3 /tmp/testcase.db 'CREATE TABLE testtable ( date date primary key unique, name varchar(32));' # sqlite3 /tmp/testcase.db 'insert into "testtable" values("2006-10-10", "Will");' # sqlite3 /tmp/testcase.db 'insert into "testtable" values("2006-10-11", "Will");'
2. A small Python script to query this database:
#!/usr/bin/python
import sqlite
cx = sqlite.connect('/tmp/testcase.db') cu = cx.cursor() cu.execute("select date from %s where date like '%s' ;" % ('testtable', '2006-10-' + "%")) print cu.fetchall() ## -------------------- END SCRIPT -------------------- ##
Now, here's what's confusing me. If I run this on a box that was built from scratch with CentOS I get the following data back...
[root@willspc python]# ./testcase.py [('2006-10-10',), ('2006-10-11',)]
If I run it on any upgraded Whitebox system I get...
[root@devmon1 python]# ./testcase.py [(<DateTime object for '2006-10-10 00:00:00.00' at b7f14138>,), (<DateTime object for '2006-10-11 00:00:00.00' at b7cbfdb0>,)]
As far as I can tell, python, sqlite and python-sqlite are all identical.
[root@willspc python]# rpm -qa | grep -Ei '(sqlite)|(python)' | sort libxml2-python-2.6.16-6 mod_python-3.1.3-5.1 python-2.3.4-14.2 python-elementtree-1.2.6-4.2.1 python-sqlite-1.1.7-1.2 python-urlgrabber-2.9.8-2 rpm-python-4.3.3-18_nonptl sqlite-3.3.3-1.2
On the upgraded system...
[root@devmon1 python]# rpm -qa | grep -Ei '(sqlite)|(python)' | sort libxml2-python-2.6.16-6 mod_python-3.1.3-5.1 MySQL-python-1.0.0-1.RHEL4.1 python-2.3.4-14.2 python-clearsilver-0.10.1-1.2.el4.rf python-elementtree-1.2.6-7.el4.rf python-sqlite-1.1.7-1.2 python-urlgrabber-2.9.8-2 rpm-python-4.3.3-18_nonptl sqlite-3.3.3-1.2 sqlite-devel-3.3.3-1.2
Obviously there some date/time issues but I can't pinpoint exactly what. Can anyone shed any light or prod me in the right direction? The Whitebox systems *do* still have a smattering of Whitebox related RPMs...
[root@devmon1 python]# rpm -qa | grep white rpmdb-whitebox-4-0.20050504 whitebox-logos-1.1.25-1.WB1
That system did have whitebox-lsb installed too but I've rpm -e'd it and replaced redhat-lsb, haven't rebooted yet but that's next on the agenda.
Cheers.
Will.