#!/bin/bash
# Usage: `restore_sqlite_db.sh db.sqlite3`
# See https://stackoverflow.com/a/15874884/3645337.
cat <( sqlite3 "$1" .dump | grep "^ROLLBACK" -v ) <( echo "COMMIT;" ) | sqlite3 "fix_$1"