#!/bin/bash
read -p "MySQL username: " USERNAME
stty -echo
read -p "MySQL password: " PASSWORD
stty echo
DB=$(basename `pwd`)
echo
echo "Using DB $DB..."
if [[ $# != 3 ]]; then
  echo usage: $0 [yyyy] [mm] [dd]
  exit -1
fi
r="([0-9]+)_([0-9]+)_([0-9]+)_*"
for f in $(pwd)/*.sql; do
  [[ $f =~ $r ]]
  (( ${BASH_REMATCH[1]} >= $1 )) &&
  (( ${BASH_REMATCH[2]} >= $2 )) &&
  [[ $( expr ${BASH_REMATCH[3]} \>= $3 ) == 1 ]] &&
  echo "updating: $(basename $f)" &&
  mysql -u$USERNAME -p"$PASSWORD" $DB < $f
done