cho45 (さとう) > Teng-0.21 > Teng::Plugin::Count

Download:
Teng-0.21.tar.gz

Dependencies

Annotate this POD

Website

View/Report Bugs
Source   Latest Release: Teng-0.25

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.

syntax highlighting: