Get sql_alchemy_conn details from Airflow

dump_sql_from_airflow.sh

#!/usr/bin/env bash
# Parsing airflow.cfg for Mysql details
export MYSQL_USER=$(grep sql_alchemy_conn /home/airflow/airflow.cfg|cut -d ":" -f 2|sed 's,//,,g')
export MYSQL_PASSWORD=$(grep sql_alchemy_conn /home/airflow/airflow.cfg|cut -d ":" -f 3|cut -d '@' -f 1)
export MYSQL_DATABASE=$(grep sql_alchemy_conn /home/airflow/airflow.cfg|cut -d ":" -f 3|cut -d '@' -f 2|cut -d '/' -f2)
export MYSQL_HOST=$(grep sql_alchemy_conn /home/airflow/airflow.cfg|cut -d ":" -f 3|cut -d '@' -f 2|cut -d '/' -f1)
# querieng data 
ocker run --rm -ti  -v "$PWD/data":/data  mysql:5 sh -c "exec mysql  -u$MYSQL_USER -p\"$MYSQL_PASSWORD\" -h $MYSQL_HOST  -D $MYSQL_DATABASE"

# dumping data
docker run --rm -ti  -v "$PWD/data":/data  mysql:5 sh -c "exec mysqldump  --single-transaction --quick --no-data --lock-tables=false -u$MYSQL_USER -p\"$MYSQL_PASSWORD\" -h $MYSQL_HOST --dump-date --databases $MYSQL_DATABASE > /data/all-databases.sql"