PHPackages                             chocofamilyme/bigquery - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. chocofamilyme/bigquery

ActiveLibrary[Database & ORM](/categories/database)

chocofamilyme/bigquery
======================

Библиотека для работы с BigQuery

2.0.0(6y ago)1445[1 PRs](https://github.com/chocofamilyme/bigquery/pulls)BSD-3-ClausePHPPHP >= 7.0.0

Since Nov 26Pushed 6y ago3 watchersCompare

[ Source](https://github.com/chocofamilyme/bigquery)[ Packagist](https://packagist.org/packages/chocofamilyme/bigquery)[ Docs](https://github.com/chocofamilyme/bigquery)[ RSS](/packages/chocofamilyme-bigquery/feed)WikiDiscussions master Synced 2d ago

READMEChangelog (6)Dependencies (2)Versions (12)Used By (0)

Библиотека для работы с BigQuery
================================

[](#библиотека-для-работы-с-bigquery)

### Возможности

[](#возможности)

- Вставка данных в таблицу BigQuery
- Выполнение запросов в BigQuery

### Требования

[](#требования)

- Phalcon 3.x+
- PHP 7.0+

### Настройка

[](#настройка)

Для работы с библиотекой нужно создать конфигурационный файл analytics со следующими полями

#### analytics.php

[](#analyticsphp)

```
...
return new \Phalcon\Config([
    'analytics' => [
        'dataset'       => 'holding',
        'queueName'     => 'analytics',
        'exchangeType'  => 'direct',

        'undeliveredDataModel' => \Helper\Analytics\Models\UndeliveredDataMock::class,
        'connection' => [
            'keyFilePath' => __DIR__.'/_data/keys/key.json',
            //'keyFile'     => {},
        ],
        'mappers' => [
            'tableName' => \Chocofamily\Analytics\NullMapper::class,
        ],

        'repeater'    => [
            'attempt' => 5,
            'exclude' => [
                \InvalidArgumentException::class,
                \Google\Cloud\Core\Exception\NotFoundException::class,
            ],
        ],

        'pathStorage' => __DIR__.'/storage',
    ],
]);
...
```

В файле `test/bootstrap.php` есть пример добавления конфига в DI.

### Пример миграции для модели UndeliveredData

[](#пример-миграции-для-модели-undelivereddata)

```
$table = $this->table('undelivered_data');
$table->addColumn('table_name', 'string', ['null' => false]);
$table->addColumn('data', 'text', ['null' => false]);
$table->addColumn('status', 'integer', ['default' => 0, 'limit' => 1]);
$table->addTimestamps()->create();
```

### Пример потоковой вставки данных в BigQuery

[](#пример-потоковой-вставки-данных-в-bigquery)

```
$bufferSize = 50;
$validator = new SenderValidator();
$streamer    = new StreamerWrapper($validator, $bufferSize)

$mapperClass = $this->config['mappers']->get($body['table_name'], NullMapper::class);
$mapper = new $mapperClass;

$streamer->setMapper($mapper);
$streamer->validator->setClientData($data);
$streamer->send();
```

### Вставка данныых с помощью задания

[](#вставка-данныых-с-помощью-задания)

Используется для загрузки большого объма данных, например отчетов.

```
$validator = new SenderValidator();
$runner    = new RunnerWrapper($validator)

$mapperClass = $this->config['mappers']->get($body['table_name'], NullMapper::class);
$mapper = new $mapperClass;

$runner->setMapper($mapper);
$runner->validator->setClientData($data);
$runner->send();
```

### Пример переотправки и удаления недоставленных данных

[](#пример-переотправки-и-удаления-недоставленных-данных)

```
$limit = 100;

$analytics = $this->getDI()->getShared('config')->analytics->toArray();
$provider  = new BigQuery($analytics);

do {
    $undeliveredDataService = new UndeliveredData($analytics->undeliveredDataModel);
    $undeliveredDataSet = $undeliveredDataService->findAllUndelivered($limit);

    foreach ($undeliveredDataSet as $undeliveredData) {
        $data = \json_decode($undeliveredData->data, true);
        $bigQuery->setTable($undeliveredData->table_name);
        if ($provider->insert($data)) {
            $undeliveredData->delete();
        }
    }
} while ($undeliveredDataSet->count() >= $limit);
```

### Отправка запроса в BigQuery

[](#отправка-запроса-в-bigquery)

Если в запросе не указать LIMIT, по умолчанию подставится LIMIT 100

```
$query = "SELECT * FROM holding.chocolife_test WHERE created_at = \"2018-11-20\" LIMIT 100"
$provider = new BigQuery($this->getDI()->getShared('config')->analytics->toArray());
$result = $provider->runQuery($query);
```

###  Health Score

29

—

LowBetter than 60% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity62

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~57 days

Recently: every ~71 days

Total

6

Last Release

2437d ago

Major Versions

0.0.3 → 1.0.02018-12-11

1.0.1 → 2.0.02019-09-10

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/42729426?v=4)[Chocofamily](/maintainers/chocofamilyme)[@chocofamilyme](https://github.com/chocofamilyme)

---

Top Contributors

[![Vadim89](https://avatars.githubusercontent.com/u/3715929?v=4)](https://github.com/Vadim89 "Vadim89 (4 commits)")

---

Tags

phalconbigquery

###  Code Quality

TestsCodeception

### Embed Badge

![Health badge](/badges/chocofamilyme-bigquery/health.svg)

```
[![Health](https://phpackages.com/badges/chocofamilyme-bigquery/health.svg)](https://phpackages.com/packages/chocofamilyme-bigquery)
```

###  Alternatives

[prologuetech/big

Google BigQuery for Laravel

1687.4k](/packages/prologuetech-big)[denchikby/phalcon-mongodb-odm

Phalcon MongoDB ODM

4212.8k](/packages/denchikby-phalcon-mongodb-odm)[zachleigh/yarak

Laravel inspired devtools for Phalcon. Database migrations, model factories and database seeders.

293.8k](/packages/zachleigh-yarak)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)