[Dbix-class] SQL Function in update

Hartmaier Alexander Alexander.Hartmaier at t-systems.at
Mon Mar 31 16:23:18 BST 2008


SGVsbG8gUm9uYWxkIQoKSW4gbXkgb3BpbmlvbiBpc3QgYmV0dGVyIHRvIGZldGNoIHRoZSBkYXRl
dGltZSBpbiB5b3VyIG1vZGVsIHRvIGJlIGRhdGFiYXNlIApmdW5jdGlvbiBpbmRlcGVuZGVudCBh
bmQgcGFzcyB0aGF0IHRvIHVwZGF0ZSBhbmQgbGV0IHRoZSBkYXRhYmFzZSBzcGVjaWZpYyAKZGVm
bGF0b3IgbWFrZSB3aGF0IGl0J3MgYmVzdCBhdDoKCiRyb3ctPm15ZGF0ZShEYXRlVGltZS0+bm93
KCB0aW1lX3pvbmU9PiAnVVRDJyApKTsKJHJvdy0+dXBkYXRlOwoKb3IKCiRyb3ctPnVwZGF0ZSht
eWRhdGUgPT4gRGF0ZVRpbWUtPm5vdyh0aW1lX3pvbmU9PiAnVVRDJyApKTsKCldoYXQgc2hvdWxk
IEdSRUFURVNUIGRvIGluIHlvdXIgY2FzZT8KCi1BbGV4CgotLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut
LS0tLQpGcm9tOiBSb25hbGQgSiBLaW1iYWxsIFttYWlsdG86cmtpbWJhbGwrZGJpeGNsYXNzQHBh
bmdlYW1lZGlhLmNvbV0KU2VudDogTW9uZGF5LCBNYXJjaCAzMSwgMjAwOCA1OjAzIFBNClRvOiBk
Yml4LWNsYXNzQGxpc3RzLnJhd21vZGUub3JnClN1YmplY3Q6IFtEYml4LWNsYXNzXSBTUUwgRnVu
Y3Rpb24gaW4gdXBkYXRlCgpZZXMsIGl0J3MgYW5vdGhlciBxdWVzdGlvbiBhYm91dCB1c2luZyBT
UUwgZnVuY3Rpb25zIGluIGFuIHVwZGF0ZS4gIEkKa25vdyBJIGNhbiBwYXNzIGEgcmVmZXJlbmNl
IHRvIGEgc3RyaW5nIGNvbnRhaW5pbmcgbGl0ZXJhbCBTUUwsIGFzIGluOgoKJHJvdy0+dXBkYXRl
KHsgbXlkYXRlID0+IFwgJ05PVygpJyB9KTsKCgpIb3dldmVyLCBpbiB0aGlzIGNhc2UgSSBuZWVk
IHRvIHBhc3MgYXJndW1lbnRzIHRvIHRoZSBmdW5jdGlvbiwgb25lIG9mCndoaWNoIG5lZWRzIHRv
IGJlIHF1b3RlZC4gIEhlcmUncyB3aGF0IEknbSB1c2luZyByaWdodCBub3c6CgpteSAkZGF0ZSA9
IERhdGVUaW1lLT5ub3coKTsKbXkgJHVudGlsICA9ICJHUkVBVEVTVChwYXVzZWRfdW50aWwsICIg
LgogICAgICAgICAgICAgICRzY2hlbWEtPnN0b3JhZ2UtPmRiaC0+cXVvdGUoIiRkdCIpIC4gIiki
OwoKJHJvdy0+dXBkYXRlKHsgcGF1c2VkX3VudGlsID0+IFwkdW50aWwgfSk7CgoKSWRlYWxseSwg
SSBjb3VsZCBkbyBzb21ldGhpbmcgbGlrZSB0aGlzOgoKJHJvdy0+dXBkYXRlKHsgcGF1c2VkX3Vu
dGlsID0+CiAgICAgICAgICAgICAgICAgeyBHUkVBVEVTVCA9PiBbIFwgJ3BhdXNlZF91bnRpbCcs
ICRkdCBdIH0gfSk7CgoKU3VnZ2VzdGlvbnM/CgpSb25hbGQKCl9fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fCkxpc3Q6IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51
ay9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vZGJpeC1jbGFzcwpJUkM6IGlyYy5wZXJsLm9yZyNk
Yml4LWNsYXNzClNWTjogaHR0cDovL2Rldi5jYXRhbHlzdC5wZXJsLm9yZy9yZXBvcy9iYXN0L0RC
SXgtQ2xhc3MvClNlYXJjaGFibGUgQXJjaGl2ZTogaHR0cDovL3d3dy5ncm9rYmFzZS5jb20vZ3Jv
dXAvZGJpeC1jbGFzc0BsaXN0cy5yYXdtb2RlLm9yZwoKLS0tLS0tLS0tLS0tLS0gbmV4dCBwYXJ0
IC0tLS0tLS0tLS0tLS0tCkEgbm9uLXRleHQgYXR0YWNobWVudCB3YXMgc2NydWJiZWQuLi4KTmFt
ZTogc21pbWUucDdzClR5cGU6IGFwcGxpY2F0aW9uL3gtcGtjczctc2lnbmF0dXJlClNpemU6IDU2
MTEgYnl0ZXMKRGVzYzogbm90IGF2YWlsYWJsZQpVcmwgOiBodHRwOi8vbGlzdHMuc2NzeXMuY28u
dWsvcGlwZXJtYWlsL2RiaXgtY2xhc3MvYXR0YWNobWVudHMvMjAwODAzMzEvZjcxMGU1MjQvc21p
bWUuYmluCg==


More information about the DBIx-Class mailing list