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 excluding

[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

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. Sort the jobs of

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 wrote: Hi all,

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

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 rabbit+d...@rabbit.us 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