1 DELETE FROM project_counts_agg;
2 INSERT INTO project_counts_agg
3 SELECT group_project_id,
4 (SELECT count(*) FROM project_task WHERE status_id != 3 AND
5 project_task.group_project_id=project_group_list.group_project_id),
6 (SELECT count(*) FROM project_task WHERE status_id = 1 AND
7 project_task.group_project_id=project_group_list.group_project_id)
8 FROM project_group_list;
10 CREATE RULE projecttask_insert_agg AS ON
11 INSERT TO project_task DO
12 UPDATE project_counts_agg
13 SET count = (project_counts_agg.count + 1),
14 open_count = (project_counts_agg.open_count + 1)
15 WHERE (project_counts_agg.group_project_id = new.group_project_id);
17 UPDATE artifact SET priority=1 WHERE priority=2;
18 UPDATE artifact SET priority=2 WHERE priority IN (3,4);
19 UPDATE artifact SET priority=3 WHERE priority IN (5,6);
20 UPDATE artifact SET priority=4 WHERE priority IN (7,8);
21 UPDATE artifact SET priority=5 WHERE priority=9;
22 UPDATE project_task SET priority=1 WHERE priority=2;
23 UPDATE project_task SET priority=2 WHERE priority IN (3,4);
24 UPDATE project_task SET priority=3 WHERE priority IN (5,6);
25 UPDATE project_task SET priority=4 WHERE priority IN (7,8);
26 UPDATE project_task SET priority=5 WHERE priority=9;