Re: Maintaing a Last updated timestamp column using triggers
"Keith Medcalf" <[email protected]> Thu, 12 Mar 2020 11:55:15 -0600
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Organization | This Side Up |
| Message-ID | <[email protected]> |
Ck9uIFRodXJzZGF5LCAxMiBNYXJjaCwgMjAyMCAwOTozNywgRGF2aWQgQmxha2UgPGRhdmVibGFr ZUBrb2RpLnR2PiB3cm90ZToKCj5XaGF0IHN0b3BzIHRoZQo+VVBEQVRFIHBvcnRzIFNFVCB0aW1l b2ZkYXkgPSBDVVJSRU5UX1RJTUVTVEFNUCBXSEVSRSBpZCA9IE5FVy5pZCA7Cj5mcm9tIGFsc28g dHJpZ2dlcmluZyB0aGUgQUZURVIgVVBEQVRFIE9OIHJlY3Vyc2l2ZWx5PwoKPlBlcmhhcHMgYSBw cmFnbWEgb3IgaW5TUUxpdGUgYXJlICB0cmlnZ2VycyBub24tcmVjdXJzaXZlIGJ5IGRlZmF1bHQ/ Cgo+SSBhbSB1c2luZyAobm93IEkgaGF2ZSBieSBzZW1pLWNvbG9ucyByaWdodCkKPkNSRUFURSBU UklHR0VSIHRnclVwZGF0ZSBBRlRFUiBVUERBVEUgT04gbXlUYWJsZSBGT1IgRUFDSCBST1cKPldI RU4gTkVXLkxhc3RVcGRhdGUgPD0gT0xELiBMYXN0VXBkYXRlCj5CRUdJTgo+VVBEQVRFIG15VGFi bGUgU0VUICBMYXN0VXBkYXRlID0gREFURVRJTUUoJ25vdycpIFdIRVJFIGlkID0gT0xELmlkOwo+ RU5ECgo+TXkgaW50ZW50aW9uIGlzIGZvciB0aGUgd2hlbiB0byBhdm9pZCBpbmZpbml0ZSBjYWxs cywgYnV0IG1heWJlIEkgYW0KPmZvb2xpbmcgbXlzZWxmLgoKSWYgeW91IGRvIG5vdCB3YW50IHRo ZSB0cmlnZ2VyIHRvIGZpcmUgcmVjdXJzaXZlbHkgeW91IGhhdmUgdG8gd3JpdGUgaXQgaW4gc3Vj aCBhIHdheSB0aGF0IGl0IHdpbGwgbm90IGZpcmUgcmVjdXJzaXZlbHkgc2luY2UgYW55b25lIGNh biB0dXJuIHJlY3Vyc2lvbiBvbiBvciBvZmYgYXQgYW55IHRpbWUuICBKdXN0IGJlY2F1c2UgeW91 IGRlY2lkZWQgdG8gd3JpdGUgYSB0cmlnZ2VyIHRoYXQgcmVxdWlyZXMgdGhhdCByZWN1cnNpdmVf dHJpZ2dlcnMgYmUgdHVybmVkIG9mZiBkb2VzIG5vdCBtZWFuIHRoYXQgcmVjdXJzaXZlX3RyaWdn ZXJzIGFyZSB0dXJuZWQgb2ZmLCBtZXJlbHkgdGhhdCB5b3VyIGRlc2lnbiBpcyBpbnN1ZmZpY2ll bnQuCgpJdCBhbHNvIGRlcGVuZHMgaWYgeW91IHdhbnQgdGhlICJsYXN0dXBkYXRlIiBmaWVsZCB0 byBiZSBhbiBhdWRpdGFibGUgZmllbGQgKHRoYXQgaXMsIGl0IGlzIG9ubHkgY2hhbmdlZCB3aGVu IGEgcm93IGlzIHVwZGF0ZWQgYW5kIGNhbm5vdCBvdGhlcndpc2UgYmUgY2hhbmdlZCkgb3Igbm90 LiAgSWYgeW91IHdhbnQgdG8gbWFrZSBpdCBhbiBhdWRpdGFibGUgZmllbGQgdGhhdCBjYW5ub3Qg YmUgdGFtcGVyZWQgd2l0aCwgdGhlbiB5b3UgbmVlZCBtYW55IHRyaWdnZXJzIHRvIG1ha2UgdGhh dCB3b3JrIHByb3Blcmx5LiAgCgpBbHRlcm5hdGl2ZWx5LCB5b3UgY2FuIHVzZSB0aGUgbmV3IEdF TkVSQVRFRCBBTFdBWVMgQVMgKC4uLikgU1RPUkVEIHRvIG1ha2UgaXQgYW4gYXV0b21hdGljYWxs eSB1cGRhdGVkIHN0b3JlZCBmaWVsZCBhbmQgeW91IGRvIG5vdCBuZWVkIHRyaWdnZXJzIGF0IGFs bCwganVzdCBhIHZlcnNpb24gb2YgU1FMaXRlMyB0aGF0IGRvZXMgZ2VuZXJhdGVkIGNvbHVtbnMg KHZlcnNpb24gMy4zMS4wIGZyb20gMjAyMC0wMS0yMiBvciBsYXRlcikuCgpjcmVhdGUgdGFibGUg TXlEYXRhCigKICBpZCAgIGludGVnZXIgcHJpbWFyeSBrZXksCiAgZGF0YSwKICBsYXN0dXBkYXRl IHJlYWwgYXMgKGp1bGlhbmRheSgpKSBzdG9yZWQKKTsKCihvZiBjb3Vyc2UsIHlvdSBjYW4gcHV0 IG90aGVyICJzdHVmZiIgc3VjaCBhcyBzdG9yaW5nIGEgaXNvODYwMSB0ZXh0IHRpbWVzdGFtcCBp ZiB5b3Ugd2FudCB0byAoYSkgdXNlIG1vcmUgc3BhY2UgYW5kIChiKSBoYXZlIGxlc3MgcHJlY2lz aW9uKQooaWYgeW91IHdhbnQgYSB1bml4ZXBvY2ggc2Vjb25kc3RhbXAgdGhlIHVzZSAoKGp1bGlh bmRheSgpLTI0NDA1ODcuNSkqODY0MDAuMCkuICBSZXNvbHV0aW9uIGlzIG9ubHkgdG8gdGhlIG1p bGxpc2Vjb25kIGFzIHRoYXQgaXMgYWxsIHRoYXQgaXMgbWFpbnRhaW5lZCBpbnRlcm5hbGx5IGFu ZCBldmVuIHRoZSBqdWxpYW5kYXkgZG91YmxlIHByZWNpc2lvbiBmbG9hdGluZyBwb2ludCBmb3Jt YXQgaGFzIGVub3VnaCBzaWduaWZpY2FudCBkaWdpdHMgdG8gYWNjdXJhdGVseSBwb3J0cmF5IG1p bGxpc2Vjb25kcyB1bnRpbCB3ZWxsIGFmdGVyIHdlIGhhdmUgdG8gc29sdmUgdGhlIFllYXIgMTBL IHByb2JsZW0uKQoKR2VuZXJhdGVkIGNvbHVtbnMgbWFrZXMgYXVkaXRhYmxlICJsYXN0dXBkYXRl IiB0eXBlIGRhdGEgYXMgc2ltcGxlIHRvIGltcGxlbWVudCBhcyB1c2luZyB0cmlnZ2VycyB0byBp bXBsZW1lbnQgImNyZWF0ZWRvbiIgdHlwZSBhdWRpdGFibGUgZGF0YSBmaWVsZHMuCgotLSAKVGhl IGZhY3QgdGhhdCB0aGVyZSdzIGEgSGlnaHdheSB0byBIZWxsIGJ1dCBvbmx5IGEgU3RhaXJ3YXkg dG8gSGVhdmVuIHNheXMgYSBsb3QgYWJvdXQgYW50aWNpcGF0ZWQgdHJhZmZpYyB2b2x1bWUuCgoK CgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpzcWxpdGUt dXNlcnMgbWFpbGluZyBsaXN0CnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwpo dHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3Nx bGl0ZS11c2Vycwo=