Hi,

I have some problem understanding this error.  From googling around,
this is about modifying data on more than 1 table, so the ORM wouldn't
do it.  However, my query is

self.session.query(e).filter(e.src_id == src_id).filter(e.tar_id ==
tar_id).update({e.status: self._DELETE})

and it only involve 1 table.  From debug, without the update part, the
select is translated to

SELECT events_1.event_id AS events_1_event_id, events_1.src_id AS
events_1_src_id, events_1.tar_id AS events_1_tar_id, events_1.type AS
events_1_type, events_1.event_ts AS events_1_event_ts, events_1.status
AS events_1_status, events_1.media_id AS events_1_media_id FROM events
AS events_1 WHERE events_1.src_id = :src_id_1 AND events_1.tar_id
= :tar_id_1

It looks very simple, what am I missing?

Thanks,
Mason

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to