#!/usr/local/bin/php -q
<?php
set_time_limit(1200);
if ($argc<2||$argc>4) die("Usage:\n\n mktestdb tablename [rows [cols]]\n\n");
$tablename = $argv[1];
if ($argc>=3) $rows = $argv[2];
else $rows = 1000;
if ($argc==4) $cols = $argv[3];
else $cols = 1;

function make_seed() {
    list($usec, $sec) = explode(' ', microtime());
    return (float) $sec + ((float) $usec * 100000);
}
srand(make_seed());

$filename = "/usr/share/dict/words";
$fp = fopen($filename,"r");
$body = fread($fp,filesize($filename));
$lines = explode("\n",$body);
$count = count($lines);
$query = "create table $tablename (\n";
for ($i=0;$i<$cols;$i++){
	$query.="\tcol_".$i;
	$query.=" text";
	if ($i<$cols-1) $query.=", \n";
	else $query.="\n";
}
$query.=");";

print $query."\n\n";

print "-- Data for $tablename\n\n";

print "COPY $tablename (";
for ($i=0;$i<$cols;$i++){
	print "col_".$i;
	if ($i<$cols-1) print ",";
}
print ") FROM STDIN;\n";



for ($i=0;$i<$rows;$i++){
	for ($j=0;$j<$cols;$j++){
		$k=rand(0,$count-1);
		print $lines[$k];
		if ($j<$cols-1) print "\t";
	}
	print "\n";
}
print '\.';
print "\n";
?>