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] more newbie questions

2008-02-28 Thread Nigel Metheringham
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 message are my own and not ITO opinion/policy

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

2008-04-03 Thread Nigel Metheringham
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] ] [ - Comments

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

2008-05-09 Thread Nigel Metheringham
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/listinfo/dbix-class

Re: [Dbix-class] Copy / cascade_copy

2008-05-09 Thread Nigel Metheringham
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/policy

Re: [Dbix-class] Versioned Cluelessness

2008-07-08 Thread Nigel Metheringham
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-class

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

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

2008-10-02 Thread Nigel Metheringham
+ 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 [EMAIL PROTECTED

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

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

2008-10-23 Thread Nigel Metheringham
in it. If anyone has good wording for the doc changes in particular I can look at making these changes. Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy

Re: [Dbix-class] Parameter ordering in exceptions

2008-11-26 Thread Nigel Metheringham
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-class IRC

Re: [Dbix-class] Parameter ordering in exceptions

2008-11-26 Thread Nigel Metheringham
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.scsys.co.uk

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

2009-08-20 Thread Nigel Metheringham
this forward... Nigel. [Just to be clear - none of this should break existing code - the test suite all still passes] -- [ 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
not a row method] Nigel. -- [ Nigel Metheringham nigel.methering...@intechnology.com ] [ - Comments in this message are my own and not ITO opinion/policy - ] ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class

Re: [Dbix-class] prefetch problem

2010-08-13 Thread Nigel Metheringham
you probably want:- while( my $file = $files-next() ) { print($_-name) foreach ($file-fieldfiles); } Nigel. -- [ Nigel Metheringham nigel.methering...@intechnology.com ] [ - Comments in this message are my own and not ITO opinion/policy

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

2011-01-19 Thread Nigel Metheringham
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 tends to break stuff). Nigel. -- [ Nigel Metheringham nigel.methering

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 -- ni

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] I get only one in a one to one

2012-01-01 Thread Nigel Metheringham
({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 Nigel. -- [ Nigel Metheringham -- ni

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] DBIx HAVING and COUNT error

2016-09-03 Thread Nigel Metheringham
> 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 -- [ Nigel Metheringham --

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

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

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:

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 Technologies

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