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

2016-12-05 Thread Nigel Metheringham
PROPOSAL A -- [ Nigel Metheringham -- ni...@dotdot.it ] [ Ellipsis Intangible Technologies ] ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org

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

2016-11-03 Thread Nigel Metheringham
I have a distinct feeling that this discussion is going deja vu all over again, but from my point of view I vote:- +1 Matt's proposal (new project team) -1 to forking -- [ Nigel Metheringham -- ni...@dotdot.it ] [ Ellipsis Intangible Technol

Re: [Dbix-class] GOVERNANCE: An actually concrete proposal w/bootstrap governance system

2016-10-19 Thread Nigel Metheringham
I am pretty happy with either MST's original proposal or Chris Prather's modified version (if pushed would go with Chris' amendments). Nigel. ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: h

Re: [Dbix-class] A slightly more concrete proposal

2016-10-05 Thread Nigel Metheringham
ensuring DBIC remains stable and does not eat data. Regards Nigel. -- [ Nigel Metheringham -- ni...@dotdot.it ] [ Ellipsis Intangible Technologies ] ___ List: http

Re: [Dbix-class] DBIx HAVING and COUNT error

2016-09-03 Thread Nigel Metheringham
t; ___ > 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.scs

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

2013-01-21 Thread Nigel Metheringham
my $rs1 = $c->model('weight::Mdata') ->search($where, { %{$attr}, prefetch => 'mc', join => 'mt' }); [so the other attributes, the prefetch and the join are all part of a single hash and not 3 different para

Re: [Dbix-class] Performance Issue

2012-02-22 Thread Nigel Metheringham
://metacpan.org/module/ORLite That is intended as extremely light weight SQLite-specific ORM. It might be a good halfway house between raw DBI and DBIx::Class. Nigel. -- [ Nigel Metheringham -- ni...@dotdot.it ] [ Ellipsis Intangible

Re: [Dbix-class] I get only one in a one to one

2012-01-01 Thread Nigel Metheringham
return $self->search({the_main_query_to_search_the_main_rows}, {prefetch=>' the_has_one_accessor'}); https://metacpan.org/module/DBIx::Class::ResultSet#prefetch https://metacpan.org/module/DBIx::Class::Manual::Cookbook#Using-joins-and-prefetch

Re: [Dbix-class] Module versioning

2011-04-15 Thread Nigel Metheringham
, with one application fully on this system and one minor one also using it. The other few apps under maintenance are likely to transition shortly. Nigel. -- [ Nigel Metheringham -- ni...@dotdot.it ] [ Ellipsis Intangible Technologies

Re: [Dbix-class] DBIC::DeploymentHandler upgrade - non-integer version numbers

2011-03-16 Thread Nigel Metheringham
On 16 Mar 2011, at 15:46, Anthony Gladdish wrote: > Have I missed the documentation that says it only works with integer version > numbers? Yes - its mentioned in Manual/Intro.pod It can probably be overridden... Nigel. -- [ Nigel Metheringham ---

Re: [Dbix-class] Performance degradation due to Class::C3

2011-02-28 Thread Nigel Metheringham
t with all the modules I use built with perlbrew and then packaged as an rpm under a different exec path to the system perl. Nigel. -- [ Nigel Metheringham -- ni...@dotdot.it ] [ Ellipsis Intangibl

Re: [Dbix-class] Filtering a SELECT based on a calculation of two columns?

2011-02-21 Thread Nigel Metheringham
to reword/add to them so that they are less confusing for you - thats where a lot of doc tweaks have come from since those learning how to use this stuff are often better at explaining it than the code authors :-/ Nigel. -- [ Nigel Metheringham -- ni...@dotd

Re: [Dbix-class] deleting many-to-many relationship entries in one query

2011-01-19 Thread Nigel Metheringham
r the query. In any case, if you want a RS, you can always use the _rs accessor, so $person->person2address_rs->delete; will work without any ambiguity (and works in Template Toolkit if you are playing with objects within templates where the inherent array mode tend

Re: [Dbix-class] deleting many-to-many relationship entries in one query

2011-01-19 Thread Nigel Metheringham
-many methods:- $person->set_addresses([]); http://search.cpan.org/perldoc?DBIx::Class::Relationship::Base#set_$rel Nigel. -- [ Nigel Metheringham nigel.methering...@intechnology.com ] [ - Comments in this message are my own and not ITO opinion/policy - ] __

Re: [Dbix-class] prefetch problem

2010-08-13 Thread Nigel Metheringham
ther a resultset of the related rows (in scalar mode - which is what your example has), or the matching rows in array mode, so you probably want:- while( my $file = $files->next() ) { print($_->name) foreach ($file->fieldfiles); } Nigel. -- [ Nigel Metheri

Re: [Dbix-class] Why is this so slow?

2010-06-08 Thread Nigel Metheringham
On 8 Jun 2010, at 16:50, Nigel Metheringham wrote: > > You may be able to approach the speed of pure DBI if you use > DBIx::Class::ResultClass::HashRefInflator Thinking about this, if you are restricting the column set you are using, you are strangling your objects in a nasty way anyho

Re: [Dbix-class] Why is this so slow?

2010-06-08 Thread Nigel Metheringham
gh you don't want to be iterating over that number of rows manually if you can avoid it... Nigel. -- [ Nigel Metheringham nigel.methering...@intechnology.com ] [ - Comments in this message are my own and not ITO opinion/policy - ]

Re: [Dbix-class] Why is this so slow?

2010-06-08 Thread Nigel Metheringham
n for an idea as to whats happening here - the get_column is a resultset method not a row method] Nigel. -- [ Nigel Metheringham nigel.methering...@intechnology.com ] [ - Comments in this message are my own and not ITO opinion/policy - ] _

Re: [Dbix-class] DBIC Schema to DDL

2010-02-10 Thread Nigel Metheringham
-Class-0.08118/lib/DBIx/Class/Schema/Versioned.pm > for this Without Versioned (which I use myself), you can just use the deploy* stuff in Schema and DBI - http://search.cpan.org/~ribasushi/DBIx-Class-0.08118/lib/DBIx/Class/Schema.pm#deploy Nigel. -- [ Nigel Metheringham

Re: [Dbix-class] Fwd: Creating a relationship

2009-09-16 Thread Nigel Metheringham
On 16 Sep 2009, at 20:43, Sungsam Gong wrote: My email below does not seem to be sent properly. Please don't do that. You are using gmail - its quite normal for gmail to hide your own postings to a mailing list from you. Nigel. -- [ Nigel Metheri

[Dbix-class] SQL::Abstract - boolean test support - should this merge?

2009-08-20 Thread Nigel Metheringham
them) So comments and votes (but this ain't a democracy) are welcome on the best way to take this forward... Nigel. [Just to be clear - none of this should break existing code - the test suite all still passes] -- [ Nigel Metheringham nigel.meth

Re: [Dbix-class] specify join type

2009-02-19 Thread Nigel Metheringham
add_relationship You can always have 2 identical, other than the join_type attribute, relationships defined under different names, to allow both forms of joins to be performed as required... [Remember that join/prefetch in resultsets refer to relations and not tables] Nigel. -- [ Nigel

Re: [Dbix-class] how to add a method that performs a database lookup?

2008-12-16 Thread Nigel Metheringham
urns a resultset, so:- my $rs = $schema->resultset('Whatever')->search({black => 'white'}); $rs->result_class('DBIx::Class::ResultClass::HashRefInflator'); while (my $hash = $rs->next) { # smoke your hash } -- [ Nigel Metheringham

Re: [Dbix-class] Parameter ordering in exceptions

2008-11-26 Thread Nigel Metheringham
ippan. So it looks like you are a short upgrade from having your wish fulfilled... Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy - ] ___ List: http://lists.s

Re: [Dbix-class] Parameter ordering in exceptions

2008-11-26 Thread Nigel Metheringham
rone to do something unexpected later). Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy - ] ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix

Re: [Dbix-class] Deleting with JOIN's

2008-10-23 Thread Nigel Metheringham
pain. Anyhow, suggested changes for now were:- - add additional bits to documentation for ResultSet delete and delete_all to explain the problem - modify delete to either die or warn when it is applied to a rs with joins in it. If anyone has good wor

Re: [Dbix-class] DBIx::Class and Red Hat perl bugs and performance redux

2008-10-05 Thread Nigel Metheringham
On 5 Oct 2008, at 12:00, Matt S Trout wrote: On Thu, Oct 02, 2008 at 02:34:10PM +0100, Nigel Metheringham wrote: DBIx::Class::StartupCheck - Both old and new perls trigger the startup check - as will any perl with the fixes to bless/overload bugs that is less than

[Dbix-class] DBIx::Class and Red Hat perl bugs and performance redux

2008-10-02 Thread Nigel Metheringham
ock secs (30.40 usr + 1.12 sys = 31.52 CPU) @ 5.43/s (n=171) join_all: 32.5188 wallclock secs (30.22 usr + 1.30 sys = 31.52 CPU) @ 6.38/s (n=201) prefetch_all: 30.8614 wallclock secs (29.40 usr + 0.63 sys = 30.03 CPU) @ 3.33/s (n=100) Nigel. -- [ Nigel Metheringham [

Re: [Dbix-class] RHEL / CentOS performance finally fixed?

2008-09-18 Thread Nigel Metheringham
had this problem. Anything earlier is outdated. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy - ] ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC

Re: [Dbix-class] RHEL / CentOS performance finally fixed?

2008-09-18 Thread Nigel Metheringham
Is this the bug referred to by the DBIx startup message? Yes. And the bug that all the fuss on slashdot and the like was about a few weeks back. Has anyone done any decent testing on this yet, or looked at what patchset they actually applied? Nigel. -- [ Nigel Metheringham

Re: [Dbix-class] Versioned Cluelessness

2008-07-08 Thread Nigel Metheringham
fixes changes how update runs the scripts. Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy - ] ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-

Re: [Dbix-class] Copy / cascade_copy

2008-05-09 Thread Nigel Metheringham
ntion when they turn it on? I applied that patch and modified the copy documentation yesterday on svn trunk. Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/p

[Dbix-class] Plug for DBICx::AutoDoc - Documentation of DBIx::Class schemas

2008-05-09 Thread Nigel Metheringham
th a look - see http://search.cpan.org/dist/DBICx-AutoDoc/ Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy - ] ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/list

Re: [Dbix-class] find_or_create problem with Pg: proposed patch

2008-04-03 Thread Nigel Metheringham
with something that generically puts default values in when the key/value to insert was missed out altogether, but in general I tend to let the DB do that. At present it looks like default_value is used only by deploy. Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ]

Re: [Dbix-class] more newbie questions

2008-02-28 Thread Nigel Metheringham
able - M:M does. Sometimes the link table may be disguised because its a useful entity in its own right... ie it contains additional info with the relationship. Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO

Re: [Dbix-class] more newbie questions

2008-02-28 Thread Nigel Metheringham
purely consists of 2 fields - the event id and the ticket_agent id, and links the pair. I refer to that as a link table, but I am a sysadmin rather than a DB expert :-) Hope that helps a bit. Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this mes

Re: [Dbix-class] Prefetch Problem: Related data can't be fetched

2008-02-26 Thread Nigel Metheringham
. Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy - ] ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http

Re: [Dbix-class] question on syntax

2008-02-11 Thread Nigel Metheringham
, $val ); } my $result_set = $c->model('DLDB::Model::CatalystModelName::AuthorizedUsers')- >search( { -and => [ { 'policy' => $data->{policy} }, { 'email' => { -in => [EM

Re: [Dbix-class] Why is prefetch so slow?

2007-10-17 Thread Nigel Metheringham
Jon, You should look at RH bug #196836 for information on the Red Hat perl bug that causes this. https://bugzilla.redhat.com/show_bug.cgi?id=196836 Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy