generate-sqlite-sqltemplates.sh

#!/bin/bash

#
# Copyright (c) 2024. Bernard Bou.
#

set -e

R='\u001b[31m'
G='\u001b[32m'
B='\u001b[34m'
Y='\u001b[33m'
M='\u001b[35m'
C='\u001b[36m'
Z='\u001b[0m'

modules="wn"

for m in ${modules}; do
  echo -e "${Y}${m}${Z}"
  templates_home="src/main/resources/${m}/sqltemplates"

  for op in create index anchor cleanup; do
    if [ ! -e "${templates_home}/mysql/${op}" ];then
      continue
    fi
    for f in ${templates_home}/mysql/${op}/*-${op}.sql; do
      b="`basename ${f}`"
      d2="${templates_home}/sqlite/${op}"
      mkdir -p "${d2}"
      f2="${d2}/${b}"
      echo -e "${M}${b}${Z}"
      if [ ! -e "${f}" ]; then
       echo -e "${R}${f}${Z}"
      #else
      #  echo -e "${C}${f} -> ${f2}${Z}"
      fi

      cat ${f} | ./filter-flat.py | ./filter-mysql2sqlite.py > "${f2}"
     done
  done
done
exit

# DIRECT TEST TO A TEST DB
for m in ${modules}; do
  echo -e "${Y}${m}${Z}"
  templates_home="sql/"

  for op in create index anchor cleanup; do
    if [ ! -e "${templates_home}/mysql/${op}" ];then
      continue
    fi
    for f in ${templates_home}/mysql/${op}/*-${op}.sql; do
      b="`basename ${f}`"
      d2="${templates_home}/sqlite/${op}"
      mkdir -p "${d2}"
      f2="${d2}/${b}"
      echo -e "${M}${b}${Z}"
      if [ ! -e "${f}" ]; then
       echo -e "${R}${f}${Z}"
      fi

      if ! cat ${f} | ./filter-flat.py | ./filter-mysql2sqlite.py | sqlite3 test.db; then
        echo -en "${R}"
        cat ${f} | ./filter-flat.py | ./filter-mysql2sqlite.py
        echo -en "${Z}"
        fi

     done
  done
done