Re: [sqlalchemy] SQLAlchemy lock-up when logging to a database

2018-02-23 Thread Stefan Schwarzer
On Wednesday, February 21, 2018 at 10:31:30 PM UTC+1, Mike Bayer wrote: > > or have your logger look for that "log_only" token in the logger name > and skip on that, that's more future-proof. > Yes, using a specific logger for the engine seems to work. :-) I had looked for something like this,

Re: [sqlalchemy] SQLAlchemy lock-up when logging to a database

2018-02-21 Thread Stefan Schwarzer
Thanks for the quick reply! On Wednesday, February 21, 2018 at 6:44:33 PM UTC+1, Mike Bayer wrote: > > I can come up with other things that can break based on the idea that > you're doing a full connection + execute sequence within the log > handler deep within that engine's own processes, such

[sqlalchemy] SQLAlchemy lock-up when logging to a database

2018-02-21 Thread Stefan Schwarzer
In our project we recently ran into the problem that SQLAlchemy would block when creating a connection for logging to a database. Set-up: Oracle server 11.2 cx_Oracle 6.1 SQLAlchemy 1.2.3 The example code for `connection_lockup.py` is:

Re: [sqlalchemy] Inserting Chinese characters in Oracle database

2018-01-16 Thread Stefan Schwarzer
Hi Mike, thanks again! On 2018-01-15 23:17, Mike Bayer wrote: > On Mon, Jan 15, 2018 at 3:18 PM, Stefan Schwarzer > <sschwar...@sschwarzer.net> wrote: >> On 2018-01-12 16:33, Mike Bayer wrote:> On Fri, Jan 12, 2018 at 7:14 AM, >> Stefan Schwarzer >>&g

Re: [sqlalchemy] Inserting Chinese characters in Oracle database

2018-01-15 Thread Stefan Schwarzer
On 2018-01-12 16:33, Mike Bayer wrote:> On Fri, Jan 12, 2018 at 7:14 AM, Stefan Schwarzer > <sschwar...@sschwarzer.net> wrote: > In SQLAlchemy 1.1 series and earlier, you can specify > exclude_setinputsizes=() to have STRING be part of the automatic > setinputsizes cal

Re: [sqlalchemy] Inserting Chinese characters in Oracle database

2018-01-12 Thread Stefan Schwarzer
Mike, many thanks for your feedback! On 2018-01-12 16:33, Mike Bayer wrote: > On Fri, Jan 12, 2018 at 7:14 AM, Stefan Schwarzer > <sschwar...@sschwarzer.net> wrote: >> I have trouble inserting Chinese characters into an Oracle database with >> SQLAlchemy (and to some e

[sqlalchemy] Inserting Chinese characters in Oracle database

2018-01-12 Thread Stefan Schwarzer
I have trouble inserting Chinese characters into an Oracle database with SQLAlchemy (and to some extent with cx_Oracle). I don't specifically need Chinese characters but I used them in a unit test to see if my code (hopefully) can handle "any" unicode characters. The setup: - SQLAlchemy

[sqlalchemy] Regression for sub-second precision when inserting timestamps into Oracle database

2018-01-08 Thread Stefan Schwarzer
Hello, I've run into a problem that's present in SQLAlchemy 1.2, but not 1.1.15 when run against an Oracle 11.2 database using cx_Oracle 6.1. When creating the table `TIMESTAMP_TEST` with CREATE TABLE TIMESTAMP_TEST ( TS TIMESTAMP(6) ) and running the following code import datetime import