Re: [Dbix-class] Duplication of records in many-to-many prefetch

2013-05-02 Thread Shea Levy
On 05/02/2013 02:25 AM, Peter Rabbitson wrote: On Wed, May 01, 2013 at 06:16:57PM -0400, Shea Levy wrote: Hi all, In my project, a user can have multiple roles and multiple users can have the same role. The username is the primary key for the users table. When I run a query like: ->sea

[Dbix-class] Duplication of records in many-to-many prefetch

2013-05-01 Thread Shea Levy
Hi all, In my project, a user can have multiple roles and multiple users can have the same role. The username is the primary key for the users table. When I run a query like: ->search({ 'me.username' => $username}, { columns => [ "me.fullname", "me.emailaddress", "me.username", "userro

Re: [Dbix-class] Test suites fail on sqlite upgrade

2013-04-15 Thread Shea Levy
Hi All, Any update on this? Thanks, Shea On 04/11/2013 06:14 PM, Shea Levy wrote: Hi Peter, On 04/11/2013 06:06 PM, Peter Rabbitson wrote: On Thu, Apr 11, 2013 at 01:47:23PM -0400, Shea Levy wrote: Hi, After updating sqlite from 3.7.14.1 to 3.7.16.1 (my package manager uses a system

Re: [Dbix-class] Test suites fail on sqlite upgrade

2013-04-11 Thread Shea Levy
Hi Peter, On 04/11/2013 06:06 PM, Peter Rabbitson wrote: On Thu, Apr 11, 2013 at 01:47:23PM -0400, Shea Levy wrote: Hi, After updating sqlite from 3.7.14.1 to 3.7.16.1 (my package manager uses a system sqlite for DBD::SQLite) Could you provide a basic instruction on how to build such a DBD

[Dbix-class] Test suites fail on sqlite upgrade

2013-04-11 Thread Shea Levy
, but the failure also occurs when building 0.08242-TRIAL. Thanks, Shea Levy ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive

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 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 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

[Dbix-class] Fine-tuning of prefetched relationships

2013-04-01 Thread Shea Levy
JOIN ON, not WHERE) Are either of these possible with a single search on Projects? Currently we're breaking it up into two queries. Thanks, Shea Levy ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-