Robert, maybe you want "as_query" ? http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as_query
On Thu, May 10, 2018 at 2:00 PM, Robert Rothenberg <rob...@gmail.com> wrote: > It looks like the only way to use multiple-column subqueries in > DBIx::Class is to define a virtual view, e.g. the SYNOPSIS in > https://metacpan.org/pod/DBIx::Class::ResultSource > > If there is a better way to do this, I haven't found it online. > > Assuming that is the way... I am wondering if it's possible to create a > new result source class at runtime (and if so, how). > > My thinking is that given a resultset, use that information to create a > new result class that can be used as a result source (e.g. subquery). > > > > > > _______________________________________________ > 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/ > dbix-class@lists.scsys.co.uk >
_______________________________________________ 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/dbix-class@lists.scsys.co.uk