Mon, 13 Mar 2023 16:39:07 +0000
Data data data
0 | 1 | #!/bin/bash |
2 | ||
3 | set -xeo pipefail | |
4 | ||
5 | python3 tools/prepare_xep_list.py | |
6 | python3 tools/prepare_software_list.py | |
7 | python3 tools/prepare_compliance.py | |
8 | ||
9 | lua normalize_json.lua | |
10 | ||
11 | sqlite-utils insert xmpp.db xeps db_xeps.json --pk=id | |
12 | sqlite-utils insert xmpp.db software db_software.json --pk=id | |
13 | sqlite-utils insert xmpp.db software_platforms db_software_platforms.json --pk=software_id --pk=platform | |
14 | sqlite-utils insert xmpp.db software_categories db_software_categories.json --pk=software_id --pk=category | |
15 | sqlite-utils insert xmpp.db implementations db_implementations.json --pk=xep_id --pk=software_id | |
16 | sqlite-utils insert xmpp.db compliance_levels db_compliance.json | |
17 | sqlite-utils add-foreign-key xmpp.db implementations xep_id xeps id | |
18 | sqlite-utils add-foreign-key xmpp.db implementations software_id software id | |
19 | sqlite-utils add-foreign-key xmpp.db compliance_levels xep_id xeps id | |
20 | sqlite-utils add-foreign-key xmpp.db software_platforms software_id software id | |
21 | sqlite-utils add-foreign-key xmpp.db software_categories software_id software id | |
22 | ||
23 | # Precompute row counts for performance | |
24 | datasette inspect xmpp.db --inspect-file=counts.json | |
25 | ||
26 | exec datasette serve -h 0.0.0.0 --metadata metadata.yml -i xmpp.db --inspect-file=counts.json |