Re: [RDBO] Best way to do sum, max, avg, group by

2006-08-30 Thread Kurt Hansen
> On 8/30/06, Kurt Hansen <[EMAIL PROTECTED]> wrote: >> I need to do sum, max, avg, group by on columns in my database. However, >> I'm not sure the best way to do it in RDBO. John Siracusa wrote: > If you want > to support customization of the query, you can use some undocumented > features of

Re: [RDBO] Best way to do sum, max, avg, group by

2006-08-30 Thread John Siracusa
On 30 Aug 2006 13:30:12 -0700, Randal L. Schwartz wrote: > > "John" == John Siracusa <[EMAIL PROTECTED]> writes: > John> package My::Product::Manager; > John> ... > John> sub get_average_prices_by_type > John> { > John> my($class) = shift; > > John> my $meta = My::Product->meta

Re: [RDBO] Best way to do sum, max, avg, group by

2006-08-30 Thread Randal L. Schwartz
> "John" == John Siracusa <[EMAIL PROTECTED]> writes: John> package My::Product::Manager; John> ... John> sub get_average_prices_by_type John> { John> my($class) = shift; John> my $meta = My::Product->meta; Shouldn't that be $class->meta, in case you want to subclass and hors

Re: [RDBO] limiting returned fields on a join ?

2006-08-30 Thread Jonathan Vanasco
On Aug 30, 2006, at 2:55 PM, John Siracusa wrote: > A more flexible (but more verbose and explicit) alternative is to use > the "select" parameter to get_objects(). That'll let you cherry-pick > your columns from all tables involved in the query. Check the > Rose::DB::Object::Manager::get_object

Re: [RDBO] limiting returned fields on a join ?

2006-08-30 Thread John Siracusa
On 8/30/06, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > I don't need the whole record, nor do I need an object.I just > need Link, under certain circumstances, to be aware of the hex_id > value in the corresponding Useraccount page > > Is there any way to do this , without loading an entire o

[RDBO] limiting returned fields on a join ?

2006-08-30 Thread Jonathan Vanasco
I'm not sure this can be done in Rose, as it probably departs from the methodology too much I have 2 tables with corresponding Rose Objects The relevant info is here Useraccount id Link id useraccount_id [ references user

Re: [RDBO] Best way to do sum, max, avg, group by

2006-08-30 Thread Kurt Hansen
John Siracusa wrote: > On 8/30/06, Kurt Hansen <[EMAIL PROTECTED]> wrote: >> I need to do sum, max, avg, group by on columns in my database. However, >> I'm not sure the best way to do it in RDBO. The count() method in >> Manager makes me think that there may be some pre-existing methods to do >>

Re: [RDBO] Best way to do sum, max, avg, group by

2006-08-30 Thread John Siracusa
On 8/30/06, Kurt Hansen <[EMAIL PROTECTED]> wrote: > I need to do sum, max, avg, group by on columns in my database. However, > I'm not sure the best way to do it in RDBO. The count() method in > Manager makes me think that there may be some pre-existing methods to do > these tasks. > > If not, is

[RDBO] Best way to do sum, max, avg, group by

2006-08-30 Thread Kurt Hansen
Hello, I need to do sum, max, avg, group by on columns in my database. However, I'm not sure the best way to do it in RDBO. The count() method in Manager makes me think that there may be some pre-existing methods to do these tasks. If not, is it best to create a method using QueryBuilder and M