Skip to content

CHANGELOG.md

Latest commit

 

History

History
464 lines (325 loc) · 46.6 KB

CHANGELOG.md

File metadata and controls

464 lines (325 loc) · 46.6 KB

Changelog

1.7.0 (2024-12-11)

Features

Bug Fixes

1.6.2 (2024-11-28)

Bug Fixes

1.6.1 (2024-08-08)

Bug Fixes

1.6.0 (2024-07-25)

Features

  • intervention status, fix: biomarker views (#431) (65d1a70)

1.5.2 (2024-04-14)

Bug Fixes

  • tweak household matching, intervention data fixes (#422) (8b5339b)

1.5.1 (2024-03-21)

Bug Fixes

1.5.0 (2024-03-20)

Features

  • revamp matching to use static intake table (externally populated) (038b0d5)

Bug Fixes

  • household intake data table rather than view (b855988)
  • update fct match (7f45753)

1.4.4 (2024-03-15)

Bug Fixes

  • source field for intervention data (b9f0e26)

1.4.3 (2024-03-08)

Bug Fixes

1.4.2 (2024-03-07)

Miscellaneous

1.4.1 (2024-03-07)

Miscellaneous

1.4.0 (2024-03-07)

Features

  • premix calculator updateS: (682650d)

Bug Fixes

  • various intervention fixes (35aeaa8)

1.3.0 (2023-11-02)

Features

  • add support for intervention formula overrides to views (9192ac5)

Bug Fixes

  • add missing field to baseline assumptions view (8cf4c9f)

1.2.0 (2023-10-13)

Features

  • add basic view to calculate summary premix cost per intervention (de5aa0f)
  • add fields to intervention to store focus geography and micronutrient. Update intervention creation function to support their use (1fff983)
  • add intervention id column to fortification targeting data (97bcc8e)
  • add mat view of cell formulae for interventions (8b98829)
  • add ovverriden flag to intervention_data to support user ovverriding formula values (b43380a)
  • add temporary population summary table (1044da9)
  • fix fortificant extraction (33a6ac1)
  • initial include formulae in intervention-values-json aggregate (62c57bd)
  • maintain source sorting order for intervention data views (0c47710)
  • update biomarker datasources to include viable aggregation fields and other utility data (5e3cfb1)
  • update susu and recurring costs views to use the intervention_values_json view as parent (acc631d)

Bug Fixes

  • add flag to intervention_data table to indicate if a value has been overriden (7dbcaac)
  • add focus nutrient to intervention_list view (f863864)
  • add user_id to intervention_list view (1b8a9ec)
  • adjust sql order for intervention cell formula view (4aa5505)
  • fix cells deps in dependent rows (0e6d22a)
  • fix intervention create function typo (b183095)
  • fix intervention formulae (348a846)
  • fix intervention total row names, omit uneeded rows from json view (516223e)
  • fix types in intervention subset view and use it for susu view (eb9d26c)
  • formula order (583f218)
  • make aggregation_area gid unique so can be used in FK relations (fccd6f5)
  • more fix (c927037)
  • remove analyse statement (b280169)
  • typo in recurring costs view (373693d)
  • update create intervention fnb to include premix (90e362b)
  • update create_derived_intervention function to accept text user_id (6e4a7d2)
  • yearXEdited fields no longer null when parent intervention value is null (61a7a45)

Miscellaneous

1.1.1 (2023-05-17)

Miscellaneous

1.1.0 (2023-05-17)

Features

  • ad override table for biomarker survey aggregation areas (17ac48d)
  • add country level to household aggregation views alongside L1 aggregations (62a2418)
  • add country level to household aggregation views alongside L1 aggregations 2 (210b599)
  • add national median dietary supply to impact summary (8fc6e8c)
  • add national median values to impact summary view (b44b281)

Miscellaneous

  • add sort to household_intake_afe view (ed519c7)
  • aggregate all household values irrespective of fct_list_id (922bb32)
  • fix country/admin aggregations (5dc3be2)
  • reorder impact migrations (ff33ecd)

1.0.10 (2023-03-24)

Bug Fixes

  • rearrange table order in afe_ear_threshold view to include all mns even if no threshold present (18469cb)

1.0.9 (2023-03-22)

Bug Fixes

  • simplify diet datasource view naming (ce9e3a5)

1.0.8 (2023-03-17)

Bug Fixes

1.0.7 (2023-03-17)

Bug Fixes

  • disable foritifcant for now (9ecd146)

1.0.6 (2023-03-17)

Bug Fixes

  • update miccronutrient dictionary and intake_thresholds table (21bb9c5)

1.0.5 (2023-02-28)

Bug Fixes

  • addordering to other intervention json views: (3909723)

Miscellaneous

1.0.4 (2023-02-08)

Bug Fixes

  • do not try to calculate bmi when weight or height are zero (95241fe)

1.0.3 (2022-10-30)

Bug Fixes

1.0.2 (2022-10-30)

Bug Fixes

1.0.1 (2022-10-30)

Bug Fixes

  • improve unmatched items view (7250975)
  • tweak release please config (7feb0b6)

1.0.0 (2022-10-30)

Features

  • add 'default' values for cells taken from the parent intervention along with an edited flag and data source information (5e33841)
  • add basic lock flag and check trigger for intervention_data updates (f19e73e)
  • add basic lock flag and check trigger for intervention_data updates (abafb3f)
  • add composition source (84d2674)
  • add default flag to biomarker groups table (c595488)
  • add description and metadata fields to data source views for consumption, composition and biomarker data (68d3f65)
  • add description field for fct, fbs and hces data (a22ed10)
  • add factors for calcultaing AFE/AME (c41428f)
  • add field to microonutrient table for user facing text around methods (8c39956)
  • add function for country intake scenarios (b406843)
  • add function to atomically create a new intervention and duplicate the intervention_data rows from its parent (838baed)
  • add function to create a 'scenario' fct by taking a source fct and changing the nutrient value for a given fooditem (bf8b3c3)
  • add geonetwork uuid to data tables (9dac883)
  • add github actions for release please (6ef1fc5)
  • add initial summary json views of intervention cost data (91f97fd)
  • add last updated date to interventions table and trigger to update on updates to intervention_data (fb65656)
  • Add lookup table between biomarker names and micronutrient ids (ea4dbed)
  • add median aggregator and create summary views aggregating household supply and deficiency across subregions (2c65d97)
  • add name and description to intervention creation function (0d86b82)
  • add pivoted view for country level deficiency. Consolidate field names for consistency (48f1d0d)
  • add scenario functions for consumption and comparison scenarios (c06cde8)
  • add sex field to biomarker summary view (c2bb122)
  • add smoker status and altitude to biomarker summary view (bfe5906)
  • add summary view for biomarrker thresholds (23a203b)
  • add summary view for extracting intervention 10yr summary costs (2f5350b)
  • add table for storing data semvar details (ebac8c0)
  • add table generation for household_fct_list table (d8430b7)
  • add units and editable flag to json summary views (87cec1b)
  • add updated time column to interventions table (d25bf3d)
  • Add view for 'best' biomarker data source for a given country (820b560)
  • add view for reported biomarkers in each survey (c8997f0)
  • add view for the micronutrients reported in a given FCT (d951348)
  • add view of age-gender groups per biomarker survey and add to biomarker data sources view (4bb0d5c)
  • add view of household aer values (15415f6)
  • add view that normalises the outputs of the household_intake table (510d8be)
  • add view to calculate AFE/AME factor for a complete household (c219258)
  • add view to select EAR thresholds based on AFE female (2c7e190)
  • Add views to reflect the quantity and weight of consumption datasets not matched by each FCT (ad6206a)
  • include micronutrient in diet_data_sources view (2cf9dbd)
  • initial tweaks (c0baa59)
  • record semver version for db schema in data_version table (084c1dd)
  • return intervention_list response for new intervention when created (a74c8c0)
  • update biomarker thresholds and summary view (78b815e)
  • update biomarker threshpolds table to store conditions in more computer parsable form (39536c2)
  • update biomarker view fields (d3b19b2)
  • update comosition sources view to include reported MN (0a2553f)
  • update fct scenario function to support array of values. Create function for creating country_deficiency_afe scenarios (acc8b1e)
  • Update scenario creation function to use micronutrient table ids (51aa187)
  • update top20 and monthly household views to reflect the fct priortisation (59ef52f)
  • update top20 mn country view to use fct_list (295bd08)
  • updated intake views to use prioritised fct and match statistics views also (9dcd740)

Bug Fixes

  • actually add summary view for extracting intervention 10yr summary costs (41c5857)
  • actually fix impact view (d72b6c7)
  • actually unbork the table alias in new fields (8299a46)
  • add food_group name field to monthly food view (ef962a7)
  • add hh mat view to refresh list (9fb1375)
  • add key to household member group_id field (c5eb543)
  • add missing field to household member (7401e43)
  • add missing fields to biomarker-thresholds-list view (a7351ac)
  • disable folic acid from mn dropdown. Only want folate (9398d42)
  • don't adlter household_fct_list table in matching fn (3cf0eb4)
  • don't drop household_fct_list table in matching fn (9de4ec7)
  • don't group by geometry on household_deficiency_afe_aggregation (2555ea9)
  • ensure materialized views dropped at start of repeatable migrations (36008bf)
  • explicitly cast columns as numeric, to allow downstream views to work (79c5dce)
  • fix comments in biomarker_trhreshold table generation (56d5c5b)
  • fix consumption sources view to include description and metadata id (b2d6dcc)
  • fix household join bug where not all households were matched (afae632)
  • fix migration filename clash (d262264)
  • fix monthly food view, adjust impact view for daily rather than annual availability (c32e046)
  • fix sql file extension (4d1e716)
  • fix trigger sql name to sort migration order (6b397ed)
  • fix typo (6dd118d)
  • fix typo (0d22783)
  • fix typo in country deficiency view (f1a5334)
  • fix typo in household agg view (a89884c)
  • fix typo in household agg view (2517b0e)
  • fix typo in household intak field names (2e34f0f)
  • fix typo in view comment (9823170)
  • intervetions: typo in baseline assumptions view (ef78d06)
  • intervetions: typo in intervention-values view (cae42a2)
  • only join country consumption where data (cf3548d)
  • only join country table where FCTs exist (6b46748)
  • remove erroneous test filter. Update intervention data clone function to reflect all fields (4dc2340)
  • replace phytic acid with phytate (460c391)
  • sstill include biomarker data that does not match a given aggregation area (can still be aggregated by other fields) (7532c00)
  • typo (9854e47)
  • typo in household_intake_afe view (ff36ac3)
  • unbork the table alias in new fields (da8911b)
  • unify fields between household and country deficiency views (e63a4ca)
  • update aggregation_area joins to only use level 1 admin area (a905d0e)
  • update aggregation_area joins to only use level 1 admin area #2 (7e4719e)
  • update country unmatched (998c018)
  • update data_version to use timestamp rather than date (99f5002)
  • update micronutirent names in micronutrient dictionary (907c199)
  • update top20 household food chart to show consumption per average AFE rather than cumulative for the whole surveyed population: (b3623d1)
  • updayte top20country to maintain previous field names (68a5186)

Miscellaneous

  • actually merge develop (fc96a35)
  • add data name to diet sources view (6b8f790)
  • adjust view generation order (c6a11d0)
  • code formatting (efac163)
  • code formatting (b4ba942)
  • comment fix (6d5fe12)
  • deficient -> is_deficient (a4da4b8)
  • energy requirement un-gendered (fa89b24)
  • filename tidy (56f42dd)
  • filename tidy (a6dc6d0)
  • fix (0928983)
  • fix biomarker_micronutrient_mapping comments (7085d2a)
  • fix biomarker_micronutrient_mapping comments 2 (1276f46)
  • fix case statement in country deficiency (d35b5bc)
  • fix case statement in country deficiency (8a25cc1)
  • fix case statement in country deficiency 2 (9925893)
  • fix comment typos. Update household_normalisation_factor table to have a sex column (f107863)
  • fix comments: (a9b1672)
  • fix data scales when at annual/daily level (534e1ef)
  • fix execution order (f0adff6)
  • fix function call params 3 (7199cbe)
  • fix function call params 5 (21247c4)
  • fix function call signatures (57618ae)
  • fix group by in household deficiency view (dff519f)
  • fix household_fct_list table (9572c93)
  • fix indentation, move json agg function to separate file, remove is_premade check from intervention_list view (ccd6ce3)
  • fix join conditions (c0620e4)
  • fix ordering (b7de3ec)
  • fix ordering (09ecea9)
  • fix syntax error (d88480a)
  • fix syntax typo (aa4707c)
  • fix typo (262e2e9)
  • fix typo (1184c67)
  • fix typo (7e0e18f)
  • fix typo (a88de37)
  • fix typo (bde6bb3)
  • fix typo (47775d3)
  • fix typo in refresh mat view (e3e168e)
  • fix typos (5b3a59e)
  • fix updated field names (c2bd05f)
  • fix view name (5fb03a8)
  • fix2 (0cb2cd9)
  • fiz typos, captialize keywords, clarify views are AFE (c2cdb65)
  • formatting improvements (de9308a)
  • merge develop (7a3dcfa)
  • misc tweaks (2867be0)
  • mix column name for su-su view (f3603bd)
  • move normalisation factor inserts to data repo (9e014b4)
  • quick fix (1852bcb)
  • quick fix (31ab725)
  • quick fix (6e86d47)
  • remove redundant comments (8762fb5)
  • remove schema names (10cdc41)
  • remove table generation from fn (e43954f)
  • remove unneeded fields from composition_sources view (be5456b)
  • sort view creation order: (fd69132)
  • switch household table alias to hh (51f3dd5)
  • tidy files and add basic food_group view (f0251c6)
  • tweaks (16b6ff1)
  • tweaks (b2e749e)
  • tweaks to intervention view outputs for consistency (1592931)
  • update aggregation_area alias and formatting in biomarker summary view (095e80c)
  • update intervention parent joins to be left joins so data still returned for interventions with no parent (6df3d7f)
  • update mat view refresh (6892fc8)
  • update scenario views to limit to a single consumption/composition source (b248401)
  • update to reflect updates to aggregation area table rather than subregion (7c4cccb)
  • update view comments (41edf9b)
  • windback tweaks (416abac)