Name

QBit::Application::Model::DB::clickhouse::dbi - Class for ClickHouse DBI.

Description

Implements dbi methods for ClickHouse driver.

Package methods

new

Arguments:

• %opts - connection options: host, port, database, user, password, timeout, db(QBit::Application::Model::DB::clickhouse)

Return values:

• $dbh - object (QBit::Application::Model::DB::clickhouse::dbi)

Example:

            

              
              
my $dbh = QBit::Application::Model::DB::clickhouse::dbi->new(
    host     => '127.0.0.1',
    port     => 8123,
    database => 'default',
    user     => 'default',
    password => '',
    timeout  => 300,
    db       => $app->clickhouse
);
            
          

prepare

Arguments:

• $sql - string (SQL)

Return values:

• $sth - object (QBit::Application::Model::DB::clickhouse::st)

Example:

            

              
              
my $sth = $dbh->prepare('SELECT 1');
            
          

do

Arguments:

• $sql - string (SQL)

• $attr - hash ref (additional attributes)

• @params - array (parameters to binding)

Return values:

• $boolean - (true on success; false otherwise)

Example:

            

              
              
$dbh->do('INSERT INTO `state` (`date`, `hits`) VALUES ("2017-09-03", 35)')
  or die $dbh->err() . ': ' . $dbh->errstr();