Extensions of ID3C for the Seattle Flu Study

Source code

github.com/seattleflu/id3c-customizations

Contributors

Latest commits

04 Jun 2021 - CODEOWNERS: Reflect rename of team from id3c-devs to core-devs

02 Jun 2021 - Merge branch 'metabase-query-info'

27 May 2021 - Merge branch 'offer-uw-testing/batched-updates'

26 May 2021 - Extract Metabase details for each connection from the query comment These details will let our connection watchdog processes (e.g. for slow queries) be more selective in what they terminate without revealing the full query of every connection to non-superusers. The format of this comment (or "remark" in Metabase's parlance) is reasonably guessable, but I also checked the code.¹ If the format changes in the future and the parse fails, the new "metabase" column added here will just be null. This seems like a reasonable failure mode. ¹ https://github.com/metabase/metabase/blob/f76d8333/src/metabase/query_processor/util.clj#L26-L37

26 May 2021 - Prepare pg_stat_activity_nonsuperuser view + function for rework Reworks the idempotent deploy script to drop and create the view and function instead of using "create or replace" so that function signatures and view definitions can change. No behaviour change to the view or function itself yet.

Pages

/ locations /

/ clinical / uw /

/

ID3C customizations for the Seattle Flu Study

This repository contains:

a Sqitch project for managing Seattle Flu-specific static data in the ID3C database, such as organism assignments for targets, extra site details, and bespoke views.
an ID3C extension which provides additional id3c CLI subcommands and ETL routines.
additional support data and code

Sqitch

Changes in this Sqitch project can rely on changes in the ID3C Sqitch project by prefixing them with the project name (seattleflu/schema currently, but subject to change after reorganization).

Tests

Run all tests with:

pipenv run pytest -v

or name an individual test file, for example:

pipenv run pytest tests/docstrings.py