[sqlalchemy] Re: Can't find anything equivalent to bit_or in PostgreSQL

2020-06-16 Thread Balukrishnan
Thank you very much. I tried that and it is working perfectly for me. On Wednesday, June 17, 2020 at 3:12:04 AM UTC+5:30, Jonathan Vanasco wrote: > > If this just needs this to be rendered for PostgreSQL, you can use the > `func` generator: > > >

[sqlalchemy] Changing database credentials after engine creation

2020-06-16 Thread Venkata Siva Naga Tatikonda
Hello Everyone, Need some suggestion/insight on some use case we have: We have python django web application which uses sqlalchemy v1.3.13 (mysqldb) to communicate with AWS Aurora (RDS). This application uses AWS Secrets Manager for managing database credentials and utilizing sqlalchemy (w/

[sqlalchemy] Re: Can't find anything equivalent to bit_or in PostgreSQL

2020-06-16 Thread 'Jonathan Vanasco' via sqlalchemy
If this just needs this to be rendered for PostgreSQL, you can use the `func` generator: https://docs.sqlalchemy.org/en/13/core/sqlelement.html#sqlalchemy.sql.expression.func from sqlalchemy.sql.expression import func query = session.query(Foo).filter(func.bit_or(Foo.cola, Foo.colb)...

[sqlalchemy] Can't find anything equivalent to bit_or in PostgreSQL

2020-06-16 Thread Balukrishnan
Hi friends, I am looking for function or operator which is equivalent to bit_or in PostgreSQL aggregate function . Is there any? I can't find any. Please help. -- SQLAlchemy - The Python SQL Toolkit and Object Relational

Re: [sqlalchemy] Connect to multiple Oracle DBs via LDAP

2020-06-16 Thread Syrrius78
oki thanks a lot. I'll send a message to the cx_Oracle devs. -- 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

Re: [sqlalchemy] Connect to multiple Oracle DBs via LDAP

2020-06-16 Thread Mike Bayer
sounds like a cx_Oracle issue ? I don't really understand what this means. A particular Engine can only connect to one database at a time in any case. Contact cx_Oracle devs at https://github.com/oracle/python-cx_Oracle/issues Python doesn't support JDBC unless you're using Jython which

[sqlalchemy] Connect to multiple Oracle DBs via LDAP

2020-06-16 Thread Syrrius78
hi, i'm using sqlalchemy 1.3.12. For a project, I try to connect to multiple oracle databases via LDAP (different LDAP url & context) . it's working fine for 1 database : cx_Oracle dialect + sqlnet.ora & ldap.ora files. Problem with this method : it seems we can declare only 1 database