#!/usr/bin/perl
#
#
# Benchmark script for Steve's marc db schema


use DBI;


my $dbh=DBI->connect("dbi:mysql:kohabenchmark", 'root', 'testpass');

my $count=$ARGV[0];
my $print=$ARGV[1];
my $bibid=$ARGV[2];


for ($i=0; $i<$count; $i++) {
    ($bibid) || ($bibid=int(rand(79998))+1);

    ($print) && (print "BIBID: $bibid\n");
    my $sth=$dbh->prepare("select tagid,tag,subfieldcode,subfieldvalue from marc_2XX_subfield_table where bibid=$bibid order by tagid,subfieldorder");
    $sth->execute;
    my $lasttag='';
    while (my ($tagid,$tag,$subfieldcode,$subfieldvalue) = $sth->fetchrow) {
	if ($tag ne $lasttag) {
	    ($print) && (print "  Tag: $tag\n");
	    $lasttag=$tag;
	}
	($print) && (print "    $subfieldcode $subfieldvalue\n");
    }
    $bibid=0;
}