Name

QBit::Application::Model::DB::clickhouse - Class for working with ClickHouse DB.

Description

Class for working with ClickHouse DB. It's not ORM.

GitHub

https://github.com/QBitFramework/QBit-Application-Model-DB-clickhouse

Install

• cpanm QBit::Application::Model::DB::clickhouse

• apt-get install libqbit-application-model-db-clickhouse-perl (http://perlhub.ru/)

Example:

  __PACKAGE__->meta(
      tables => {
          stat => {
              fields => [
                  {name => 'date', type => 'Date',},
                  {name => 'hits', type => 'UInt32',},
              ],
              engine => {MergeTree => ['date', [',' => ['date', 'hits']], \8192]}
          },
      },
  );

Package methods

filter

Arguments:

• $filter - filter (perl variables)

• %opts - additional options

  • type - type (AND/OR NOT)

Return values:

• $filter - object (QBit::Application::Model::DB::Filter)

Example:

  my $filter = $app->clickhouse->filter([id => '=' => \23]);

query

Arguments:

• %hash - options

  • without_table_alias - boolean(default: false)

Return values:

• $query - object (QBit::Application::Model::DB::clickhouse::Query)

Example:

  my $table = $app->clickhouse->stat;

  my $query = $app->clickhouse->query();
  $query->_field_to_sql(undef, 'hits', $table); # `stat`.`hits`

  my $query2 = $app->clickhouse->query(without_table_alias => TRUE);
  $query->_field_to_sql(undef, 'hits', $table); # `hits`

Internal packages

QBit::Application::Model::DB::clickhouse::Field - class for ClickHouse fields;

QBit::Application::Model::DB::clickhouse::Query - class for ClickHouse queries;

QBit::Application::Model::DB::clickhouse::Table - class for ClickHouse tables;

QBit::Application::Model::DB::clickhouse::dbi - class for ClickHouse DBI;

QBit::Application::Model::DB::clickhouse::st - class for ClickHouse sth;