QBit::Application::Model::DB::clickhouse - Class for working with ClickHouse DB.
Class for working with ClickHouse DB. It's not ORM.
https://github.com/QBitFramework/QBit-Application-Model-DB-clickhouse
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]} }, }, );
Arguments:
$filter - filter (perl variables)
%opts - additional options
type - type (AND/OR NOT)
Return values:
$filter - object (QBit::Application::Model::DB::Filter)
my $filter = $app->clickhouse->filter([id => '=' => \23]);
%hash - options
without_table_alias - boolean(default: false)
$query - object (QBit::Application::Model::DB::clickhouse::Query)
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`
To install QBit::Application::Model::DB::clickhouse, copy and paste the appropriate command in to your terminal.
cpanm
CPAN shell
perl -MCPAN -e shell install QBit::Application::Model::DB::clickhouse
For more information on module installation, please visit the detailed CPAN module installation guide.