#!/bin/bash

MYSQL_USERNAME=$1
MYSQL_PASSWORD=$2
MYSQL_DATABASE=$3

mysql -u $MYSQL_USERNAME -p$MYSQL_PASSWORD $MYSQL_DATABASE -e "SHOW FULL TABLES WHERE table_type='VIEW';" 2>/dev/null \
| grep "VIEW" \
| awk '{print $1}' \
| xargs -I view_name \
bash -c "mysql -u $MYSQL_USERNAME -p$MYSQL_PASSWORD $MYSQL_DATABASE -e 'SHOW CREATE VIEW view_name;' 2>/dev/null" \
| grep -v "^View" \
| sed -r 's/\b(\w+)\b\s+(.*)\s+\b(\w+)\b\s*\b(\w+)\b\s*$/DROP VIEW IF EXISTS \1;\n\2;/g'