From: David G. <dg...@gm...> - 2006-04-01 17:14:26
|
Hi all - Simple question: How do you use sqlobject to delete a record? Thanks! David Geller |
From: inhahe <in...@gm...> - 2008-12-24 14:22:11
|
Hello, can somebody tell me how to delete a record using SQLObject? I don't see it in the documentation. Do I have to use SQL?h |
From: Oleg B. <ph...@ph...> - 2008-12-24 14:29:57
|
On Wed, Dec 24, 2008 at 09:21:12AM -0500, inhahe wrote: > Hello, can somebody tell me how to delete a record using SQLObject? row.destroySelf() table.delete(id) # table is an SQLObject class table.deleteMany(condition) # condition is an SQLBuilder expression Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Oleg B. <ph...@ma...> - 2006-04-01 17:34:02
|
On Sat, Apr 01, 2006 at 12:14:16PM -0500, David Geller wrote: > How do you use sqlobject to delete a record? .destroySelf() Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: sophana <so...@zi...> - 2006-04-02 11:02:30
|
Oleg Broytmann wrote: >On Sat, Apr 01, 2006 at 12:14:16PM -0500, David Geller wrote: > > >>How do you use sqlobject to delete a record? >> >> > > .destroySelf() > >Oleg. > > What about destroying a whole selection at the transaction level (without python iteration)? |
From: Oleg B. <ph...@ma...> - 2006-04-02 11:41:08
|
On Sun, Apr 02, 2006 at 01:03:34PM +0200, sophana wrote: > What about destroying a whole selection at the transaction level > (without python iteration)? from sqlobject.sqlbuilder import Delete connection.query(connection.sqlrepr(Delete(MyTable.sqlmeta.table, MyTable.q.name == "value"))) Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: sophana <so...@zi...> - 2006-04-02 21:36:40
|
Oleg Broytmann wrote: >On Sun, Apr 02, 2006 at 01:03:34PM +0200, sophana wrote: > > >>What about destroying a whole selection at the transaction level >>(without python iteration)? >> >> > >from sqlobject.sqlbuilder import Delete >connection.query(connection.sqlrepr(Delete(MyTable.sqlmeta.table, MyTable.q.name == "value"))) > >Oleg. > > Thanks for your response. Can I just ask another silly question? Where is all this documented? I've been looking on the website, and the sqlbuilder doc is a little bit 'light'. I don't event know what it is for... Maybe I've searched not hard enough... What about a wiki? |
From: Oleg B. <ph...@ma...> - 2006-04-04 07:53:41
|
On Sun, Apr 02, 2006 at 11:37:47PM +0200, sophana wrote: > Can I just ask another silly question? Sure. (-: > Where is all this documented? In the code. > I've been looking on the website, and the > sqlbuilder doc is a little bit 'light'. I don't event know what it is for... It is there for users to extend. It is we, the users, who should write the docs. Nobody will write them for us. > What about a wiki? http://wiki.sqlobject.org Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |