forecast_api/route_sql/undo.sql

WITH
d AS (
    DELETE FROM rlarp.osm_log WHERE id = replace_id RETURNING id
)
,d_osm AS (
    DELETE FROM rlarp.osm_pool WHERE logid IN (select id from d)
)
SELECT json_agg(row_to_json(d)) x from d
add undo route, and include comments 2020-02-14 14:41:29 -05:00			`WITH`
			`d AS (`
drop rows from both tables when undoing changes 2020-02-14 15:42:41 -05:00			`DELETE FROM rlarp.osm_log WHERE id = replace_id RETURNING id`
			`)`
			`,d_osm AS (`
			`DELETE FROM rlarp.osm_pool WHERE logid IN (select id from d)`
add undo route, and include comments 2020-02-14 14:41:29 -05:00			`)`
			`SELECT json_agg(row_to_json(d)) x from d`