The-Academic-Observatory / oaebu-workflows

Telescopes, Workflows and Data Services for the 'Book Analytics Dashboard Project (2022-2025)', building upon the project 'Developing a Pilot Data Trust for Open Access eBook Usage (2020-2022)'
https://documentation.book-analytics.org/
Apache License 2.0
5 stars 0 forks source link

include jstor country_name join for collections #204

Closed kathrynnapier closed 11 months ago

kathrynnapier commented 11 months ago

The oaebu country reference table has been updated to include a mapping to country names used in jstor usage reports in csv format for collections.

Therefore updated export_book_metrics_country.sql.jinja to join to jstor country_name field to either alpha2 codes or jstor_name. Tested for umich (publisher report with country_name as an alpha2 code, joins to alpha2) and btob (collection with country_name as a string, join to jstor_name).

codecov[bot] commented 11 months ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Comparison is base (324028e) 93.18% compared to head (7386f60) 93.18%.

Additional details and impacted files ```diff @@ Coverage Diff @@ ## main #204 +/- ## ======================================= Coverage 93.18% 93.18% ======================================= Files 16 16 Lines 2743 2743 Branches 390 390 ======================================= Hits 2556 2556 Misses 103 103 Partials 84 84 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.