Re: [Dbix-class] Generating DISTINCT ON with sub query

2013-04-03 Thread Rippl, Steve
On Wed, Apr 3, 2013 at 8:55 AM, Peter Rabbitson wrote: > On Wed, Apr 03, 2013 at 08:41:05AM -0700, Rippl, Steve wrote: > > Have I given you enough info? > > I think so but I want to make sure I got it right. Tell me if the thing > below is correct: > > $course_section

Re: [Dbix-class] Generating DISTINCT ON with sub query

2013-04-03 Thread Rippl, Steve
On Wed, Apr 3, 2013 at 2:46 AM, Peter Rabbitson wrote: > On Tue, Apr 02, 2013 at 08:20:34PM -0700, Rippl, Steve wrote: > > I have something like the following > > > > $self->search( > > $search, > > { join =&

[Dbix-class] Generating DISTINCT ON with sub query

2013-04-02 Thread Rippl, Steve
I have something like the following $self->search( $search, { join => [ { 'course' => [ { course_coursetypes => 'type' }, { course_grades => 'grade' }, 'course_locations',

[Dbix-class] Re: New many-to-many warnings

2012-12-10 Thread Rippl, Steve
OK, my bad! I had previously manually defined many-to-many relations for a couple of the tables and now they're being autogenerated with the same names. Sorry! On Thu, Dec 6, 2012 at 8:17 PM, Rippl, Steve wrote: > Hi, > > I have a Catalyst app using DBIx::Class and just upd

[Dbix-class] New many-to-many warnings

2012-12-06 Thread Rippl, Steve
Hi, I have a Catalyst app using DBIx::Class and just updated to latest versions and suddenly I'm getting warnings when loading the schema from our Postgres DB that I hadn't seen before DBIx::Class is up to date. (0.08204) DBIx::Class::Schema::Loader is up to date. (0.07033) *

Re: [Dbix-class] multiple database connection

2011-10-21 Thread Rippl, Steve
On Fri, Oct 21, 2011 at 7:52 AM, Roland Philibert wrote: > > Hi all, > Could anybody send me an example on how to connect multiple databases > using DBIC::Schema? > > I have: > > package MyApp::Model::DB; > > use strict; > use base 'Catalyst::Model::DBIC::Schema'; > > __PACKAGE__->config( >sch