Event: do_orm_execute inserted value

[Tomas Pavlovsky]

Hi Mike,

how to access inserted value in do_orm_execute?
Event "before_insert" has "target" parameter, but how to do it in do_orm_execute?

session.execute(insert(User).values(name="name"))

I need to access name value but don't know how?

Thanks

[Mike Bayer]

for a statement like that where the values are embedded in the insert() construct directly you would use:

     orm_execute_state.statement.compile().params

this is mentioned in the tutorial at https://docs.sqlalchemy.org/en/20/tutorial/data_insert.html#the-insert-sql-expression-construct

otherwise if parameters are sent separately, they are in orm_execute_state.parameters

--

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 sqlalchemy+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/9bea7c27-f67b-4d87-ab5e-71ece8c1dd46n%40googlegroups.com.

[Tomas Pavlovsky]

Thank you.