Skip to content

Instantly share code, notes, and snippets.

View schwuk's full-sized avatar

David M. schwuk

View GitHub Profile

Keybase proof

I hereby claim:

  • I am schwuk on github.
  • I am schwuk (https://keybase.io/schwuk) on keybase.
  • I have a public key whose fingerprint is B278 852C FF3C 219C 204E 4E16 D072 DD92 3BBF C414

To claim this, I am signing this object:

@schwuk
schwuk / countries.sql
Last active August 29, 2015 14:07
County names and two-letter codes
CREATE TABLE countries (id VARCHAR(2) NOT NULL, name VARCHAR(64) NOT NULL, PRIMARY KEY(id));
INSERT INTO "countries" ("id", "name") VALUES ('AF', 'Afghanistan');
INSERT INTO "countries" ("id", "name") VALUES ('AL', 'Albania');
INSERT INTO "countries" ("id", "name") VALUES ('DZ', 'Algeria');
INSERT INTO "countries" ("id", "name") VALUES ('AS', 'American Samoa');
INSERT INTO "countries" ("id", "name") VALUES ('AD', 'Andorra');
INSERT INTO "countries" ("id", "name") VALUES ('AO', 'Angola');
INSERT INTO "countries" ("id", "name") VALUES ('AI', 'Anguilla');
INSERT INTO "countries" ("id", "name") VALUES ('AQ', 'Antarctica');
@schwuk
schwuk / gitpull
Last active August 28, 2018 09:22
Simple shell script to update all git repositories in a directory. Requires the `lockfile` utility from Procmail.
#!/bin/sh
# Updates git repositories
LOCKFILE=/tmp/git.lock
lockfile -r 0 $LOCKFILE || exit 1
GIT=`which git`
@schwuk
schwuk / cliploc
Created February 3, 2023 14:12
Count lines of code in a folder and copy to clipboard
#!/usr/bin/env bash
cloc . --quiet --hide-rate --csv | head -n -1 | tail -n +2 | awk -F',' '{ print $2","$5 }' | sort | awk -F',' '{ print $2}' | xclip -sel clip