Page MenuHomePhabricator
Paste P250

(An Untitled Masterwork)
ActivePublic

Authored by stwalkerster on May 23 2019, 11:13 PM.
select replace(s.vsql, '$$ID$$', r.id) from request r
cross join (
select 'INSERT INTO log (objectid, objecttype, user, action, timestamp) VALUES ($$ID$$, ''Request'', 7, ''Deferred to users'', current_timestamp());' as vsql from dual
union all select 'UPDATE request SET status = ''Open'', reserved = 0 WHERE id = $$ID$$;' from dual
) s where r.id in (1,2,3,4,5,6,7);

Event Timeline

stwalkerster created this object with visibility "Public (No Login Required)".