prepare_dev_environment.sh

#!/bin/bash -ex

# TODO: detect latest archive
FILENAME=ifdb-archive-20210317.zip
if [ ! -f sql/$FILENAME ]; then
    curl -o sql/$FILENAME https://ifarchive.org/if-archive/info/ifdb/$FILENAME
fi
unzip -o sql/$FILENAME

rm -rf initdb
mkdir initdb
cat sql/create-db.sql ifdb-archive.sql > initdb/00-init.sql
cp sql/patch-schema.sql initdb/01-patch-schema.sql
cp sql/create-admin.sql initdb/02-create-admin.sql

sed 's/"127.0.0.1", "username", "password"/"db", "root", "secret"/' local-credentials.php.template > www/local-credentials.php