18F / identity-analytics-etl

ETL and SQL scripts for Login.gov data warehouse and business intelligence
10 stars 6 forks source link

Add funnel view query and a cmd tools to execute query #200

Closed MacHu-GWU closed 5 years ago

MacHu-GWU commented 5 years ago

labels: task

Summary

Addresses Issue LG-965

  1. implements funnel view query version1, without remember_device=True
  2. create a command line tools to execute query with parameters.

Please note if fully resolves the issue per the acceptance criteria: Y

Describe the pull request here, including any supplemental information needed to understand it.

the command line tools, use query name to specify which sql file to execute. the query name is defined in rsq.py file. please read the doc string in rsq.sh and rsq.py to understand how it works.

rsq stands for redsfhit query.

How to test: bash tests/test_rsq.sh # password = 'password'

This pull request changes...

This pull request is ready to merge when...

MacHu-GWU commented 5 years ago

@lauraGgit test added.

How to test are also documented.

MacHu-GWU commented 5 years ago

Use #204 to replace this PR