Thank you, it worked perfectly! 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] <javascript:>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/cc45324e-e194-4030-b9f7-a48a36c19747%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/cc45324e-e194-4030-b9f7-a48a36c19747%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > >
-- 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/2c1cf74b-6886-4e9f-8a85-a86a80aba9a5%40googlegroups.com.
