Bash script

1. generate sql statement

#!/bin/bash
 
PATCH_NAME=$1
PATCH_DESC=$2
PATCH_DEP="schema"
 
(
cat <<EOF
 
-- this is a generated template patch file.
-- overwrite depends_on value if any
 
begin;
 
insert into patches (patch_name, description, depends_on)
    values (
        '$PATCH_NAME',
        '$PATCH_DESC',
        '$PATCH_DEP'
    );
 
rollback;
EOF
) > $PATCH_NAME