====== Bash script ======

  - generate sql statement
<code bash>
#!/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
</code>