#!/bin/bash err() { echo ERROR: $* exit 1 } usage() { err "usage: $0 <[m|p|o|i|s]>" } [ 1 != $# ] && usage ESC_STR_CONST= db= case $1 in m) db=mysql ;; p) db=postgresql ESC_STR_CONST="E" ;; *) usage ;; esac lines=( "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=0 while [ "${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