#!/bin/bash

BUILD_DIR=$(realpath "$1")

MYSQL="$BUILD_DIR/bin/mysql"
MYCNF="$BUILD_DIR/mysql-test/var/my.cnf"

MASTER_SOCKET=$(awk '
/\[mysqld\.1\]/ {f=1;next}
/^\[/ {f=0}
f && /^socket=/ {
  sub(/^socket=/,"")
  print
  exit
}
' "$MYCNF")

for i in $(seq 100 500)
do
    $MYSQL -uroot --socket="$MASTER_SOCKET" \
      -e "INSERT INTO test.t1 VALUES($i);"

    echo "Inserted $i"
    sleep 1
done
