Re: Re[2]: [Dbix-class] Paging and distinct

On Wed, 17 Oct 2007 21:34:38 +0400 [EMAIL PROTECTED] wrote: [8<] > > THE THIRD decision/ you can override SQL::Abstract::Limit like > this: > > BEGIN { > > package DBIC::SQL::Abstract; # Would merge upstream, but nate doesn't reply :( Is there a fix pending for this problem? Didn't the DBIX f

Re: [Dbix-class] Second join gets eaten in _merge_attr

I don't think its as simple as that. I recently had to implement this behaviour and realised that in some cases you might need to rename the columns in the query. eg $rs->search({'foo.bar_id' => 2},{join=>'foo'}); then later my $new_rs = $rs->search({'foo.bar_id' = 45},{join=>'foo'}); which

Re: [Dbix-class] last insert ID from MSSQL?

On Wed, 17 Oct 2007 12:44:42 -0700 Marc Mims <[EMAIL PROTECTED]> wrote: > * Matt S Trout <[EMAIL PROTECTED]> [071017 12:30]: > > On Tue, Oct 16, 2007 at 04:48:49PM -0700, Michael Higgins wrote: > > > Folks -- > > > > > > Something changed to break the lousy hack I had to get this before... [8<]

[Dbix-class] Re: prefetch too slow

Matt S Trout <[EMAIL PROTECTED]> writes: > If it's 10k+ rows it's probably pure object inflation overhead. > > Why not use the HashRefInflator cookbook entry to bypass that? Haven't known about this, I'll give it a try. Thank you. -- Radek ___ List

Re: [Dbix-class] Second join gets eaten in _merge_attr

my bad. fixed in trunk: http://dev.catalystframework.org/svnweb/bast/revision/?rev=3844 thanks for the test. On 10/29/07, Zbigniew Lukasiak <[EMAIL PROTECTED]> wrote: > When you have a resultset that has a join in it and you try to do a > search on it with another join to the same table twice the

[Dbix-class] Second join gets eaten in _merge_attr

When you have a resultset that has a join in it and you try to do a search on it with another join to the same table twice then the second join is joined only once. # t/90join_torture.t my $rs = $schema->resultset("Artist")->search({}, { join => 'twokeys' }); my $second_search_rs = $rs->search({

[Dbix-class] Get wrong id after insert in Pg

Hi, I have a table where a trigger creates another record in the same table on INSERT (Postgres 8.2) I've the same workflow working with Class::DBI and so I've checked it again there, but it works OK with Class:DBI Any ideas ? Rolf Schaufelberger ___

Re: [Dbix-class] prefetch too slow

On Mon, Oct 29, 2007 at 02:53:17PM +0100, rahed wrote: > Hi, > > in Catalyst I get a resultset from five tables roughly like this: > (actualy there are more columns) > > $rs = $c->model('MyAppDB:Tab1')->search(undef, > {prefetch=> {rel1=>{rel2=>['rel3','rel4']}}, >select => ['me.id

[Dbix-class] Re: prefetch too slow

Randy Moore <[EMAIL PROTECTED]> writes: > Hi, > > I'm a total beginner with DBIC, but can you use 'join' instead of > prefetch'? I don't think it will remedy the big time differencies between running a query from the command line and within the framework. I've tried, prefetch and join both take u

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

On Sun, Oct 28, 2007 at 11:11:55PM -0400, Randy Moore wrote: > Erm. Please don't do that. You'll find a significant number of the people you really want reading your posts will drop HTML-only e-mail straight into the special mailbox also referred to as /dev/null on the grounds it must be spam.

[Dbix-class] prefetch too slow

Hi, in Catalyst I get a resultset from five tables roughly like this: (actualy there are more columns) $rs = $c->model('MyAppDB:Tab1')->search(undef, {prefetch=> {rel1=>{rel2=>['rel3','rel4']}}, select => ['me.id','me.col2', \'strftime(\'%s\',date)',

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

On 29/10/2007, Randy Moore <[EMAIL PROTECTED]> wrote: > > John Goulah wrote: > > > > > > On 10/28/07, *Randy Moore* <[EMAIL PROTECTED] > > > wrote: > > > > Jonathan Rockway wrote: > >> Randy Moore wrote: > >> > >>> Hi, > >>> > >>> I'm very new with DBIx-Cla

Re: [Dbix-class] prefetch too slow

rahed wrote: Hi, in Catalyst I get a resultset from five tables roughly like this: (actualy there are more columns) $rs = $c->model('MyAppDB:Tab1')->search(undef, {prefetch=> {rel1=>{rel2=>['rel3','rel4']}}, select => ['me.id','me.col2', \'strftime(\'%s\',date)'

[Dbix-class] Re: prefetch too slow

Jonathan Rockway <[EMAIL PROTECTED]> writes: > What OS is this on? RedHat? No, it's Solaris 10. -- Radek ___ 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

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

John Goulah wrote: On 10/28/07, *Randy Moore* <[EMAIL PROTECTED] > wrote: Jonathan Rockway wrote: Randy Moore wrote: Hi, I'm very new with DBIx-Class, but I don't think I'm doing anything wrong . It looks like the 'as' attribute to a s

Re: [Dbix-class] prefetch too slow

rahed wrote: > Is there a better and more efficient way? > Thanks much. > What OS is this on? RedHat? signature.asc Description: OpenPGP digital signature ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#db

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 PROTECTED]> PO Bo