ccms/test.sql at main · indexdata/ccms · GitHub

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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
create fund _f1;
create fund _f2;
create fund _f4;
alter fund _f4 alter property name set _f3;
alter fund _f3 alter property title set 'Filter 3';
create track _t1;
create track _t2;
create track _t4;
alter track _t4 alter property name set _t3;
alter track _t3 alter property title set 'Track 3';
create project _p1;
alter project _p1 alter property title set 'CCMS test project';
alter project _p1 alter property action set digitize;
alter project _p1 alter property mou_link set 'https://the_mou_link';
alter project _p1 alter property funds add _f1;
alter project _p1 alter property funds add _f2;
alter project _p1 alter property funds add _f3;
alter project _p1 alter property funds drop _f1;
alter project _p1 alter property funds drop all;
alter project _p1 alter property funds add _f1;
alter project _p1 alter property origins add clockss;
alter project _p1 alter property origins add lehigh;
alter project _p1 alter property origins add nyu;
alter project _p1 alter property destinations add clockss;
alter project _p1 alter property destinations add lehigh;
alter project _p1 alter property destinations add nyu;
alter project _p1 alter property destinations drop clockss;
alter project _p1 alter property destinations drop all;
alter project _p1 alter property tracks add _t1;
alter project _p1 alter property tracks add _t2;
alter project _p1 alter property tracks add _t3;
alter project _p1 alter property tracks drop _t1;
alter project _p1 alter property tracks drop all;
alter project _p1 alter property tracks add _t1;
create set _p1._s2;
alter set _p1._s2 alter property name set _s1;
alter set _p1._s1 alter property title set 'Test set';
insert into _p1._s1 select * from _p1.object where id >= 1 and id <= 9999;
insert into _p1._s1 select * from _p1.object where id > 9999 limit 1;
create filter _p1._r1 where id < 3;
create filter _p1._r2 where decision = true;
select * from _p1._s1 where filter(_p1._r1) limit 1;
select * from _p1._s1 where filter(_p1._r2) limit 1;
update _p1.object set decision = true where id = 10;
update _p1.object set fund = _f1 where id = 10;
update _p1.object set fund = null where id = 10;
update _p1.object set track = _t1 where id = 10;
delete from _p1._s1 where filter(_p1._r1);
delete from _p1._s1 where filter(_p1._r2);
delete from _p1._s1 where id > 5 and id < 10;
delete from _p1._s1 where decision = false;
show funds;
show fund _f1;
show tracks;
show track _t1;
show projects;
show project _p1;
show sets;
show sets in project _p1;
show filters;
show filters in project _p1;
show version;
drop filter _p1._r1;
drop filter _p1._r2;
drop set _p1._s1;
drop project _p1;
drop fund _f1;
drop fund _f2;
drop fund _f3;
drop track _t1;
drop track _t2;
drop track _t3;