doorda-sdk 1.0.5

Doorda package for access to host and API platform

Doorda Python SDK

Requirements

Works with Python 3

Installation

PyPi

$ pip install doorda-sdk

Source

Download from:

1. https://github.com/Doorda/doorda-python-sdk/releases

wget https://github.com/Doorda/doorda-python-sdk/archive/1.0.4.zip

unzip 1.0.4.zip

Install

python setup.py install

Usage

DoordaHost

1. 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()
   

2. 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()
   

3. 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, head over to https://github.com/Doorda/Getting-Started