Ejemplo n.º 1
0
<?php

$status = array("cancelado", "em espera", "processando", "concluído");
$car_id = 0;
$loc_id = 0;
for ($i = 1; $i <= $_REQUEST["registros"]; $i++) {
    //Campos gerados para a tabela TRANSACTION.
    if ($i % 3 == 0 || $i == 1) {
        $tra_lat = Faker\Geo::latitude(\Faker\Geo\SaoPaulo::bounds());
        $tra_lon = Faker\Geo::longitude(\Faker\Geo\SaoPaulo::bounds());
        $usr_token = md5(uniqid(rand(), true));
        $car_id++;
        $loc_id++;
    }
    $tra_confirmationcode = md5(uniqid(rand(), true));
    $tra_date = (int) (microtime(true) * 1000);
    //$tra_date = (int) (rand(1400965802, microtime(true)) * 1000);
    $tra_status = $status[array_rand($status)];
    $tra_value = number_format(mt_rand() / mt_getrandmax() * 1000, 2);
    try {
        $statement = $connection->queryAsync('INSERT INTO ' . $namespace . ' (
                    usr_token,
                    tra_id,
                    car_id,
                    loc_id,
                    tra_confirmationcode,
                    tra_date,
                    tra_lat,
                    tra_lon,
                    tra_status,
                    tra_value,
Ejemplo n.º 2
0
    }
    $limite = floor($porcentagem / 100 * count($rows1));
    $response2 = $connection->querySync('SELECT *
                                      FROM ' . $namespace . " WHERE tra_alt = 'n'" . 'LIMIT ' . $limite);
    $rows2 = $response2->fetchAll();
} catch (Cassandra\Exception $e) {
    //echo 'Caught exception: ',  $e->getMessage(), "\n";
    //exit;
}
foreach ($rows2 as $row) {
    $usr_token[] = $row["usr_token"];
    $tra_id[] = $row["tra_id"];
}
$dados = array_combine($tra_id, $usr_token);
$dados = array_unique($dados);
foreach ($dados as $tra_id => $usr_token) {
    //recupera lista de dados alterados no momento
    $ids[] = $tra_id;
    try {
        $statement = $connection->querySync('UPDATE ' . $namespace . ' SET tra_alt = :tra_alt,
                tra_lat = :tra_lat,
                tra_lon = :tra_lon
            WHERE usr_token = ' . "'" . $usr_token . "'" . ' AND tra_id = ' . $tra_id, [new Cassandra\Type\Varchar("s"), new Cassandra\Type\Float(Faker\Geo::latitude(\Faker\Geo\NewYork::bounds())), new Cassandra\Type\Float(Faker\Geo::longitude(\Faker\Geo\NewYork::bounds()))]);
        $update = $statement->fetchAll();
        $tokenAnterior = $row["usr_token"];
    } catch (Cassandra\Exception $e) {
        //echo 'Caught exception: ',  $e->getMessage(), "\n";
        //exit;//if connect failed it may be good idea not to continue
    }
}
$ids = implode(",", $ids);