Thread: [SQLObject] capability for projection and row deletion?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: coriolinus <cor...@gm...> - 2005-11-14 23:26:39
|
I've been looking through the SQLObject documentation, and I can't seem to find any way to accomplish projection. In particular, I'd like to be able to accomplish something like this: prefectures =3D query("select distinct prefecture from users") prefecture =3D chooseFromPrefectures(prefectures) cities =3D query("select distinct city from users where prefecture=3D'"+prefecture"'") city =3D chooseFromCities(cities) usernames =3D query("select username from users where prefecture=3D'"+prefecture+"' and city=3D'"+city+"'") Is there any way of accomplishing this using SQLObject directly? The syntax Users.select(..., distinct=3DTrue) seems to eliminate only tuples where every field matches. My second question has to do with row deletion: it's not clear from the documentation how to remove a row from the table. The only thing I could think of looked like this: temp =3D User.get(4) del(temp) It didn't work. What is the proper syntax? Thanks, -Peter Goodspeed |
From: Oleg B. <ph...@ma...> - 2005-11-15 07:53:59
|
On Tue, Nov 15, 2005 at 08:20:07AM +0900, coriolinus wrote: > My second question has to do with row deletion: it's not clear from > the documentation how to remove a row from the table. The only thing I > could think of looked like this: > > temp = User.get(4) > del(temp) > > It didn't work. What is the proper syntax? temp.destroySelf() Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Jorge G. <go...@ie...> - 2005-11-15 11:04:33
|
Oleg Broytmann <ph...@ma...> writes: > On Tue, Nov 15, 2005 at 08:20:07AM +0900, coriolinus wrote: > > My second question has to do with row deletion: it's not clear from > > the documentation how to remove a row from the table. The only thing I > > could think of looked like this: > > > > temp = User.get(4) > > del(temp) > > > > It didn't work. What is the proper syntax? > > temp.destroySelf() An alternative that saves a select is: User.delete(4) I believe this is desirable in most cases, for saving one operation on the database. Be seeing you, -- Jorge Godoy <go...@ie...> |
From: Oleg B. <ph...@ma...> - 2005-11-16 08:41:33
|
On Tue, Nov 15, 2005 at 08:59:27AM -0200, Jorge Godoy wrote: > > temp.destroySelf() > > An alternative that saves a select is: > > User.delete(4) > > I believe this is desirable in most cases, for saving one operation on the > database. Please look at the .delete() implementation! Do you still belive it saves an operation?! ;) Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |