#!/bin/sh

print_usage() {
  echo "Usage:

  $0 [COMMAND] [ARG...]

Exemplo:

  ./sprinklr start

Comandos:

  start                       Inicializar os servidores
                              (php5, mysql etc)
  -------------------------------------------------------------
  stop                        Finalizar os servidores
  -------------------------------------------------------------
  build                       Faz o build inicial do projeto
                              (rodar apenas na primeira vez)
  -------------------------------------------------------------
  rebuild                     Caso queira resetar o projeto,
                              rodar este comando
  -------------------------------------------------------------
  ssh                         Entrar no servidor
  -------------------------------------------------------------
  status                      Mostra se o servidor está
                              rodando (state=running)
  -------------------------------------------------------------
  db                          Entrar no banco de dados
  -------------------------------------------------------------
  dbdrop                      Apagar banco de dados (perigoso)
  -------------------------------------------------------------
  dbrestore  [arquivo]        Subir banco de dados
  -------------------------------------------------------------
  dbdump     [arquivo]        Exporta banco e joga em db/dumps
  -------------------------------------------------------------
  dbmigrate                   Para subir migrations
  -------------------------------------------------------------
  dbrollback [nome]           Reverter uma migration
  -------------------------------------------------------------
  dbtables                    Exibir tabelas do banco
  -------------------------------------------------------------
  dbdescribetable [nome]      Exibir estrutura da tabela
  -------------------------------------------------------------
  dbstatus                    Status das migrations

" >&2
}

OPTION="help"

case "$1" in
    # This is a flag type option. Will catch either -f or --foo
    start)
      vagrant resume
    ;;
    stop)
      vagrant suspend
    ;;
    ssh)
      vagrant ssh
    ;;
    build)
      vagrant up
    ;;
    rebuild)
      vagrant destroy
    ;;
    dbmigrate)
      vagrant ssh -c "cd /vagrant/sites;php vendor/bin/phinx migrate -e development"
    ;;
    dbrollback)
      vagrant ssh -c "cd /vagrant/sites;php vendor/bin/phinx rollback -e development -t $2"
    ;;
    dbstatus)
      vagrant ssh -c "cd /vagrant/sites;php vendor/bin/phinx status -e development"
    ;;
    dbtables)
      vagrant ssh -c "echo \"use sprinklr;show tables;\" | mysql -uroot -ppassword"
    ;;
    dbdescribetable)
      vagrant ssh -c "echo \"use sprinklr;DESCRIBE $2;\" | mysql -uroot -ppassword"
    ;;
    status)
      vagrant global-status | grep "sprinklr\|provider"
    ;;
    db)
      vagrant ssh -c "mysql -uroot -ppassword"
    ;;
    dbdump)
      DUMP_DIR='/vagrant/sites/db/dumps/'
      if [ "$2" = "" ]; then
        echo "vc precisa informar o nome do dump \nexemplo; \n\n./sprinklr dbdump my-dump"
        exit 3
      fi
      vagrant ssh -c "mysqldump -uroot -ppassword --databases sprinklr > $DUMP_DIR/$2"

    ;;
    dbrestore)
      DUMP_DIR='/vagrant/sites/db/dumps/'
      if [ "$2" = "" ]; then
        echo "vc precisa informar o nome do dump \nexemplo; \n\n./sprinklr dbrestore my-dump"
        exit 3
      fi
      vagrant ssh -c "echo \"CREATE DATABASE sprinklr;\" | mysql -uroot -ppassword"
      vagrant ssh -c "mysql -uroot -ppassword sprinklr < $DUMP_DIR/$2"

    ;;
    dbdrop)
      vagrant ssh -c "echo \"DROP DATABASE sprinklr;\" | mysql -uroot -ppassword"
      echo "---------------------"
      vagrant ssh -c "echo \"SHOW DATABASES;\" | mysql -uroot -ppassword"
      echo "---------------------"
    ;;
    *)
    # Do whatever you want with extra options
    echo "comando '$1' não existe!"
    print_usage
    ;;
esac
# Shift after checking all the cases to get the next option
shift