Commit Graph

228 Commits

Author SHA1 Message Date
Anthony Tuininga 7c51c67179 Fixed crash when using the deprecated parameter name keywordParameters
with Cursor.callproc(); added to test suite to verify deprecations.
2021-05-28 15:02:28 -06:00
Anthony Tuininga cd21e92edd Improve test suite. 2021-05-18 16:58:03 -06:00
Anthony Tuininga 0633e1017c Minor tweaks for PEP 8 compliance. 2021-05-18 16:56:55 -06:00
Anthony Tuininga cfa2750854 Add support for pool reconfiguration. 2021-05-18 16:56:04 -06:00
Anthony Tuininga 4ed562c205 Documentation updates, including changes for PEP 8 compliance, to take
into account the fact that the default branch has changed to main, etc.
2021-05-18 16:53:31 -06:00
Anthony Tuininga c527c06650 Further work on adjusting attribute, method and parameter names to be
consistent and to comply with PEP 8 naming guidelines; add a separate
section to the documentation to deal with all deprecations so that they
are all in one place.
2021-04-23 13:40:24 -06:00
Anthony Tuininga 4b72d0de02 Rename samples and test files in order to be consistent. 2021-04-23 13:36:00 -06:00
Anthony Tuininga 74d16d8962 Improved the test suite. 2021-04-23 12:04:29 -06:00
Anthony Tuininga 5e2a363ac5 Modify the parameter names of the SessionPool constructor in order to
follow PEP 8 naming guidelines.
2021-04-23 12:01:52 -06:00
Anthony Tuininga 4264d7bc5d Improved test suite; added check that the LOB type matches the expected
LOB type.
2021-04-23 11:53:13 -06:00
Anthony Tuininga 8f901abce7 The distributed transaction handle assosciated with the connection is now
cleared on commit or rollback (`issue 530
<https://github.com/oracle/python-cx_Oracle/issues/530>`__).
2021-03-04 09:41:37 -07:00
Christopher Jones 5f60401c4a Use aq_administrator_role for AQ samples 2021-03-03 17:12:57 +11:00
Christopher Jones bf381478c4 Update pool testcases 2021-03-03 17:11:55 +11:00
Anthony Tuininga 188608e748 Tweak documentation and README files. 2021-02-26 16:52:28 -07:00
Anthony Tuininga 3b8c9cbd5f Added more test cases. 2020-12-21 14:57:45 -07:00
Anthony Tuininga f3984cee55 The connection created by using an external handle should never be used after
the external handle has been closed or destroyed (since otherwise the memory
used may have already been freed and reused by other parts of the application).
2020-12-08 11:51:54 -07:00
Anthony Tuininga 6b9a7b011b Rename "base" to "test_env" to be clearer as to the purpose of the module. 2020-12-08 11:44:55 -07:00
Anthony Tuininga 9c9b92a39c Added new tests. 2020-12-08 11:42:53 -07: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 633d1141db Change to use PEP 8 format guidelines. 2020-11-12 14:27:23 -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
Anthony Tuininga 229f9f5533 Rework test suite further to use PEP 8 style guidelines. 2020-11-02 15:25:51 -07:00
Anthony Tuininga ef3d84318e The ability to pickle/unpickle Database and API types has been restored. 2020-11-02 15:24:23 -07:00
Anthony Tuininga d242bc716d Rework build to use setuptools exclusively and enable use of pyproject.toml;
rework test suite to use tox and simplify test suite (also added a test number
to each test case for easier reference).
2020-11-02 15:21:52 -07:00
Anthony Tuininga 2194d81965 Added test cases for prefetch. 2020-11-02 15:20:45 -07:00
Anthony Tuininga 10e5c258fe Update to ODPI-C 4.0.1 and add test to ensure that the offset is returned
correctly when a parse error is encountered.
2020-06-26 10:33:13 -06:00
Anthony Tuininga c144216b95 Adjust test name to remove reference to very old version of Python. 2020-06-03 09:12:45 -06:00
Anthony Tuininga c7a23115ad Remove remaining references to Python 2 syntax. 2020-06-03 09:11:03 -06:00
Anthony Tuininga d5144aa58f Added test cases for cursor.lastrowid and SODA collection truncation (and added
code to check for situation where SODA support is lacking and stop running the
test suite for SODA in that case).
2020-05-18 16:34:58 -06: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 856d0aab76 Tweaks to boolean variable improvements patch supplied by Alex Henrie
(https://github.com/oracle/python-cx_Oracle/pull/435).
2020-05-15 21:47:40 -06:00
Alex Henrie 17fd92f8f6
Convert Python objects to booleans based on their Python truth value (#435)
Signed-off-by: Alex Henrie <alexhenrie24@gmail.com>
2020-05-15 17:00:13 -06:00
Anthony Tuininga fbe929d5c8 The database types CLOB, NCLOB, BFILE and BLOB no longer compare equal to
STRING and BINARY.
2020-04-17 10:19:44 -06:00
Anthony Tuininga f7b7785e82 Reworked type management to clarify and simplify code (see release notes for
details).
2020-02-10 10:02:03 -07:00
Anthony Tuininga e85a03b57b Remove commented out code 2020-01-06 20:14:11 -07:00
Anthony Tuininga 6b73d2223f cx_Oracle 8 when it is released will not support Python 2.7. 2019-12-04 15:06:25 -07:00
Anthony Tuininga 5f70edd71c Be consistent and always raise cx_Oracle.InterfaceError when a connection is
closed and unusable.
2019-11-29 14:58:47 -07:00
Anthony Tuininga 7b144440aa Ensure that the session time zone is UTC so that values can be compared without
concern for the time zones of the client and database server.
2019-11-25 21:41:58 -07:00
Anthony Tuininga 80b9a31fa6 Remove invalid test. 2019-11-13 16:48:06 -07:00
Anthony Tuininga fcbf9ff17c DatabaseError, not ProgrammingError is now returned as this check is performed
at the ODPI-C level.
2019-11-13 16:47:45 -07: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 a16a944964 Restore support for setting numeric bind variables with boolean values. 2019-08-22 21:39:15 -06:00
Anthony Tuininga 2cec047870 Update to new default PDB service name. 2019-08-08 14:19:23 -06: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 82097891b3 Add support for setting a CLOB attribute on a SQL object, as requested
(https://github.com/oracle/python-cx_Oracle/issues/299).
2019-04-29 11:41:28 -06:00
Anthony Tuininga 8681366f53 For Python 2.7, raw_input is needed to request input; also ensure that
sample parameters are saved once requested.
2019-03-29 09:49:40 -06:00
Anthony Tuininga f324757909 Adjust formatting of PR #287. 2019-03-28 11:57:33 -06:00
Andrey Petukhov a654befddf Cursor.callproc method changed with respect to doc (#287)
Signed-off-by: Andrey Petukhov <APetukhov@bellintegrator.com>
2019-03-28 10:55:30 -07:00