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 github.com/cngarrison metacpan.org/author/CNG ___ List: http://lists.scsys.co.uk/cgi-bin/mail

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 github.com/cngarrison metacpan.org/author/CNG ___ List: http

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 github.com/cngarrison metacpan.org/author/CNG ___ List: http://lists

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

Proposal A cng -- Charlie Garrison 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.perl.org/repos/bast/DBIx-Class

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

(assuming 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 github.com/cngarrison metacpan.org/

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 github.com/cngarrison

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 github.com/cngarrison metacpa

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

nse amount 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 github.com/cngarrison me

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

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

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

t using 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 github.com/cngarrison metacpan.or

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

u need to either import the `trim` 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 --

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

ey_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 github.com/cngarrison metacpan.org/author/CNG O< ascii ribbon

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

uses), eg: result_base_class => 'YourResultBase' Charlie -- Charlie Garrison 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: ht

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

est-practice, but using roles is working 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 ♊ O< a

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

s, mailing list, etc. Before asking I thought I should clarify *what* I was asking, by which point I had answered it myself. But I spent 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

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 ♊ O< ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http://

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

how to get $schema. If you did read it, then which part of it is confusing? (There has been recent discussion about improving docs and a patch to make it clearer would be appreciated I'm sure.) Also, telling us where your confusion is will help us to help you further. Charlie -- Ꮚ

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

y arrayref then just push onto it): $attr->{join} = [$attr->{join}, 'mt']; $attr->{prefetch} = [$attr->{prefetch}, 'mc']; search($where, $attr}); Charlie -- Ꮚ Charlie Garrison ♊ O< ascii ribbon campaign - stop html mail - www.ascii

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 ♊ 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/l

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

olumns> Look at the `accessor` attribute; don't know whether it will help with custom column names when doing a `search`. Charlie -- Ꮚ Charlie Garrison ♊ O< ascii ribbon campaign - stop html mail - www.asciiribbon.org 〠 http://www.ietf.or

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

f = 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 ♊ O< asc

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

cpan.org/perldoc?DBIx::Class::Relationship#many_to_many Charlie -- Ꮚ Charlie Garrison ♊ 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/mai

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

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

Re: [Dbix-class] DBIx::Class::Tree::NestedSet RFC

ckage. But thinking about past project requirements while reading the DBIC::T::NS code, and the both the interface and implementation look really good. As soon as I have a need for it in another project I'll be keen to give it a try. Charlie -- Ꮚ Charlie Garrison ♊ 〠 PO Box 141, Wi

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

ding block, but the real power comes from custom methods. And DBIC has been great at teaching me how great the M part of MVC can be. My controllers have gone on a serious diet. :-) Charlie -- Ꮚ Charlie Garrison ♊ 〠 PO Box 141, Windsor, NSW 2756

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

hod I gave allows the 'type' to be passed as an argument or taken from the current 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), b

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

relationship defined in this package return $self->other_things->search({type=>$type}, {order_by=>'sort_idx'}); } Charlie -- Ꮚ Charlie Garrison ♊ 〠 PO Box 141, Windsor, NSW 2756, Australia O< ascii ribbon campaign - stop html mail - www.asci

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

hes; and I don't believe I got a commit bit. Charlie -- Ꮚ Charlie Garrison ♊ 〠 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:/

Re: [Dbix-class] Prefetch question

d then it used the in-memory copy. I always disabled that >> feature as it seems to cause more breakage than not. > >Hm, no. Well at least not here (DBIx::Class 0.08115). Note, Bill said Class::DBI, not DBIx::Class. They are completely different packages. Charlie -- Ꮚ Charl

Re: [Dbix-class] applying check constraint

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

Re: [Dbix-class] Question the Book Authors

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

Re: [Dbix-class] Call mysql stored procedure using Arbitrary SQL through a custom ResultSource

be sent to: My question is: What does this have to do with calling stored procedures? Charlie -- Charlie Garrison PO Box 141, Windsor, NSW 2756, Australia O< ascii ribbon campaign - stop html mail - www.asciiribbon.org http://www.ietf.o

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

set('Table')->search( { 'glr_date' => [ -and => { '>=' => $beg_date }, { '<' => $end_date } ] } ); Charlie -- Charlie Garrison PO Box 141, Windsor, NSW 2756, Australia O< ascii ribbon campaign

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

tagid=5, cdid=2 my $cheesy_cds2a = $schema->resultset('CD')->find(2)->cheesy_tags(); # tagid=5, cdid=2 # my $cheesy_cds2b = $schema->resultset('CD')->find(2)->cheesy_tags_cond();# tagid=5, cdid=2 is_deeply( [map { $_->id } $cheesy_cds1a->

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

gt;Is there way to use the values from my conf file or a variable that >will refer to the Cataylst root dir that DBIC::Schema will be aware >of? I think you're looking for: connect_info dbi:SQLite:__HOME__/motion.db Change Model::DBIC to match the name of your model. Ch

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

ing forward to integrating it in my app. 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 ___ List:

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

got enough DBIC skills to drive it myself. I 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

Re: [Dbix-class] Is the 'as' attribute to a search method broken?

Good evening, On 28/10/07 at 11:11 PM -0400, Randy Moore <[EMAIL PROTECTED]> wrote: >Content-Type: text/html; charset=ISO-8859-1 >Content-Transfer-Encoding: 7bit Could you also please include a plain-text part in your posts? Thanks, Charlie -- Charlie Garrison <[EMAIL PR