Howdy, I'm trying to execute the following:
nis_accounts_table.update( and_(nis_accounts_table.c.domain_id == 20, nis_users_table.c.id == nis_accounts_table.c.nis_user_id, nis_users_table.c.expires < datetime.today() )).execute(active=False) with PostgreSQL > 8.1 and sqlalchemy 0.4.6 Unforutnately the SQL getting generated is: 'UPDATE nis_accounts SET active=%(active)s WHERE nis_accounts.domain_id = %(domain_id_1)s AND nis_users.id = nis_accounts.nis_user_id AND nis_users.expires < % (expires_1)s' {'active': False, 'expires_1': datetime.datetime(2008, 6, 4, 8, 43, 8, 91895), 'domain_id_1': 20} and PostgreSQL complains about a missing FROM clause for table nis_users. The SQL should be: 'UPDATE nis_accounts SET active=%(active)s FROM nis_users WHERE nis_accounts.domain_id = %(domain_id_1)s AND nis_users.id = nis_accounts.nis_user_id AND nis_users.expires < % (expires_1)s' {'active': False, 'expires_1': datetime.datetime(2008, 6, 4, 8, 43, 8, 91895), 'domain_id_1': 20} It is not clear to me how to get this clause added using SQLA. Do I need to use a raw SQL statement here? Any help will be greatly appreciated. Thanks in advance, Jeff. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---