A package containing key sp functions

# Currently primarily contains functions for getting data from Redshift but will be extended in the future

## Installing the package

This package can be installed using pip, e.g. pip install sportpursuit
The recommended way to call the functions is by importing sportpursuit.sportpursuit as sp then invoking the GetData class as sp.GetData.function_name()

For example a minimum set of commands to get Redshift data in a Jupyter Notebook would look like the following:
!pip install sportpursuit
import sportpursuit.sportpursuit as sp
test_sql_string = "select * from example_table limit 10;"
sp.GetData.get_redshift_data(test_sql_string)

Please note that you will have to have environment variables saved that match the form of "redshift_password" and "redshift_username" for the function to read data, or else be in a cloud environment.

# Description of functions present in package

## Get Redshift Data

### The purpose of this function is to take a sql query as input and return a dataframe with the results of that query. It will attempt to read in credentials automatically as part of this and will fail if none can be found. Example usage:

test_sql_string = "select * from example_table limit 10;"
sp.GetData.get_redshift_data(test_sql_string)

## Execute Redshift Command

### The purpose of this function is very similar to the get data function, however it differs in that it executes a command and doesn't return any data. This is used when you want to make Redshift do something internal, such as copying data into a table, or creating a new table etc. Example usage:

example_redshift_sql_command = "copy example_table from existing_table;"
sp.GetData.execute_redshift_command(example_redshift_sql_command)

## Project details

Uploaded source
Uploaded py3