Re: [Dbix-class] Proposal for hook into deploy()

2008-02-26 Thread Pedro Melo
Hi, On Feb 23, 2008, at 10:58 PM, Jon Schutz wrote: On Sat, 2008-02-23 at 11:47 +, Ash Berlin wrote: Any comments or suggestions of a better way? Yes, how about this: http://search.cpan.org/~jrobinson/DBIx-Class-0.08009/lib/DBIx/ Class/Schema.pm#sqlt_deploy_hook($sqlt_schema)

Re: [Dbix-class] count behaviour

2008-02-26 Thread Alex Povolotsky
Ash Berlin wrote: On 26 Feb 2008, at 11:23, Alex Povolotsky wrote: Hello! I'm using (with Catalyst and TT) some simple code to count related data [% FOREACH loc IN llist -%] li[% loc.name %] : (a href=[% Catalyst.uri_for(edit/$loc.lid) %]Edit/a) [% loc.contacts.count+0 %] contacts (more):

Re: [Dbix-class] count behaviour

2008-02-26 Thread Ash Berlin
On 26 Feb 2008, at 11:34, Alex Povolotsky wrote: Ash Berlin wrote: On 26 Feb 2008, at 11:23, Alex Povolotsky wrote: Hello! I'm using (with Catalyst and TT) some simple code to count related data [% FOREACH loc IN llist -%] li[% loc.name %] : (a href=[% Catalyst.uri_for(edit/

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

2008-02-26 Thread Matt Lawrence
[EMAIL PROTECTED] wrote: Hi, I am having a problem, in which I couldn't get the relationship column data by using prefetch. My relationship is declared like this, suppose we have two tables: railway and railway_station, which relationship is 1 to many. #in railway schema

Re: [Dbix-class] count behaviour

2008-02-26 Thread Alex Povolotsky
Ash Berlin wrote: As for where its documened... somewhere in the Template Toolkit manual. the _rs methods are mentioned in Relationship docs of DBIC. Tho it could be more obvious, since currently there is just this snippet (and ones like it) Thanks a lot Might be nice if you prepare a

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

2008-02-26 Thread Jess Robinson
On Tue, 26 Feb 2008, Matt Lawrence wrote: [EMAIL PROTECTED] wrote: Hi, I am having a problem, in which I couldn't get the relationship column data by using prefetch. My relationship is declared like this, suppose we have two tables: railway and railway_station, which relationship is 1 to

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

2008-02-26 Thread Matt Lawrence
Jess Robinson wrote: On Tue, 26 Feb 2008, Matt Lawrence wrote: [EMAIL PROTECTED] wrote: Hi, I am having a problem, in which I couldn't get the relationship column data by using prefetch. My relationship is declared like this, suppose we have two tables: railway and railway_station, which

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

2008-02-26 Thread Nigel Metheringham
On 26 Feb 2008, at 14:03, Matt Lawrence wrote: Jess Robinson wrote: You can indeed prefetch a has_many rel. Excellent. How does that work? Do you get one instance of each object with a prepopulated resultset? Single object which returns an array from the has_many accessor.

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

2008-02-26 Thread Jess Robinson
On Tue, 26 Feb 2008, Matt Lawrence wrote: Jess Robinson wrote: On Tue, 26 Feb 2008, Matt Lawrence wrote: Rubbish, whatever gave you that idea? Docs say: |prefetch| can be used with the following relationship types: |belongs_to|, |has_one| (or if you're using |add_relationship|, any