Re: [Dbix-class] What's the best way to join with an aggregated query in DBIC

It sounds like you are doing a correlated subquery -- take a look at DBIx::Class::Helper::ResultSet::CorrelateRelationship (thank you so much frew!) On Wed, Jan 27, 2021 at 5:50 AM Veesh Goldman wrote: > have you tried ->as_subselect_rs? That should be what you're looking for. > Just make sure

Re: [Dbix-class] Restore old behavior of DBIx::Class::Loader

"Aux" is not a special prefix in DBICL -- did some of your table names change? You can override how some of the names work with a configuration file -- see all the options documented in DBIx::Class::Schema::Loader;:Base. I suspect you can do what you need with some entries in 'moniker_map'.

Re: [Dbix-class] Is this list dead?

It's neither nice nor not nice -- it's just practical, since there are lots of people that use irc every day and this channel does get a fair amount of traffic with people asking questions. If irc isn't your thing, please feel free to use the list instead. But I do encourage you to give irc a

Re: [Dbix-class] Twitter accounts

I can't vote as I don't have a twitter account. I vote for the option where people can actually cooperate in a group where $size > 1. I think Jess deserves an apology here. Reasonable communication could have been had, but instead there was none, with the implication that she was holding the

Re: [Dbix-class] Avé! Duci Novo, Similis Duci Seneci!*

On Tue, Jan 23, 2018 at 6:59 AM, John SJ Anderson wrote: > > Could you please turn on issue submission (it seems to be disabled at the > moment > ​) > ​Why? rt.cpan.org is better: 1. that's where all the existing bugs are, so to start creating new issues in a new location

Re: [Dbix-class] VOTE: Relinquish firstcome rights to Peter Rabbitson

I have questions, before I vote: - Is there an official response from Peter Rabbitson regarding this proposal? - Is there an official response from the current comaint-bit holders (FREW, ILMARI, JROBINSON, MSTROUT)? - What would the upcoming development plans be if this vote failed? If this

Re: [Dbix-class] PROPOSAL: merging Haarg's patch and making it easier to do simple merges / emergency fixes

I vote yes on proposal 1 (https://github.com/dbsrgits/dbix-class/pull/114 should be merged), so long as (as discussed) the documentation is suitably amended to allow such a merge. I vote no on proposal 2, to allow immediate merge and release of "obvious" changes. I would be more likely to

Re: [Dbix-class] VOTE: Removing bootstrap phase

I vote yes to the proposal. -et...@cpan.org On Sat, Jan 13, 2018 at 1:16 PM, Darren Duncan wrote: > I vote +1. > > > ___ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class >

Re: [Dbix-class] View Definitions for non-virtual views

If they were dumped as comments rather than strings, then there would be no runtime impact, but you still get the documentation benefit. I'd certainly make use of such an option, as I sometimes perform a dump just to confirm that there were no surprising side effects to a change I made, and do

Re: [Dbix-class] Governance: Proposal A is adopted

The exact vote count was 50-2-1. Here is the tally of votes: https://gist.github.com/karenetheridge/dc2f217e5064e08b34c443fdb89b5ae0 ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN:

Re: [Dbix-class] ★ VOTE NOW: DBIC Governance andNamespace Control ★

Proposal A. ___ 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

Re: [Dbix-class] Decision time: which fork inherits the existing DBIx::Class namespace

Me too. Since now we know that Peter has nothing more to add to the proposal, let's get on with it. On Sat, Dec 3, 2016 at 12:23 PM, Dave Cross wrote: > On 03/12/2016 08:36, Chisel wrote: > > Sorry, I'm just sick of all this , and want to move forward. >> > > +1 > > I'm

Re: [Dbix-class] An answer and a question

Happy [American] Thanksgiving! On Mon, Nov 14, 2016 at 3:24 AM, Peter Rabbitson wrote: > On 11/14/2016 06:11 AM, Darren Duncan wrote: > >> >> I would be interested to see Peter address this, in particular, to >> either affirm or deny etc that he emailed Mark in May, and

Re: [Dbix-class] Alternative proposals proposal

I don't see how more people would either "dilute responsibility" nor destabilize the team. For example, consider the people who hold comaint on the Moose namespace: https://metacpan.org/author/DOY https://metacpan.org/author/DROLSKY https://metacpan.org/author/ETHER

Re: [Dbix-class] IMPORTANT: A discussion of DBIC governance and future development

el "fREW" Schmidt) ILMARI (Dagfinn Ilmari Mannsåker) JROBINSON (Jess Robinson; castaway) MSTROUT (Matt Trout; mst) RIBASUSHI (Peter Rabbitson) - Karen Etheridge, et...@cpan.org On Mon, Oct 3, 2016 at 1:37 PM, David Golden <x...@xdg.me> wrote: > Hello, DBIC community. > > I

Re: [Dbix-class] Joining the same table several times with different conditions each join

On Sat, May 17, 2014 at 11:01:59AM +0100, Andrew Beverley wrote: I'd like to join the same table multiple times, with different conditions each join (and a variable number of joins). If you define each of your join permutations as a relationship, you can bring in the joins using that/those

Re: [Dbix-class] Memory leak when connect string has utf8 flag set

On Sun, Feb 16, 2014 at 01:31:51AM +0100, Roman Daniel wrote: Tracing some memory leak I found that my DBIC code leaks when the connection string is utf8 flagged. This is my favourite go-to article for finding a leak: http://blog.woobling.org/2009/05/become-hero-plumber.html I've found several

[Dbix-class] constructing a query where fields are compared to each other

I'm trying to figure out how to construct a WHERE clause [1] like: ... WHERE field_x - field_y = 1 Is this possible? The best guess I have is: { '1' = [ '-' = { -ident = 'field_x' }, { -ident = 'field_y' } ] } ...but this expands to: ( 1 = ? OR 1 = me.field_x

Re: [Dbix-class] constructing a query where fields are compared to each other

On Wed, Oct 16, 2013 at 08:13:34PM -0400, Rob Kinyon wrote: It's good you showed all the code because the extended comparison in a join relationship isn't possible. (It's one of ribasushi's many in-progress branches. Patches most definitely welcome here.) However, this is definitely possible