Re: [Dbix-class] Paging all re nested sets

would put myself in the 'tweak' and 'test' category. Charlie -- Charlie Garrison [EMAIL PROTECTED] PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc/rfc1855.txt

Re: [Dbix-class] Paging all re nested sets

-- Charlie Garrison [EMAIL PROTECTED] PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc/rfc1855.txt ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC

Re: [Dbix-class] Configuration query - Catalyst::Model::DBIC::Schema

-- Charlie Garrison [EMAIL PROTECTED] PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc/rfc1855.txt ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC

[Dbix-class] DBIC tests for where attribute in relations

} $cheesy_cds1a-all], [map { $_-id } $cheesy_cds2a-all], 'we got the same Tags', ) or diag(Expected: \n, (map { $_-id.\n } $cheesy_cds1a-all) , Got: \n, (map { $_-id.\n } $cheesy_cds2a-all) , ); -- Charlie Garrison [EMAIL PROTECTED] PO Box

Re: [Dbix-class] Searching - two criteria for the same field

-- Charlie Garrison garri...@zeta.org.au PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc/rfc1855.txt ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC

Re: [Dbix-class] Question the Book Authors

; it simply renames an exiting thread (thread hijacking). The correct procedure is to create a new message. Charlie -- Charlie Garrison garri...@zeta.org.au PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc

Re: [Dbix-class] applying check constraint

on a field. I think you're looking for DBIx::Class::Validation. http://search.cpan.org/perldoc?DBIx::Class::Validation Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au 〠 PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http

Re: [Dbix-class] DBIC equivalent to DBIx::OO::Tree?

; and I don't believe I got a commit bit. Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au 〠 PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc/rfc1855.txt

Re: [Dbix-class] Relationship to the same table

({type=$type}, {order_by='sort_idx'}); } Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au 〠 PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc/rfc1855.txt ___ List

Re: [Dbix-class] Relationship to the same table

record as a default. Anything you are wanting to define in the %attr for relationships can also be defined in your custom method. There is some fancy glue you don't get (eg. add_to_* methods), but for doing different queries the technique works a treat. Charlie -- Ꮚ Charlie Garrison

Re: [Dbix-class] Relationship to the same table

the M part of MVC can be. My controllers have gone on a serious diet. :-) Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au 〠 PO Box 141, Windsor, NSW 2756, Australia O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc/rfc1855.txt

Re: [Dbix-class] query for m:n relation

( { 'tags.id' = { -in = \...@tag_ids } }, { join = { 'picture_tags' = 'tags' } } ); Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http://www.ietf.org/rfc/rfc1855.txt

Re: [Dbix-class] Multiple joins, noob questions

::Class::Relationship#many_to_many Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http://www.ietf.org/rfc/rfc1855.txt ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo

Re: [Dbix-class] Breakage on .127 - .192 upgrade

= shift; my ($sqlt_table) = @_; to: my ($result_source, $sqlt_table) = @_; And things are working again. I was calling some methods from within sqlt_deploy_hook, which I changed to calling subs instead, since there is no $self available. Charlie -- Ꮚ Charlie Garrison ♊ garri

Re: [Dbix-class] Consistent column name aliasing?

#add_columns Look at the `accessor` attribute; don't know whether it will help with custom column names when doing a `search`. Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http://www.ietf.org/rfc/rfc1855.txt

Re: [Dbix-class] Is there a framework for translating raw database errors into human-readable errors

: https://metacpan.org/module/Data::FormValidator Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http://www.ietf.org/rfc/rfc1855.txt ___ List: http://lists.scsys.co.uk/cgi-bin

Re: [Dbix-class] Re: Prefetch and join on different tables

} = [$attr-{join}, 'mt']; $attr-{prefetch} = [$attr-{prefetch}, 'mc']; search($where, $attr}); Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http://www.ietf.org/rfc/rfc1855.txt

Re: [Dbix-class] transaction in a resultset class

Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http://www.ietf.org/rfc/rfc1855.txt ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http

Re: [Dbix-class] transaction in a resultset class

the recent the apparent complexity of it all ML thread where there has been much discussion about improving the docs. Contributions there would be most welcome. Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http

Re: [Dbix-class] best way to share schema elements?

way too much time doing so; I'm happy to contribute some docuentation; suggestions for what/where? Or does it already exist and I just couldn't find it, in which case some meta-docco may be needed. Thanks, Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop

Re: [Dbix-class] best way to share schema elements?

