-
Notifications
You must be signed in to change notification settings - Fork 2
/
capabilities.go
58 lines (53 loc) · 1.77 KB
/
capabilities.go
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
/*-
* Copyright (c) 2016, Jörg Pernfuß <joerg.pernfuss@1und1.de>
* All rights reserved
*
* Use of this source code is governed by a 2-clause BSD license
* that can be found in the LICENSE file.
*/
package stmt
const ListAllCapabilities = `
SELECT smc.capability_id,
smc.capability_monitoring,
smc.capability_metric,
smc.capability_view,
sms.monitoring_name
FROM soma.monitoring_capabilities smc
JOIN soma.monitoring_systems sms
ON smc.capability_monitoring = sms.monitoring_id;`
const ListScopedCapabilities = `
WITH sysid AS (
SELECT sms.monitoring_id
FROM inventory.users iu
JOIN soma.monitoring_system_users smsu
ON iu.organizational_team_id = smsu.organizational_team_id
JOIN soma.monitoring_systems sms
ON smsu.monitoring_id = sms.monitoring_id
WHERE iu.user_id = $1::uuid
AND sms.monitoring_system_mode = 'private'
UNION
SELECT sms.monitoring_id
FROM soma.monitoring_systems sms
WHERE sms.monitoring_system_mode = 'public'
)
SELECT smc.capability_id,
smc.capability_monitoring,
smc.capability_metric,
smc.capability_view,
sms.monitoring_name
FROM soma.monitoring_capabilities smc
JOIN soma.monitoring_systems sms
ON smc.capability_monitoring = sms.monitoring_id
WHERE smc.capability_monitoring IN (SELECT monitoring_id FROM sysid);`
const ShowCapability = `
SELECT smc.capability_id,
smc.capability_monitoring,
smc.capability_metric,
smc.capability_view,
smc.threshold_amount,
sms.monitoring_name
FROM soma.monitoring_capabilities smc
JOIN soma.monitoring_systems sms
ON smc.capability_monitoring = sms.monitoring_id
WHERE smc.capability_id = $1::uuid;`
// vim: ts=4 sw=4 sts=4 noet fenc=utf-8 ffs=unix