Skip to content

README.md

Latest commit

 

History

History
30 lines (15 loc) · 1.07 KB

README.md

File metadata and controls

30 lines (15 loc) · 1.07 KB

data-wrangling-with-python-and-sql

A CLI app which use programmatic access to the database sql server.

Usage

  • git clone https://github.com/bngom/data-wrangling-with-python-and-sql

  • cd data-wrangling-with-python-and-sql

  • py -m venv env Create a virtual environment

  • .\env\Scripts\activate Activate the virtual environment

  • pip install . Install the setup for the command line interface

  • pysql-cli --help To check the usage of the CLI. Will also install requirements.

  • pysql-cli generate-last-survey-structure Create a file lastsurveystructure.csv in db folder

  • pysql-cli get-last-survey-structure Get the last known survey structure

  • pysql-cli get-view-surveydata Check if the view vw_AllSurveyData exists

  • pysql-cli update-survey-structure "YOUR QUERY" Trigger the view creation (on INSERT, UPDATE or DELETE on SurveyStructure table)

    • example pysql-cli update-survey-structure "DELETE FROM SurveyStructure WHERE SurveyId = 2 AND QuestionId = 3"

  • pysql-cli get-view-surveydata Returns data from vw_AllSurveyData