gitlab: automatically add web hooks for each project

raw

cron-command.sh

1
2
gitlab-rails dbconsole < gitlab-add.sql
 
raw

gitlab-add.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
INSERT INTO web_hooks
 (url,project_id,created_at,updated_at,TYPE,push_events,issues_events,merge_requests_events,tag_push_events,note_events,enable_ssl_verification,build_events)
SELECT
 'http://klonfisch.mogiedyne.mogic/webhook-call.php',
 projects.id,
 NOW(), NOW(),
 'ProjectHook',
 TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE
FROM projects
 LEFT JOIN web_hooks
  ON projects.id = web_hooks.project_id
   AND web_hooks.url = 'http://klonfisch.mogiedyne.mogic/webhook-call.php'
 WHERE web_hooks.id IS NULL;
 
Christian Weiske Christian Weiske
owner

History