Re: Cross between MightHave and HasMany?

[prev] [thread] [next] [Date index for 2004/11/05]

--- William McKee <william@xxxxxxx.xxx> wrote:

> On Tue, Nov 02, 2004 at 02:06:45PM -0800, Peter Speltz wrote:
> > But if you want , Have you tried making a Temp column of person category? I
> > haven't tried Temp but from reading the docs, i hope to be able to say:
> > 
> > Person->columns( Temp => [ "category"]);
> > Person->has_a(category => "PersonCategory");
> > 
> > .... then  have everything work just like if the category column was in the
> > person table.  It should be able to update the PersonCategory object.
> 
> Wouldn't using might_have provide the same results with less code?
> 
> e.g.
> 
>   Person->might_have(category => "PersonCategory" => qw/cat_id/);
> 
> This brings up the question of whether CDBI makes category into a Temp
> column. Tony?
> 
> 
> > .... then  have everything work just like if the category column was in the
> > person table.  It should be able to update the PersonCategory object.
> > 
> > prsn_obj->category->cat_id($cgi_val);
> > prsn_obj->update; # or maybe prsn_obj->category->update;
> 
> I would think that the prsn_obj->category->update would be the correct
> call. Personally, I wouldn't use this setup with a M2M relation. To get
> a category name, you'd need to use something like:
> 

Its not really a M2M relationship but a One 2 One or 0. He just can't store the
category id in the Person table. 

>   prsn_obj->category->category;
> 
> Or stringify Category to the category column (which potentially
> introduces other weirdness).
> 
> 
> William
> 
> -- 
> Knowmad Services Inc.
> http://www.knowmad.com
> 


=====
pjs

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com