All pastes #2091051 Raw Edit

Unnamed

public shellscript v1 · immutable
#2091051 ·published 2011-10-18 11:48 UTC
rendered paste body
#!/bin/basherr(){       echo ERROR: $*    exit 1}usage(){       err "usage: $0 <[m|p|o|i|s]>"}[ 1 != $# ] && usageESC_STR_CONST=db=case $1 in    m)  db=mysql        ;;    p)  db=postgresql        ESC_STR_CONST="E"        ;;    *)  usage        ;;esaclines=(    "INSERT INTO items VALUES (21883,0,10044,__ESC_STR_CONST__'SQL: % Processor Time','perf_counter[\"\\Process(sqlservr#1)\\% Processor Time\"]',60)"    "UPDATE items SET foo = __ESC_STR_CONST__'perf_counter[\"\\Process(sqlservr#1)\\% Processor Time\"]' WHERE bar = 'baz'")i=0while [ "${lines[$i]}" ]; do    s=$(echo ${lines[$i]} | sed "s/__ESC_STR_CONST__/$ESC_STR_CONST/g")    case $db in        mysql)            echo -n "$db "            ;;        postgresql)            echo -n "$db "            ;;        *)              err "invalid db"            ;;    esac    echo "[$i] $s"    ((i++))done