Re: Problems with set_sql and iterators

[prev] [thread] [next] [Date index for 2005/06/20]

On Mon, Jun 20, 2005 at 05:50:52PM +1000, Jacinta Richardson wrote:
> 	# Declare our primary key field(s)
> 	__PACKAGE__->columns(Primary => 'StaffID', 'ProjectName', 
> 	'Allocation');
> 	__PACKAGE__->columns(TEMP => 'Total');
> 	# Select total time allocated to each project
> 	Staff::Projects->set_sql(total_times =>
>         	"SELECT ProjectName, sum(Allocation) as Total
>         	 FROM Projects
>         	 GROUP BY ProjectName
>         	 ORDER BY ProjectName"
> 	);

As you say, it's a PK issue. As you're grouping by ProjectName, surely
you should be declaring that as the sole PK?

If you need to use this class to access this table in its 'normal' form
elsewhere, then turn this version of it into a different class (think of
it as a cheap VIEW) that can have ProjectName as a single PK.

Tony