Re: Vague thoughts about is_a and might_be relationships

[prev] [thread] [next] [Date index for 2004/08/19]

  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.
  Send mail to mime@xxxxxxxxx.xxx.xxxxxxxxxx.xxx for more info.

--0-1474383814-1092916710=:9178
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Wed, 18 Aug 2004, Tom Hukins wrote:
> I've been thinking about how Class::DBI might work with table
> inheritance recently and briefly experimented with writing a custom
> relationship for this.

Cool.

I have a very short Class::DBI::Relationship::IsA module that Richard
Hundt wrote but isn't on CPAN. It seems to work when he used it but I
haven't used it in anger yet. It is attached, but I haven't tested (or
even compiled it). usual disclaimers and caveats apply :)

Right now he is on holiday in South Africa but he gets back we plan to
work together on some more relationships and attribute types and get them
onto CPAN. Any feedback or suggestions appreciated.

cheers,

A.

        -- 
        Aaron J Trevena - Perl Hacker, Kung Fu Geek, Internet Consultant
AutoDia --- Automatic UML and HTML Specifications from Perl, C++
and Any Datasource with a Handler.     http://droogs.org/autodia
--0-1474383814-1092916710=:9178
Content-Type: TEXT/PLAIN; charset=US-ASCII; name="IsA.pm"
Content-Transfer-Encoding: BASE64
Content-ID: <Pine.NEB.4.56.0408191258300.9178@xxxx.xxxxxxx.xxx.xx>
Content-Description: IsA.pm
Content-Disposition: attachment; filename="IsA.pm"

