NAME

Teng::Plugin::Count - Count rows in database.

NAME

            

              
              
package MyDB;
use parent qw/Teng/;
__PACKAGE__->load_plugin('Count');
package main;
my $db = MyDB->new(...);
$db->count('user'); # => The number of rows in 'user' table.
$db->count('user', '*', {type => 2}); # => SELECT COUNT(*) FROM user WHERE type=2
            
          

DESCRIPTION

This plugin provides shorthand for counting rows in database.

METHODS

$db->count($table[, $column[, \%where]]) : Int

$table table name for counting

$column Column name for COUNT(...), the default value is '*'.

\%where : HashRef for creating where clause. The format is same as $db->select(). This parameter is optional.

Return: The number of rows.