• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

run.sh@bfc568736c13 (annotated)

run.sh

Mon, 07 Aug 2023 12:47:52 +0100

author

Matthew Wild <mwild1@gmail.com>

date

Mon, 07 Aug 2023 12:47:52 +0100

changeset 7

bfc568736c13

parent 2

e245cf75db68

permissions

-rwxr-xr-x

metadata: Fix prepared statements joining on XEP status

0 8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	1	#!/bin/bash
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	2
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	3	set -xeo pipefail
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	4
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	5	python3 tools/prepare_xep_list.py
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	6	python3 tools/prepare_software_list.py
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	7	python3 tools/prepare_compliance.py
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	8
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	9	lua normalize_json.lua
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	10
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	11	sqlite-utils insert xmpp.db xeps db_xeps.json --pk=id
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	12	sqlite-utils insert xmpp.db software db_software.json --pk=id
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	13	sqlite-utils insert xmpp.db software_platforms db_software_platforms.json --pk=software_id --pk=platform
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	14	sqlite-utils insert xmpp.db software_categories db_software_categories.json --pk=software_id --pk=category
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	15	sqlite-utils insert xmpp.db implementations db_implementations.json --pk=xep_id --pk=software_id
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	16	sqlite-utils insert xmpp.db compliance_levels db_compliance.json
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	17	sqlite-utils add-foreign-key xmpp.db implementations xep_id xeps id
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	18	sqlite-utils add-foreign-key xmpp.db implementations software_id software id
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	19	sqlite-utils add-foreign-key xmpp.db compliance_levels xep_id xeps id
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	20	sqlite-utils add-foreign-key xmpp.db software_platforms software_id software id
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	21	sqlite-utils add-foreign-key xmpp.db software_categories software_id software id
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	22
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	23	# Precompute row counts for performance
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	24	datasette inspect xmpp.db --inspect-file=counts.json
8e1675826e46 Data data data Matthew Wild <mwild1@gmail.com> parents: diff changeset	25
2 e245cf75db68 Allow overriding base URL path Matthew Wild <mwild1@gmail.com> parents: 0 diff changeset	26	exec datasette serve \
e245cf75db68 Allow overriding base URL path Matthew Wild <mwild1@gmail.com> parents: 0 diff changeset	27	-h 0.0.0.0 \
e245cf75db68 Allow overriding base URL path Matthew Wild <mwild1@gmail.com> parents: 0 diff changeset	28	--metadata metadata.yml \
e245cf75db68 Allow overriding base URL path Matthew Wild <mwild1@gmail.com> parents: 0 diff changeset	29	-i xmpp.db \
e245cf75db68 Allow overriding base URL path Matthew Wild <mwild1@gmail.com> parents: 0 diff changeset	30	--inspect-file=counts.json \
e245cf75db68 Allow overriding base URL path Matthew Wild <mwild1@gmail.com> parents: 0 diff changeset	31	--setting base_url "$DATASETTE_PATH"