---
name: "Class::DBI::Plugin::AbstractCount"
section: "3pm"
platform: "linux"
package: "libclass-dbi-plugin-abstractcount-perl"
version: "0.08-3"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Class::DBI::Plugin::AbstractCount"
---

# Class::DBI::Plugin::AbstractCount(3pm)

get COUNT(\*) results with abstract SQL

## NAME

Class::DBI::Plugin::AbstractCount - get COUNT(\*) results with abstract SQL

## SYNOPSIS

```
  use base 'Class::DBI';
  use Class::DBI::Plugin::AbstractCount;

  my $count = Music::Vinyl->count_search_where(
    { artist   => 'Frank Zappa'
    , title    => { like    => '%Shut Up 'n Play Yer Guitar%' }
    , released => { between => [ 1980, 1982 ] }
    });
```

## DESCRIPTION

This Class::DBI plugin combines the functionality from Class::DBI::Plugin::CountSearch (counting objects without having to use an array or an iterator), and Class::DBI::AbstractSearch, which allows complex where-clauses a la SQL::Abstract.

## METHODS

### count\_search\_where

Takes a hashref with the abstract where-clause. An additional attribute hashref can be passed to influence the default behaviour: arrayrefs are OR'ed, hashrefs are AND'ed.

## TODO

More tests, more doc.

## SEE ALSO

- SQL::Abstract for details about the where-clause and the attributes.

  - Class::DBI::AbstractSearch

  - Class::DBI::Plugin::CountSearch

  ## AUTHOR

Jean-Christophe Zeus, \<mail@jczeus.com\> with some help from Tatsuhiko Myagawa and Todd Holbrook.

## COPYRIGHT AND LICENSE

Copyright (C) 2004 by Jean-Christophe Zeus

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.