Hello Oleg,
It doesn't worked for me:
Please, consider the following scenario:
class DBObject(InheritableSQLObject):
title = UnicodeCol(length=100, default="")
class DBItem(DBObject, InheritableSQLObject):
local_path = UnicodeCol(length=1000, default="")
If I do:
DBItem.deleteMany(LIKE(DBItem.q.local_path, local_path + "%"))
... SQLObject deletes from db_item table but maintains the correspondent
item in db_object
I then tried:
DBObject.deleteMany(LIKE(DBItem.q.local_path, local_path + "%"))
... SQLObject returned an error telling "unknown column:
db_item.local_path"
So, I tried this:
DBObject.deleteMany(LIKE(DBItem.q.local_path, local_path + "%"),
clauseTables=['db_item'])
... and it returns an error: "got an unexpected paramater clauseTables".
So, what am I doing wrong? Thank you so much,
Leandro.
2007/12/13, Oleg Broytmann <[EMAIL PROTECTED]>:
>
> On Wed, Dec 12, 2007 at 07:11:56PM -0300, Leandro Sales wrote:
> > DELETE FROM db_item WHERE db_item.local_path LIKE ' " + local_path + "%'
> "
>
> from sqlobject.sqlbuilder import LIKE
> DBItem.deleteMany(LIKE(DBItem.q.local_path, '...'))
>
> Oleg.
> --
> Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
> Programmers don't die, they just GOSUB without RETURN.
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
--
Leandro Melo de Sales.
Pervasive and Embedded Computing Laboratory
BRisa and E-Phone Projects Manager
Network Admin @ http://embedded.ufcg.edu.br/indexen.html
+55 83 3310-1404 (extension 208)
O especialista é alguém que conhece sempre mais sobre cada vez menos e
termina por saber tudo sobre nada!
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
