Postgre requires table names, column names and so on
to be enclosed in double quotes if they contain
capital letters. Otherwise it assumes that they are
all lower-case. In order to be more DBMS-agnostic,
SQLObject should deal with that.
It is possible to do something like:
lastName = StringCol(dbName='"lastName"')
It would be nicer to be able to do this:
lastName = StringCol(dbName='lastName')
The current solution is error-prone. Also, when doing
this, it get's a bit confusing as you have to leave
out the quotes when doing joins:
address = SingleJoin('"Address"')
address = SingleJoin('Address')
as the joins relate to Python objects, not directly to
I have to deal with this, as I am migrating a web-
application from PHP to Python, and the database
already exists and modifying it is not an option.
Log in to post a comment.