JSON-RPC DB

Primary goal

This library realize Python Database API Specification v2.0 PEP 249 for JSON-RPC. Standart python database api, but under the hood you make remote procedure call.

Install

pip install jsonrpcdb

Usage

import jsonrpcdb

# without authentication
conn_params = {
    'host': 'ip/hostname',  # default localhost
    'port': 4000,  # default 4000
    'database': 'uri path', # default empty value
    'schema': 'http/https', # default http
}

# with token authentication
conn_params = {
    'host': 'ip/hostname',
    'port': 4000,
    'database': 'uri path',
    'schema': 'http/https',
    'user': 'username',
    'password': 'password',
    'auth_type': 'token'
}

conn = jsonrpcdb.connect(**conn_params)
cur = conn.cursor()
data = {
    'params': {} # remote procedure parameters
}
cur.execute('some_method', data)
results = cur.fetchall()