#!/usr/bin/php -q
<?php 
/***************************************** "help large_table" output:
Name:                 large_table
Owner:                ingres10
Created:              12-aug-2009 18:15:22
Type:                 user table
Version:              II9.0

Column Information:
                                                                  Key
Column Name                      Type       Length Nulls Defaults Seq
id                               integer         4   no  identity   1
email                            varchar        32  yes    null
********************************************************************/

function genRandomString() {
  $length = 14;
  $characters = "0123456789abcdefghijklmnopqrstuvwxyz";
  $string = "";    
  for ($p = 0; $p < $length; $p++) {
    $string .= $characters[mt_rand(0, strlen($characters)-1)];
  }
  return $string;
} //getRandomString()

$every = 1000;
$count = 0;
$numQueries = 100;
$qc = 1;
$dbc = ingres_connect("school", "ingres10", "changeme");
if (is_resource($dbc)) {
  echo "Connection succeeded.\n";
  for ($i = 0; $i < 100000000; $i++) {
    $sql = "insert into large_table(email) values (?)";
    $email = genRandomString() . '@' . genRandomString() . ".eu";
    $params = array($email);
    $res = ingres_query($dbc, $sql, $params);
    if (!is_resource($res)) {
      trigger_error(ingres_error(), E_USER_ERROR);
      die("failure.");
    }
    ingres_commit($dbc);
    /*
    if ($qc == $numQueries) {
    ingres_commit($dbc);
      $qc = 1;
    } else {
      ++$qc;
    } // else
    */
    ++$count;
    if ($count == $every) {
      echo $email , "\n";
//    echo strlen($email), "\n";
      $count = 0;
    } // if
  } // for
  // final commit
} else {
  trigger_error(ingres_error(), E_USER_ERROR);
} // else
?>