diff options
| author | Terry Truong <terry06890@gmail.com> | 2023-01-14 22:03:57 +1100 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2023-01-14 22:03:57 +1100 |
| commit | ebe74b640adaed5382046a49b1c2d6a48b31ebfd (patch) | |
| tree | 8ca2b824d3667d9a6e5ef4e8b2d6b739f6692aaf /backend/hist_data/README.md | |
| parent | a8ea534f13cc23dfab25c6d856f9d9833dd000ba (diff) | |
Add img_dist and img_disp db tables
Having separate event counts for events with images resolves some
redundant server querying, and makes event count indicators moree
representative.
Diffstat (limited to 'backend/hist_data/README.md')
| -rw-r--r-- | backend/hist_data/README.md | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/backend/hist_data/README.md b/backend/hist_data/README.md index c947aa6..50108e0 100644 --- a/backend/hist_data/README.md +++ b/backend/hist_data/README.md @@ -27,6 +27,10 @@ This directory holds files used to generate the history database data.db. - `event_disp`: <br> Format: `id INT, scale INT, unit INT, PRIMARY KEY (id, scale)` <br> Maps events to scales+units they are 'displayable' on (used to make displayed events more uniform across time). +- `img_dist`: <br> + Like `dist`, but only counts events with images. +- `img_disp`: <br> + Like `events_disp`, but only counts events with images. - `images`: <br> Format: `id INT PRIMARY KEY, url TEXT, license TEXT, artist TEXT, credit TEXT` <br> Holds metadata for available images @@ -84,3 +88,6 @@ Some of the scripts use third-party packages: 1. Additional events can be described in `picked/events.json`, with images for them put in `picked` (see the README for details). 1. Can run `gen_picked_data.py` to add those described events to the database. + +## Generation Event Image Display Data +1. Run `gen_disp_data.py img`, which adds the `img_dist` and `img_disp` tables. |