git clone https://github.com/Kvas1988/skp_parse_sql.git
pip install -r requirements.txt
Also you should create config.toml file with DB_CONN parameter:
DB_CONN = 'oracle://user:[email protected]/dbname'
You can run script with given path to sql-file
python parse_reports.py -f path/to/query.sql
python parse_reports.py -f path/with/quries/
Or via python api
from sqlalchemy.engine import create_engine
from parse_reports import Parser
engine = create_engine("YOUR_DB_CREDS")
p = Parser("path/to/query", engine)
df = p.parse() # return is pandas DataFrame