Re: Inflate a boolean

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

At 23:24 2005-02-20, Ofer Nave wrote:
>3) (the missing case) So if you just want to convert the value to another 
>non-object value upon load... what do you do?  Is there a solution 
>involving triggers that I'm overlooking?

How about something like:
(untested, but adapted from what I use to numify values):

sub bool2yesno {
     my ($self, $name) = @_;
     $self->{$name} = $self->{$name} ? "Yes" : "No";
}
__PACKAGE__->add_trigger(select  => sub { my $self = shift;
     $self->bool2yesno("your_column_i_forgot_what_it_was_called");
});


>>But, most of the time, if you really want "yes" and "no", store those
>>in your database, not 1 and 0.
>>
>That is entirely subjective, and most definitely poor design (in my 
>opinion) in many cases.

Me too. Possibly there would be a value table for that to achieve 3NF.


/J

-------- ------ ---- --- -- --  --  -     -     -        -          -
Johan Lindström    Sourcerer @ Boss Casinos   johanl AT DarSerMan.com

Latest bookmark: "TCP Connection Passing"
http://tcpcp.sourceforge.net/
dmoz: /Computers/Programming/Languages/JavaScript/ 12