On Thu, Jun 17, 2010 at 10:42, Dave Howorth <[email protected]> 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

_______________________________________________
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: http://www.grokbase.com/group/[email protected]

Reply via email to