diff options
Diffstat (limited to 'scripts/boostrap-steam-db.bash')
-rw-r--r-- | scripts/boostrap-steam-db.bash | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/scripts/boostrap-steam-db.bash b/scripts/boostrap-steam-db.bash new file mode 100644 index 0000000..ca06dd2 --- /dev/null +++ b/scripts/boostrap-steam-db.bash @@ -0,0 +1,22 @@ +#!/bin/bash +set -euo pipefail +tmp="$(mktemp -d)" +trap 'rm -rf -- "$tmp"' EXIT + +# deps +hash sqlite3 rq + +# first generate clean db +bash update-schema-models.bash + +for db in kanta; do + rm -f "$db".sqlite{,-shm,-wal} + sqlite3 "$db".sqlite < db/"$db".sql + sqlite3 "$db".sqlite <<'EOF' +insert into engines (id, name) values (0, "generic"); +insert into roles (id, name) values (0, "developer"); +EOF + jq -r -f scripts/jq/transform-creators.jq steam-dataset-messy/steam.json | sqlite3 "$db".sqlite + jq -r -f scripts/jq/transform-products.jq steam-dataset-messy/steam.json | sqlite3 "$db".sqlite + jq -r -f scripts/jq/transform-product-creators.jq steam-dataset-messy/steam.json | sqlite3 "$db".sqlite +done |