aboutsummaryrefslogtreecommitdiff
path: root/cmd
diff options
context:
space:
mode:
authorGibheer <gibheer+git@zero-knowledge.org>2018-12-12 13:26:41 +0100
committerGibheer <gibheer+git@zero-knowledge.org>2018-12-12 13:26:41 +0100
commit6beb37eb9656430442d72328308b13b9e544a7a3 (patch)
treede71f44d00a72fa66c6b63bf3856b15598d4b342 /cmd
parent627423044209526108fe2664dbd8f9e5d0b2e033 (diff)
monwork - ignore missing notify column
The notify column was removed when moving everything into the notification tables.
Diffstat (limited to 'cmd')
-rw-r--r--cmd/monwork/main.go6
1 files changed, 3 insertions, 3 deletions
diff --git a/cmd/monwork/main.go b/cmd/monwork/main.go
index 13c4f39..d7f0791 100644
--- a/cmd/monwork/main.go
+++ b/cmd/monwork/main.go
@@ -218,13 +218,13 @@ var (
where c.last_refresh < c.updated or c.last_refresh is null
limit 1
for update of c skip locked;`
- SQLRefreshActiveCheck = `insert into active_checks(check_id, cmdline, intval, enabled, notify, msg, mapping_id)
-select c.id, $2, c.intval, c.enabled, c.notify, case when ac.msg is null then '' else ac.msg end, case when c.mapping_id is not null then c.mapping_id when n.mapping_id is not null then n.mapping_id else 1 end
+ SQLRefreshActiveCheck = `insert into active_checks(check_id, cmdline, intval, enabled, msg, mapping_id)
+select c.id, $2, c.intval, c.enabled, case when ac.msg is null then '' else ac.msg end, case when c.mapping_id is not null then c.mapping_id when n.mapping_id is not null then n.mapping_id else 1 end
from checks c
left join active_checks ac on c.id = ac.check_id
left join nodes n on c.node_id = n.id
where c.id = $1
on conflict(check_id)
-do update set cmdline = $2, intval = excluded.intval, enabled = excluded.enabled, notify = excluded.notify, mapping_id = excluded.mapping_id;`
+do update set cmdline = $2, intval = excluded.intval, enabled = excluded.enabled, mapping_id = excluded.mapping_id;`
SQLUpdateLastRefresh = `update checks set last_refresh = now() where id = $1;`
)