mervick

/* gcc -o tmp `pkg-config --libs --cflags glib-2.0` tmp.c
 *
 * # modprobe ec_sys
 *
 * # watch -n 0.1 hexdump -C /sys/kernel/debug/ec/ec0/io
 *
 * 00000000  a7 05 a0 e2 00 86 05 00  00 00 47 00 00 03 00 10  |..........G.....|
 * 00000000  a7 05 a0 e2 00 86 05 00  00 00 47 00 00 43 00 10  |..........G..C..|
 * 00000000  a7 05 a0 e2 00 86 05 00  00 00 47 00 00 83 00 10  |..........G.....|

mervick

urlencode() {
    # urlencode <string>

    local length="${#1}"
    for (( i = 0; i < length; i++ )); do
        local c="${1:i:1}"
        case $c in
            [a-zA-Z0-9.~_-]) printf "$c" ;;
            *) printf '%%%02X' "'$c"
        esac

mervick

#!/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.

# Usage: $ ./mysql2sqlite mysqldump-opts db-name | sqlite3 database.sqlite
# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase | sqlite3 database.sqlite