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.