dvx4e9AA

1CREATE temporary table if not exists ass_rel_ids as (
2	SELECT rel.id
3	FROM assessments AS obj
4	JOIN relationships AS rel ON (
5		(rel.source_type="Assessment" AND
6		rel.source_id=obj.id AND
7		rel.destination_type NOT IN ("Audit", "Comment", "OrgGroup", "Section", "AccessGroup", "System", "Contract", "DataAsset", "Regulation", "Snapshot", "Threat", "Objective", "Document", "Control", "Product", "Vendor", "Risk", "Facility", "Process", "Clause", "Standard", "Policy", "Person", "Market")) OR
8		(rel.destination_type="Assessment" AND
9		rel.destination_id=obj.id AND
10		rel.source_type NOT IN ("Audit", "Comment", "OrgGroup", "Section", "AccessGroup", "System", "Contract", "DataAsset", "Regulation", "Snapshot", "Threat", "Objective", "Document", "Control", "Product", "Vendor", "Risk", "Facility", "Process", "Clause", "Standard", "Policy", "Person", "Market")))
11	ORDER BY obj.id
12);
13
14delete from relationships where id in (select * from ass_rel_ids);
15
16
17CREATE temporary table if not exists issue_rel_ids as (
18	SELECT rel.id
19	FROM issues AS obj
20	JOIN relationships AS rel ON (
21		(rel.source_type="Issue" AND
22		rel.source_id=obj.id AND
23		rel.destination_type NOT IN ("Audit","Comment","OrgGroup","Section","AccessGroup","System","Contract","DataAsset","Regulation","Snapshot","Threat","Objective","Document","Control","Product","Vendor","Risk","Facility","Process","Clause","Standard","Policy","Person","Market")) OR
24		(rel.destination_type="Issue" AND
25		rel.destination_id=obj.id AND
26		rel.source_type NOT IN ("Audit","Comment","OrgGroup","Section","AccessGroup","System","Contract","DataAsset","Regulation","Snapshot","Threat","Objective","Document","Control","Product","Vendor","Risk","Facility","Process","Clause","Standard","Policy","Person","Market")))
27	ORDER BY obj.id
28);
29  
30
31delete from relationships where id in (select * from issue_rel_ids);