A simple utility to read all .sql files in the current directory, create an in-memory database from them and start a sqlite3 shell

minidb

#!/usr/bin/env bash

# A simple utility to read all .sql files in the current directory, create an
#  in-memory database from them and start a sqlite3 shell

if [ -f mini.db ]; then
    echo "found existing database, removing"
    rm mini.db;
fi

cat ./*.sql | sqlite3 mini.db -init - && sqlite3 mini.db

# cleanup
if [ -f mini.db ]; then
    rm mini.db;
fi

echo "done."