[Dbix-class] Many to many relationship searching

jakac jakac at iprom.si
Mon Jun 23 12:26:10 BST 2008


SGVsbG8sCgpJIHRyaWVkIHdpdGg6Cm15ICRhcnRpY2xlcyA9ICRjLT5tb2RlbCgnTXlEQjo6QXJ0
aWNsZXMnKS0+c2VhcmNoKAogICAgeyAnY2F0ZWdvcmllcy51c2Vyc19pZCcgPT4gJGMtPnVzZXIt
PnVzZXJzX2lkIH0sCiAgICAgICAgewogICAgICAgICAgICBqb2luID0+IHsgJ2NhdGVnb3JpZXNf
YXJ0aWNsZXNfcmVsJyA9PiAnY2F0ZWdvcnlfaWQnIH0KICAgICAgICB9CiAgICApOwoKQnV0IG5v
dyBJIGdldCBhIGxpc3Qgb2YgOTkgbGluZXMsIGFsbCBvZiB0aGVtIGFyZSBkdXBsaWNhdGVkIG11
bHRpcGxlIAp0aW1lcyAuLi4KClRoZSBzdGF0ZW1lbnQgdGhhdCBpcyBleGVjdXRlZCBpczoKClNF
TEVDVCBtZS5hcnRpY2xlX2lkLCBtZS50aXRsZSwgbWUuY29udGVudCBGUk9NIGFydGljbGVzIG1l
IExFRlQgSk9JTiAKY2F0ZWdvcmllc19hcnRpY2xlc19yZWwgY2F0ZWdvcmllc19hcnRpY2xlc19y
ZWwgT04gKCAKY2F0ZWdvcmllc19hcnRpY2xlc19yZWwuYXJ0aWNsZV9pZCA9IG1lLmFydGljbGVf
aWQgKSBMRUZUIEpPSU4gCmNhdGVnb3JpZXMgY2F0ZWdvcnlfaWQgT04gKCBjYXRlZ29yeV9pZC5j
YXRlZ29yeV9pZCA9IApjYXRlZ29yaWVzX2FydGljbGVzX3JlbC5jYXRlZ29yeV9pZCApIFdIRVJF
ICggY2F0ZWdvcmllcy51c2Vyc19pZCA9ID8gKTsKCih1c2Vyc19pZCA9IDEpCgpUaGVyZSBzaG91
bGQgYmUgb25seSA3IGxpbmVzIHNpbmNlIEkgaGF2ZSBvbmx5IDcgYXJ0aWNsZXMgaW4gdGhlIApk
YXRhYmFzZSB0aGF0IGFyZSBpbiBjYXRlZ29yaWVzCmJ5IHVzZXIgd2l0aCBJRCAxLi4uCkNhbiBz
b21lYm9keSBwbGVhc2Ugd3JpdGUgdGhlIGV4YWN0IGNvZGUgaG93IHRoaXMgc2VhcmNoK3NvcnQg
c2hvdWxkIGJlIApkb25lPwpJIHN0dWRpZWQgbWFudWFsLCBjb29rYm9vayBidXQgSSBzdGlsbCBk
b24ndCBnZXQgaXQgOigKCkxpa2UgSSBzYWlkIC0gdGhlIHN0YXRlbWVudCB0aGF0IHJldHVybnMg
d2hhdCBJIG5lZWQgaXM6CgpzZWxlY3QgYS4qIGZyb20gYXJ0aWNsZXMgYSwgY2F0ZWdvcmllcyBj
LCBjYXRlZ29yaWVzX2FydGljbGVzX3JlbCByZWwKd2hlcmUKYS5hcnRpY2xlX2lkID0gcmVsLmFy
dGljbGVfaWQKYW5kCmMuY2F0ZWdvcnlfaWQgPSByZWwuY2F0ZWdvcnlfaWQKYW5kCmMudXNlcl9p
ZCA9ICckc29tZXVzZXInCm9yZGVyIGJ5IGEudGl0bGU7CgoKQnV0IEkgd2FudCB0byBkbyBpdCB3
aXRoIERCSXg6OkNsYXNzLi4uCgoKVGhhbnghCgoKClpiaWduaWV3IEx1a2FzaWFrIHdyb3RlOgo+
IDIwMDgvNi8yMyBqYWthYyA8amFrYWNAaXByb20uc2k+Ogo+ICAgCj4+IFNvcnJ5IGZvciBhIHR5
cG8uLi4KPj4KPj4gX19QQUNLQUdFX18tPmJlbG9uZ3NfdG8oICJhcnRpY2xlX2lkIiwgIk15REI6
OkFydGljbGVzCj4+ICIsIHsgcmVjaXBpZW50c19pZCA9PiAicmVjaXBpZW50c19pZCIgfSwgKTsK
Pj4KPj4gc2hvdWxkIGJlCj4+Cj4+IF9fUEFDS0FHRV9fLT5iZWxvbmdzX3RvKCAiYXJ0aWNsZV9p
ZCIsICJNeURCOjpBcnRpY2xlcyIsIHsgYXJ0aWNsZV9pZCA9Pgo+PiAiYXJ0aWNsZV9pZCIgfSwg
KTsKPj4KPj4gU3RpbGwuLi4gdGhlIHF1ZXN0aW9uIGlzIHRoZSBzYW1lIDopCj4+Cj4+Cj4+IGph
a2FjIHdyb3RlOgo+Pgo+PiBIZWxsbywKPj4KPj4gSSBhbSBkZXZlbG9waW5nIGFwcGxpY2F0aW9u
IHVzaW5nIENhdGFseXN0ICYgUG9zdGdyZXMgYW5kIEkgaGF2ZSBhIHNpbXBsZQo+PiBtYW55IHRv
IG1hbnkKPj4gcmVsYXRpb25zaGlwIHRoYXQgaW5jbHVkZXMgZm9sbG93aW5nIHRocmVlIHRhYmxl
czoKPj4KPj4gLSBjYXRlZ29yaWVzIChjYXRlZ29yeV9pZCBwcmltYXJ5IGtleSwgY2F0ZWdvcnlf
bmFtZSwgdXNlcnNfaWQsIC4uLi4uLikKPj4gLSBhcnRpY2xlcyAoYXJ0aWNsZV9pZCBwcmltYXJ5
IGtleSwgdGl0bGUsIGNvbnRlbnQuLi4uLi4uKQo+PiAtIGNhdGVnb3JpZXNfYXJ0aWNsZXNfcmVs
IChyZWxfaWQgcHJpbWFyeSBrZXksIGNhdGVnb3J5X2lkLCBhcnRpY2xlX2lkKQo+Pgo+PiBNeSBz
Y2hlbWEgaW5jbHVkZXM6Cj4+ICMgQ0FURUdPUklFUwo+PiBfX1BBQ0tBR0VfXy0+aGFzX21hbnko
ICJjYXRlZ29yaWVzX2FydGljbGVzX3JlbCIsCj4+ICJNeURCOjpDYXRlZ29yaWVzQXJ0aWNsZXNS
ZWwiLCAgeyAiZm9yZWlnbi5jYXRlZ29yeV9pZCIgPT4KPj4gInNlbGYuY2F0ZWdvcnlfaWQiIH0s
ICk7Cj4+Cj4+ICMgQVJUSUNMRVMKPj4gX19QQUNLQUdFX18tPmhhc19tYW55KCAiY2F0ZWdvcmll
c19hcnRpY2xlc19yZWwiLAo+PiAiTXlEQjo6Q2F0ZWdvcmllc0FydGljbGVzUmVsIiwgeyAiZm9y
ZWlnbi5hcnRpY2xlX2lkIiA9PiAic2VsZi5hcnRpY2xlX2lkIgo+PiB9LCApOwo+Pgo+PiAjIENB
VEVHT1JJRVNfQVJUSUNMRVNfUkVMCj4+IF9fUEFDS0FHRV9fLT5iZWxvbmdzX3RvKCAiY2F0ZWdv
cnlfaWQiLCAiTXlEQjo6Q2F0ZWdvcmllcyIsICB7IGNhdGVnb3J5X2lkCj4+ID0+ICJjYXRlZ29y
eV9pZCIgfSwpOwo+PiBfX1BBQ0tBR0VfXy0+YmVsb25nc190byggImFydGljbGVfaWQiLCAiTXlE
Qjo6QXJ0aWNsZXMiLCB7IHJlY2lwaWVudHNfaWQgPT4KPj4gInJlY2lwaWVudHNfaWQiIH0sICk7
Cj4+Cj4+Cj4+IE5vdyBJIHdhbnQgdG8gZ2V0IGEgbGlzdCBvZiBhbGwgYXJ0aWNsZXMgdGhhdCBh
cmUgaW4gY2F0ZWdvcmllcyB0aGF0IGFyZQo+PiBvd25lZCBieQo+PiBjZXJ0YWluIHVzZXIgYW5k
IG9yZGVyIHRoZW0gYnkgc29tZSBmaWVsZC4uLiBVc2luZyB0aGUgcGxhaW4gU1FMIEkgd291bGQK
Pj4gbm9ybWFsbHkgd3JpdGU6Cj4+Cj4+IHNlbGVjdCBhLiogZnJvbSBhcnRpY2xlcyBhLCBjYXRl
Z29yaWVzIGMsIGNhdGVnb3JpZXNfYXJ0aWNsZXNfcmVsIHJlbAo+PiB3aGVyZQo+PiBhLmFydGlj
bGVfaWQgPSByZWwuYXJ0aWNsZV9pZAo+PiBhbmQKPj4gYy5jYXRlZ29yeV9pZCA9IHJlbC5jYXRl
Z29yeV9pZAo+PiBhbmQKPj4gYy51c2VyX2lkID0gJyRzb21ldXNlcicKPj4gb3JkZXIgYnkgYS50
aXRsZTsKPj4KPj4gKGlmIEkgd2FudCB0byBvcmRlciBieSB0aXRsZSkKPj4KPj4gU28gbm93IG15
IHF1ZXN0aW9uIGlzIC0gaG93IHRvIGRvIHRoaXMgdXNpbmcgREJJeDo6Q2xhc3M/Cj4+Cj4+ICAg
ICAKPgo+IFJlYWQgcGVybGRvYyBEQkl4OjpDbGFzczo6TWFudWFsOjpKb2luaW5nCj4KPiBTb21l
dGhpbmcgbGlrZSB0aGF0IHNob3VsZCB3b3JrOgo+Cj4gJGFydGljbGVzX3JzLT5zZWFyY2goeyAu
Li4gfSB7IGpvaW4gPT4geyBjYXRlZ29yaWVzX2FydGljbGVzX3JlbCA9Pgo+IGNhdGVnb3J5X2lk
IH0gfSkKPgo+Cj4gQW5kIGJ5IHRoZSB3YXkgSSB3b3VsZCBjYWxsIHRoZSByZWxhdGlvbiBjYXRl
Z29yeSAtIHRvIGRpZmZlciBpdCBmcm9tCj4gdGhlIG5hbWUgb2YgdGhlIGNvbHVtbjoKPiAgX19Q
QUNLQUdFX18tPmJlbG9uZ3NfdG8oICJhcnRpY2xlIiwgIk15REI6OkFydGljbGVzIiwgeyBhcnRp
Y2xlX2lkID0+Cj4gICJhcnRpY2xlX2lkIiB9LCApOwo+Cj4gQ2hlZXJzLAo+IFpiaWduaWV3Cj4K
Pgo+ICAgCj4+IFRoYW5rIHlvdSEKPj4KPj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X18KPj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPj4g
TGlzdDogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9k
Yml4LWNsYXNzCj4+IElSQzogaXJjLnBlcmwub3JnI2RiaXgtY2xhc3MKPj4gU1ZOOiBodHRwOi8v
ZGV2LmNhdGFseXN0LnBlcmwub3JnL3JlcG9zL2Jhc3QvREJJeC1DbGFzcy8KPj4gU2VhcmNoYWJs
ZSBBcmNoaXZlOgo+PiBodHRwOi8vd3d3Lmdyb2tiYXNlLmNvbS9ncm91cC9kYml4LWNsYXNzQGxp
c3RzLnJhd21vZGUub3JnCj4+Cj4+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fCj4+IExpc3Q6IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9jZ2ktYmluL21h
aWxtYW4vbGlzdGluZm8vZGJpeC1jbGFzcwo+PiBJUkM6IGlyYy5wZXJsLm9yZyNkYml4LWNsYXNz
Cj4+IFNWTjogaHR0cDovL2Rldi5jYXRhbHlzdC5wZXJsLm9yZy9yZXBvcy9iYXN0L0RCSXgtQ2xh
c3MvCj4+IFNlYXJjaGFibGUgQXJjaGl2ZToKPj4gaHR0cDovL3d3dy5ncm9rYmFzZS5jb20vZ3Jv
dXAvZGJpeC1jbGFzc0BsaXN0cy5yYXdtb2RlLm9yZwo+Pgo+PiAgICAgCj4KPgo+Cj4gICAKLS0t
LS0tLS0tLS0tLS0gbmV4dCBwYXJ0IC0tLS0tLS0tLS0tLS0tCkFuIEhUTUwgYXR0YWNobWVudCB3
YXMgc2NydWJiZWQuLi4KVVJMOiBodHRwOi8vbGlzdHMuc2NzeXMuY28udWsvcGlwZXJtYWlsL2Ri
aXgtY2xhc3MvYXR0YWNobWVudHMvMjAwODA2MjMvOTljMTNhYjUvYXR0YWNobWVudC5odG0K


More information about the DBIx-Class mailing list