cGFja2FnZSBDbGFzczo6REJJOjpSZWxhdGlvbnNoaXA6OklzQTsNCg0KPWhl
YWQxIE5BTUUNCg0KQ2xhc3M6OkRCSTo6UmVsYXRpb25zaGlwOjpJc0EgLSBB
IENsYXNzOjpEQkkgbW9kdWxlIGZvciAnSXMgQScgcmVsYXRpb25zaGlwcw0K
DQo9aGVhZDEgREVTQ1JJUFRJT04NCg0KUHJvdmlkZXMgYW4gSXMgQSByZWxh
dGlvbnNoaXAgYmV0d2VlbiBDbGFzczo6REJJIGNsYXNzZXMuDQoNClNlZSBD
bGFzczo6REJJLCB0aGlzIHNob3VsZCBEVFJUIHdoZW4geW91IHNwZWNpZnkg
YW4gSXNBIHJlbGF0aW9uc2hpcA0KYmV0d2VlbiBjbGFzc2VzIHRyYW5zcGFy
ZW50bHkuDQoNCj1jdXQNCg0KIyBub3RlIHRvIHJpY2hhcmQgOiB5b3Uga25v
dyB0aGUgaGFzaCBzeW1ib2wsIGluIHBlcmwgd2UgdXNlIGl0IGZvciANCiMg
Y29tbWVudHMsIG9mdGVuIHNldmVyYWwgdGltZXMgaW4gYSBzaW5nbGUgcHJv
Z3JhbSENCg0KdXNlIHN0cmljdDsNCnVzZSB3YXJuaW5nczsNCnVzZSBiYXNl
IHF3KCBDbGFzczo6REJJOjpSZWxhdGlvbnNoaXAgKTsNCg0Kc3ViIHJlbWFw
X2FyZ3VtZW50cyB7DQogICAgbXkgJHByb3RvID0gc2hpZnQ7DQogICAgbXkg
JGNsYXNzID0gc2hpZnQ7DQogICAgJGNsYXNzLT5faW52YWxpZF9vYmplY3Rf
bWV0aG9kKCdpc19hKCknKSBpZiByZWYgJGNsYXNzOw0KICAgIG15ICRjb2x1
bW4gPSAkY2xhc3MtPmZpbmRfY29sdW1uKCtzaGlmdCkNCglvciByZXR1cm4g
JGNsYXNzLT5fY3JvYWsoImlzX2EgbmVlZHMgYSB2YWxpZCBjb2x1bW4iKTsN
CiAgICBteSAkZl9jbGFzcyA9IHNoaWZ0DQoJb3IgJGNsYXNzLT5fY3JvYWso
IiRjbGFzcyAkY29sdW1uIG5lZWRzIGFuIGFzc29jaWF0ZWQgY2xhc3MiKTsN
CiAgICBteSAlbWV0aHMgPSBAXzsNCiAgICANCiAgICBteSBAZl9jb2xzOw0K
ICAgIGZvcmVhY2ggbXkgJGZfY29sICgkZl9jbGFzcy0+YWxsX2NvbHVtbnMp
IHsNCglwdXNoIEBmX2NvbHMsICRmX2NvbA0KCSAgICB1bmxlc3MgJGZfY29s
IGVxICRmX2NsYXNzLT5wcmltYXJ5X2NvbHVtbjsNCiAgICB9DQogICAgDQog
ICAgJGNsYXNzLT5fX2dyb3VwZXItPmFkZF9ncm91cChURU1QID0+IG1hcCB7
ICRfLT5uYW1lIH0gQGZfY29scyk7DQoNCiAgICByZXR1cm4gKCRjbGFzcywg
JGNvbHVtbiwgJGZfY2xhc3MsIFwlbWV0aHMpOw0KfQ0KIA0Kc3ViIHRyaWdn
ZXJzIHsNCiAgICBteSAkc2VsZiA9IHNoaWZ0Ow0KICAgICRzZWxmLT5jbGFz
cy0+X3JlcXVpcmVfY2xhc3MoJHNlbGYtPmZvcmVpZ25fY2xhc3MpOw0KICAg
IG15ICRjb2x1bW4gPSAkc2VsZi0+YWNjZXNzb3I7DQogICAgcmV0dXJuICgN
CgkgICAgc2VsZWN0ICAgICAgICA9PiAkc2VsZi0+X2luZmxhdG9yLA0KCSAg
ICBiZWZvcmVfY3JlYXRlID0+ICRzZWxmLT5fY3JlYXRvciwNCiAgICApOw0K
fQ0KDQpzdWIgbWV0aG9kcyB7DQogICAgbXkgJHNlbGYgPSBzaGlmdDsNCiAg
ICAkc2VsZi0+Y2xhc3MtPl9yZXF1aXJlX2NsYXNzKCRzZWxmLT5mb3JlaWdu
X2NsYXNzKTsNCiAgICByZXR1cm4oDQogICAgICAgIHNlYXJjaCAgICAgID0+
ICRzZWxmLT5zZWFyY2gsDQogICAgICAgIHNlYXJjaF9saWtlID0+ICRzZWxm
LT5zZWFyY2hfbGlrZSwNCglhbGxfY29sdW1ucyA9PiAkc2VsZi0+YWxsX2Nv
bHVtbnMsDQogICAgKTsNCn0NCg0Kc3ViIHNlYXJjaCB7DQogICAgbXkgJHNl
bGYgPSBzaGlmdDsNCiAgICBteSAkU1VQRVIgPSAkc2VsZi0+Zm9yZWlnbl9j
bGFzczsNCiAgICBteSAkY29sID0gJHNlbGYtPmFjY2Vzc29yOw0KICAgIHsN
CglubyBzdHJpY3QgInJlZnMiOw0KCSp7JHNlbGYtPmNsYXNzLiI6Om9yaWdf
c2VhcmNoIn0gPSBcJnsiQ2xhc3M6OkRCSTo6c2VhcmNoIn07DQogICAgfSAg
DQogICAgcmV0dXJuIHN1YiB7DQoJbXkgKCRzZWxmLCAkaywgJHYpID0gKEBf
KTsNCglpZiAoISRzZWxmLT5oYXNfcmVhbF9jb2x1bW4oJGspKSB7DQoJICAg
IHJldHVybiBtYXAgeyAkc2VsZi0+b3JpZ19zZWFyY2goJGNvbCA9PiAkXy0+
aWQpDQoJCQkgfSAkU1VQRVItPnNlYXJjaCgkayA9PiAkdik7DQoJfSBlbHNl
IHsNCgkgICAgcmV0dXJuICRzZWxmLT5vcmlnX3NlYXJjaCgkayA9PiAkdik7
DQoJfQ0KICAgIH07DQp9DQoNCnN1YiBzZWFyY2hfbGlrZSB7DQogICAgbXkg
JHNlbGYgPSBzaGlmdDsNCiAgICBteSAkU1VQRVIgPSAkc2VsZi0+Zm9yZWln
bl9jbGFzczsNCiAgICBteSAkY29sID0gJHNlbGYtPmFjY2Vzc29yOw0KICAg
IHsNCglubyBzdHJpY3QgInJlZnMiOw0KCSp7JHNlbGYtPmNsYXNzLiI6Om9y
aWdfc2VhcmNoX2xpa2UifSA9IFwmeyJDbGFzczo6REJJOjpzZWFyY2hfbGlr
ZSJ9Ow0KICAgIH0gIA0KICAgIHJldHVybiBzdWIgew0KCW15ICgkc2VsZiwg
JGssICR2KSA9IChAXyk7DQoJaWYgKCEkc2VsZi0+aGFzX3JlYWxfY29sdW1u
KCRrKSkgew0KCSAgICByZXR1cm4gbWFwIHsgJHNlbGYtPm9yaWdfc2VhcmNo
X2xpa2UoJGNvbCA9PiAkXy0+aWQpDQoJCQkgfSAkU1VQRVItPnNlYXJjaF9s
aWtlKCRrID0+ICR2KTsNCgl9IGVsc2Ugew0KCSAgICByZXR1cm4gJHNlbGYt
Pm9yaWdfc2VhcmNoX2xpa2UoJGsgPT4gJHYpOw0KCX0NCiAgICB9Ow0KfQ0K
DQpzdWIgYWxsX2NvbHVtbnMgew0KICAgIG15ICRzZWxmID0gc2hpZnQ7DQog
ICAgbXkgJFNVUEVSID0gJHNlbGYtPmZvcmVpZ25fY2xhc3M7DQogICAgbXkg
JGNvbCA9ICRzZWxmLT5hY2Nlc3NvcjsNCiAgICB7DQoJbm8gc3RyaWN0ICJy
ZWZzIjsNCgkqeyRzZWxmLT5jbGFzcy4iOjpvcmlnX2FsbF9jb2x1bW5zIn0g
PSBcJnsiQ2xhc3M6OkRCSTo6YWxsX2NvbHVtbnMifTsNCiAgICB9ICANCiAg
ICByZXR1cm4gc3ViIHsNCglteSAkc2VsZiA9IHNoaWZ0Ow0KCXJldHVybiAo
JHNlbGYtPm9yaWdfYWxsX2NvbHVtbnMsICRzZWxmLT5jb2x1bW5zKCdURU1Q
JykpOw0KICAgIH07DQp9DQoNCnN1YiBfY3JlYXRvciB7DQogICAgbXkgJHBy
b3RvID0gc2hpZnQ7DQogICAgbXkgJGNvbCA9ICRwcm90by0+YWNjZXNzb3I7
DQoNCiAgICByZXR1cm4gc3ViIHsNCglteSAkc2VsZiA9IHNoaWZ0Ow0KCW15
ICRtZXRhID0gJHNlbGYtPm1ldGFfaW5mbyhpc19hID0+ICRjb2wpOw0KCW15
ICRmX2NsYXNzID0gJG1ldGEtPmZvcmVpZ25fY2xhc3M7DQoNCglteSAkaGFz
aCA9IHsgfTsNCg0KCWZvcmVhY2ggKCRzZWxmLT5fX2dyb3VwZXItPmdyb3Vw
X2NvbHMoJ1RFTVAnKSkgew0KCSAgICAkaGFzaC0+eyRffSA9ICRzZWxmLT5f
YXR0cnMoJF8pOw0KCX0NCg0KCW15ICRmX29iaiA9ICRmX2NsYXNzLT5jcmVh
dGUoJGhhc2gpOw0KCSRwcm90by0+X2ltcG9ydF9jb2x1bW5fdmFsdWVzKCRz
ZWxmLCAkZl9jbGFzcywgJGZfb2JqKTsNCg0KCXJldHVybiAkc2VsZi0+X2F0
dHJpYnV0ZV9zdG9yZSgkY29sID0+ICRmX29iaik7DQogICAgfTsNCn0NCg0K
c3ViIF9pbmZsYXRvciB7DQogICAgbXkgJHByb3RvID0gc2hpZnQ7DQogICAg
bXkgJGNvbCA9ICRwcm90by0+YWNjZXNzb3I7DQoNCiAgICByZXR1cm4gc3Vi
IHsNCglteSAkc2VsZiA9IHNoaWZ0Ow0KCW15ICR2YWx1ZSA9ICRzZWxmLT4k
Y29sOw0KCW15ICRtZXRhID0gJHNlbGYtPm1ldGFfaW5mbyhpc19hID0+ICRj
b2wpOw0KCW15ICRmX2NsYXNzID0gJG1ldGEtPmZvcmVpZ25fY2xhc3M7DQoN
CglyZXR1cm4gaWYgcmVmKCR2YWx1ZSkgYW5kICR2YWx1ZS0+aXNhKCRmX2Ns
YXNzKTsNCg0KCSR2YWx1ZSA9ICRmX2NsYXNzLT5fc2ltcGxlX2JsZXNzKCR2
YWx1ZSk7DQoJJHByb3RvLT5faW1wb3J0X2NvbHVtbl92YWx1ZXMoJHNlbGYs
ICRmX2NsYXNzLCAkdmFsdWUpOw0KCQ0KCXJldHVybiAkc2VsZi0+X2F0dHJp
YnV0ZV9zdG9yZSgkY29sID0+ICR2YWx1ZSk7DQogICAgfTsNCn0NCg0Kc3Vi
IF9pbXBvcnRfY29sdW1uX3ZhbHVlcyB7DQogICAgbXkgKCRzZWxmLCAkY2xh
c3MsICRmX2NsYXNzLCAkZl9vYmopID0gKEBfKTsNCiAgICBmb3JlYWNoICgk
Zl9jbGFzcy0+YWxsX2NvbHVtbnMpIHsNCgkkY2xhc3MtPl9hdHRyaWJ1dGVf
c3RvcmUoJF8sICRmX29iai0+JF8pDQoJICAgIHVubGVzcyAkXy0+bmFtZSBl
cSAkY2xhc3MtPnByaW1hcnlfY29sdW1uLT5uYW1lOw0KICAgIH0NCn0NCg0K
c3ViIF9zZXRfdXBfY2xhc3NfZGF0YSB7DQogICAgICAgIG15ICRzZWxmID0g
c2hpZnQ7DQogICAgICAgICRzZWxmLT5jbGFzcy0+X2V4dGVuZF9jbGFzc19k
YXRhKF9faXNhX3JlbHMgPT4gJHNlbGYtPmFjY2Vzc29yID0+DQogICAgICAg
ICAgICAgICAgICAgICAgICBbICRzZWxmLT5mb3JlaWduX2NsYXNzLCAleyAk
c2VsZi0+YXJncyB9IF0pOw0KICAgICAgICAkc2VsZi0+U1VQRVI6Ol9zZXRf
dXBfY2xhc3NfZGF0YTsNCn0NCg0KIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMNCg0KPWhlYWQxIFNFRSBBTFNPDQoNCkw8cGVybD4NCg0K
Q2xhc3M6OkRCSQ0KDQpDbGFzczo6REJJOjpSZWxhdGlvbnNoaXANCg0KPWhl
YWQxIEFVVEhPUg0KDQpSaWNoYXJkIEh1bmR0LCBFPGx0PnJpY2hhcmRAd2Vi
dGsub3JnRTxndD4NCg0KPWhlYWQxIENPUFlSSUdIVA0KDQpMaWNlbnNlZCBm
b3IgdXNlLCBtb2RpZmljYXRpb24gYW5kIGRpc3RyaWJ1dGlvbiB1bmRlciB0
aGUgQXJ0aXN0aWMNCmFuZCBHTlUgR1BMIGxpY2Vuc2VzLg0KDQpDb3B5cmln
aHQgKEMpIDIwMDQgYnkgUmljaGFyZCBIdW5kdCA8cmljaGFyZEB3ZWJ0ay5v
cmc+DQoNClRoaXMgbGlicmFyeSBpcyBmcmVlIHNvZnR3YXJlOyB5b3UgY2Fu
IHJlZGlzdHJpYnV0ZSBpdCBhbmQvb3IgbW9kaWZ5DQppdCB1bmRlciB0aGUg
c2FtZSB0ZXJtcyBhcyBQZXJsIGl0c2VsZiwgZWl0aGVyIFBlcmwgdmVyc2lv
biA1LjguMSBvciwNCmF0IHlvdXIgb3B0aW9uLCBhbnkgbGF0ZXIgdmVyc2lv
biBvZiBQZXJsIDUgeW91IG1heSBoYXZlIGF2YWlsYWJsZS4NCg0KPWN1dA0K
DQoNCiMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjDQojIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIw0KDQoxOw0KDQo=

--0-1474383814-1092916710=:9178--