26 Commits

Author SHA1 Message Date
Anthony Tuininga
2d33fec37a Test suite improvements. 2021-11-04 13:19:04 -06:00
Anthony Tuininga
4b72d0de02 Rename samples and test files in order to be consistent. 2021-04-23 13:36:00 -06:00
Christopher Jones
5f60401c4a Use aq_administrator_role for AQ samples 2021-03-03 17:12:57 +11:00
Anthony Tuininga
b59fe3b0be Added support for new JSON data type available in Oracle Client and Database 21
and higher.
2020-12-08 11:40:21 -07:00
Anthony Tuininga
7e7133b09a The value of prefetchrows for REF CURSOR variables is now honored
(https://github.com/oracle/python-cx_Oracle/issues/482).
2020-11-12 14:24:42 -07:00
Alex Henrie
ba141dd799
Create TestLongs and TestLongRaws tables without compression (#437)
Signed-off-by: Alex Henrie <alexhenrie24@gmail.com>
2020-05-18 13:43:13 -06:00
Anthony Tuininga
a7b958d68a Added test cases for pls_integer and binary_integer data types. 2019-11-13 16:44:50 -07:00
Anthony Tuininga
cd9c7e3fa3 Adjust test suite so that it runs unchanged against Oracle Cloud databases:
- administrative user is ADMIN on the Oracle Cloud databases and SYSTEM on
  local databases (SYSDBA is not available on the Oracle Cloud database)
- environment variables CX_ORACLE_TEST_SYSDBA_USER and
  CX_ORACLE_TEST_SYSDBA_PASSWORD are replaced with CX_ORACLE_TEST_ADMIN_USER
  and CX_ORACLE_TEST_ADMIN_PASSWORD
- skip tests that change passwords as passwords on Oracle Cloud database are
  strictly controlled
- skip tests that check subscriptions as these are not currently supported on
  Oracle Cloud database
2019-11-13 16:43:49 -07:00
Anthony Tuininga
e37e502724 Added test cases, particularly for bulk AQ operations. 2019-07-05 14:32:59 -06:00
Anthony Tuininga
ee5fe39544 Rename queues and queue tables to be more clear as to which is which. 2019-06-11 19:13:21 -06:00
Anthony Tuininga
0ae5b9e715 Added test cases for session tagging. 2019-03-07 17:00:14 -07:00
Anthony Tuininga
4ed95aad94 Reworked test suite to eliminate the use of default passwords and to make the
individual test modules directly runnable (instead of using execfile() within
test.py).
2019-01-31 10:18:04 -07:00
Anthony Tuininga
b340771c37 Rework handling of numbers so that, unless using the NATIVE_INT,
NATIVE_FLOAT or NATIVE_DOUBLE types, all numbers are converted to strings and
passed through to ODPI-C in all Python versions; improved error message when
a value cannot be represented by an Oracle number value; improved test suite to
verify that calling executemany() with integers, floats and decimal values
intermixed with each other works as expected
(https://github.com/oracle/python-cx_Oracle/issues/241).
2018-12-07 19:16:33 -07:00
Anthony Tuininga
851c9a4650 Add support for getting/setting raw attributes of objects, as requested
(https://github.com/oracle/odpi/issues/72).
2018-11-02 15:44:49 -06:00
Anthony Tuininga
548440016e Add support for passing an object type (such as those created by the method
connection.gettype()) as the first parameter to cursor.var(), as requested
(https://github.com/oracle/python-cx_Oracle/issues/231).
2018-10-30 16:32:05 -06:00
Anthony Tuininga
bc69e784f8 Adjust copyright notices to match requirements of Oracle Legal. 2018-09-10 11:39:51 -06:00
Anthony Tuininga
64f65050a2 Add support (as preview) for SODA. 2018-09-10 11:37:53 -06:00
Anthony Tuininga
85a0ad3ee3 Use the built-in type SYS_REFCURSOR instead of creating a new one. 2018-05-29 21:55:45 -06:00
Anthony Tuininga
c31eef50de Correct handling of statements and rowids in DML returning statements. 2018-05-29 21:55:26 -06:00
Anthony Tuininga
d9c50574f5 Added test cases for AQ transformations and trimming collections. 2018-05-09 19:34:21 -06:00
Anthony Tuininga
e15851220b Correct the handling of ANSI types REAL and DOUBLE PRECISION as implemented by
Oracle. These types are just subtypes of NUMBER and are not actually stored as
native floating point numbers. Native floating point numbers are used with
Oracle types BINARY_FLOAT and BINARY_DOUBLE
(https://github.com/oracle/python-cx_Oracle/issues/163).
2018-03-21 11:46:17 -06:00
Anthony Tuininga
fb71f1126b Additional test cases for AQ. 2017-11-27 10:38:27 -07:00
Anthony Tuininga
d4b13eb584 Added test cases for rowids. 2017-10-24 22:03:47 -06:00
Anthony Tuininga
c2c8d541bf On Windows, sizeof(long) = 4 which means that integers between 10 and 18 digits
were not converted to Python correctly
(https://github.com/oracle/python-cx_Oracle/issues/70).
2017-08-22 21:40:21 -06:00
Anthony Tuininga
1eba9d55be Use dpiData_*() functions to simplify setting data; correct handling of
timestamp with time zone attributes.
2017-07-21 15:35:49 -06:00
Anthony Tuininga
340dcb7195 Rework test suite and samples so that they are independent of each other and
so that the SQL scripts used to create/drop schemas are easily adjusted to
use different schema names, if desired. Improve documentation for test suite
and samples.
2017-07-14 16:50:41 -06:00