#!/bin/bash
set -e

source ~/cloud-env.sh

mysql \
   --comments -u "${SERVERLESS_CLUSTER_USERNAME}" -p"${SERVERLESS_CLUSTER_PASSWORD}" \
   -h ${SERVERLESS_CLUSTER_HOST} -P ${SERVERLESS_CLUSTER_PORT} \
   --ssl-mode=VERIFY_IDENTITY --ssl-ca=/etc/ssl/certs/ca-certificates.crt\
   -D ${SERVERLESS_CLUSTER_DATABASE_NAME} <<EOF
USE ${SERVERLESS_CLUSTER_DATABASE_NAME};
UPDATE books SET stock = stock+1 WHERE id = 1;
ALTER TABLE books ADD COLUMN (valid_for_training INT);
EOF