Re: [sqlalchemy] No NOWAIT for FOR UPDATE

[Mike Bayer]

hi

you need to compile with the postgresql dialect, see https://docs.sqlalchemy.org/en/14/faq/sqlexpressions.html#stringifying-for-specific-databases

from sqlalchemy import column

from sqlalchemy import table

from sqlalchemy.dialects import postgresql

from sqlalchemy.future import select

t = table("internal", column("person_id_internal"))

sql = select(

    t.c.person_id_internal

).with_for_update(nowait=True)

print(sql.compile(dialect=postgresql.dialect()))

On Sun, Jun 13, 2021, at 12:23 PM, sector119 wrote:

Hello!

On a PostgreSQL database can't get NOWAIT with FOR UPDATE clause (

sqlalchemy 1.4.18

from sqlalchemy.future import select

from unity.models.unity import Internal

sql = select(

    Internal.person_id_internal

).with_for_update(nowait=True)

str(sql)

Out[12]: 'SELECT unity.internals.person_id_internal \nFROM unity.internals FOR UPDATE'

--

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/587b5317-e275-4c22-a78e-460eeafff1c1n%40googlegroups.com.