Skip to content

samples

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History
 
 

samples

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
agent
agent
 
 
async
async
 
 
README.md
README.md
 
 
conversation_chat_session.py
conversation_chat_session.py
 
 
conversation_create.py
conversation_create.py
 
 
conversation_delete.py
conversation_delete.py
 
 
conversations_list.py
conversations_list.py
 
 
create_ai_credential.py
create_ai_credential.py
 
 
delete_ai_credential.py
delete_ai_credential.py
 
 
disable_ai_provider.py
disable_ai_provider.py
 
 
enable_ai_provider.py
enable_ai_provider.py
 
 
profile_chat.py
profile_chat.py
 
 
profile_create.py
profile_create.py
 
 
profile_delete.py
profile_delete.py
 
 
profile_explain_sql.py
profile_explain_sql.py
 
 
profile_feedback.py
profile_feedback.py
 
 
profile_gen_multi_table_synthetic_data.py
profile_gen_multi_table_synthetic_data.py
 
 
profile_gen_single_table_synthetic_data.py
profile_gen_single_table_synthetic_data.py
 
 
profile_narrate.py
profile_narrate.py
 
 
profile_run_sql.py
profile_run_sql.py
 
 
profile_show_sql.py
profile_show_sql.py
 
 
profile_summarize_content.py
profile_summarize_content.py
 
 
profile_summarize_uri.py
profile_summarize_uri.py
 
 
profile_translate.py
profile_translate.py
 
 
profiles_list.py
profiles_list.py
 
 
select_ai_grant_privilege.py
select_ai_grant_privilege.py
 
 
select_ai_revoke_privilege.py
select_ai_revoke_privilege.py
 
 
vector_index_create.py
vector_index_create.py
 
 
vector_index_delete.py
vector_index_delete.py
 
 
vector_index_fetch.py
vector_index_fetch.py
 
 
vector_index_list.py
vector_index_list.py
 
 
vector_index_rag.py
vector_index_rag.py
 
 
vector_index_update_attributes.py
vector_index_update_attributes.py
 
 

README.md

select_ai samples

This directory contains samples for python-select-ai. To run the scripts, define and export the following environment variables

export SELECT_AI_ADMIN_USER=<db_admin>
export SELECT_AI_ADMIN_PASSWORD=<db_admin_password>
export SELECT_AI_USER=<select_ai_db_user>
export SELECT_AI_PASSWORD=<select_ai_db_password>
export SELECT_AI_DB_CONNECT_STRING=<db_connect_string>
export TNS_ADMIN=<path/to/dir_containing_tnsnames.ora>

Note: In production, do not save secrets in environment variables

SELECT_AI_ADMIN_USER and SELECT_AI_ADMIN_PASSWORD are needed only to grant privileges to regular user. They are used in 2 sample scripts enable_ai_provider.py and disable_ai_provider.py

SELECT_AI_DB_CONNECT_STRING can be in any one of the following formats

  • TNS alias

    export SELECT_AI_DB_CONNECT_STRING=db2025adb_medium

    Ensure there is an entry in $TNS_ADMIN/tnsnames.ora mapping to the connect descriptor

    >> tnsnames.ora

db2025adb_medium = (description= (retry_count=20)(retry_delay=3)
                   (address=(protocol=tcps)(port=1521)(host=adb.<region>.oraclecloud.com))
                   (connect_data=(service_name=db2025adb_medium.adb.oraclecloud.com))
                   (security=(ssl_server_dn_match=yes)))

  • Complete connect string

    export SELECT_AI_DB_CONNECT_STRING="(description= (retry_count=20)(retry_delay=3)
(address=(protocol=tcps)(port=1521)(host=adb.<region>.oraclecloud.com))
(connect_data=(service_name=db2025adb_medium.adb.oraclecloud.com))
(security=(ssl_server_dn_match=yes)))"

  • Simplified connect string

    export SELECT_AI_DB_CONNECT_STRING="tcps://adb.<region>.oraclecloud.com:1521/db2025adb_medium.adb.oraclecloud.com?retry_count=2&retry_delay=3"