[Dbix-class] $rs-count fails with multiple group_by

2008-12-16 Thread Noel Burton-Krahn
gets generated. Any pointers? ~Noel - #! /usr/bin/perl -w =head1 NAME dbix_select_count_group_by.t - $rs-count fails with multiple group_by =head1 AUTHOR Noel Burton-Krahn n...@burton

Re: [Dbix-class] convention for naming primary keys to avoid ambiguousselects

2008-11-25 Thread Noel Burton-Krahn
On Tue, Nov 25, 2008 at 9:45 AM, Peter Rabbitson [EMAIL PROTECTED] wrote: As far as the don't repeat yourself - what do you propose? Your query (the join-ed one) selects from two tables that have the same column. Unless you specify which column you are interested in, it is not safe for DBIC

Re: [Dbix-class] convention for naming primary keys to avoid ambiguousselects

2008-11-25 Thread Noel Burton-Krahn
On Tue, Nov 25, 2008 at 10:22 AM, Peter Rabbitson [EMAIL PROTECTED] wrote: Noel Burton-Krahn wrote: The problem is that DBIx has the smarts to prefix column names in the select clause, like select me.id, cds.id but not in the where clause where id=?. How does DBIC know if the user meant

Re: [Dbix-class] convention for naming primary keys to avoidambiguousselects

2008-11-25 Thread Noel Burton-Krahn
On Tue, Nov 25, 2008 at 2:06 PM, Peter Rabbitson [EMAIL PROTECTED] wrote: Octavian Rasnita wrote: From: Noel Burton-Krahn [EMAIL PROTECTED] By the way, does anyone know what happends if a secondary table is named me? The name of the table is irrelevant as they are all aliased anyway

Re: [Dbix-class] bug in delete_all: CascadeActions::delete removes parent before children

2008-10-26 Thread Noel Burton-Krahn
On Sun, Oct 26, 2008 at 1:19 AM, Peter Rabbitson [EMAIL PROTECTED] wrote: 1) You call delete_all 2) You traverse the entire relationship chain, and start calling delete on the resulting three backwards, depth first. 3) By the time you get to the main row that you wanted to delete_all in the

Re: [Dbix-class] bug in delete_all: CascadeActions::delete removes parent before children

2008-10-24 Thread Noel Burton-Krahn
the ambiguous column name error though. Any thoughts? ~Noel On Fri, Oct 24, 2008 at 2:32 PM, Peter Rabbitson [EMAIL PROTECTED] wrote: Noel Burton-Krahn wrote: DBIx's cascading delete_all (in DBIx::Class::ResultSet) it broken, because it deletes the parent table before it deletes the children