Re: Cross between MightHave and HasMany?

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

Peter Speltz writes:
 > Since a person has at most only one category, Why do you not want to store
 > category_id  in person?  

Jess -- Peter's response is right on.  Why can't you use has_a?

create table person (
    personid int primary key auto_increment,
    category int,
    firstname varchar(32),
    initials varchar(16),
    surname varchar(64),
    date_of_birth datetime
  );

create table categories (
    catid int primary key auto_increment,
    category varchar(128)
  );

Person->has_a(category => 'Categories');

Jess originally wrote:
 > Essentially I'd like  
 > $person->category() and $person->category($catobj) to do the right thing.

$person->category() does what you want.

$person->category($catobj->id) DWYW.

Jess originally wrote:
 > Also I'd like to be able to remove the relationship, without deleting  
 > either the person or the category themselves.

$person->category(undef) does that.

Kings