Re: one to one revisited (has_own)

[prev] [thread] [next] [Date index for 2005/01/26]

From: Peter Speltz
Subject: Re: one to one revisited (has_own)
Date: 23:24 on 26 Jan 2005
--0-244502363-1106781853=:97450
Content-Type: text/plain; charset=us-ascii
Content-Id: 
Content-Disposition: inline

I have a might_have and a has_one (note 'one') relationship ready for testing.
I've given them a little work out. HasOne.pm has a synopsis of using both. I
chose has_one over has_own. If anyone has a better name i'm all ears. Maybe
has_own could be an alternative to a has_a relationship as i originally
thought. Maybe better just to add an extra arg for the meta data instead of 
making a whole new relationship. Same could be said for has_one and might_have
but since the whole point was to take the "might" out of it a new relationship
seems warranted.

Here is the synopsis and attached are the files. Except for where i noted with
"# pjs ...", they are both copies of original CDBI::Relationship::MightHave.pm.
Thanks.

=head1 NAME

Class::DBI::Relationsip::HasOne -

Like might_have without the might. Offers a small but significant
improvement in program readability and CDBI tuning.

=head1 SYNOPSIS

    # Example with experimental has_one and might_have
    # Below not tested but code just like it was.

    package Music::CD;

    Music::CD->add_relationship_type(
        'has_one' => 'Class::DBI::Relationship::HasOne');

    Music::CD->columns(All => qw/cd_id .../);

    Music::CDArtist->columns(All =>
        qw/cd_id artist_type artist_id instrument/);


    Music::CD->has_one(primary_artist => Music::CDArtist =>
        qw(artist_id),{_FK_=>'cd_id', artist_type =>'primary'}
    );
     
    Music::CD->might_have(secondary_artist => Music::CDArtist =>
        qw(), {_FK_=>'cd_id', artist_type => 'secondary'}
    );

    Music::CD->might_have(cover_artist => Music::CDArtist =>
        qw(), {_FK_=>'cd_id', artist_type => 'graphic'}
    );

    # Old style should still work
    Music::CD->might_have(liner_notes => LinerNotes => qw(notes));

    # And maybe a new has_many style that takes limiters ?
    Music::CD->has_many(band_members => Music::CDArtist,
        {   _FK_ => 'cd_id', order_by => 'instrument',
            artist_type => 'band_member'
        }
    );

    # And to make it all worth while . . .
    sub create_new {
        my $self = shift;
        my $req_components = $self->meta_info('has_one');
        my $opt_components = $self->meta_info('might_have');

        my %cgi = $self->to_cgi; # get inputs from AsForm
        foreach my $comp (keys %$req_components) {
            my $fclass = $req_components->{$comp}->{foreign_class};
            $cgi{$comp} = $fclass->to_cgi;
        }

        my $template_args = {
            cgi => $cgi,
            opt_components => $opt_components
        };
    }

    # ... accessing in TT templates
    [% cd.primary_artist; %]
    [% cd.secondary_artist;%]
    [% flute_players = cd.band_members('instrument' , 'flute')%]


    # A Comparison:  do above with with just a has_many
    ...
    Music::CD->has_many(artists => "Music::CDArtist");
    ...
    sub create_new_cd {
        my $self->shift;
        my $required_components = ;
        # This isn't fun anymore.
    }

    # accessing in TT templates
    [% primary = cd.artists('artist_type' , 'primary');
       # hopefully %]
    [% secondary  = cd.artists('artist_type' , 'secondary')%]
    [% flute_players = cd.artists('instrument' , 'flute')%]

=====
pjs

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--0-244502363-1106781853=:97450
Content-Type: application/x-perl; name="MightHave.pm"
Content-Transfer-Encoding: base64
Content-Description: MightHave.pm
Content-Disposition: attachment; filename="MightHave.pm"

cGFja2FnZSBDbGFzczo6REJJOjpSZWxhdGlvbnNoaXA6Ok1pZ2h0SGF2ZTsK
dXNlIHN0cmljdDsKdXNlIHdhcm5pbmdzOwoKdXNlIGJhc2UgJ0NsYXNzOjpE
Qkk6OlJlbGF0aW9uc2hpcCc7CnVzZSBEYXRhOjpEdW1wZXI7IAoKc3ViIHJl
bWFwX2FyZ3VtZW50cyB7CglteSAoJHByb3RvLCAkY2xhc3MsICRtZXRob2Qs
ICRmX2NsYXNzLCBAbWV0aG9kcykgPSBAXzsKCSRjbGFzcy0+X3JlcXVpcmVf
Y2xhc3MoJGZfY2xhc3MpOwoKCSMgcGpzIC0tIHB1dCBjb25zdHJhaW50cyBh
bmQgY29sdW1uIG5hbWUgaW4gYXJncyAKCW15ICgkY29uc3RyYWludHMsICRm
X2NvbCkgPSAoe30sJycpOyAKCSRjb25zdHJhaW50cyA9IHBvcCBAbWV0aG9k
cyAgaWYgKHJlZiAkbWV0aG9kc1stMV0gZXEgIkhBU0giKTsKCSRmX2NvbCA9
IGRlbGV0ZSAkY29uc3RyYWludHMtPntfRktffSB8fCAkZl9jbGFzcy0+cHJp
bWFyeV9jb2x1bW47ICAKCglyZXR1cm4gKCRjbGFzcywgJG1ldGhvZCwgJGZf
Y2xhc3MsIAoJICAgICAgICB7IGZvcmVpZ25fY29sdW1uID0+ICRmX2NvbCwg
CgkJCSAgY29uc3RyYWludHMgPT4gJGNvbnN0cmFpbnRzLCAKCQkJICBpbXBv
cnQgPT4gXEBtZXRob2RzIAoJCQl9CgkpOwp9CgpzdWIgdHJpZ2dlcnMgewoJ
bXkgJHNlbGYgPSBzaGlmdDsKCglteSAkbWV0aG9kID0gJHNlbGYtPmFjY2Vz
c29yOwoKCXJldHVybiAoCgkJYmVmb3JlX3VwZGF0ZSA9PiBzdWIgewoJCQlp
ZiAobXkgJGZvcl9vYmogPSBzaGlmdC0+JG1ldGhvZCgpKSB7ICRmb3Jfb2Jq
LT51cGRhdGUgfQoJCX0sCgoJCWJlZm9yZV9kZWxldGUgPT4gc3ViIHsKCQkJ
aWYgKG15ICRmb3Jfb2JqID0gc2hpZnQtPiRtZXRob2QoKSkgeyAkZm9yX29i
ai0+ZGVsZXRlIH0KCQl9LAoKCSk7Cn0KCnN1YiBtZXRob2RzIHsKCW15ICRz
ZWxmID0gc2hpZnQ7CglteSAoJGNsYXNzLCAkbWV0aG9kKSA9ICgkc2VsZi0+
Y2xhc3MsICRzZWxmLT5hY2Nlc3Nvcik7CglyZXR1cm4gKAoJCSRtZXRob2Qg
PT4gJHNlbGYtPl9vYmplY3RfYWNjZXNzb3IsCgkJbWFwIHsgJF8gPT4gJHNl
bGYtPl9pbXBvcnRlZF9hY2Nlc3NvcigkXykgfSBAeyAkc2VsZi0+YXJncy0+
e2ltcG9ydH0gfSk7Cn0KCgpzdWIgX29iamVjdF9hY2Nlc3NvciB7CglteSAk
c2VsZiA9IHNoaWZ0OwoJbXkgKCRjbGFzcywgJG1ldGhvZCkgPSAoJHNlbGYt
PmNsYXNzLCAkc2VsZi0+YWNjZXNzb3IpOwoJcmV0dXJuIHN1YiB7CgkJbXkg
JHNlbGYgPSBzaGlmdDsKCQlteSAkbWV0YSA9ICRjbGFzcy0+bWV0YV9pbmZv
KG1pZ2h0X2hhdmUgPT4gJG1ldGhvZCk7CgkJbXkgKCRmX2NsYXNzLCBAZXh0
cmEpID0KCQkJKCRtZXRhLT5mb3JlaWduX2NsYXNzLCBAeyAkbWV0YS0+YXJn
cy0+e2ltcG9ydH0gfSk7CgkJIyBwanMgLS0gdG8gbWFrZSB0aGlzIGFuIE06
MSBuZWVkIHNlYXJjaCB3aXRoIGNvbnN0cmFpbnRzCgkJbXkgJWNvbnN0ciA9
KCAkbWV0YS0+YXJncy0+e2ZvcmVpZ25fY29sdW1ufSA9PiAkc2VsZi0+aWQs
ICV7JG1ldGEtPmFyZ3MtPntjb25zdHJhaW50c319ICk7CgkJdW5sZXNzICgk
c2VsZi0+eyJfJHttZXRob2R9X29iamVjdCJ9KSB7CgkJCSgkc2VsZi0+eyJf
JHttZXRob2R9X29iamVjdCJ9KSA9ICRmX2NsYXNzLT5zZWFyY2goJWNvbnN0
cik7CgkJfQoJCSRzZWxmLT57Il8ke21ldGhvZH1fb2JqZWN0In07Cgl9OwoK
fQoKc3ViIF9pbXBvcnRlZF9hY2Nlc3NvciB7CglteSAoJHNlbGYsICRuYW1l
KSA9IEBfOwoJbXkgKCRjbGFzcywgJG1ldGhvZCkgPSAoJHNlbGYtPmNsYXNz
LCAkc2VsZi0+YWNjZXNzb3IpOwoJcmV0dXJuIHN1YiB7CgkJbXkgJHNlbGYg
PSBzaGlmdDsKCQlteSAkbWV0YSA9ICRjbGFzcy0+bWV0YV9pbmZvKG1pZ2h0
X2hhdmUgPT4gJG1ldGhvZCk7CgkJbXkgKCRmX2NsYXNzLCBAZXh0cmEpID0K
CQkJKCRtZXRhLT5mb3JlaWduX2NsYXNzLCBAeyAkbWV0YS0+YXJncy0+e2lt
cG9ydH0gfSk7CgkJbXkgJGZvcl9vYmogPSAkc2VsZi0+JG1ldGhvZCgpIHx8
IGRvIHsKCQkJbXkgJHZhbCA9IHNoaWZ0IG9yIHJldHVybjsgICAgIyBqdXN0
IGZldGNoaW5nCgkJCSMgcGpzICBubyBwayBwdXQgYW55bW9yZT8KCQkJJGZf
Y2xhc3MtPmNyZWF0ZSh7ICRtZXRhLT5hcmdzLT57Zm9yZWlnbl9jb2x1bW59
ID0+ICRzZWxmLT5pZCwgJG5hbWUgPT4gJHZhbCB9KTsKCQkJJHNlbGYtPiRt
ZXRob2QoKTsKCQl9OwoJCSRmb3Jfb2JqLT4kbmFtZShAXyk7Cgl9Owp9Cgox
OwoKX19FTkRfXwoKPXBvZAoKPWhlYWQxCgpXQVJOSU5HIC0tIEVYUEVSSU1F
TlRBTCAKCj1oZWFkMSBOQU1FCgpDbGFzczo6REJJOjpSZWxhdGlvbnNoaXA6
Ok1pZ2h0SGF2ZSAtIApqdXN0IGxpa2Ugb2xkIGJ1dCBtb3JlIGZsZXhpYmxl
Cgo9aGVhZDEgU1lOT1BTSVMKCgkjIEV4YW1wbGUgbm90IHNwZWNpZmljYWxs
eSB0ZXN0ZWQgCgoJcGFja2FnZSBNdXNpYzo6Q0Q7CgkuLi4KCSMganVzdCBs
aWtlIG9sZCAtLSBMaW5lck5vdGVzIHByaW1hcnkgY29sdW1uIGlzIAoJIyBl
eHBlY3RlZCB0byBjb250YWluIHRoZSBjZF9pZC4KCglNdXNpYzo6Q0QtPm1p
Z2h0X2hhdmUobGluZXJfbm90ZXMgPT4gTGluZXJOb3RlcyA9PiBxdyhub3Rl
cykpOwoKCSMgc3BlY2lmeSB3aGF0IGNvbHVtbiBjZF9pZCBpcyBpbiBpbiBm
b3JlaWduIGNsYXNzIAoJIyB3aXRoICJfRktfIiBhcyB3ZWxsIGFzIGNvbnN0
cmFpbnRzIHRvIGZpbmQgdGhlIHJpZ2h0IHJvdy4gCgkjIEluIGdlbmVyYWwg
bWlnaHRfaGF2ZSBhc3N1bWVzIF9GS18gYW5kIG90aGVyIGNvbnN0cmFpbnRz
IAoJIyBtYWtlIHVwIGEgdW5pcXVlIGtleSBpbiB0aGUgZm9yZWlnbiBjbGFz
cyBhbmQgZ2l2ZXMgeW91IAoJIyBmaXJzdCBvbmUgcmV0dXJuZWQgZnJvbSBh
ICJzZWFyY2giIGNhbGwuCgoJTXVzaWM6OkNELT5taWdodF9oYXZlKHNlY29u
ZGFyeV9hcnRpc3QgPT4gTXVzaWM6OkNEQXJ0aXN0ID0+IAoJCXF3KCksIHtf
RktfPT4nY2RfaWQnLCBhcnRpc3RfdHlwZSA9PiAnc2Vjb25kYXJ5J30gCgkp
OwoKCSMgQ2QgbWlnaHQgaGF2ZSBhbm90aGVyIGFydGlzdAoJCglNdXNpYzo6
Q0QtPm1pZ2h0X2hhdmUoZ3Vlc3Rfc3RhciA9PiBNdXNpYzo6Q0RBcnRpc3Qg
PT4gCgkJcXcoKSwge19GS189PidjZF9pZCcsIGFydGlzdF90eXBlID0+ICdn
dWVzdF9zdGFyJ30gCgkpOwoKCgkjIGdldCBtaWdodF9oYXZlcyBrZXllZCBv
biBmb3JlaWduIGNsYXNzOwoJTXVzaWM6OkJhc2U6Om9wdGlvbmFsX2NvbXBv
bmVudHMgewoJCW15ICgkY2xhc3MsICRmX2NsYXNzKSA9IEBfOwoJCW15ICRv
cHRzID0gICRjbGFzcy0+bWV0YV9pbmZvKCdtaWdodF9oYXZlJyk7CgkJbXkg
JXJlc3VsdDsgCgkJZm9yZWFjaCBteSAkYSAoa2V5cyAlJG9wdHMpIHsKCQkJ
bXkgJGZjbGFzcyA9ICRvcHRzLT57JGF9LT57Zm9yZWlnbl9jbGFzc307CgkJ
CSRyZXN1bHR7JGZjbGFzc30gPSBbXSB1bmxlc3MgJHJlc3VsdHskZmNsYXNz
fTsKCQkJcHVzaCBAeyRyZXN1bHR7JGZjbGFzc319LCAkb3B0cy0+eyRhfTsK
CQl9CgoJCSRmX2NsYXNzID8gcmV0dXJuICRyZXN1bHR7JGZfY2xhc3N9IDog
cmV0dXJuIFwlcmVzdWx0OwoJfQoJCgo9Y3V0Cgo=

--0-244502363-1106781853=:97450
Content-Type: application/x-perl; name="HasOne.pm"
Content-Transfer-Encoding: base64
Content-Description: HasOne.pm
Content-Disposition: attachment; filename="HasOne.pm"

cGFja2FnZSBDbGFzczo6REJJOjpSZWxhdGlvbnNoaXA6Okhhc09uZTsKdXNl
IHN0cmljdDsKdXNlIHdhcm5pbmdzOwoKdXNlIGJhc2UgJ0NsYXNzOjpEQkk6
OlJlbGF0aW9uc2hpcCc7CgpzdWIgcmVtYXBfYXJndW1lbnRzIHsKCW15ICgk
cHJvdG8sICRjbGFzcywgJG1ldGhvZCwgJGZfY2xhc3MsIEBtZXRob2RzKSA9
IEBfOwoJJGNsYXNzLT5fcmVxdWlyZV9jbGFzcygkZl9jbGFzcyk7CgkjIHBq
cyAtLSBwdXQgY29uc3RyYWludHMgYW5kIGZvcmVpZ24gY29sdW1uIG5hbWUg
aW4gYXJncyAKCW15ICgkY29uc3RyYWludHMsICRmX2NvbCkgPSAoe30sJycp
OyAKCSRjb25zdHJhaW50cyA9IHBvcCBAbWV0aG9kcyAgaWYgKHJlZiAkbWV0
aG9kc1stMV0gZXEgIkhBU0giKTsKCSRmX2NvbCA9IGRlbGV0ZSAkY29uc3Ry
YWludHMtPntfRktffSB8fCAkZl9jbGFzcy0+cHJpbWFyeV9jb2x1bW47ICAK
CXJldHVybiAoJGNsYXNzLCAkbWV0aG9kLCAkZl9jbGFzcywgCgkJeyBmb3Jl
aWduX2NvbHVtbiA9PiAkZl9jb2wsIGNvbnN0cmFpbnRzID0+ICRjb25zdHJh
aW50cywgCgkJICBpbXBvcnQgPT4gXEBtZXRob2RzIAoJCX0KCSk7Cn0KCnN1
YiB0cmlnZ2VycyB7CglteSAkc2VsZiA9IHNoaWZ0OwoKCW15ICRtZXRob2Qg
PSAkc2VsZi0+YWNjZXNzb3I7CgoJcmV0dXJuICgKCQliZWZvcmVfdXBkYXRl
ID0+IHN1YiB7CgkJCWlmIChteSAkZm9yX29iaiA9IHNoaWZ0LT4kbWV0aG9k
KCkpIHsgJGZvcl9vYmotPnVwZGF0ZSB9CgkJfSwKCgkJYmVmb3JlX2RlbGV0
ZSA9PiBzdWIgewoJCQlpZiAobXkgJGZvcl9vYmogPSBzaGlmdC0+JG1ldGhv
ZCgpKSB7ICRmb3Jfb2JqLT5kZWxldGUgfQoJCX0sCgoJKTsKfQoKc3ViIG1l
dGhvZHMgewoJbXkgJHNlbGYgPSBzaGlmdDsKCW15ICgkY2xhc3MsICRtZXRo
b2QpID0gKCRzZWxmLT5jbGFzcywgJHNlbGYtPmFjY2Vzc29yKTsKCXJldHVy
biAoCgkJJG1ldGhvZCA9PiAkc2VsZi0+X29iamVjdF9hY2Nlc3NvciwKCQlt
YXAgeyAkXyA9PiAkc2VsZi0+X2ltcG9ydGVkX2FjY2Vzc29yKCRfKSB9IEB7
ICRzZWxmLT5hcmdzLT57aW1wb3J0fSB9KTsKfQoKCnN1YiBfb2JqZWN0X2Fj
Y2Vzc29yIHsKCW15ICRzZWxmID0gc2hpZnQ7CglteSAoJGNsYXNzLCAkbWV0
aG9kKSA9ICgkc2VsZi0+Y2xhc3MsICRzZWxmLT5hY2Nlc3Nvcik7CglyZXR1
cm4gc3ViIHsKCQlteSAkc2VsZiA9IHNoaWZ0OwoJCW15ICRtZXRhID0gJGNs
YXNzLT5tZXRhX2luZm8oaGFzX29uZSA9PiAkbWV0aG9kKTsKCQlteSAoJGZf
Y2xhc3MsIEBleHRyYSkgPQoJCQkoJG1ldGEtPmZvcmVpZ25fY2xhc3MsIEB7
ICRtZXRhLT5hcmdzLT57aW1wb3J0fSB9KTsKCQkjIHBqcyAtLSB0byBtYWtl
IHRoaXMgYW4gTToxIG5lZWQgc2VhcmNoIHdpdGggY29uc3RyYWludHMKCQlt
eSAlY29uc3RyID0oICRtZXRhLT5hcmdzLT57Zm9yZWlnbl9jb2x1bW59ID0+
ICRzZWxmLT5pZCwgJXskbWV0YS0+YXJncy0+e2NvbnN0cmFpbnRzfX0gKTsK
CQl1bmxlc3MgKCRzZWxmLT57Il8ke21ldGhvZH1fb2JqZWN0In0pIHsKCQkJ
KCRzZWxmLT57Il8ke21ldGhvZH1fb2JqZWN0In0pID0gJGZfY2xhc3MtPnNl
YXJjaCglY29uc3RyKTsKCQl9CgkJJHNlbGYtPnsiXyR7bWV0aG9kfV9vYmpl
Y3QifTsKCX07Cgp9CgpzdWIgX2ltcG9ydGVkX2FjY2Vzc29yIHsKCW15ICgk
c2VsZiwgJG5hbWUpID0gQF87CglteSAoJGNsYXNzLCAkbWV0aG9kKSA9ICgk
c2VsZi0+Y2xhc3MsICRzZWxmLT5hY2Nlc3Nvcik7CglyZXR1cm4gc3ViIHsK
CQlteSAkc2VsZiA9IHNoaWZ0OwoJCW15ICRtZXRhID0gJGNsYXNzLT5tZXRh
X2luZm8oaGFzX29uZSA9PiAkbWV0aG9kKTsKCQlteSAoJGZfY2xhc3MsIEBl
eHRyYSkgPQoJCQkoJG1ldGEtPmZvcmVpZ25fY2xhc3MsIEB7ICRtZXRhLT5h
cmdzLT57aW1wb3J0fSB9KTsKCQlteSAkZm9yX29iaiA9ICRzZWxmLT4kbWV0
aG9kKCkgfHwgZG8gewoJCQlteSAkdmFsID0gc2hpZnQgb3IgcmV0dXJuOyAg
ICAjIGp1c3QgZmV0Y2hpbmcKCQkJIyBwanMgIG5vIHBrIHB1dCBhbnltb3Jl
PwoJCQkkZl9jbGFzcy0+Y3JlYXRlKHsgCQoJCQkJCQkJCSRtZXRhLT5hcmdz
LT57Zm9yZWlnbl9jb2x1bW59ID0+ICRzZWxmLT5pZCwgCgkJCQkJCQkJJG5h
bWUgPT4gJHZhbCAKCQkJCQkJCSB9KTsKCQkJCQkJCQoJCQkkc2VsZi0+JG1l
dGhvZCgpOwoJCX07CgkJJGZvcl9vYmotPiRuYW1lKEBfKTsKCX07Cn0KCjE7
CgpfX0VORF9fCgoKPWhlYWQxICBXQVJOSU5HIAoKRVhQRVJJTUVOVEFMIAoK
PWhlYWQxIE5BTUUKCkNsYXNzOjpEQkk6OlJlbGF0aW9uc2lwOjpIYXNPbmUg
LQoKTGlrZSBtaWdodF9oYXZlIHdpdGhvdXQgdGhlIG1pZ2h0LiBPZmZlcnMg
YSBzbWFsbCBidXQgc2lnbmlmaWNhbnQgCmltcHJvdmVtZW50IGluIHByb2dy
YW0gcmVhZGFiaWxpdHkgYW5kIENEQkkgdHVuaW5nLgoKPWhlYWQxIFNZTk9Q
U0lTCgoJIyBFeGFtcGxlIHdpdGggZXhwZXJpbWVudGFsIGhhc19vbmUgYW5k
IG1pZ2h0X2hhdmUKCSMgQmVsb3cgbm90IHRlc3RlZCBidXQgY29kZSBqdXN0
IGxpa2UgaXQgd2FzLgoJCglwYWNrYWdlIE11c2ljOjpDRDsKCglNdXNpYzo6
Q0QtPmFkZF9yZWxhdGlvbnNoaXBfdHlwZSgKCQknaGFzX29uZScgPT4gJ0Ns
YXNzOjpEQkk6OlJlbGF0aW9uc2hpcDo6SGFzT25lJyk7CgoJTXVzaWM6OkNE
LT5jb2x1bW5zKEFsbCA9PiBxdy9jZF9pZCAuLi4vKTsKCglNdXNpYzo6Q0RB
cnRpc3QtPmNvbHVtbnMoQWxsID0+IAoJCXF3L2NkX2lkIGFydGlzdF90eXBl
IGFydGlzdF9pZCBpbnN0cnVtZW50Lyk7CgoKCU11c2ljOjpDRC0+aGFzX29u
ZShwcmltYXJ5X2FydGlzdCA9PiBNdXNpYzo6Q0RBcnRpc3QgPT4gCgkJcXco
YXJ0aXN0X2lkKSx7X0ZLXz0+J2NkX2lkJywgYXJ0aXN0X3R5cGUgPT4ncHJp
bWFyeSd9IAoJKTsKICAgIAkKCU11c2ljOjpDRC0+bWlnaHRfaGF2ZShzZWNv
bmRhcnlfYXJ0aXN0ID0+IE11c2ljOjpDREFydGlzdCA9PiAKCQlxdygpLCB7
X0ZLXz0+J2NkX2lkJywgYXJ0aXN0X3R5cGUgPT4gJ3NlY29uZGFyeSd9IAoJ
KTsKCglNdXNpYzo6Q0QtPm1pZ2h0X2hhdmUoY292ZXJfYXJ0aXN0ID0+IE11
c2ljOjpDREFydGlzdCA9PiAKCQlxdygpLCB7X0ZLXz0+J2NkX2lkJywgYXJ0
aXN0X3R5cGUgPT4gJ2dyYXBoaWMnfSAKCSk7CgkJCgkjIE9sZCBzdHlsZSBz
aG91bGQgc3RpbGwgd29yawoJTXVzaWM6OkNELT5taWdodF9oYXZlKGxpbmVy
X25vdGVzID0+IExpbmVyTm90ZXMgPT4gcXcobm90ZXMpKTsKCgkjIEFuZCBt
YXliZSBhIG5ldyBoYXNfbWFueSBzdHlsZSB0aGF0IHRha2VzIGxpbWl0ZXJz
ID8KCU11c2ljOjpDRC0+aGFzX21hbnkoYmFuZF9tZW1iZXJzID0+IE11c2lj
OjpDREFydGlzdCwgCgkgICAgeyAJX0ZLXyA9PiAnY2RfaWQnLCBvcmRlcl9i
eSA9PiAnaW5zdHJ1bWVudCcsIAoJICAgIAlhcnRpc3RfdHlwZSA9PiAnYmFu
ZF9tZW1iZXInCgkJfQoJKTsKCgkjIEFuZCB0byBtYWtlIGl0IGFsbCB3b3J0
aCB3aGlsZSAuIC4gLiAKCXN1YiBjcmVhdGVfbmV3IHsKCQlteSAkc2VsZiA9
IHNoaWZ0OwoJCW15ICRyZXFfY29tcG9uZW50cyA9ICRzZWxmLT5tZXRhX2lu
Zm8oJ2hhc19vbmUnKTsKCQlteSAkb3B0X2NvbXBvbmVudHMgPSAkc2VsZi0+
bWV0YV9pbmZvKCdtaWdodF9oYXZlJyk7CgoJCW15ICVjZ2kgPSAkc2VsZi0+
dG9fY2dpOyAjIGdldCBpbnB1dHMgZnJvbSBBc0Zvcm0KCQlmb3JlYWNoIG15
ICRjb21wIChrZXlzICUkcmVxX2NvbXBvbmVudHMpIHsKCQkJbXkgJGZjbGFz
cyA9ICRyZXFfY29tcG9uZW50cy0+eyRjb21wfS0+e2ZvcmVpZ25fY2xhc3N9
OwoJCQkkY2dpeyRjb21wfSA9ICRmY2xhc3MtPnRvX2NnaTsKCQl9CgoJCW15
ICR0ZW1wbGF0ZV9hcmdzID0geyAKCQkJY2dpID0+ICRjZ2ksIAoJCQlvcHRf
Y29tcG9uZW50cyA9PiAkb3B0X2NvbXBvbmVudHMgIAoJCX07Cgl9CgoJIyAu
Li4gYWNjZXNzaW5nIGluIFRUIHRlbXBsYXRlcwoJWyUgY2QucHJpbWFyeV9h
cnRpc3Q7ICVdCglbJSBjZC5zZWNvbmRhcnlfYXJ0aXN0OyVdCglbJSBmbHV0
ZV9wbGF5ZXJzID0gY2QuYmFuZF9tZW1iZXJzKCdpbnN0cnVtZW50JyAsICdm
bHV0ZScpJV0KCgogICAJIyBBIENvbXBhcmlzb246ICBkbyBhYm92ZSB3aXRo
IHdpdGgganVzdCBhIGhhc19tYW55ICAKCS4uLgoJTXVzaWM6OkNELT5oYXNf
bWFueShhcnRpc3RzID0+ICJNdXNpYzo6Q0RBcnRpc3QiKTsKCS4uLgoJc3Vi
IGNyZWF0ZV9uZXdfY2QgewoJCW15ICRzZWxmLT5zaGlmdDsKCQlteSAkcmVx
dWlyZWRfY29tcG9uZW50cyA9IDsgCgkJIyBUaGlzIGlzbid0IGZ1biBhbnlt
b3JlLiAKCX0KCgkjIGFjY2Vzc2luZyBpbiBUVCB0ZW1wbGF0ZXMKCVslIHBy
aW1hcnkgPSBjZC5hcnRpc3RzKCdhcnRpc3RfdHlwZScgLCAncHJpbWFyeScp
OyAKCSAgICMgaG9wZWZ1bGx5ICVdIAoJWyUgc2Vjb25kYXJ5ICA9IGNkLmFy
dGlzdHMoJ2FydGlzdF90eXBlJyAsICdzZWNvbmRhcnknKSVdCglbJSBmbHV0
ZV9wbGF5ZXJzID0gY2QuYXJ0aXN0cygnaW5zdHJ1bWVudCcgLCAnZmx1dGUn
KSVdCgo9Y3V0Cgo=

--0-244502363-1106781853=:97450--

(message missing)

one to one relationship revisited (has_own)
Peter Speltz 22:26 on 20 Jan 2005

Re: one to one relationship revisited (has_own)
Perrin Harkins 21:59 on 21 Jan 2005

Re: one to one relationship revisited (has_own)
Peter Speltz 05:11 on 22 Jan 2005

Re: one to one revisited (has_own)
Peter Speltz 18:16 on 22 Jan 2005

Re: one to one revisited (has_own)
William McKee 15:39 on 24 Jan 2005

Re: one to one revisited (has_own)
Peter Speltz 16:01 on 24 Jan 2005

Re: one to one revisited (has_own)
Andreas Fromm 08:19 on 25 Jan 2005

Re: one to one revisited (has_own)
Peter Speltz 19:34 on 25 Jan 2005

Selecting from a datetime field in MySQL
John Day 22:24 on 25 Jan 2005

Re: Selecting from a datetime field in MySQL
Perrin Harkins 22:29 on 25 Jan 2005

Re: one to one revisited (has_own)
Peter Speltz 23:24 on 26 Jan 2005

Re: one to one revisited (has_own)
Peter Speltz 17:40 on 01 Feb 2005

Re: one to one revisited (has_own)
Peter Speltz 08:23 on 25 Jan 2005

Generated at 12:39 on 05 Feb 2005 by mariachi v0.52