Hi all

I want to update a table named Space that have a column pages:

class Space(SQLObject):
   ......
   pages = MultipleJoin('Page', orderBy=['type', 'name'])

And there is Page class:
class Page(SQLObject):
   ...
   space = ForeignKey('Space')
   synchronized = BoolCol(default=False)

I need to update all of records'  synchronized attribute to 'True' in
page table where the space.id is 1.

I guessed I may write the code such as:

from sqlobject.sqlbuilder import Update
Update(Page.sqlmeta.table, True, ..., "Space.q.id=1")

But I dont know what is the third parameter, from the source code I
saw template.
What is template?

The document of sqlobject.org does not introduce the class detail of
sqlbuilder and the FAQ just have Delete.


-- 
with kind regards

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to