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 [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/587b5317-e275-4c22-a78e-460eeafff1c1n%40googlegroups.com
>
> <https://groups.google.com/d/msgid/sqlalchemy/587b5317-e275-4c22-a78e-460eeafff1c1n%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/391054ea-1ade-429b-ad41-100390cd935b%40www.fastmail.com.
