[Phpgroupware-cvs] phpgwapi/inc/adodb/tests/testgenid.php, 1.1.2.1

[nomail]

Update of /phpgwapi/inc/adodb/tests
Added Files:
        Branch: proposed-0_9_18-branch
          testgenid.php

date: 2004/12/30 04:51:48;  author: skwashd;  state: Exp;  lines: +36 -0

Log Message:
switch to ADOdb
=====================================================================
<?php
/*
        V4.50 6 July 2004 
        
        Run multiple copies of this php script at the same time
        to test unique generation of id's in multiuser mode
*/
include_once('../adodb.inc.php');
$testaccess = true;
include_once('testdatabases.inc.php');

function testdb(&$db,$createtab="create table ADOXYZ (id int, firstname 
char(24), lastname char(24), created date)")
{
        $table = 'adodbseq';
        
        $db->Execute("drop table $table");
        //$db->debug=true;
        
        $ctr = 5000;
        $lastnum = 0;
        
        while (--$ctr >= 0) {
                $num = $db->GenID($table);
                if ($num === false) {   
                        print "GenID returned false";
                        break;
                }
                if ($lastnum + 1 == $num) print " $num ";
                else {
                        print " <font color=red>$num</font> ";
                        flush();
                }
                $lastnum = $num;
        }
}
?>