Commit Graph

119 Commits

Author SHA1 Message Date
Anthony Tuininga 0633e1017c Minor tweaks for PEP 8 compliance. 2021-05-18 16:56:55 -06:00
Anthony Tuininga d5461bd008 Further simplification. 2021-05-18 16:55:21 -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 932b413226 Adjust sample to match other AQ samples. 2021-04-28 15:29:54 -06:00
Anthony Tuininga 89aea21176 Support non-simple characters. 2021-04-23 16:12:12 -06:00
Anthony Tuininga 96f938286d Further work on adjusting attribute, method and parameter names to be
consistent and to comply with PEP 8 naming guidelines; also adjust
implementation of #385 (originally done in pull request #549) to use the
parameter name `bypass_decode` instead of `bypassencoding`.
2021-04-23 16:05:42 -06:00
Anthony Tuininga ab6e6f06ef Documentation and sample updates for clarity and to note the fact that
connection pools now always enable threading.
2021-04-23 14:21:45 -06:00
Anthony Tuininga fa8d6fa5be Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
Anthony Tuininga 0edb436abf Simplify samples. 2021-04-23 13:48:28 -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 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
Draco94 95baec2436
Implemented #385 enhancement and updated documentation (#549)
* Implemented #385 enhancement and updated documentation

Signed-off-by: Darko Djolovic <ddjolovic@outlook.com>

* Created flag to Cursor.var()

Signed-off-by: Darko Djolovic <ddjolovic@outlook.com>

* Removed first commit changes, updated documetnation

Signed-off-by: Darko Djolovic <ddjolovic@outlook.com>

* Added testing sample 'QueringRawData.py' and renamed attribute 'bypassstringencoding' to 'bypassencoding' with updated documentation

Signed-off-by: Darko Djolovic <ddjolovic@outlook.com>
2021-04-23 11:38:45 -06:00
Anthony Tuininga bdf6b4ee4c Use explicit SODA metadata for maximum version interoperability. 2021-03-03 11:30:10 -07:00
Anthony Tuininga e1b05d5095 Correct file references. 2021-03-03 11:20:55 -07:00
Christopher Jones fb2668e87c Update tutorial configuration and setup instructions 2021-03-03 17:14:32 +11:00
Christopher Jones 5f60401c4a Use aq_administrator_role for AQ samples 2021-03-03 17:12:57 +11:00
Anthony Tuininga 188608e748 Tweak documentation and README files. 2021-02-26 16:52:28 -07:00
Anthony Tuininga 8ea16b1345 Tweak formatting to comply with PEP 8 and remove extraneous comments. 2021-01-21 10:29:43 -07:00
Anthony Tuininga fa5fc20997 Fix typo. 2021-01-05 11:23:11 -07:00
Anthony Tuininga 9f32c9073e Remove trailing blank lines. 2021-01-05 11:21:50 -07:00
Anthony Tuininga 543c1b9d99 Minor tweaks to samples and documentation to take into account recent changes. 2021-01-05 11:20:29 -07:00
Anthony Tuininga b199c5d57f Fix typos. 2020-12-21 15:01:01 -07:00
Anthony Tuininga 3a23957f6d Further tweaks to documentation and samples. 2020-12-08 11:47:53 -07:00
Anthony Tuininga 30979c6a57 Modify samples to follow the PEP 8 style guide. 2020-12-08 11:46:17 -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 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 dd492591a3 Remove version numbers. Fixes incorrect number. 2020-07-28 09:50:24 -06:00
Anthony Tuininga 59231532a4 Add missing favicon. 2020-07-15 16:01:16 -06:00
Anthony Tuininga 079927c8ce Various documentation and tutorial improvements. 2020-06-25 15:23:41 -06:00
Anthony Tuininga 7df78b98d0 Tutorial improvements. 2020-06-19 10:42:06 -06:00
Anthony Tuininga 3a941687ea Added multiple consumer AQ example. 2020-06-19 10:39:19 -06:00
Anthony Tuininga 0467db9e4b Tutorial updates to get ready for the coming weekend's Quest session. 2020-06-09 14:50:41 -06:00
Anthony Tuininga 4956aee0e5 Remove sample that is only relevant with Python 2. 2020-06-03 09:11:32 -06:00
Anthony Tuininga c7a23115ad Remove remaining references to Python 2 syntax. 2020-06-03 09:11:03 -06:00
Anthony Tuininga 20686a1fc9 Various documentation and samples improvements. 2020-05-18 16:34:23 -06:00
Anthony Tuininga c710fb89a6 Update tutorial links. 2020-04-06 14:02:20 -06:00
Anthony Tuininga c513b71fe7 Use with clause when acquiring connections from a pool so that they are
returned automatically at the end of the block.
2020-04-06 13:53:26 -06:00
Anthony Tuininga dd31b41036 Added sample demonstrating the use of sharding capabilities. 2020-04-03 13:20:55 -06:00
Anthony Tuininga 4874f68712 Add a second CQN example to demonstrate how to fetch modified rows inside the
notification callback.
2020-01-21 15:03:28 -07:00
Anthony Tuininga 4fd326bb63 Remove unnecessary imports. 2020-01-21 15:03:08 -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 6ca6f2b0c3 Added a sample demonstrating the use of cursor.lastrowid. 2019-12-02 16:35:17 -07:00
Anthony Tuininga 952580a565 Adjust samples so that they run 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)
- use dbms_session.sleep() instead of dbms_lock.sleep() where possible
- environment variables CX_ORACLE_SAMPLES_SYSDBA_USER and
  CX_ORACLE_SAMPLES_SYSDBA_PASSWORD are replaced with
  CX_ORACLE_SAMPLES_ADMIN_USER and CX_ORACLE_SAMPLES_ADMIN_PASSWORD
- new environment variable CX_ORACLE_SAMPLES_DRCP_CONNECT_STRING used for
  specifying the connect string to use for DRCP usage
2019-11-13 16:43:07 -07:00
Anthony Tuininga d16c939f74 Adjust sample to take into account changes made to AQ support. 2019-11-13 16:41:10 -07:00
Anthony Tuininga 2cec047870 Update to new default PDB service name. 2019-08-08 14:19:23 -06:00
Anthony Tuininga ff25784c21 Use most recent default connect string in tutorial. 2019-07-15 14:23:05 -06:00
Anthony Tuininga b104d40016 Added a SODA section to the tutorial. 2019-07-15 14:22:28 -06:00
Anthony Tuininga 3c4d83fe6c Adjusted tutorial to use new AQ syntax. 2019-06-19 16:02:55 -06:00
Anthony Tuininga 5f8d24dd24 Eliminated deprecation of attribute "id" on subscriptions. It is now populated
with the value of REGID found in the database view
USER_CHANGE_NOTIFICATION_REGS or the value of REG_ID found in the database
view USER_SUBSCR_REGISTRATIONS. For AQ subscriptions, the value is 0.
2019-06-19 16:01:57 -06:00