I am trying to figure out how to do this in sqlalchemy:
update mailings set sent_ts = now(), is_done=True
from mailing_stats
where
mailings.id = 123
and mailings.id = mailing_stats.mailing_id
and mailings.message_count = mailing_stats.sent_count;
Here are my tables:
mailing_stats = Table('mailing_stats',metadata,
Column('mailing_id', Integer, primary_key=True),
Column('sent_count', Integer),
Column('bounced', Integer)
)
mailings = Table('mailings',metadata,
Column('id', Integer, primary_key=True),
Column('start_ts', DateTime),
Column('finish_ts', DateTime),
Column('is_done', Integer),
Column('message_count',Integer),
)
This is where i've gotten to in the expression language:
up = mailings.update().where(mailings.c.id == 1234).values
({mailings.c.sent_ts:func.now(){)
up = up.where(mailings.c.id == mailing_stats.c.mailing_id)
up = up.where(mailings.c.message_count == mailing_stats.c.sent_count)
This is the error that i get from my postgres db:
missing FROM-clause entry for table mailing_stats
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
