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 rabbit+d...@rabbit.uswrote: On Tue, Apr 02, 2013 at 08:20:34PM -0700, Rippl, Steve wrote: I have something like the following $self-search( $search, { join = [ { 'course

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 rabbit+d...@rabbit.uswrote: 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_rs-search

[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 rip...@woodlandschools.orgwrote: Hi, I have a Catalyst app using DBIx::Class and just

[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 rphilib...@aptina.comwrote: 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(