function pull() {
    HOST=$1
    REMOTE_DB=$2
    LOCAL_DB=$3
    # pull database into docker container
    echo "Downloading database from $HOST..."
    ssh deploy@$HOST "mysqldump $REMOTE_DB" > dump.sql

    echo "Dropping database ${LOCAL_DB} from your Docker host and creating it again..."
    docker-compose exec -T mysql mysql -e "DROP DATABASE ${LOCAL_DB}; CREATE DATABASE ${LOCAL_DB};"

    echo "Writing downloaded database to your Docker host..."
    cat dump.sql | docker-compose exec -T mysql mysql $LOCAL_DB

    # rsync assets
    echo "Downloading assets from $HOST..."
    RSYNC_SRC=deploy@$HOST:/var/www/html/public/assets/*
    RSYNC_DEST=./public/assets/
    rsync -avz $RSYNC_SRC $RSYNC_DEST
}

function push() {
    HOST=$1
    REMOTE_DB=$2
    LOCAL_DB=$3
    # push database up to server
    echo "Getting database from Docker..."
    docker-compose exec -T mysql mysqldump ${LOCAL_DB} > dump.sql

    echo "Dropping database ${REMOTE_DB} from ${HOST} and creating it again..."
    SQL=$(printf "DROP DATABASE \`%s\`; CREATE DATABASE \`%s\`;" "${REMOTE_DB}" "${REMOTE_DB}" )
    ssh deploy@$HOST "mysql -e '${SQL}'"

    echo "Sending database to ${HOST}..."
    cat dump.sql | ssh deploy@$HOST "mysql $REMOTE_DB"

    # rsync assets
    echo "Sending assets to $HOST..."
    RSYNC_SRC=./public/assets/*
    RSYNC_DEST=deploy@$HOST:/var/www/html/public/assets/
    rsync -avz $RSYNC_SRC $RSYNC_DEST
}