build-dbs.sh

#!/bin/bash

set -eu -o pipefail

rm -f data.sqlite3
sqlite3 cryptics.sqlite3 ".dump clues" | sqlite3 data.sqlite3
sqlite3 cryptics.sqlite3 ".dump indicators" | sqlite3 data.sqlite3
sqlite3 cryptics.sqlite3 ".dump indicators_unpivoted" | sqlite3 data.sqlite3
sqlite3 cryptics.sqlite3 ".dump indicators_consolidated" | sqlite3 data.sqlite3
sqlite3 cryptics.sqlite3 ".dump charades" | sqlite3 data.sqlite3
sqlite3 cryptics.sqlite3 ".dump charades_unpivoted" | sqlite3 data.sqlite3
sqlite3 data.sqlite3 ".read queries/prepare-db-for-publication.sql"
sqlite3 data.sqlite3 "
INSERT INTO metadata (key, value)
VALUES
    ('license', 'This dataset is made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/. Any rights in individual contents of the database are licensed under the Database Contents License: http://opendatacommons.org/licenses/dbcl/1.0/'),
    ('last_built', '$(date)'),
    ('last_commit', '$(git log --format="%H" -n 1)')
"
sqlite3 data.sqlite3 "VACUUM;"
sqlite-utils enable-fts data.sqlite3 clues clue answer
sqlite-utils enable-fts data.sqlite3 indicators indicator
sqlite-utils enable-fts data.sqlite3 charades charade answer