diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2018-08-01 14:12:49 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2018-08-01 19:21:13 -0400 |
| commit | 75d48e65eaac9e97283bb14fdec54a143d9997f1 (patch) | |
| tree | 362e11c643d10d30aed8a72ae54f5635e40cd6b6 /lib/sqlalchemy/dialects | |
| parent | 1c32206120b1a6555f8bb7a20a0c4c53ea2f52a8 (diff) | |
| download | sqlalchemy-75d48e65eaac9e97283bb14fdec54a143d9997f1.tar.gz | |
Bind Integers to int for cx_Oracle
For cx_Oracle, Integer datatypes will now be bound to "int", per advice
from the cx_Oracle developers. Previously, using cx_Oracle.NUMBER caused a
loss in precision within the cx_Oracle 6.x series.
Change-Id: I4c6b2cca490aff5b98b7ceff3414715202881c89
Fixes: #4309
Diffstat (limited to 'lib/sqlalchemy/dialects')
| -rw-r--r-- | lib/sqlalchemy/dialects/oracle/cx_oracle.py | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/lib/sqlalchemy/dialects/oracle/cx_oracle.py b/lib/sqlalchemy/dialects/oracle/cx_oracle.py index 2225000f7..61fd0dbf4 100644 --- a/lib/sqlalchemy/dialects/oracle/cx_oracle.py +++ b/lib/sqlalchemy/dialects/oracle/cx_oracle.py @@ -293,6 +293,10 @@ import time class _OracleInteger(sqltypes.Integer): + def get_dbapi_type(self, dbapi): + # see https://github.com/oracle/python-cx_Oracle/issues/208#issuecomment-409715955 + return int + def _cx_oracle_var(self, dialect, cursor): cx_Oracle = dialect.dbapi return cursor.var( |