Skip to main content

Doorda SDK for access to Hosted Platform

Project description

Doorda Python SDK

GitHub Action GitHub Action PyPI version PyPI pyversions

Requirements

Installation

PyPi

$ pip install doorda-sdk

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")
    
    # Returns generator of results
    # Does not put result into memory. Iterates through rows in a streaming fashion.
    for row in cursor.iter_result():
        # Do something with row
    
    # 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

    # List Permissions
    ## Permissions are shown as a hierarchical tree structure
    ### Level 1 = Catalog, Level 2 = Schemas, Level 3 = Table Names
    
    permissions = cursor.permissions()
    print(permissions)
    
    # Check database connection
    results = cursor.is_connected()
    
    # List all catalogs
    rows = cursor.show_catalogs()
    
    # List all schemas
    rows = cursor.show_schemas("catalog_name")
    
    # List all tables
    rows = cursor.show_tables("catalog_name", "schema_name")
    
    # 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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for doorda-sdk, version 1.0.11
Filename, size File type Python version Upload date Hashes
Filename, size doorda_sdk-1.0.11-py3-none-any.whl (15.6 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size doorda_sdk-1.0.11.tar.gz (11.1 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page