コード例 #1
0
<?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) {
コード例 #2
0
<?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++) {