cavaconn
With cavaconn you can connect to servers and create SQLAlchemy Engines, PsychoPG connections, and connect to twitter APIs. This is intended to be a series of helper methods, not a full functioning package.
Installation
$ git clone https://github.com/cavagrill/cava_connect.git && cd cava_connect
$ python setup.py install
or
$ pip install cavaconn
Usage
a server_info.yml and a twitter_info.yml file should be placed in a directory
import cavaconn as cc
# creates a SQLAlchemy engine object tied to our postgresql db
eng = cc.get_engine('server_info.yml', db_name)
# creates a PostgreSQL connection
conn = cc.get_connection('server_info.yml', db_name)
# creates a named_tuple object of twitter auth keys that can be accessed like api_keys.access_token
api_keys = cc.connect_twitter('twitter_info.yml')
# Executes a SQL Query on an existing PostgreSQL connection
q = """DROP TABLE IF EXISTS throwaway;"""
cc.pg_commit(conn, q)
# creates Microsoft SQL server connection
eng = cc.get_MSSQL('server_info.yml', db_name)
# creates connection string for web application
conn_str = cc.get_connst('server_info.yml', dbname)
Example Twitter YAML
---
access_token: 'a'
access_token_secret: 'a'
consumer_key: 'b'
consumer_secret: 'b'
Example Connection YAML
---
to_server: 'server_addres.com'
to_port: '8088'
to_user: 'some_user_name'
to_pass: 'Password1'