Get sql execution result as .txt and csv(UTG-8 or shift_jis for excel format). Available for python3.6+
DEMO:
- Python 3.6.6 or above
$ git clone https://github.com/norabal/fabric_sql
if you have anaconda...
$ conda create -n fabric_sql python=3.6 pip
$ conda activate fabric_sql
$ pip install -r requirements.txt
if you don't...
$ python3 -m venv venv
$ source venv/bin/activate
$ pip install -r requirements.txt
After the above processes, do following these steps.
- Copy config.ini.sample as 'config.ini'.
- Edit 'config.ini'
- Write sql on 'exec.py'.
- Execute remote_sql task with set keys.
text file:
csv file:
excel file:
if you want to extract sql result from staging environment with csv format for excel.
$ fab --set dest=stg,format=excel remote_sql