#!/bin/sh

# Translates a MySQL DB export to PostgreSQL

# The export must be created with:

# `--compatible=postgresql --add-locks=false --set-charset`

# Usage: self {input...|<input} >translated

sedEreFlag="$(test "$(uname)" = Darwin && echo E || echo r)"

sed () { "$(which sed)" -"$sedEreFlag" "$@";}

sed \

-e 's/^  KEY "([^"]*)" \([^)]*\)/  "\1_index" boolean/' \

-e "s/\/\*.* (SET NAMES )([0-9A-Za-z_]+) \*\/;/\1'\2';/" \

-e 's/ longtext/ text/g' \

-e 's/ (int|smallint|tinyint)([ (])/ integer\2/g' \

-e 's/ double/ double precision/g' \

-e 's/ (integer|double precision|float)(\([^)]*\))?( unsigned)?/ \1/g' \

"$@"