#!/bin/bash
if [ $# -ne 1 ]
then
	echo "usage: $0 name@domain.sth"
	exit -1;
fi
echo "populating db for user $1"

dbName='testDB.db'
sqlite="sqlite3"
JIDs=('andrew@gmail.com' 'john@gmail.com' 'carol@redcode.com' 'nick@foss.org' 'james@random.org')
selfJID=$1
randomWords=('cheese' 'house' 'berry' 'tree' 'glass' 'door' 'music' 'work')  

baseStatement="INSERT INTO messages('message', 'fromBare', 'fromResource', 'toBare', 'toResource', 'type', 'time') VALUES("
baseMessage="Message from: "

firstDay=1
lastDay=8
month=6

$sqlite -line $dbName "CREATE TABLE IF NOT EXISTS messages('message' STRING, 'fromBare' INTEGER, 'fromResource' STRING, 'toBare' INTEGER, 'toResource' STRING, 'type' INTEGER, 'time' INTEGER, 'offset' INTEGER);"

$sqlite -line $dbName "CREATE TABLE IF NOT EXISTS jids('id' INTEGER PRIMARY KEY ASC AUTOINCREMENT, 'jid' STRING UNIQUE NOT NULL);"

$sqlite -line $dbName "INSERT INTO jids('jid') VALUES('$selfJID');" 

for (( id=2; id<${#JIDs[@]} + 2; id++ ))
do
	echo $id
	$sqlite -line $dbName "INSERT INTO jids('jid') VALUES('${JIDs[$((id - 2))]}');" 
	for (( i=$firstDay; i<lastDay; i++ ))
	do
			for (( r=0; r < $((RANDOM%29)); r++ ))
			do
				for (( c=0; c < $((RANDOM%12)); c++ ))
				do
				date=$(date --date="$month/$i/12" +%s)
				message="$baseMessage$month/$i/12:$c ${randomWords[$((RANDOM%100))]}"
				statement="$baseStatement '$message', $id, '', 1, '', 0, $((date + c * 30 + 3600 * 8)));"
				$sqlite -line $dbName "$statement" 
			done

			for (( c=0; c < $((RANDOM%12)); c++ ))
			do
				date=$(date --date="$month/$i/12" +%s)
				message="$baseMessage$month/$i/12:$c ${randomWords[$((RANDOM%100))]}"
				statement="$baseStatement '$message', 1, '', $id, '', 0, $((date + c * 60 + 3600 * 8)));"
				$sqlite -line $dbName "$statement" 
			done
		done
	done
done