SqliteCloud 0.0.30

A Python package for working with SQLite databases in the cloud.

Python SDK for SqliteCloud

SQLiteCloud is a powerful Python package that allows you to interact with the SQLite Cloud backend server seamlessly. It provides methods for various database operations. This package is designed to simplify database operations in Python applications, making it easier than ever to work with SQLite Cloud.

Installation

You can install SqliteCloud Package using Python Package Index (PYPI):

$ pip install SqliteCloud

• Follow the instructions reported here https://github.com/sqlitecloud/sdk/tree/master/C to build the driver.

• Set SQLITECLOUD_DRIVER_PATH environment variable to the path of the driver file build.

Usage

---

from sqlitecloud.client import SqliteCloudClient, SqliteCloudAccount

Init a connection

Using explicit configuration

account = SqliteCloudAccount(user, password, host, db_name, port)
client = SqliteCloudClient(cloud_account=account)
conn = client.open_connection()

Using string configuration

account = SqliteCloudAccount("sqlitecloud://user:[e-mail]:port/dbname?timeout=10&key2=value2&key3=value3")
client = SqliteCloudClient(cloud_account=account)
conn = client.open_connection()

Execute a query

You can bind values to parametric queries: you can pass parameters as positional values in an array

result = client.exec_statement(
    "SELECT * FROM table_name WHERE id = ?",
    [1],
    conn=conn
)

Iterate result

result is an iterable object

for row in result:
    print(row)

Close connection

client.disconnect(conn)