<?
/**
 *  Este script foi criado para  alimentar o dicionario com valores aleatorios
 *  o primeiro paramentro sao as tags... o | divide os dicionarios.
 */


$connect = pg_connect("host=localhost port=5432 dbname=gnuteca3 user=postgres");

$fields     = isset($_SERVER['argv'][1]) ? $_SERVER['argv'][1] : "100.a,700.a|650.a";
$nContent   = isset($_SERVER['argv'][2]) ? $_SERVER['argv'][2] : 1000;
$nContentR  = isset($_SERVER['argv'][3]) ? $_SERVER['argv'][3] : 10;

$listF = explode("|", $fields);

$contentId  = 1;
$contentRId = 1;

pg_query($connect, "delete from gtcdictionaryrelatedcontent");
pg_query($connect, "delete from gtcdictionarycontent");
pg_query($connect, "delete from gtcdictionary");

foreach ($listF as $i => $campos)
{
    $id = $i+1;

    pg_prepare($connect, "my_query_$id", "insert into gtcdictionary (dictionaryid, description, tags, readonly) values ($1, $2, $3, $4)");
    pg_execute($connect, "my_query_$id", array($id, "Dictionary $id", $campos, 'f'));

    for($x = 0; $x < $nContent; $x++)
    {
        pg_prepare($connect, "my_query_Content_{$id}_{$x}", "insert into gtcdictionarycontent (dictionarycontentid, dictionaryid, content) values ($1, $2, $3)");
        pg_execute($connect, "my_query_Content_{$id}_{$x}", array($contentId, $id, "Dictionary Content $id $x"));

        for($x2=0; $x2<$nContentR; $x2++)
        {
            pg_prepare($connect, "my_query_ContentR_{$id}_{$x}_{$x2}", "insert into gtcdictionaryrelatedcontent (dictionaryrelatedcontentid, dictionarycontentid, relatedcontent) values ($1, $2, $3)");
            pg_execute($connect, "my_query_ContentR_{$id}_{$x}_{$x2}", array($contentRId, $contentId, "Dictionary Content  Related $id $x $x2"));

            $contentRId++;
            echo ".";
        }

        $contentId++;
    }
}

?>