|
From: SourceForge.net <no...@so...> - 2006-08-16 07:19:50
|
Bugs item #1541095, was opened at 2006-08-16 09:19 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1541095&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Postgres Group: SQLObject release (specify) Status: Open Resolution: None Priority: 5 Submitted By: Michel Albert (exhuma) Assigned to: Nobody/Anonymous (nobody) Summary: Capital letters in table/column names Initial Comment: 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: wrong: address = SingleJoin('"Address"') correct: address = SingleJoin('Address') as the joins relate to Python objects, not directly to tables. 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. Best regards, Michel Albert ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1541095&group_id=74338 |
