blob: 13616aeac904c09d9068e730a87bab1e9d20511d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
-- Zurich would like to update the detail text of a whole bunch
-- of reports on the site. They've provided a CSV file with the report id
-- and the new detail text for the reports in question.
-- This script applies the new details to the database
-- from the file 'report_updates.txt'. This file must be stripped
-- of its header row or errors will occur.
BEGIN;
CREATE TEMP TABLE report_updates (id int, detail text);
\copy report_updates FROM 'report_updates.txt' WITH (FORMAT CSV)
UPDATE problem
SET detail = report_updates.detail
FROM report_updates
WHERE problem.id = report_updates.id
-- Only update a report if its detail field has actually changed:
AND problem.detail != report_updates.detail;
DROP TABLE report_updates;
COMMIT;
|
