Skip to content

Instantly share code, notes, and snippets.

#!/bin/sh
# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
# CREATE block and create them in separate commands _after_ all the INSERTs.
# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
# The mysqldump file is traversed only once.
# Thanks to and @artemyk and @gkuenning for their nice tweaks.

Keybase proof

I hereby claim:

  • I am mrhanlon on github.
  • I am mrhanlon (https://keybase.io/mrhanlon) on keybase.
  • I have a public key whose fingerprint is B167 04D8 20F3 7853 0C22 E0E1 BA60 555E 2A65 CCAA

To claim this, I am signing this object:

@mrhanlon
mrhanlon / package.json
Last active February 5, 2016 22:36
Gets project information for jobs currently running on TACC Stampede, Lonestar, and Maverick
{
"name": "projects-running-jobs",
"version": "1.0.0",
"description": "",
"main": "projects-running-jobs.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1"
},
"repository": {
"type": "git",
@mrhanlon
mrhanlon / TUTORIAL.md
Last active August 29, 2015 14:08
AIP Developer Workshop: Tutorial

AIP Developer Workshop

Tutorial Application

Tutorial 1

In this tutorial you will create and run your first science app.

git checkout tutorial/1
@mrhanlon
mrhanlon / Generate a MathCaptcha
Created May 9, 2014 21:32
Math Captcha for Java Portlets
private static final String[] NUMBERS = {"zero","one","two","three","four","five","six","seven","eight","nine","ten"};
private static final String[] OPERATIONS = {"+", "-", "×"};
private static final Random RAND = new Random(); // not high entropy, but not a big deal here
private Map<String,String> generateCaptcha(PortletSession session) {
Map<String,String> captcha = new HashMap<String, String>();
int first, second, third, op, pos, solution;
op = RAND.nextInt(OPERATIONS.length);