rich1.0phorkiehttps://p.cweiske.de/gitlab: automatically add web hooks for each projectChristian Weiske86400900900<!-- embedding all files of https://p.cweiske.de/307 -->
<link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/>
<div class="phork" id="307">
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.bash .de1, .bash .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.bash {font-family:monospace;}
.bash .imp {font-weight: bold; color: red;}
.bash li, .bash .li1 {color: #DDD;}
.bash .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.bash .kw1 {color: #000000; font-weight: bold;}
.bash .kw2 {color: #c20cb9; font-weight: bold;}
.bash .kw3 {color: #7a0874; font-weight: bold;}
.bash .co0 {color: #666666; font-style: italic;}
.bash .co1 {color: #800000;}
.bash .co2 {color: #cc0000; font-style: italic;}
.bash .co3 {color: #000000; font-weight: bold;}
.bash .es1 {color: #000099; font-weight: bold;}
.bash .es2 {color: #007800;}
.bash .es3 {color: #007800;}
.bash .es4 {color: #007800;}
.bash .es5 {color: #780078;}
.bash .es_h {color: #000099; font-weight: bold;}
.bash .br0 {color: #7a0874; font-weight: bold;}
.bash .sy0 {color: #000000; font-weight: bold;}
.bash .st0 {color: #ff0000;}
.bash .st_h {color: #ff0000;}
.bash .nu0 {color: #000000;}
.bash .re0 {color: #007800;}
.bash .re1 {color: #007800;}
.bash .re2 {color: #007800;}
.bash .re4 {color: #007800;}
.bash .re5 {color: #660033;}
.bash span.xtra { display:block; }
</style><div class="code"><table class="bash"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
</pre></td><td class="de1"><pre class="de1">gitlab-rails dbconsole <span class="sy0"><</span> gitlab-add.sql
 </pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/307/rev-raw/f62aa14ff2c193b677ecce7c05732d36a9cc4f1f/cron-command.sh" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/307#cron-command.sh">cron-command.sh</a>
</div>
</div>
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.sql .de1, .sql .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.sql {font-family:monospace;}
.sql .imp {font-weight: bold; color: red;}
.sql li, .sql .li1 {color: #DDD;}
.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.sql .kw1 {color: #993333; font-weight: bold;}
.sql .co1 {color: #808080; font-style: italic;}
.sql .coMULTI {color: #808080; font-style: italic;}
.sql .es0 {color: #000099; font-weight: bold;}
.sql .br0 {color: #66cc66;}
.sql .sy0 {color: #66cc66;}
.sql .st0 {color: #ff0000;}
.sql .nu0 {color: #cc66cc;}
.sql span.xtra { display:block; }
</style><div class="code"><table class="sql"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
</pre></td><td class="de1"><pre class="de1"><span class="kw1">INSERT</span> <span class="kw1">INTO</span> web_hooks
 <span class="br0">(</span>url<span class="sy0">,</span>project_id<span class="sy0">,</span>created_at<span class="sy0">,</span>updated_at<span class="sy0">,</span><span class="kw1">TYPE</span><span class="sy0">,</span>push_events<span class="sy0">,</span>issues_events<span class="sy0">,</span>merge_requests_events<span class="sy0">,</span>tag_push_events<span class="sy0">,</span>note_events<span class="sy0">,</span>enable_ssl_verification<span class="sy0">,</span>build_events<span class="br0">)</span>
<span class="kw1">SELECT</span>
 <span class="st0">'http://klonfisch.mogiedyne.mogic/webhook-call.php'</span><span class="sy0">,</span>
 projects<span class="sy0">.</span>id<span class="sy0">,</span>
 NOW<span class="br0">(</span><span class="br0">)</span><span class="sy0">,</span> NOW<span class="br0">(</span><span class="br0">)</span><span class="sy0">,</span>
 <span class="st0">'ProjectHook'</span><span class="sy0">,</span>
 <span class="kw1">TRUE</span><span class="sy0">,</span> <span class="kw1">FALSE</span><span class="sy0">,</span> <span class="kw1">FALSE</span><span class="sy0">,</span> <span class="kw1">FALSE</span><span class="sy0">,</span> <span class="kw1">FALSE</span><span class="sy0">,</span> <span class="kw1">TRUE</span><span class="sy0">,</span> <span class="kw1">FALSE</span>
<span class="kw1">FROM</span> projects
 <span class="kw1">LEFT</span> <span class="kw1">JOIN</span> web_hooks
  <span class="kw1">ON</span> projects<span class="sy0">.</span>id <span class="sy0">=</span> web_hooks<span class="sy0">.</span>project_id
   <span class="kw1">AND</span> web_hooks<span class="sy0">.</span>url <span class="sy0">=</span> <span class="st0">'http://klonfisch.mogiedyne.mogic/webhook-call.php'</span>
 <span class="kw1">WHERE</span> web_hooks<span class="sy0">.</span>id <span class="kw1">IS</span> <span class="kw1">NULL</span>;
 </pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/307/rev-raw/f62aa14ff2c193b677ecce7c05732d36a9cc4f1f/gitlab-add.sql" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/307#gitlab-add.sql">gitlab-add.sql</a>
</div>
</div>
</div>