REPOST: [Dbix-class] DBIx::Class and caching
Oleg Pronin
syber.rus at gmail.com
Thu Jul 17 16:18:08 BST 2008
MjAwOC83LzE2IEhhcnRtYWllciBBbGV4YW5kZXIgPEFsZXhhbmRlci5IYXJ0bWFpZXJAdC1zeXN0
ZW1zLmF0PjoKCj4gIFRoaXMgbG9va3MgcHJvbWlzaW5nIHRvIG1lIChidXQgSSdtIHN1cmUgbXN0
IHdpbGwgZmluZCBhbiBhcmd1bWVudAo+IGFnYWluc3QgaXQgOy0pLgo+CgpUaGUgbWFpbiBhcmd1
bWVudCBpcyBwZXJmb21hbmNlIGZvciB0aGlzIHRoaW5nIChpdCBkb2VzIG1hdHRlciBpbiBodWdl
CnByb2plY3RzKS4KCgo+IElmIG5vdCBpdCB3b3VsZCBiZSBhIGdyZWF0ICBhZGRpdGlvbiB0byBk
YmljIG9yIGEgbmljZSBzdGFuZGFsb25lIG1vZHVsZSEKPgoKbWF5YmUsIChpZiBpIHdpbGwgdW5k
ZXJzdGFuZCBob3cgdG8gbWFrZSBpdCBtb3JlIGNvbnZlbmllbnQgZm9yIGNvbmZpZ3VyaW5nKQoK
Cj4KPgo+IC1BbGV4Cj4KPgo+Cj4gKkZyb206KiBPbGVnIFByb25pbiBbbWFpbHRvOnN5YmVyLnJ1
c0BnbWFpbC5jb21dCj4gKlNlbnQ6KiBUaHVyc2RheSwgSnVseSAwMywgMjAwOCA0OjE5IFBNCj4g
KlRvOiogZGJpeC1jbGFzc0BsaXN0cy5zY3N5cy5jby51awo+ICpTdWJqZWN0OiogUkVQT1NUOiBb
RGJpeC1jbGFzc10gREJJeDo6Q2xhc3MgYW5kIGNhY2hpbmcKPgo+Cj4KPgo+Cj4gLS0tLS0tLS0t
LSDwxdLF08zBzs7PxSDTz8/C3cXOycUgLS0tLS0tLS0tLQo+IO/UOiAqT2xlZyBQcm9uaW4qIDxz
eWJlci5ydXNAZ21haWwuY29tPgo+IOTB1ME6IDI1IMnAztEgMjAwOCDHLiAxMjoxNwo+IPTFzcE6
IFJlOiBbRGJpeC1jbGFzc10gREJJeDo6Q2xhc3MgYW5kIGNhY2hpbmcKPiDrz83VOiBhbmRyM2Fz
QHlhaG9vLmNvbSwgIkRCSXg6OkNsYXNzIHVzZXIgYW5kIGRldmVsb3BlciBsaXN0IiA8Cj4gZGJp
eC1jbGFzc0BsaXN0cy5zY3N5cy5jby51az4KPgo+Cj4gVGhpcyBpcyBob3cgaSBjYWNoZSByZXN1
bHRzZXQgc2VhcmNoIHJlc3VsdHMgaW4gbWVtY2FjaGU6Cj4KPiBUaGVyZSAyIG1vZHVsZXMgaW4g
YXR0YWNoLgo+Cj4gMSkgVG8gdXNlIG1lbWNhY2hpbmcgZm9yIHNvbWUgb2JqZWN0IHlvdSBuZWVk
IHRvIHNldCBSZXN1bHRTZXRNZW1jYWNoZWQgYXMKPiBpdHMgcmVzdWx0c2V0IGNsYXNzIChvciBy
ZXN1bHRzZXQgd2hpY2ggZGVyaXZlcyBmcm9tIGl0KS4KPiAyKSBDb2RlIGluIFJlc3VsdFNvdXJj
ZS5wbSBtdXN0IGJlIGluIHlvdXIgYmFzZSByZXN1bHRzb3VyY2UgY2xhc3MuCj4gMykgWW91IGhh
dmUgdG8gc2V0IHVwIG9uIHN0YXJ0Ogo+ICAgICAgUmVzdWx0U2V0TWVtY2FjaGVkLT5tZW1kICjB
IG1lbWQgb2JqZWN0KQo+ICAgICAgUmVzdWx0U291cmNlLT5zY2hlbWFfYnlfY2xhc3Moewo+ICAg
ICAgICAgICdNeUFwcDo6U2NoZW1hJyA9PiAkbXlhcHBTY2hlbWFPYmplY3QsCj4gICAgICAgICAg
J015QXBwOjpPdGhlclNjaGVtYScgPT4gJG15YXBwT3RoZXJTY2hlbWFPYmplY3QsCj4gICAgICB9
KTsKPiAgICAgIFRoaXMgaXMgbmVlZGVkIGZvciBjb3JyZWN0IHJlc3RvcmluZyBmcm9tIGNhY2hl
Owo+Cj4gVXNhZ2U6Cj4KPiAkc29tZVJTLT5zZWFyY2goCj4gICAgIHtBTllDT05EfSwKPiAgICAg
e0FUVFJTLAo+ICAgICAgIGNhY2hlX2ZvciA9PiAzMAo+ICAgICB9LAo+ICk7Cj4gb3IgJHNvbWVS
Uy0+c2VhcmNoKC4uLiktPnNlYXJjaCguLi4pLT5jYWNoZV9mb3IoMzApLT5zZWFyY2goLi4uKS0+
YWxsOwo+IG9yICRzb21lUlMtPnNpbmdsZSh7aWQgPT4gJGlkfSwge2NhY2hlX2ZvciA9PiAxMjB9
KTsKPgo+IFRoZSBrZXkgZm9yIG1lbWNhY2hlIGlzIGdlbmVyYXRlZCBhdXRvbWF0aWNhbGx5Lgo+
IFlvdSBjYW4gZ2VuZXJhdGUgaXQgbWFudWFsbHkKPiAkc29tZVJTLT5zZWFyY2goe2lkID0+ICRp
ZH0sIHsKPiAgICAgY2FjaGVfZm9yID0+IDMwLAo+ICAgICBjYWNoZV9rZXkgPT4gJ3VzZXJfJy4k
aWQsCj4gfSk7Cj4KPiBTb21lIGNvZGUgY2FuIGJlIGV4ZWN1dGVkIGJlZm9yZSBvYmplY3QgaXMg
Y2FjaGVkIChmcm9tIERCKToKPiAkc29tZVJTLT5zZWFyY2goe2lkID0+ICRpZH0sIHsKPiAgICAg
Y2FjaGVfZm9yID0+IDMwLAo+ICAgICBjYWNoZV9rZXkgPT4gJ3VzZXJfJy4kaWQsCj4gICAgIGNh
Y2hlX2FmdGVyID0+IHN1YiB7ICRfWzBdLT5zZXRfc29tZV9kaWZmaWN1bHRfdmlydHVhbF9kYXRh
KC4uLi4pIH0sCj4gfSk7Cj4KPiAyMDA4LzYvMjQgQW5kcmVhcyBQcm9uYWtpcyA8YW5kcjNhc0B5
YWhvby5jb20+Ogo+Cj4KPgo+IEZvcmdpdmUgbWUgaWYgdGhpcyBxdWVzdGlvbiBzb3VuZHMgbGlr
ZSBhc2tpbmcgZm9yIGJhYnkgc3RlcCBpbnN0cnVjdGlvbnMKPiAgYnV0IEkgaG9wZSBpdCB3aWxs
IGJlbmVmaXQgb3RoZXIgREJJeDo6Q2xhc3Mgc3RhcnRlcnMuCj4KPiBXZSBoYXZlIGEgbG90IG9m
IHByb2NlZHVyYWwgY29kZSB0aGF0IHdlIGFyZSBsb29raW5nIHRvIGNvbnZlcnQgdG8gRE9NCj4g
KERvbWFpbiBPYmplY3QgTW9kZWxpbmcpIGFuZCBvbmUgb2YgdGhlIHRvb2xzIHdlIGFyZSBsb2tv
aW5nIHRvIHVzZSBpcwo+IERCSXg6OkNsYXNzIChpbnN0ZWFkIG9mIHdyaXRpbmcgb3VyIG93biBN
b2RlbCB3aGljaCBjb3VsZCBiZSBmdW4gYnV0IGEKPiBtYWludGVuYW5jZSBuaWdodG1hcmUpLgo+
Cj4gQW55d2F5LCB0aGUgc2V0IHVwLCB3ZSBhcmUgbG9vayBpcyBtb2RfcGVybCwgREJJeDo6Q2xh
c3MsIE15U1FMIGJhY2tlbmQsCj4gYW5kIHNvbWUgc29ydCBvZiBNVkMgY29uY2VwdCBidXQgd2Ug
d2lsbCBub3QgKGZvciBub3cpIGJlIHVzaW5nIENhdGFseXN0Cj4gKGRvbid0IGFzayB3aHkpLgo+
Cj4gQmFzZWQgb24gdGhlIGFib3ZlIGluZm9ybWF0aW9uIG15IHF1ZXN0aW9ucyBhcmU6Cj4gMS4g
UmVzdWx0U2V0IGhhcyBhIGNvdXBsZSBvZiBtZXRob2RzIHJlbGF0ZWQgdG8gY2FjaGluZywgYnV0
IGdvaW5nIGJ5IHRoZQo+IGV4YW1wbGUgZ2l2ZW4gKAo+IGh0dHA6Ly9zZWFyY2guY3Bhbi5vcmcv
fmFzaC9EQkl4LUNsYXNzLTAuMDgwMTAvbGliL0RCSXgvQ2xhc3MvUmVzdWx0U2V0LnBtI2NhY2hl
PGh0dHA6Ly9zZWFyY2guY3Bhbi5vcmcvJTdFYXNoL0RCSXgtQ2xhc3MtMC4wODAxMC9saWIvREJJ
eC9DbGFzcy9SZXN1bHRTZXQucG0jY2FjaGU+KQo+ICBpdCBzZWVtcyBsaWtlIHlvdSBoYXZlIHRv
IHR1cm4gY2FjaGluZyBvbiBhIHBlciBzZWFyY2goKS9maW5kKCkgY2FsbCwgaXMKPiB0aGVyZSBz
b21lIHdheSBvZiB0dXJuaW5nIGl0IG9uIGZvciB0aGUgd2hvbGUgY2xhc3MgKGV2ZW4gYmV0dGVy
IGFsbAo+IGNsYXNzZXMpIGluIG9uZSBwbGFjZSAoaS5lLiBQYXJlbnQgY2xhc3MgdGhhdCBhbGwg
b3RoZXIgY2xhc3NlcyBpbmhlcml0Cj4gZnJvbSk/Cj4gMS4xIElzIG92ZXJyaWRpbmcvc3ViY2xh
c3MgcmVzdWx0c2V0L1Jlc3VsdFNldCB0byBjYXB0dXJlIHNlYXJjaC9maW5kCj4gcmVxdWVzdCB0
byBhZGQgdGhlIGNhY2hlIHBhcmFtZXRlciBhbiBvcHRpb25zIHRvIGFjaGlldmUgdGhlIGFib3Zl
Pwo+IDIuIElzIHRoZXJlIGEgZGlmZmVyZW50IHdheSB0byBjYWNoZSBvYmplY3RzIGFuZC9vciBS
ZXN1bHRTZXQgb2JqZWN0cz8KPiAzLiBDYW4gd2UgY2FjaGUgU1FMIG5hdGl2ZWx5IGluIERCSXg6
OkNsYXNzIGkuZS4gdGhlIFNRTCBleGVjdXRlZCBieSBhCj4gZmluZCwgc2VhcmNoIG9yIG1hbnVh
bCBTRUxFQ1QgLSBJIGd1ZXNzIGlmIDEgYW5kIDEuMSBhcmUgc3VwcG9ydGVkIFNRTAo+IGNhY2hp
bmcgbWlnaHQgYmUgcmVkdW5kYW50IGV4Y2VwdCBmcm9tIG1hbnVhbCBTRUxFQ1RzPwo+IDQuIElm
IHRoZXJlIGlzbid0IG5hdGl2ZSBzdXBwb3J0IGZvciB0aGUgYWJvdmUsIGNhbiBzb21lb25lIGdp
dmUgbWUgYW55Cj4gYWR2aWNlIGFuZC9vciBleGFtcGxlcyByZWdhcmRpbmcgdXNpbmcgREJJeDo6
Q2xhc3MgYW5kIE1lbUNhY2hlIHRvIGFjaGlldmUKPiB0aGUgc2FtZSByZXN1bHQ/Cj4gNS4gSSBj
YW1lIGFjcm9zcyB0aGUgbW9kdWxlIERCSXg6OkNsYXNzOjpDdXJzb3I6OkNhY2hlZCBidXQgc2lu
Y2UgdGhlCj4gZG9jdW1lbnRhdGlvbiBpcyBhIGJpdCBvbiB0aGUgdGhpbiBzaWRlLCBJIHdhcyB3
b25kZXJpbmcgaWYgc29tZW9uZSBjYW4KPiBleHBsYWluIGl0IGluIGEgYml0IG1vcmUgZGV0YWls
LiAgRm9yIGV4YW1wbGUgaXMgaXQgcG9zc2libGUgdG8gdXNlIGl0IHRvCj4gYWNoaWV2ZSBwb2lu
dHMgMS8xLjEgYW5kIGFsc28gc2V0IGEgZGVmYXVsdCBjYWNoZV9mb3IgcGVyaW9kZiBmb3IgYSB3
aG9sZQo+IGNsYXNzLCByYXRoZXIgdGhhbiBpbmRpdmlkdWFsIHNlYXJjaCByZXF1ZXN0cz8KPgo+
IFRoYW5rcyBpbiBhZHZhbmNlIGZvciB5b3VyIHBhdGllbmNlIGFuZCBoZWxwCj4KPiBBbmRyZWFz
IFByb25ha2lzCj4gREJJeDo6Q2xhc3MgbmV3YmllIGJ1dCBiZWxpZXZlcgo+Cj4KPgo+Cj4gX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBMaXN0OiBodHRw
Oi8vbGlzdHMuc2NzeXMuY28udWsvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL2RiaXgtY2xhc3MK
PiBJUkM6IGlyYy5wZXJsLm9yZyNkYml4LWNsYXNzCj4gU1ZOOiBodHRwOi8vZGV2LmNhdGFseXN0
LnBlcmwub3JnL3JlcG9zL2Jhc3QvREJJeC1DbGFzcy8KPiBTZWFyY2hhYmxlIEFyY2hpdmU6Cj4g
aHR0cDovL3d3dy5ncm9rYmFzZS5jb20vZ3JvdXAvZGJpeC1jbGFzc0BsaXN0cy5yYXdtb2RlLm9y
Zwo+Cj4KPgo+Cj4KPgo+ICoiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIq
IioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqCj4gVC1TeXN0ZW1zIEF1c3RyaWEg
R2VzbWJIIFJlbm53ZWcgOTctOTksIDEwMzAgV2llbgo+IEhhbmRlbHNnZXJpY2h0IFdpZW4sIEZO
IDc5MzQwYgo+Cj4gKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIq
IioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioKPiBOb3RpY2U6IFRoaXMgZS1tYWlsIGNv
bnRhaW5zIGluZm9ybWF0aW9uIHRoYXQgaXMgY29uZmlkZW50aWFsIGFuZCBtYXkgYmUKPiBwcml2
aWxlZ2VkLgo+IElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQsIHBsZWFzZSBu
b3RpZnkgdGhlIHNlbmRlciBhbmQgdGhlbgo+IGRlbGV0ZSB0aGlzIGUtbWFpbCBpbW1lZGlhdGVs
eS4KPgo+ICoiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioi
KiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqCj4KPiBfX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fXwo+IExpc3Q6IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9j
Z2ktYmluL21haWxtYW4vbGlzdGluZm8vZGJpeC1jbGFzcwo+IElSQzogaXJjLnBlcmwub3JnI2Ri
aXgtY2xhc3MKPiBTVk46IGh0dHA6Ly9kZXYuY2F0YWx5c3QucGVybC5vcmcvcmVwb3MvYmFzdC9E
Qkl4LUNsYXNzLwo+IFNlYXJjaGFibGUgQXJjaGl2ZToKPiBodHRwOi8vd3d3Lmdyb2tiYXNlLmNv
bS9ncm91cC9kYml4LWNsYXNzQGxpc3RzLnJhd21vZGUub3JnCj4KLS0tLS0tLS0tLS0tLS0gbmV4
dCBwYXJ0IC0tLS0tLS0tLS0tLS0tCkFuIEhUTUwgYXR0YWNobWVudCB3YXMgc2NydWJiZWQuLi4K
VVJMOiBodHRwOi8vbGlzdHMuc2NzeXMuY28udWsvcGlwZXJtYWlsL2RiaXgtY2xhc3MvYXR0YWNo
bWVudHMvMjAwODA3MTcvNzMxNDI3OTMvYXR0YWNobWVudC5odG0K
More information about the DBIx-Class
mailing list