Re: [Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Peter Rabbitson
On Mon, Apr 01, 2013 at 08:43:43AM -0400, Shea Levy wrote: > Hi all, > > In my db, a Project has many Jobs. I have a query on Projects where > I want to: > > 1. Sort the jobs of each project by a particular column on the Jobs table > 2. Only include jobs that satisfy some criterion, without exclu

[Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Shea Levy
Hi all, In my db, a Project has many Jobs. I have a query on Projects where I want to: 1. Sort the jobs of each project by a particular column on the Jobs table 2. Only include jobs that satisfy some criterion, without excluding projects where no such jobs exist (i.e. add a condition to JOI

Re: [Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Shea Levy
Hi Peter, On 04/01/2013 08:46 AM, Peter Rabbitson wrote: On Mon, Apr 01, 2013 at 08:43:43AM -0400, Shea Levy wrote: Hi all, In my db, a Project has many Jobs. I have a query on Projects where I want to: 1. Sort the jobs of each project by a particular column on the Jobs table 2. Only include

Re: [Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Peter Rabbitson
On Mon, Apr 01, 2013 at 08:54:55AM -0400, Shea Levy wrote: > Hi Peter, > > On 04/01/2013 08:46 AM, Peter Rabbitson wrote: > >On Mon, Apr 01, 2013 at 08:43:43AM -0400, Shea Levy wrote: > >>Hi all, > >> > >>In my db, a Project has many Jobs. I have a query on Projects where > >>I want to: > >> > >>1

Re: [Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Shea Levy
On 04/01/2013 08:58 AM, Peter Rabbitson wrote: On Mon, Apr 01, 2013 at 08:54:55AM -0400, Shea Levy wrote: Hi Peter, On 04/01/2013 08:46 AM, Peter Rabbitson wrote: On Mon, Apr 01, 2013 at 08:43:43AM -0400, Shea Levy wrote: Hi all, In my db, a Project has many Jobs. I have a query on Projects

Re: [Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Peter Rabbitson
On Mon, Apr 01, 2013 at 09:07:51AM -0400, Shea Levy wrote: > On 04/01/2013 08:58 AM, Peter Rabbitson wrote: > >On Mon, Apr 01, 2013 at 08:54:55AM -0400, Shea Levy wrote: > >>Hi Peter, > >> > >>On 04/01/2013 08:46 AM, Peter Rabbitson wrote: > >>>On Mon, Apr 01, 2013 at 08:43:43AM -0400, Shea Levy wr

Re: [Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread will trillich
Shea -- There may be a legacy code situation or some political barriers, but Peter's point is that you can modify both individual Result:: classes and ResultSet:: classes to make your scripts much more powerful and flexible. They're designed to work this way, which is why each Result class contain

Re: [Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Shea Levy
Hi Peter, On 04/01/2013 09:37 AM, Peter Rabbitson wrote: On Mon, Apr 01, 2013 at 09:07:51AM -0400, Shea Levy wrote: On 04/01/2013 08:58 AM, Peter Rabbitson wrote: On Mon, Apr 01, 2013 at 08:54:55AM -0400, Shea Levy wrote: Hi Peter, On 04/01/2013 08:46 AM, Peter Rabbitson wrote: On Mon, Apr

Re: [Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Octavian Rasnita
From: "Peter Rabbitson" > what is so scary/undesirable about "modifying the schema" ? > > That is a real question - you are not the first to word things thusly. I > need to figure out where the fear to add an extra definition is coming > from. > > Cheers I can tell you my source of fear of