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:28 -0400 |
| commit | 108d331e8932833ae9f81c79ccc6a522717a75f4 (patch) | |
| tree | 4f365f989ddc6e50ce8c90691907ef6ecb90ddcb /lib/sqlalchemy/dialects | |
| parent | 4580f942fb851963ce09a05a0c3e6ad6b861ed7d (diff) | |
| download | sqlalchemy-108d331e8932833ae9f81c79ccc6a522717a75f4.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
(cherry picked from commit 75d48e65eaac9e97283bb14fdec54a143d9997f1)
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( |