Metadata-Version: 2.1
Name: data-dealer
Version: 0.0.4
Summary: A command line interface for the Data Dealer
Home-page: https://github.com/lifeofabit/data-dealer.git
Author: Matt Downs
Author-email: 
License: UNKNOWN
Platform: UNKNOWN
Requires-Dist: boto3
Requires-Dist: Click
Requires-Dist: pandas
Requires-Dist: psycopg2
Requires-Dist: pymssql
Requires-Dist: python-dateutil (<2.7)
Requires-Dist: ruamel.yaml
Provides-Extra: test
Requires-Dist: coverage; extra == 'test'
Requires-Dist: pytest; extra == 'test'
Requires-Dist: pytest-cov; extra == 'test'

# data-dealer (0.0.4)
A Python wrapper for data virtualization, ETL and serialization as a pandas dataframe.  

## Installation
``` pip install data-dealer```

## Integrations
- .json and .csv file formats
- MS SQL Server
- AWS DynamoDB
- AWS Redshift
- AWS Athena (In Development)
- AWS s3 (In Development)

## Registry
In order to begin using the data dealer, you must register some suppliers. The following CLI commands will help you manage your registry

#### Register a new supplier

``` dealer registry -s test-supplier -p "dbms=mssql;host=localhost;uname=MyUsername;pword=MyPassword" add``` 

Valid supplier properties:
- dbms (athena, mssql, dynamo)
- host
- port
- uname
- pword
- aws_key
- aws_secret

#### Load a registry from file
``` dealer registry -s ~/registry.yaml load ```

#### Display current registry
``` dealer registry [display|show] ```

#### Remove a supplier from the registry
``` dealer registry -s test-supplier remove ```

## To-Do List:
Too many things to count

