<?php $_ENV['helpers_dir'] = 'helpers/'; $_ENV['db_xslt_create'] = $_ENV['helpers_dir'] . 'create.xslt'; $_ENV['db_xslt_drop'] = $_ENV['helpers_dir'] . 'drop.xslt'; $_ENV['beautify_dir'] = $_ENV['helpers_dir'] . 'beautifyphp/'; $_ENV['zipfile'] = 'build/com_fussball.zip'; $_ENV['src_db_dir'] = 'src/db/'; $_ENV['db_xml_file'] = $_ENV['src_db_dir'] . 'model/datenbank.xml'; $_ENV['sql_script_dir'] = 'src/com_fussball/admin/db/'; require_once 'helpers/beautify.php'; remove_dir('build'); mkdir('build'); createSQLScripts(); addStoredProcedures(); addViews(); copyUpdateScripts(); handleDir('src', 'build'); chdir('build'); exec('zip -r com_fussball.zip com_fussball'); function copyUpdateScripts() { exec('cp ' . $_ENV['src_db_dir'] . '/update/* ' . $_ENV['sql_script_dir']); } function addStoredProcedures() { $handle = fopen($_ENV['sql_script_dir'] . 'install.sql', 'a'); $d = dir($_ENV['src_db_dir'] . 'stored_procedure/'); while (false !== ($entry = $d->read())) { $endpos = strripos($entry, '.sql'); if ($endpos == strlen($entry) - 4) {
<?php global $auctions; global $faker; /*$auction = $auctions[0]; //var_dump($auction); addViews($auction, 1); return;*/ foreach ($auctions as $auction) { if ($numBids = $auction->getField("numBids")) { addViews($auction, $numBids * $faker->numberBetween(5, 50)); } else { addViews($auction, $faker->numberBetween(1, 50)); } } /** * @param $auction DbAuction * @param $numViews int */ function addViews($auction, $numViews) { global $faker; //var_dump($auction); $startTime = new DateTime($auction->getField("startTime")); $endTime = new DateTime($auction->getField("endTime")); //echo "startTime: " . $startTime->getTimestamp() . "\t"; //echo "endTime: " . $endTime->getTimestamp() . "\t"; date_sub($endTime, date_interval_create_from_date_string("5 seconds")); $timeDiff = (int) ($endTime->getTimestamp() - $startTime->getTimestamp()); //echo "timeDiff: ".$timeDiff . "\t"; for ($i = 0; $i < $numViews; $i++) {