#!/bin/bash

MYSQL_HOST=graphs.cao0umbvcdjq.us-east-1.rds.amazonaws.com
MYSQL_USER=graphs
MYSQL_PASS=graphs
MYSQL_DB=testdb

MYSQL_CLIENT="mysql -h $MYSQL_HOST -u$MYSQL_USER -p$MYSQL_PASS $MYSQL_DB"

# create table
$MYSQL_CLIENT -e "DROP TABLE names; CREATE TABLE names (
  id int(11) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"

for i in {0..500}; do
  uuid=`uuidgen`
  echo "Write #$i... $uuid"
  $MYSQL_CLIENT -e "BEGIN; INSERT INTO names (name) VALUES ('$uuid'); COMMIT;"
done