[SQLObject] Select queries based on "virtual" columns?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Dominic L. <dom...@gm...> - 2010-08-07 02:57:39
|
Hello, Is it possible to create a "virtual" column in SQLObject? To give you an example of what I mean by a virtual column, given a table named "agtAgent" with a StringCol() named "name", and two IntCol()'s named "level" and "quality", consider this SQL statement: select name, level, quality, (((level -1)*2) + (quality/20)) as reqStanding from agtAgent where reqStanding > %i Is it possible to do something like this in SQLObject without having to drop down to writing the sql queries manually? -- Dominic LoBue |