Convert mermaid definition of models into PosgresSQL schema

mermaid2sql.sh

#!/usr/bin/env bash

if [[ "$@" =~ -h ]]; then
  echo "Convert mermaid definition of models into PosgresSQL schema"
  echo "Usage: $0 <mermaid model definition>"
  exit 0
fi

if ! command -v awk sed &>/dev/null; then
  echo "Install: awk, sed" >&2
  exit 1
fi

if ! [ -f "$1" ]; then
  echo "$0: '$1' is not found">&2
  exit 1
fi

awk '
/{/{
  print "CREATE TABLE "tolower($1)"("
}

$2!="{"&&NF==2{
  switch($1){
    case "string":
      $1="text"
      break
  }
  print "  "tolower($2)" "$1($2=="id" ? " PRIMARY KEY" : $2~"_id" ? " NOT NULL" : "")","
}

NF==1{
  print");"
}
' "$1" | sed -z 's/,\n)/\n)/g'