Skip to main content

The Alphacruncher python library

Project description

aclib - The alphacruncher python library

Installation

$ pip install aclib

Usage

The library provides 2 convenience functions for connecting to the remote database with your credentials. It assumes that you have a credential file ~/.odbc.ini in the following format

[nuvolos]
uid = <username>
pwd = <password>

The library will also look for a special /lifecycle/.dbpath file. When used inside an Alphacruncher application, this file is populated by the platfrom with the db and schema name of the application, and the library will pick these up automatically.

You can then get the SQLAlchemy connection string, or create an SQLAlchemy engine directly:

>>> from aclib import get_url, get_engine
>>> get_url()
'snowflake://<username>:<password>@alphacruncher.eu-central-1/?warehouse=<username>'
>>> get_url("db_name","schema_name")
'snowflake://<username>:<password>@alphacruncher.eu-central-1/?warehouse=<username>&database=db_name&schema=schema_name'
>>> eng = get_engine("db_name","schema_name")

Source: https://github.com/datahub-ac/python-connector

Project details


Download files

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

Source Distribution

aclib-0.2.4.tar.gz (2.5 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page