siwefe/python-oracledb - Gitee

OSC Recruit Statement

forked from mirrors_oracle/python-oracledb

Create your Gitee Account

Explore and code with more than 13.5 million developers，Free private repositories ！：）

文件

Clone or Download

Update doc and samples for new features. 3bc7d37 4 months ago

aq_notification.py

array_dml_rowcounts.py

array_dml_rowcounts_async.py

async_gather.py

batch_errors.py

batch_errors_async.py

bind_insert_async.py

bind_query_async.py

call_timeout.py

call_timeout_async.py

connection_pool.py

create_schema.py

database_change_notification.py

database_shutdown.py

database_startup.py

dataframe_numpy.py

dataframe_pandas.py

dataframe_pandas_async.py

dataframe_parquet_write.py

dataframe_polars.py

dataframe_pyarrow.py

dataframe_torch.py

dbms_output_async.py

dml_returning_multiple_rows.py

dml_returning_multiple_rows_async.py

generic_row_factory.py

generic_row_factory_async.py

implicit_results.py

implicit_results_async.py

insert_geometry.py

insert_geometry_async.py

json_blob_async.py

json_direct_async.py

json_duality.py

json_duality_async.py

last_rowid_async.py

load_csv_async.py

multi_consumer_aq.py

object_dump_async.py

oracledb_upgrade.py

pipelining_basic.py

pipelining_error.py

pipelining_parallel.py

plsql_batch_async.py

plsql_collection.py

plsql_collection_async.py

plsql_function.py

plsql_function_async.py

plsql_procedure.py

plsql_procedure_async.py

plsql_record.py

plsql_record_async.py

plsql_rowtype.py

plsql_rowtype_async.py

query_arraysize.py

query_arraysize_async.py

query_strings_as_bytes.py

query_strings_as_bytes_async.py

ref_cursor_async.py

return_lobs_as_strings.py

return_lobs_as_strings_async.py

return_numbers_as_decimals.py

return_numbers_as_decimals_async.py

rows_as_instance.py

rows_as_instance_async.py

scrollable_cursors.py

session_callback.py

session_callback_plsql.py

session_callback_tagging.py

sharding_number_key.py

soda_bulk_insert.py

soda_json_duality.py

spatial_to_geopandas.py

subclassing_async.py

transaction_guard.py

type_handlers_json_strings.py

type_handlers_json_strings_async.py

type_handlers_objects.py

type_handlers_objects_async.py

universal_rowids.py

universal_rowids_async.py

vector_async.py

vector_numpy.py

vector_numpy_async.py

vector_string.py

write_csv_async.py

Loading...

README

Python-oracledb Examples

Python-oracledb Examples

This directory contains samples for python-oracledb.

Basic Examples

The schemas and SQL objects that are referenced in the samples can be created by running the Python script create_schema.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 create_schema.py
```
Run a Python script, for example:
```
python query.py
```
After running python-oracledb samples, the schemas and SQL objects can be dropped by running the Python script drop_schema.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_schema.py
```

Examples in a Container

The sample_container directory has a Dockerfile that will build a container with the samples and a running Oracle Database.

Notebooks

The notebooks directory has Jupyter notebooks with runnable examples.

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

1

https://gitee.com/siwefe/python-oracledb.git

git@gitee.com:siwefe/python-oracledb.git

siwefe

python-oracledb

python-oracledb

main