#!/bin/bash

DBFILE="/root/generated-db.sql"
TOTALRECORDS=700000
RECORDSPERLINE=1000

echo '-- MySQL dump 10.13  Distrib 5.5.9, for Win32 (x86)' > $DBFILE
echo '--' >> $DBFILE
echo '-- Host: cadev01    Database: Tester' >> $DBFILE
echo '-- ------------------------------------------------------' >> $DBFILE
echo '-- Server version            5.5.14-log' >> $DBFILE
echo '' >> $DBFILE
echo '' >> $DBFILE
echo '/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;' >> $DBFILE
echo '/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;' >> $DBFILE
echo '/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;' >> $DBFILE
echo '/*!40101 SET NAMES utf8 */;' >> $DBFILE
echo '/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;' >> $DBFILE
echo "/*!40103 SET TIME_ZONE='+00:00' */;" >> $DBFILE
echo '/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;' >> $DBFILE
echo '/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;' >> $DBFILE
echo '/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;' >> $DBFILE
echo '/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;' >> $DBFILE
echo '' >> $DBFILE
echo '--' >> $DBFILE
echo '-- Current Database: `Tester`' >> $DBFILE
echo '--' >> $DBFILE
echo '' >> $DBFILE
echo 'CREATE DATABASE /*!32312 IF NOT EXISTS*/ `Tester` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;' >> $DBFILE
echo '' >> $DBFILE
echo 'USE `Tester`;' >> $DBFILE
echo '' >> $DBFILE
echo '--' >> $DBFILE
echo '-- Table structure for table `Test`' >> $DBFILE
echo '--' >> $DBFILE
echo '' >> $DBFILE
echo 'DROP TABLE IF EXISTS `Test`;' >> $DBFILE
echo '/*!40101 SET @saved_cs_client     = @@character_set_client */;' >> $DBFILE
echo '/*!40101 SET character_set_client = utf8 */;' >> $DBFILE
echo 'CREATE TABLE `Test` (' >> $DBFILE
echo '  `TestId` int(11) NOT NULL AUTO_INCREMENT,' >> $DBFILE
echo '  `Message` varchar(1000) NOT NULL,' >> $DBFILE
echo '  PRIMARY KEY (`TestId`)' >> $DBFILE
echo ") ENGINE=InnoDB AUTO_INCREMENT=1225104 DEFAULT CHARSET=latin1 COMMENT='Test';" >> $DBFILE
echo '/*!40101 SET character_set_client = @saved_cs_client */;' >> $DBFILE
echo '' >> $DBFILE
echo '--' >> $DBFILE
echo '-- Dumping data for table `Test`' >> $DBFILE
echo '--' >> $DBFILE
echo '' >> $DBFILE
echo 'LOCK TABLES `Test` WRITE;' >> $DBFILE
echo '/*!40000 ALTER TABLE `Test` DISABLE KEYS */;' >> $DBFILE


# Loop through the 2nd loop 28 times
# Each inner loop drops 25,000 records onto a line
#for a in $(seq 2); do
	for i in $(seq 0 $(($TOTALRECORDS - 1))); do
		TEMPNUMBER=$(($i % $RECORDSPERLINE))
		if [ $TEMPNUMBER == 0 ]; then
			printf 'INSERT INTO `Test` VALUES ' >> $DBFILE
		else
			printf ', ' >> $DBFILE
		fi
		printf "( $(($i + 1)),'Swamping Message Swamping Message Swamping Message Swamping Message ')" >> $DBFILE
		if [ $TEMPNUMBER == $(($RECORDSPERLINE - 1)) ]; then
			printf ';\n' >> $DBFILE
		fi
	done
#done

echo '/*!40000 ALTER TABLE `Test` ENABLE KEYS */;' >> $DBFILE
echo 'UNLOCK TABLES;' >> $DBFILE
echo '/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;' >> $DBFILE
echo '' >> $DBFILE
echo '/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;' >> $DBFILE
echo '/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;' >> $DBFILE
echo '/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;' >> $DBFILE
echo '/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;' >> $DBFILE
echo '/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;' >> $DBFILE
echo '/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;' >> $DBFILE
echo '/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;' >> $DBFILE
echo '' >> $DBFILE
echo '-- Dump completed on 2011-10-05 13:39:50' >> $DBFILE


printf "all done \n"