PHP code example of ynizon / big

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

ynizon / big example snippets

$this->options = [
    'useLegacySql' => false,
    'useQueryCache' => false,
];

$datasetId = 'test';
$tableId = 'events';

// Create our BQ helper
$big = new Big();

// Create table, we will pass in a mocked model to mutate into BQ schema
// Note: create table will only make a new table if it does not exist

/** @var Google\Cloud\BigQuery\Table $table */
$table = $big->createFromModel($datasetId, $tableId, new Event());

// Let's stream our events into BQ in large chunks
// Note: notArchived() is a simple scope, use whatever scopes you have on your model
Event::notArchived()->chunk(1000, function ($events) use ($big, $table) {
    // Prepare our rows
    $rows = $big->prepareData($events);

    // Stream into BQ, you may also pass in any options with a 3rd param.
    // Note: By default we use: 'ignoreUnknownValues' => true
    $big->insert($table, $rows);

    // Get our current id's
    /** @var Illuminate\Support\Collection $events */
    $ids = $events->pluck('id')->toArray();

    // Update these event's as processed
    Event::whereIn('id', $ids)->update([
        'system_processed' => 1
    ]);
});

 bash
php artisan vendor:publish --provider="Prologuetech\Big\BigServiceProvider"

 php
Prologuetech\Big\BigServiceProvider::class,

 php
$query = 'SELECT count(id) FROM test.events';

$big = new Big();
$results = $big->run($query);

 php
$products = Product::whereIn("account_id",$accounts_id);
$arrLikeFields[] = "title";
$products = $products->where("title","LIKE","%".$q."%");
$sql = $big->bindCountQuery($query, array("products"), $arrLikeFields);

//Get count
$totalProducts = $big->run($sql);
$totalProducts = $totalProducts[0]["nb"];

//Get products
$sql = $big->bindQuery($query->orderBy("updated_at"), array("products"),15, $currentPage, $arrLikeFields);
$products = Big::unflipModel(new Product(), $big->run($sql));

$url = "/";
if (isset($_SERVER["REDIRECT_URL"])){
	$url = $_SERVER["REDIRECT_URL"];
}
$products = new LengthAwarePaginator($products, $totalProducts, 15, $currentPage, ['path'=>url($url)]);