Backfill Shotwell exposure _time for WhatsApp photos and videos

shotwell_whatsapp_exposure_time_backfill.sql

/*
 * WhatsApp photos in shotwell don't get an exposure time set, but it can be backfilled from the filename
 * sqlite3 .local/share/shotwell/photo.db
 */
update videotable set exposure_time=unixepoch(substring(filename, -19, 4)||"-"||substring(filename, -15, 2)||"-"||substring(filename, -13, 2)||"T00:00:00") where filename like "%VID-%-WA%.mp4" and exposure_time=0;
update phototable set exposure_time=unixepoch(substring(filename, -19, 4)||"-"||substring(filename, -15, 2)||"-"||substring(filename, -13, 2)||"T00:00:00") where filename like "%IMG-%-WA%.jpg" and exposure_time=0;