[Dbix-class] Using update on a resultset with join

I'm stuck with (at the moment) version 0.08011 of DBIC, so please let me know if a newer version addresses this issue. I'm creating a resultset of source 'Foo', joining against one or more other sources, and then trying to update, assuming that the update would work against 'Foo' and not the

[Dbix-class] Multiple DBs, one Schema to rule them all

Hello, I am investigating whether DBIC has support for switching between logical databases (ala 'use db1; ...; use db2; ...;'). I've a situation where there exist many cloned databases (same DDL), one per customer. The current model is that all customers share the same front-end, and it

Re: [Dbix-class] Module versioning

Robert Kinyon wrote: On Thu, Apr 14, 2011 at 11:14, Octavian Rasnita orasn...@gmail.com wrote: From: Robert Kinyon rob.kin...@gmail.com At $work, we build RPMs of the stuff we depend on. Then, we build RPMs of our stuff with dependencies on the RPMs we built of CPAN modules. Then, we have our

Re: [Dbix-class] connecting to different environments

Rob Kinyon wrote: On Fri, Sep 9, 2011 at 11:30, Alan Humphrey alan.humph...@comcast.net wrote: Hi – I’m wondering how people are handling connecting to different databases, e.g. dev vs. test vs. production. Is there a technique that’s considered “best practice”? Configuration files are good

Re: [Dbix-class] connecting to different environments

Trevor Leffler wrote: Rob Kinyon wrote: On Fri, Sep 9, 2011 at 11:30, Alan Humphrey alan.humph...@comcast.net wrote: Hi – I’m wondering how people are handling connecting to different databases, e.g. dev vs. test vs. production. Is there a technique that’s considered “best practice

Re: [Dbix-class] connecting to different environments

Alan Humphrey wrote: Hi – In a system like this (or in any system using config files) what does your connect statement look like? I’m imagining something like: my $schema = MyApp::Schema-connect(); or my $schema = MyApp::Schema-connect( $env_override ); where the logic in connect takes

Re: [Dbix-class] Join Three Tables With Aggregate Functions

Hi Scott, The cookbook has a section that should help you form subqueries in your search: http://search.cpan.org/dist/DBIx-Class-0.08121/lib/DBIx/Class/Manual/Cookbook.pod#Correlated_subqueries Note how a subquery can return a column max (or sum in your case) while referencing the outer

Re: [Dbix-class] sub resultset in Template Toolkit presented as an array, not a resultset

On 02/04/2015 09:23 AM, Peter Rabbitson wrote: On 02/04/2015 06:14 PM, Chris Welch wrote: ... However, in my template (having stashed |$divisions|), I'm unable to access the grid_positions_filled object because division.team_seaons gives me an arrayref of team resultsets in that division:

[Dbix-class] How to deal with right joins while under test/sqlite

Up until recently I've been exclusively using a mysql database. I've started writing tests using Test::DBIx::Class, which loads my schema into an in-memory sqlite database. I got it working after making a few minor code changes to my Result/ResultSet classes. For example, I had to replace the

Re: [Dbix-class] How to deal with right joins while under test/sqlite

...@lists.scsys.co.uk] On Behalf Of Trevor Leffler Sent: Friday, November 3, 2017 12:56 PM To: dbix-class@lists.scsys.co.uk Subject: [Dbix-class] How to deal with right joins while under test/sqlite Up until recently I've been exclusively using a mysql database. I've started writing tests using Test

Re: [Dbix-class] Multi-tennant application/data and dbix-class

challenging. Best, Trevor Leffler Sr. Software Engineer and Scrum Master | University of Washington Office of Educational Assessment tleff...@uw.edu | 206.616.1479 -Original Message- From: dbix-class-boun...@lists.scsys.co.uk [mailto:dbix-class-boun...@lists.scsys.co.uk] On Behalf Of Aaron