On Wed, Jun 10, 2009 at 06:06:16PM -0700, Sam's Lists wrote:
> class sqlmeta:
> style = MixedCaseStyle(longID=True)
>
> It appears that under the really old versions of TurboGears one could
> refer to this EventQueueID as just .id and everything would work the
> way you want it to. (This appears to only be done in the app under
> kid templates).
>
> But now, under TG 1.0.8/the latest version of SQLObject that doesn't work.
> Either I have to rename the
> column to id or I have to refer to it as EventQueueID.
Well, you can always give the name of the column:
class MyTable(SQLObject):
class sqlmeta:
style = MixedCaseStyle(longID=True)
idName = 'id' # or 'MyTableID' or whatever.
> How can I make sqlObject seemlessly let me refer to columns named in
> the long style just using id?
class Test(SQLObject):
class sqlmeta:
style = MixedCaseStyle(longID=True)
Test.createTable()
test = Test()
print test.id
Output (SQLObject 0.10):
1/Query : CREATE TABLE Test (
id INTEGER PRIMARY KEY
)
1/QueryR : CREATE TABLE Test (
id INTEGER PRIMARY KEY
)
1/Query : CREATE TABLE Test (
id INTEGER PRIMARY KEY
)
1/QueryR : CREATE TABLE Test (
id INTEGER PRIMARY KEY
)
2/QueryIns: INSERT INTO Test VALUES (NULL)
2/QueryR : INSERT INTO Test VALUES (NULL)
3/QueryOne: SELECT NULL FROM Test WHERE ((Test.id) = (1))
3/QueryR : SELECT NULL FROM Test WHERE ((Test.id) = (1))
1/Query : CREATE TABLE Test (
id INTEGER PRIMARY KEY
)
1/QueryR : CREATE TABLE Test (
id INTEGER PRIMARY KEY
)
2/QueryIns: INSERT INTO Test VALUES (NULL)
2/QueryR : INSERT INTO Test VALUES (NULL)
3/QueryOne: SELECT NULL FROM Test WHERE ((Test.id) = (1))
3/QueryR : SELECT NULL FROM Test WHERE ((Test.id) = (1))
No problem so far - id is id, not TestId. What am I doing wrong?
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
