PHP populate_prepare_queries Examples

Example #1

File: test_concurrence.php Project: regilero/PostgreSQL-formation-pratique

function populate($dbconn)
{
    populate_prepare_queries($dbconn);
    echo "->Choose commande:";
    $com_id = populate_choose_min_commande($dbconn);
    echo $com_id . "\n";
    echo "->Generating\n";
    for ($i = 1; $i <= NUMBER_OF_COMMANDES; $i++) {
        echo ".";
        if (0 == $i % (int) SHOW_STEP) {
            echo '[' . $i . ']';
        }
        populate_modify_quantity_in_ligne_commande($dbconn, $com_id);
        detect_incoherence($dbconn, $com_id);
        if (0 == $i % (int) SHOW_STEP) {
            echo "\n";
        }
    }
}

Example #2

File: populate_app.php Project: regilero/PostgreSQL-formation-pratique

function populate($dbconn)
{
    if (DROP_ALL_COMMANDS_BEFORE) {
        echo "->Cleaning up previous commands (...)\n";
        pg_query($dbconn, 'DELETE FROM COMMANDES');
    }
    if (INITIALIZE_POINTS) {
        echo "->Put everyone to score 0\n";
        pg_query($dbconn, 'UPDATE vue_drh_points SET points=0');
    }
    echo "->Generating\n";
    populate_prepare_queries($dbconn);
    for ($i = 1; $i <= NUMBER_OF_COMMANDES; $i++) {
        echo ".";
        if (0 == $i % (int) SHOW_STEP) {
            echo '[' . $i . ']';
        }
        $per_id = populate_choose_personnel($dbconn);
        populate_create_commande($dbconn, $per_id);
        if (0 == $i % (int) SHOW_STEP) {
            echo "\n";
        }
    }
}