Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (herse.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: AW: performing count
Date: Mon, 4 Jun 2007 08:27:46 +0200
Message-ID: 
 <49D23F7404DC5B4086D7352312597E0F01115C6E@FNHH-SVMEXDB002.Freenet-AG.de>
Thread-Topic: performing count
Thread-Index: AcekY9gE9BAG4K46ToKG7z8qqLu83ACDX5Ag
From: =?iso-8859-1?Q?Peter_Schr=F6der?= <Peter.Schroeder@freenet-ag.de>
To: <user@cayenne.apache.org>

+1 from me=20

-----Urspr=FCngliche Nachricht-----
Von: Michael Gentry [mailto:blacknext@gmail.com]=20
Gesendet: Freitag, 1. Juni 2007 17:44
An: user@cayenne.apache.org
Betreff: Re: performing count

Looking at that CountQuery class makes me think we should actually add =
it to
Cayenne as a utility class.  Perhaps with two additional methods added:

public int getCount();
public int getCount(DataContext dc);


That way you could then do:

CountQuery query =3D new CountQuery(Artist.class);
int rowCount =3D query.getCount();

or even:

int rowCount =3D new CountQuery(Artist.class).getCount();

I think that would simplify things and needing a count is a pretty =
comment
activity.  Perhaps for more flexibility, it would be good to have a
constructor that could take a WHERE clause, too, in case you only need
counts matching certain criteria.

Thoughts?

/dev/mrg