dnrops
/
python-cx_Oracle
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
python-cx_Oracle/samples
History
Anthony Tuininga 0633e1017c Minor tweaks for PEP 8 compliance. 2021-05-18 16:56:55 -06:00
..
sql Rename samples and test files in order to be consistent. 2021-04-23 13:36:00 -06:00
tutorial Documentation updates, including changes for PEP 8 compliance, to take 2021-05-18 16:53:31 -06:00
README.md Documentation updates, including changes for PEP 8 compliance, to take 2021-05-18 16:53:31 -06:00
app_context.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
aq_notification.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
array_dml_rowcounts.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
batch_errors.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
bind_insert.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
bind_query.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
bulk_aq.py Minor tweaks for PEP 8 compliance. 2021-05-18 16:56:55 -06:00
call_timeout.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
connection_pool.py Documentation and sample updates for clarity and to note the fact that 2021-04-23 14:21:45 -06:00
cqn.py Minor tweaks for PEP 8 compliance. 2021-05-18 16:56:55 -06:00
cqn2.py Documentation and sample updates for clarity and to note the fact that 2021-04-23 14:21:45 -06:00
database_change_notification.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
database_shutdown.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
database_startup.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
dbms_output.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
dml_returning_multiple_rows.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
drcp.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
drop_samples.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
editioning.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
generic_row_factory.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
implicit_results.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
insert_geometry.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
json_blob.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
json_direct.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
last_rowid.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
multi_consumer_aq.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
object_aq.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
plsql_collection.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
plsql_function.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
plsql_procedure.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
plsql_record.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
query.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
query_arraysize.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
query_strings_as_bytes.py Further work on adjusting attribute, method and parameter names to be 2021-04-23 16:05:42 -06:00
raw_aq.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
ref_cursor.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
return_lobs_as_strings.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
return_numbers_as_decimals.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
rows_as_instance.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
sample_env.py Rename samples and test files in order to be consistent. 2021-04-23 13:36:00 -06:00
scrollable_cursors.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
session_callback.py Documentation and sample updates for clarity and to note the fact that 2021-04-23 14:21:45 -06:00
session_callback_plsql.py Documentation and sample updates for clarity and to note the fact that 2021-04-23 14:21:45 -06:00
setup_samples.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
sharding_number_key.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
soda_basic.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
soda_bulk_insert.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
spatial_to_geopandas.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
subclassing.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00
transaction_guard.py Minor tweaks for PEP 8 compliance. 2021-05-18 16:56:55 -06:00
type_handlers.py Minor tweaks for PEP 8 compliance. 2021-05-18 16:56:55 -06:00
universal_rowids.py Migrate samples to use PEP 8 naming style consistently. 2021-04-23 13:50:06 -06:00

README.md

cx_Oracle Examples

This directory contains samples for cx_Oracle. Documentation is here.

  1. The schemas and SQL objects that are referenced in the samples can be created by running the Python script setup_samples.py. The script requires SYSDBA privileges and will prompt for these credentials as well as the names of the schemas and edition that will be created, unless a number of environment variables are set as documented in the Python script sample_env.py. Run the script using the following command:

    python setup_samples.py

    Alternatively, the SQL script can be run directly via SQL*Plus, which will always prompt for the names of the schemas and edition that will be created.

    sqlplus sys/syspassword@hostname/servicename @sql/setup_samples.sql

  2. Run a Python script, for example:

     python Query.py

  3. After running cx_Oracle samples, the schemas and SQL objects can be dropped by running the Python script drop_samples.py. The script requires SYSDBA privileges and will prompt for these credentials as well as the names of the schemas and edition that will be dropped, unless a number of environment variables are set as documented in the Python script sample_env.py. Run the script using the following command:

    python drop_samples.py

    Alternatively, the SQL script can be run directly via SQL*Plus, which will always prompt for the names of the schemas and edition that will be dropped.

    sqlplus sys/syspassword@hostname/servicename @sql/drop_samples.sql