[Dbix-class] combining tables

Rob Kinyon rob.kinyon at gmail.com
Thu Jun 17 14:48:02 GMT 2010


On Thu, Jun 17, 2010 at 10:42, Dave Howorth <dhoworth at mrc-lmb.cam.ac.uk> wrote:
> Rob Kinyon wrote:
>> That's called a view. Use that keyword when searching.
>
> My google-foo apparently isn't strong enough. My searching hasn't thrown
> up any hits that look relevant. Can you give me a bigger hint please? Or
> even an actual URL.

A view is a database concept that provides a table-like thing from a
user-defined query. DBIx::Class supports them on the client-side as
well if your DBMS does not.

>> Though, I'd seriously consider refactoring your schema.
>
> Agreed. Sadly, it's not my schema to refactor. I just have read access.

DBIx::Class views are the way to go. Look in the ResultSource documentation.

Rob



More information about the DBIx-Class mailing list