Hmm, I seem to be banging my head against the wall here. I’ve been looking at Gadfly, a python database that supports a subset of SQL. I haven’t tested it against other versions of Python on other platforms, but I’m having some issues with it under Python 2.3 on Win32. Here’s a code snippet copied and pasted from the Gadfly documentation:
import gadfly connection = gadfly.gadfly() connection.startup("mydatabase", "./") cursor = connection.cursor() cursor.execute("create table ph (nm varchar, ph varchar)") cursor.execute("insert into ph(nm, ph) values ('arw', '3367')") cursor.execute("select * from ph") for x in cursor.fetchall(): print x # prints ('arw', '3367') connection.commit()
The only problem is, here’s what I get as output:
A simple reversing wouldn’t be too hard to deal with, but in a more complex situation, I had an ID field first that was ending up somewhere in the middle during output. It definately wasn’t the order that I was expecting.
Any thoughts? At first I thought that I was doing something horribly stupid, but I’m supposed to get one answer and I’m getting another! 🙂