Name

QBit::QueryData - Query constructor for the data.

GitHub

https://github.com/QBitFramework/QBit-QueryData

Install

• cpanm QBit::QueryData

• apt-get install libqbit-querydata-perl (http://perlhub.ru/)

Methods

• new - created object. Params:

  • data - data.

  • fields - default fields (optional, defualt all fields)

  • filter - default filter (optional, default all data)

  • definition - fields definition (optional, default 'string')

  Example:

  my $q = QBit::QueryData->new(
      data => [
          {
              id      => 1,
              caption => 'c1',
              data    => {
                  k1 => 1.1,
                  k2 => 'd1_2'
              },
          },
          {
              id      => 2,
              caption => 'c2',
              data    => {
                  k1 => 2.1,
                  k2 => 'd2_2'
              },
          },
      ],
      fields => [qw(id caption)],
      filter => ['OR', [{id => 1}, ['caption' => '=' => \'c2']]],
      definition => {
          'id'      => {type => 'number'},
          'caption' => {type => 'string'},
          'data.k1' => {type => 'number'},
          'data.k2' => {type => 'string'},
      },
  );

• fields - set fields for request

  Example:

  $q->fields([qw(caption)]); # or $q->fields({caption => ''});
  
  $q->fields([]); # use default fields
  
  $q->fields(); # all fields

• get_fields - get fields

  Example:

  my $fields = $q->get_fields(); # ['caption', 'id']

• filter - set filter for request

  Types:

  • number: "=" "<>" "!=" ">" ">=" "<" "<=" "IN" "NOT IN" "IS" "IS NOT"

  • string: "=" "<>" "!=" ">" ">=" "<" "<=" "IN" "NOT IN" "IS" "IS NOT" "LIKE" "NOT LIKE"

  For list: "=" "<>" "!=" "IN" "NOT IN"

  Example:

  $q->filter({id => 1, caption => 'c1'}); # or ['AND', [['id' => '=' => \1], ['caption' => '=' => \'c1']]]
  
  $q->filter(['caption' => 'LIKE' => \'c']);
  
  $q->filter(); # all data

• definition - set fields definition

  Example:

  $q->definition({
      'id'      => {type => 'number'},
      'caption' => {type => 'string'},
      'data.k1' => {type => 'number'},
      'data.k2' => {type => 'string'},
  });

• order_by - set order sorting

  Example:

  # Ascending
  $q->order_by(qw(id caption data.k1)); # or (['id', 0], ['caption', 0], ['data.k1', 0])
  
  # Descending
  $q->order_by(['id', 1]);

• limit - set offset and limit

  Example:

  $q->limit($offset, $limit);
  
  $q->limit(); # all data

• found_rows - data count

  Example:

  my $rows = $q->found_rows(); # 2

• distinct - set/reset only unique elements

  Example:

  #set
  $q->distinct(1); # or $q->distinct();
  
  #reset
  $q->distinct(0);

• insensitive - set/reset insensitive mode for LIKE

  Example:

  #set
  $q->insensitive(1); # or $q->insensitive();
  
  #reset
  $q->insensitive(0);

• get_all - get data by settings

  Example:

  my $data = $q->get_all();
  
  $data = $q->fields([qw(id)])->filter(['caption' => 'LIKE' => \'c'])->order_by(['id', 1])->get_all();

• all_langs - support interface DB::Query

• calc_rows - support interface DB::Query

• for_update - support interface DB::Query