Skip to content

Instantly share code, notes, and snippets.

View fiee's full-sized avatar

Henning Hraban Ramm fiee

View GitHub Profile
@fiee
fiee / laenderinfos.sql
Last active July 17, 2023 14:04
table of information about all countries of the world (German names)
CREATE TABLE adressen.land
(
isocode_2 character(2) not null, -- ISO 3166 ALPHA-2
isocode_3 character(3) not null, -- ISO 3166 ALPHA-3
name character varying not null, -- deutscher Name des Landes (international besser via ISO-Code ankoppeln!) // German name of the country
vorwahl integer default null, -- internationale Vorwahl // international phone code
null_bei_vorwahl boolean default FALSE, -- muss man die Null der Ortsvorwahl auch nach der internationalen Vorwahl wählen? // must one dial zero between international and local phone code?
vorwahl_lokal boolean default FALSE, -- muss man vor Ort die Vorwahl wählen? // must one dial the local phone code also locally?
tld character varying default NULL, -- Top Level Domain
kfz character varying default NULL, -- KFZ-Kennzeichen // car code
@fiee
fiee / choir_template.ly
Created September 30, 2011 08:02
Lead sheet setup for GNU LilyPond 2.14+
\version "2.14.0"
\include "global.ly"
\include "articulate.ly" % for better MIDI
\header{
title = ""
poet = ""
%composer = ""
%arranger = "arr."
%instrument = "2 voc + git"
@fiee
fiee / fabfile.py
Created July 29, 2009 13:55 — forked from anonymous/gist:156623
fabric fabfile.py for deployment of django apps on Debian servers
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
fabfile for Django
------------------
see http://morethanseven.net/2009/07/27/fabric-django-git-apache-mod_wsgi-virtualenv-and-p/
modified for fabric 0.9/1.0 by Hraban (fiëé visuëlle)
several additions, corrections and customizations, too
@fiee
fiee / colors.py
Created November 16, 2010 10:48
Color conversion helpers, see also fiee/fiee-coloree
#!/usr/bin/env python
# -*- coding: utf-8 -*-
def HtmlColorCode_to_strings(value):
"Convert a HTML color code like '#FFCC00' or 'FFCC00' to a list of strings ['FF', 'CC', '00']"
x = 1 * value.startswith('#')
return [value[x:x+2],value[x+2:x+4],value[x+4:x+6]]
def HtmlColorCode_to_ints(value):
"Convert a HTML color code like '#FFCC00' or 'FFCC00' to a list of integers [255, 204, 0]"
@fiee
fiee / class_from_name.py
Created April 12, 2016 09:46
get a Python class from a class name
import importlib
def class_from_name(name):
"""
Take a class name like `django.db.models.Model` and return the class
"""
parts = name.split('.')
mod = importlib.import_module('.'.join(parts[:-1]))
return getattr(mod, parts[-1])
@fiee
fiee / update.sh
Last active April 3, 2016 06:12
Update script for MacPorts, ConTeXt, Python, LilyPond, Google Fonts and Perl
#!/bin/bash
NO_PORT=0
NO_TEX=0
NO_PYTHON=0
NO_FONTS=0
DO_PERL=0
for PARAM in $*
do
@fiee
fiee / global_liedvorlage.ly
Last active April 3, 2016 06:00
lead sheet template
%\version "2.18.0"
\include "../global.ly"
\include "articulate.ly" % for better MIDI
\header{
title = ""
poet = ""
%composer = "M: "
%arranger = "arr."
%instrument = "2 voc + git"
@fiee
fiee / .bashrc
Created November 7, 2013 04:57
Colored bash prompt with git information (tested on OSX 10.9)
# for ANSI color codes see e.g. http://bitmote.com/index.php?post/2012/11/19/Using-ANSI-Color-Codes-to-Colorize-Your-Bash-Prompt-on-Linux
parse_exit_code() {
# check exit code and display a green checkmark on "0" or a red cross with exit code on error
if [ "$?" == "0" ]; then
echo -e "\033[32m✓\033[00m"
else
echo -e "\033[1;31m❌ $?\033[00m"
fi
}
@fiee
fiee / imagecrop.sh
Created April 5, 2012 15:18
use imagemagick to crop a picture to a fixed size
#!/bin/bash
# ~/croptest is our work dir, ~/croptest/img contains test images
cd ~/croptest
EXT="_resized"
SIZES="88x88 88x50 300x172 300x233 300x111"
# delete all remains of previous runs and copy test pics over
rm *.jpg
cp img/*.jpg ./
@fiee
fiee / cwpuzzle_beispiel.tex
Created October 12, 2011 13:07
LaTeX cwpuzzle Beispiel
% see the docs for Gerd Neugebauer’s cwpuzzle.sty at http://ctan.org/tex-archive/macros/latex/contrib/gene/crossword
\documentclass[a4paper]{article}
\usepackage{cwpuzzle}
\usepackage[utf8]{inputenc}
\usepackage{german}
\begin{document}
\PuzzleUnsolved