项目作者: habracoder

项目描述 :
PHP ClickHouse Builder
高级语言: PHP
项目地址: git://github.com/habracoder/ch-builder.git
创建时间: 2018-06-07T19:15:29Z
项目社区:https://github.com/habracoder/ch-builder

开源协议:

下载


PHP QueryBuilder for ClickHouse SQL

Simple query builder

Building insert query

  1. $data = [
  2. ['id' => 123, 'clicks' => 1],
  3. ['id' => 124, 'clicks' => 1],
  4. ];
  5. $sql = (string) $qb
  6. ->insert($data)
  7. ->into('statistic_clicks')
  8. ->database('analytics');

Building select query

  1. $sql = (string) $qb
  2. ->select('date', 'id', 'clicks')
  3. ->from('statistic_clicks')
  4. ->database('analytics')
  5. ->where(
  6. $qb->expr()->andX(
  7. $qb->expr()->eq('id', 123),
  8. $qb->expr()->gt('clicks', 10)
  9. )
  10. );