Connect Using pyocient
The module pyocient supports direct connections to Ocient Systems in a Command Line Interface (CLI) as well as in Python programs that follow the Python Database API Specification 2.0.
After you install pyocient, you can establish Ocient connections to run queries and commands.
To install and run pyocient, follow these steps.
Install pyocient
Install pyocient using pip.
After running the pip install, pyocient is installed in the bin directory.
Use venv to install pyocient using a virtual environment. For more information, see the Python venv documentation.
Start pyocient
pyocient is started from the command line with a connection string. It includes many options to configure the connection and client similar to the JDBC driver. Learn more about supported options in the Ocient Python Module: pyocient.
After installation, you can launch from a command line by typing the pyocient command.
To connect to the system database, replace the example username (example_user) and password (example_password) with your credentials, set your IP address,
The connection example assume a SQL Node exists at 10.10.1.1. The example uses the default port 4050, and is set up with default self-signed certificates for TLS.
Example Response
Use the command quit; to exit the pyocient CLI interface.
Run a Query
In the pyocient CLI, you can run any SQL query supported by your database. In this example, a query is selecting rows from the system tables:
You can also run queries from the command line with the connection string:
Example Response:
The system cancels any queries made with the pyocient driver if you perform any of these actions:
- Fetch the entire result set.
- Close the connection.
- Execute a new query using the same connection.
For more information and API reference material for pyocient, see the Ocient Python Module: pyocient page.