On Fri, Mar 10, 2006 at 04:16:06PM +0100, Fran?ois Heredero - Top Music SA
wrote:
> class Order(SQLObject):
> class sqlmeta:
> idName = "order_no"
> defaultOrder = "date"
> date = DateTimeCol(default=datetime.datetime.now())
> ...
> lines = MultipleJoin('OrderLines', joinColumn="order_no")
>
> class OrderLines(SQLObject):
> class sqlmeta:
> idName = "line_no"
> order = ForeignKey('Order', dbName='order_no')
> ...
>
> I want to delete (or select) all 'Order's without 'OrderLines' using
> sqlobject (and no direct sql). It's possible ?
for order in Order.select():
if not order.lines:
order.destroySelf()
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
