Skip to content

Instantly share code, notes, and snippets.

View macghriogair's full-sized avatar

Patrick macghriogair

  • Berlin
View GitHub Profile
@macghriogair
macghriogair / Makefile
Created April 25, 2019 09:35
[ERD diagram generation via Makefile] #erd #make
#!/usr/bin/make -f
.DEFAULT_GOAL := help
.ONESHELL:
cwd := $(shell pwd)
comma := ,
.PHONY: build-erd
@macghriogair
macghriogair / readme.md
Created March 27, 2019 12:02
[git sync fork] #git #fork
@macghriogair
macghriogair / readme.md
Last active March 25, 2019 15:27
[install wkhtmltopdf]

Debian/Ubuntu

wget https://github.com/h4cc/wkhtmltopdf-amd64/archive/0.12.3.tar.gz
tar -xzf 0.12.3.tar.gz

sudo chmod a+x ./wkhtmltopdf-amd64-0.12.3/bin/wkhtmltopdf-amd64
sudo mv ./wkhtmltopdf-amd64-0.12.3/bin/wkhtmltopdf-amd64 /usr/local/bin/wkhtmltopdf

rm -rf ./wkhtmltopdf-amd64-0.12.3 0.12.3.tar.gz

@macghriogair
macghriogair / readme.md
Created March 24, 2019 20:27
[Kubernetes cheatsheet]

Kubernetes

Create Deployment

kubectl run <DEPLOYMENT> -- image= <IMAGE> --port= <PORT>

Get Deployments

kubectl get deployments
@macghriogair
macghriogair / bash.sh
Created March 23, 2019 12:21
[Update Jenkins from terminal] #jenkins
# as sudoer
# download new .war file from http://updates.jenkins-ci.org/download
cd /tmp
wget -O jenkins-{version}.war http://updates.jenkins-ci.org/download/war/{version}/jenkins.war
# move to libraries
mv jenkins-{version}.war /usr/lib/jenkins-{version}.war
# stop jenkins
@macghriogair
macghriogair / csv-to-xlsx.py
Created February 28, 2019 20:31
[Combine multiple CSV files into Excel sheets] Simple Python 3 script to combine multiple csv files, e.g. dumped from SQL into a single Excel file with one sheet per CSV #excel #csv #xlsxwriter
import os
import glob
import argparse
import csv
import xlsxwriter
def writeToXlsx(inputFiles, workbookFilename, encoding, delimiter, quotechar):
print("Creating workbook {}".format(workbookFilename))
workbook = xlsxwriter.Workbook(workbookFilename)
@macghriogair
macghriogair / bash.sh
Created January 20, 2019 17:29
[Google Photo Upload with GO client on Raspberry Pi] #go #raspi #gphoto
# Install GO language on Raspberry PI 2/3
cd /tmp
# Check latest GO version and adapat URL if necessary
wget https://storage.googleapis.com/golang/go1.10.1.linux-armv6l.tar.gz
sudo tar -C /usr/local -xvf go1.10.1.linux-armv6l.tar.gz
# Add environment vars to .bashrc
export GOPATH=$HOME/go
export PATH=/usr/local/go/bin:$PATH:$GOPATH/bin
@macghriogair
macghriogair / ImmutableTrait.php
Created October 1, 2018 11:20
[Immutable] #valueobject #immutable
<?php
namespace Website\Traits;
trait ImmutableTrait
{
/** @var bool */
private $constructorWasCalled = false;
/**
@macghriogair
macghriogair / no-js-message.html
Created September 5, 2018 09:40
[no javascript message] #ux #noscript
<noscript>
<div class="">
<p><strong>We're sorry, but our site requires Javascript to be enabled to run.</strong><br/>
You can easily enable Javascript in your browser.<br/> If you would like instructions on how to do this, please <br/>
<a href="http://www.activatejavascript.org" target="_blank">click here</a>
</p>
</div>
</noscript>
@macghriogair
macghriogair / bash.sh
Last active February 16, 2019 17:36
[Elasticsearch stats] #elasticsearch #cat
curl localhost:9200/_stats | python -m json.tool
# specific indices only
curl localhost:9200/index1,index2/_stats | python -m json.tool
# CAT all indices pretty format
curl 'localhost:9200/_cat/indices?format=json&pretty'