out great for my usage. Sounds like Moose will give you more benefits than DBIx::Class::Candy. Splitting functionality into roles will make your code easier to manage; I prefer that over easier to read. Charlie -- Ꮚ Charlie Garrison ♊ garri...@zeta.org.au O ascii ribbon campaign - stop

Re: [Dbix-class] Proper way to suppress die from DBIx::Class

= 'YourResultBase' Charlie -- Charlie Garrison garri...@zeta.org.au github.com/cngarrison metacpan.org/author/CNG O ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.org/rfc/rfc1855.txt ___ List: http

Re: [Dbix-class] Fastest method to check for key existence?

key_exists { my ($self, $key) = @_; my $row = $self-find( $key ); return $row ? 1 : 0; } Elsewhere: my $got_row = $schema-resultset('RSClass')-key_exists($key); Charlie -- Charlie Garrison garri...@zeta.org.au github.com/cngarrison metacpan.org/author/CNG O ascii ribbon

Re: [Dbix-class] scope in DBIx::Class::Core subclass

` sub: use String::Util 'trim'; .. return 'CALC: '.trim( $self-acolumn ); Or you need to call the sub with the package name as you were doing before: return 'CALC: '.String::Util::trim( $self-acolumn ); Charlie -- Charlie Garrison garri...@zeta.org.au github.com/cngarrison

Re: [Dbix-class] How to manage customer-specific / user-defined attributes?

sing the above tools, like I think about git and code repos. All the gnarly details are hidden, I just prepare db/schema/data updates (commit changes) and then *easily* upgrade db for designers/staging/production/etc. Charlie -- Charlie Garrison <garri...@zeta.org.au> g

Re: [Dbix-class] Supported Form library for use whith DBIx::Class?

comment on the other modules you mentioned. Charlie -- Charlie Garrison <garri...@zeta.org.au> github.com/cngarrison metacpan.org/author/CNG O< ascii ribbon campaign - stop html mail [Conundrum](http://www.ietf.org/rfc/rfc1855.txt) ___ L

Re: [Dbix-class] Clarification on the split-namespace proposal

of work over the past few years from the users (and me) during these past few weeks points to this.  Thanks Matt. That’s what I’ve been thinking during this conversation but wasn’t sure how to express it. +1 Peter Charlie -- Charlie Garrison <garri...@zeta.org.au> gith

Re: [Dbix-class] The email I didn't want to write.

something important, otherwise just walk away). Making the ‘the problem’ someone else just makes the situation harder for me; it’s much easier to fix myself than fix someone else. cng -- Charlie Garrison <garri...@zeta.org.au> github.com/cngarrison metacpan.org/auth

Re: [Dbix-class] GOVERNANCE: Aggregation and conclusion

On 30 Oct 2016, at 19:43, Andrew Beverley wrote: > Personally I would like to see a straightforward "A vs B" vote. Only > then will I consider this a fair decision. +1 -- Charlie Garrison <garri...@zeta.org.au> github.com/cngarrison m

Re: [Dbix-class] GOVERNANCE: Aggregation and conclusion

On 1 Nov 2016, at 19:48, Thomas Klausner wrote: > I think a fork will not work. The "old" DBIC will stagnate, the "new" > will not gain traction. Everybody loses. Agreed. Another, -1 Charlie -- Charlie Garrison <garri...@zeta.org.au> github.com/cnga

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

Proposal A cng -- Charlie Garrison <garri...@zeta.org.au> github.com/cngarrison metacpan.org/author/CNG ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.pe

Re: [Dbix-class] Deflating DateTime for searching purposes

n if you switch to a different db type, the storage engine will always return a parser which handles parsing/formatting dates in correct format. -cng -- Charlie Garrison <garri...@zeta.org.au> github.com/cngarrison metacpan.org/author/CNG _

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

+1 On 17 Jan 2018, at 23:48, Matthew Phillips wrote: > Per the process, the proposal has now been turned to a vote. -- Charlie Garrison <garri...@zeta.org.au> github.com/cngarrison metacpan.org/author/CNG ___ List: http://lists.sc

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

I vote yes. -cng On 14 Jan 2018, at 3:37, Tom Bloor wrote: Voting on PROPOSAL: Removing bootstrap phase[1], seconded by Kaitlyn Parkhurst[2]. -- Charlie Garrison <garri...@zeta.org.au> github.com/cngarrison metacpan.org/auth