[DBIx-Class-Devel] Optimized update_or_create

Alexander Hartmaier alex.hartmaier at gmail.com
Mon Jul 15 09:02:00 GMT 2013


T24gRnJpLCBKdWwgMTIsIDIwMTMgYXQgOTo1MiBQTSwgZlJFVyBTY2htaWR0IDxmcmlvdXhAZ21h
aWwuY29tPiB3cm90ZToKCj4gQ3VycmVudGx5IGNyZWF0ZV9vcl91cGRhdGUgdXNlcyBleGFjdGx5
IHR3byBxdWVyaWVzOyBvbmUgdG8gbG9hZCB0aGUKPiByb3csIGFub3RoZXIgdG8gdXBkYXRlIGl0
IGlmIGl0IGlzIGZvdW5kIG9yIGluc2VydCBpdCBpZiBpdCBpcyBub3QKPiBmb3VuZC4KPgo+IEZv
ciBwcm9wZXJseSB3cml0dGVuIERCRCdzIChvbmUgd291bGQgaG9wZSB0aGF0IGlzIG1vc3QsIGJ1
dCBJCj4gd291bGRuJ3QgYXNzdW1lIGl0IDopIHRoaXMgY2FuIGJlIHJld3JpdHRlbiB0byBqdXN0
IGJlIGEgc2luZ2xlCj4gdXBkYXRlLCBsaWtlIHRoaXM6Cj4KPiAgICBzdWIgdXBkYXRlX29yX2Ny
ZWF0ZSB7Cj4gICAgICBteSAkc2VsZiA9IHNoaWZ0Owo+ICAgICAgbXkgJGF0dHJzID0gKEBfID4g
MSAmJiByZWYgJF9bJCNfXSBlcSAnSEFTSCcgPyBwb3AoQF8pIDoge30pOwo+ICAgICAgIyBiZWdp
biBoYW5kd2F2aW5nICh3ZSBuZWVkIHRvIGNvcnJlY3RseSBmaW5kIHRoZSBVQyBvciBQSykKPiAg
ICAgIG15ICRjb25kID0gcmVmICRfWzBdIGVxICdIQVNIJyA/IHNoaWZ0IDoge0BffTsKPgo+ICAg
ICAgIyBjYW4ndCB1c2UgdW5sZXNzIGJlY2F1c2UgMGUwIGlzIHJldHVybmVkIG9uIGVycm9yCj4g
ICAgICAkc2VsZi0+Y3JlYXRlKCRjb25kKSBpZiAkc2VsZi0+c2VhcmNoKCRzZWFyY2gpLT51cGRh
dGUoJGNvbmQpID09IDA7Cj4KPiAgICAgIHJldHVybgo+ICAgIH0KPgo+IFRoaXMgYnJlYWtzIGJh
Y2tjb21wYXQgaW4gdHdvIHNlcmlvdXMgd2F5czogZmlyc3QgaXQgdXNlcyB0aGUKPiByZXN1bHRz
ZXQgdXBkYXRlIGluc3RlYWQgb2YgdGhlIHJvdyB1cGRhdGUsIGFuZCBzZWNvbmQgaXQgZG9lc24n
dAo+IHJldHVybiB0aGUgY3JlYXRlZC91cGRhdGVkIHJvdy4KPgo+IEknbGwgcHJvYmFibHkgbWFr
ZSBhIGhlbHBlciB0aGF0IHdpbGwgZG8gdGhpcywgYnV0IEkgd2FzIHdvbmRlcmluZwo+IHdoYXQg
cGVvcGxlIHRob3VnaCBvZiBmb3IgbmFtZXM/ICBTb21ldGhpbmcgbGlrZQo+IHVwZGF0ZV9vcl9p
bnNlcnQgc2luY2UgeW91IGRvbid0IGdldCB0aGUgb2JqZWN0IGJhY2s/ICBJIGRvbid0IGxpa2UK
PiB1cGRhdGVfb3JfY3JlYXRlX2Zhc3QsIGJ1dCBpdCBraW5kYSBtYWtlcyBzZW5zZS4KPgo+IElk
ZWFzPwo+CkkgbmV2ZXIgbmVlZGVkIGNyZWF0ZV9vcl91cGRhdGUgaW4gYW55IHByb2R1Y3Rpb24g
Y29kZSBhbmQgSSBhbHNvIGRvbid0Cm9wdGltaXplIGZvciBwZXJmb3JtYW5jZSBtb3N0IG9mIHRo
ZSB0aW1lLgoKQXMgZm9yIHRoZSBuYW1pbmcgSSBkb24ndCBsaWtlIDo6RmFzdCBtb2R1bGUgbmFt
ZXMsIHNhbWUgZ29lcyBmb3IgbWV0aG9kCm5hbWVzLgp1cGRhdGVfb3JfaW5zZXJ0IGlzIGEgYml0
IG1pc2xlYWRpbmcgYmVjYXVzZSB5b3UgY2FuIG9ubHkgY2FsbCBpbnNlcnQgb24gYQpyb3cgb2Jq
ZWN0LCBoYXZpbmcgYSByZXN1bHRzZXQgbWV0aG9kIGhhdmluZyAnaW5zZXJ0JyBpbiBpdHMgbmFt
ZSBtaWdodApjb25mdXNlIHVzZXJzLgpXZSBhbHJlYWR5IGhhdmUgY29kZSB0aGF0IGJlaGF2ZXMg
ZGlmZmVyZW50bHkgZGVwZW5kaW5nIG9uIGNvbnRleHQsIG1heWJlCnZvaWQgY29udGV4dCBjYW4g
YmUgdXNlZCB0byBkZXRlY3QgaWYgdGhlIHVzZXJzIG5lZWRzIHRoZSByb3cgb2JqZWN0LCBpZgpu
b3QgdXNlIHRoZSBvcHRpbWl6ZWQgY29kZSBwYXRoPwoKCgo+IC0tCj4gZlJFVyBTY2htaWR0Cj4g
aHR0cDovL2Jsb2cuYWZvb2xpc2htYW5pZmVzdG8uY29tCj4KPiBfX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fXwo+IERCSXgtQ2xhc3MtRGV2ZWwgbWFpbGluZyBs
aXN0Cj4gREJJeC1DbGFzcy1EZXZlbEBsaXN0cy5zY3N5cy5jby51awo+IGh0dHA6Ly9saXN0cy5z
Y3N5cy5jby51ay9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vZGJpeC1jbGFzcy1kZXZlbAo+Cj4K
LS0tLS0tLS0tLS0tLS0gbmV4dCBwYXJ0IC0tLS0tLS0tLS0tLS0tCkFuIEhUTUwgYXR0YWNobWVu
dCB3YXMgc2NydWJiZWQuLi4KVVJMOiBodHRwOi8vbGlzdHMuc2NzeXMuY28udWsvcGlwZXJtYWls
L2RiaXgtY2xhc3MtZGV2ZWwvYXR0YWNobWVudHMvMjAxMzA3MTUvYzZjOTk4YTkvYXR0YWNobWVu
dC5odG0K


More information about the DBIx-Class-Devel mailing list