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,


2007/12/13, Oleg Broytmann < phd@phd.pp.ru>:
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 Broytmann            http://phd.pp.ru/            phd@phd.pp.ru
           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.
sqlobject-discuss mailing list

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!