#!/bin/bash -eu CMDD=$(dirname $(realpath $0)) pgdump_file=$1 sqlite_db=$2 export PGPASSWORD=${DB_PASS} PGCONN="-h ${DB_HOST} -p ${DB_PORT} -U ${DB_USER}" PSQL="psql ${PGCONN}" PGDUMP="pg_dump ${PGCONN}" $PSQL <<< "drop database if exists ${DB_NAME}" $PSQL <<< "create database ${DB_NAME}" $PSQL -d ${DB_NAME} < $pgdump_file $PSQL -d ${DB_NAME} < ${CMDD}/create_instances.sql rm ${sqlite_db} sqlite3 ${sqlite_db} < schema.sql $PGDUMP -d ${DB_NAME} --no-comments --section=data --data-only --column-inserts --no-owner -t instances | awk 'NR>22' | sed -e 's/ public\.instances / instances /' | sqlite3 ${sqlite_db} $PSQL -d ${DB_NAME} --csv < ${CMDD}/query_stats.sql | sqlite3 ${sqlite_db} ".import --skip 1 --csv '|cat -' stats" sqlite3 ${sqlite_db} <<< 'select count(*) from instances' sqlite3 ${sqlite_db} <<< 'select count(*) from stats'