/usr/share/gforge/db/20130523-fix_tracker_open_count.sql is in gforge-db-postgresql 5.3.2+20141104-3+deb8u3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | -- Fix count first
UPDATE artifact_counts_agg
SET count=subquery.count,
open_count=subquery.open_count
FROM (SELECT group_artifact_id, COUNT(group_artifact_id) AS count,
SUM(CASE WHEN status_id=1 THEN 1 ELSE 0 END) AS open_count
FROM artifact
GROUP BY group_artifact_id) AS subquery
WHERE artifact_counts_agg.group_artifact_id=subquery.group_artifact_id;
-- Fix insert rule (only increase open count if open)
DROP RULE artifact_insert_agg ON artifact;
CREATE OR REPLACE RULE artifact_insert_agg AS
ON INSERT TO artifact DO UPDATE artifact_counts_agg SET count = artifact_counts_agg.count + 1, open_count =
CASE
WHEN new.status_id = 1 THEN artifact_counts_agg.open_count + 1
ELSE artifact_counts_agg.open_count
END
WHERE artifact_counts_agg.group_artifact_id = new.group_artifact_id;
|