Name

QBit::Application::Model::DB::mysql - Class for working with MySQL DB.

Description

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

GitHub

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

Install

• cpanm QBit::Application::Model::DB::mysql

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

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->db->filter([id => '=' => \23]);

get_dbh

No arguments.

Returns DBI object.

Return values:

• $dbh - object (DBI::db)

Example:

  my $dbh = $app->db->get_dbh();

query

No arguments.

Create and returns a new query object.

Return values:

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

Example:

  my $query = $app->db->query();

transaction

Arguments:

• $sub - reference to sub

Example:

  $app->db->transaction(sub {
      # work with db
      ...
  });

Internal packages

QBit::Application::Model::DB::mysql::Field - class for MySQL fields;

QBit::Application::Model::DB::mysql::Query - class for MySQL queries;

QBit::Application::Model::DB::mysql::Table - class for MySQL tables;

cpanm QBit::Application::Model::DB::mysql

perl -MCPAN -e shell
install QBit::Application::Model::DB::mysql