git checkout main && make build

pushd examples/local

./101_initial_cluster.sh

func exec_migration() {
  ddl=${1}
  echo "Executing: ${ddl}..."
  uuid=$(command mysql --no-defaults -N -h 127.0.0.1 -P 15306 -e "set @@ddl_strategy=vitess; ${ddl};")

  while command mysql --no-defaults -N -h 127.0.0.1 -P 15306 -e "show vitess_migrations like '${uuid}'" commerce 2> /dev/null | grep -q -v "complete"; do
    echo -e "\twaiting for migration to complete"
    sleep 1
  done
}

exec_migration "CREATE TABLE commerce.mytt (id int unsigned not null, name varchar(120) not null, js1 JSON, PRIMARY KEY (id))"
exec_migration "ALTER TABLE commerce.mytt ADD COLUMN js2 JSON"
exec_migration "ALTER TABLE commerce.mytt MODIFY name VARCHAR(60) NULL"