[sqlalchemy] Oracle connection problem

I am using sqlalchemy 1.4.22 and cx oracle 8.2.1 to connect to production and development environments that each host a similar copy of the same schema. The connection string that I use is the same for each excluding the password: oracle+cx_oracle://user:pass@MyTNS Dev works without a

[sqlalchemy] Common datetime call

Hi, Does a means exist to generically call a local datetime func such that it renders as SYSDATE in Oracle and GETDATE() in SQL Server? Thanks, jlc -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE:

[sqlalchemy] Proper date abstraction in case statement

Hi, I have a case statement that should compare just the date for equality, however the code considers the time as well: Model.dateCol == func.sysdate() Another issue is this is a DATE field (therefore datetime) in an Oracle database in one environment and a DATE field (actual date) in an

Re: [sqlalchemy] Logging handler logic

you want to > use your own handlers then you should use traditional logging steps; > there's nothing the echo flag does that can't be accomplished using the > logging API directly. > > > > On Sun, Jun 13, 2021, at 10:24 PM, jca...@gmail.com wrote: > > Hi, > Thank

[sqlalchemy] Logging handler logic

Hello everyone, After reviewing the handler logic, I am not clear that it implements logging within the pattern guidelines defined by the base logging implementation. In log.py#L103