Doorda package for access to host and API platform
Project description
Doorda Python SDK
Requirements
Works with Python 3
Installation
PyPi
$ pip install doorda-sdk
Source
Download from:
- https://github.com/Doorda/doorda-python-sdk/releases
- git clone git@github.com:doorda/doorda-python-sdk.git
Install
python setup.py install
Usage
DoordaHost
-
Connect to database
from doorda_sdk.host import client conn = client.connect(username="username", password="password", catalog="catalog_name", schema="schema_name") cursor = conn.cursor()
-
Execute Queries
cursor.execute("SELECT * FROM table_name") # Fetch all results rows = cursor.fetchall() # Fetch one results rows = cursor.fetchone() # Fetch multiple results rows = cursor.fetchmany(size=10) # Get list of column names cursor.col_names() # Get column names mapped to data types cursor.col_types()
-
Simplified Functions
# Check database connection results = cursor.is_connected() # List all catalogs rows = cursor.show_catalogs() # Get number of rows rows = cursor.table_stats(catalog="catalog_name", schema="schema_name", table="table_name")
Find out more
To find out more about DoordaHost, go to https://github.com/Doorda/Getting-Started
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
doorda_sdk-1.0.4.tar.gz
(4.1 kB
view hashes)