-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathremove_experiments.sql
More file actions
38 lines (28 loc) · 891 Bytes
/
remove_experiments.sql
File metadata and controls
38 lines (28 loc) · 891 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
-- Script for manually removing experiments
-- and all the data related to them
BEGIN TRANSACTION;
CREATE TEMP TABLE expids as
SELECT unnest(ARRAY[
-- \/ ids list separated by commas \/
-- for example: 1,2,3,4,5,6
1,2,3,4,5,6
-------------------------------------
]) as exp_id;
CREATE TEMP TABLE sids as (
SELECT session_id
FROM sessions
WHERE exp_id IN (SELECT exp_id FROM expids)
);
DELETE FROM sessionevents
WHERE session_id IN (SELECT session_id FROM sids);
DELETE FROM sessionsfeedback
WHERE session_id IN (SELECT session_id FROM sids);
DELETE FROM sessions
WHERE session_id IN (SELECT session_id FROM sids);
DELETE FROM experimentsfeedback
WHERE exp_id IN (SELECT exp_id FROM expids);
DELETE FROM experiments
WHERE exp_id IN (SELECT exp_id FROM expids);
-- return the end result to be able to review before committing
SELECT * FROM experiments
ORDER BY exp_id DESC;