Something like this perhaps? (untested)
def getwhereclause(table, filters):
conditions = []
for colname, value in filters.items():
column = table.c[colname]
conditions.append(column == value)
return sqlalchemy.and_(conditions)
whereclause = getwhereclause(table, filters)
statement=table.update().where(whereclause).values(**datum).returning(table.c.rowid)
Hope that helps,
Simon
On Tue, Nov 26, 2019 at 12:23 PM Javier Collado Jiménez
<[email protected]> wrote:
>
> Is there an easy way to construct the where clause for update with a
> dictionary?
> I'm trying
>
> statement=table.update().where(**filters).values(**datum).returning(table.c.rowid)
>
> but it doesn't work.
>
> Thank you!!
>
> El miércoles, 20 de noviembre de 2019, 16:39:36 (UTC+1), Mike Bayer escribió:
>>
>>
>>
>> On Wed, Nov 20, 2019, at 9:05 AM, Javier Collado Jiménez wrote:
>>
>> Hello,
>>
>> Using ORM, i'm inserting like that:
>>
>> session.add(table_mapper(**datum))
>>
>> And updating:
>>
>> session.query(dest_table).filter_by(**filters).filter(filter_column >
>> from_date).update(datum, synchronize_session=False)
>>
>>
>> Is there a way to get returning rowid of the rows affected.
>>
>> I want to keep them to be used in further updates (it's really faster if you
>> use rowid in UPDATE WHERE clause)
>>
>>
>> you would need to construct a core UPDATE statement adding this column using
>> returning() (see
>> https://docs.sqlalchemy.org/en/13/core/dml.html?highlight=returning#sqlalchemy.sql.expression.Update.returning
>> ). You might want to add it to your table definition as a "system" column
>> perhaps, not really sure. making a system column is illustrated at
>> https://docs.sqlalchemy.org/en/13/orm/versioning.html?highlight=system#server-side-version-counters
>>
>>
>>
>>
>> --
>> SQLAlchemy -
>> The Python SQL Toolkit and Object Relational Mapper
>>
>> http://www.sqlalchemy.org/
>>
>> To post example code, please provide an MCVE: Minimal, Complete, and
>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
>> description.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "sqlalchemy" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/sqlalchemy/cc45324e-e194-4030-b9f7-a48a36c19747%40googlegroups.com.
>>
>>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/cbdf1b69-a0fc-41f5-a1cc-57c4fd156132%40googlegroups.com.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/CAFHwexdb2%3DLTgjAqd9yJShh9mhxxQRinFaPV7zct0g9N7oEr%2Bg%40mail.gmail.com.
