Version 2.14.0

Application Changes

• Replace all references of named_tuple= in database cursors to dictionary= due to cursors using NamedTuple being marked for deprecation in future versions of MySQL Connector/Python
• Fix "Total Score" column for Panelist "First Appearance Wins" report where non-decimal scores were not populating

Component Changes

• Upgrade mysql-connector-python from 8.2.0 to 8.4.0
• Upgrade numpy from 1.26.4 to 2.1.0
• Upgrade pytz from 2024.1 to 2024.2

Development Changes

• Upgrade black from 24.4.2 to 24.8.0
• Upgrade pytest from 8.1.2 to 8.3.3
• Upgrade ruff from 0.6.7 to 0.6.9
• Add initial pytest coverage reporting using pytest-cov, which can be generated by running: pytest --cov=app tests/

Pull Request(s): #47

Full Changelog: https://github.com/questionlp/reports.wwdt.me/compare/v2.13.0...v2.14.0

Version 2.13.0

Application Changes

• Fix Guest Scoring Exceptions report where an exception does not contain any notes
• Code cleanup and fix Pylint errors and warnings

Development Changes

• Upgrade black from 0.5.1 to 0.6.7

Pull Request(s): #45

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.12.0...v2.13.0

Version 2.12.0

Application Changes

• Add show descriptions and show notes reports
• Fix issues reported by Pylint

Component Changes

• Upgrade gunicorn from 22.0.0 to 23.0.0

Pull Request(s): #43, #44

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.11.0...v2.12.0

Version 2.11.0

Application Changes

• Add support for Umami web analytics via settings.umami_analytics config object with the following keys:

Pull Request(s): #42

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.10.0...v2.11.0

Version 2.10.0

Application Changes

• Change the database queries and application logic for the panelist "Perfect Score Counts" and "Single Appearance" reports to allow the application to experimentally support MariaDB 11.4.2

Development Changes

• Upgrade ruff from 0.3.6 to 0.5.1
• Upgrade black from 24.3.0 to 24.4.2
• Upgrade pytest from 8.1.1 to 8.1.2

Pull Request(s): #41

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.9.2...v2.10.0

Version 2.9.2

Component Changes

• Upgrade flask from 3.0.0
• Upgrade gunicorn from 21.2.0 to 22.0.0
• Upgrade numpy from 1.26.3 to 1.26.4
• Upgrade pytz from 2023.3.post1 to 2024.1

Development Changes

• Upgrade ruff from 0.1.13 to 0.3.6
• Upgrade pytest from 7.4.4 to 8.1.1

Pull Request(s): #39

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.9.1...v2.9.2

Version 2.9.1

Development Changes

• Upgrade black from 23.12.1 to 24.3.0

Pull Request(s): #38

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.9.0...v2.9.1

Version 2.9.0

Application Changes

• Add type hints for a majority of the return types for routes and utility modules
• Replace use of typing.Optional and typing.Union with the with the conventions documented in PEP-484 and PEP-604
• Change handling of time_zone configuration value to prevent use of pytz.timezone() in function arguments
• Add support for project sponsorship links to Patreon and GitHub via settings.patreon_url and settings.github_sponsors_url config keys

Component Changes

• Upgrade Markdown from 3.5.1 to 3.5.2
• Upgrade numpy from 1.26.0 to 1.26.3

Development Changes

• Switch to Ruff for code linting and formatting (with the help of Black)
• Upgrade pytest from 7.4.3 to 7.4.4
• Upgrade black from 23.11.0 to 23.12.1

Pull Request(s): #36

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.8.0...v2.9.0

Version 2.8.0

Application Changes

• Addition of Panelist Bluff the Listener Statistics by Year report
• Fix a bug in the Panelist Single Appearance report where the panelists' ranking was not being rendered

Component Changes

• Upgrade Pure CSS from 2.3.2 to 3.0.0
• Upgrade Markdown from 3.4.3 to 3.5.1

Development Changes

• Migrate to using Ruff for linting and formatting
• Migrate use of typing.Dict, typing.List and typing.Union to dict, list and | respectively

Pull Request(s): #33

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.7.0...v2.8.0

Version 2.7.0

Starting with version 2.7.0, support for all versions of Python prior to 3.10 have been deprecated.

Application Changes

• Replace dateutil.parser.parse with datetime.datetime.strptime

Component Changes

• Upgrade MySQL Connector/Python from 8.0.33 to 8.2.0
• Upgrade numpy from 1.24.3 to 1.26.0
• Remove python-dateutil from dependencies

Development Changes

• Upgrade black from 23.10.1 to 23.11.0
• Remove py38 and py39 from tool.black in pyproject.toml

Pull Request(s): #30

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.6.2...v2.7.0

Version 2.6.2

Application Changes

• Correct wording for the Low Scoring Shows report description to reflect that the report only includes shows with a panelist total score of less than 30 points

Pull Request(s): #29

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.6.1...v2.6.2

Version 2.6.1

Application Changes

• Improve handling of conditions where shows have missing hosts, scorekeepers, panelists and guests for several show reports

Pull Request(s): #28

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.6.0...v2.6.1

Version 2.6.0

Component Changes

• Upgrade Flask from 2.3.2 to 3.0.0
• Upgrade gunicorn from 20.1.0 to 21.2.0
• Upgrade pytz from 2023.3 to 2023.3.post1

Development Changes

• Upgrade pycodestyle from 2.11.0 to 2.11.1
• Upgrade pytest from 7.4.0 to 7.4.3
• Upgrade black from 23.7.0 to 23.10.1

Pull Request(s): #27

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.5.0...v2.6.0

Version 2.5.0

Application Changes

• Add support for the new decimal panelist Lightning Fill-in-the-Blank start and correct columns, panelistlrndstart_decimal and panelistlrndcorrect_decimal, respectively
• Optimize some of the template checks for use_decimal_scores

Pull Request(s): #26

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.4.0...v2.5.0

Version 2.4.0

Application Changes

• Add support for the new decimal panelist score column, panelistscore_decimal in the ww_showpnlmap table of the Wait Wait Stats Database.
• Add a use_decimal_scores setting in config.json to enable or disable pulling data from the new column. The default is false
• All calculations that use of decimal scores, versus integer scores, use the Python Decimal data type
• Change the rounding of certain stats from 4 decimal places to 5 decimal places

Component Changes

• Upgrade NumPy from 1.24.2 to 1.24.3

Development Changes

• Upgrade black from 23.3.0 to 23.7.0
• Upgrade flake8 from 6.0.0 to 6.1.0
• Upgrade pycodestyle from 2.10.0 to 2.11.0
• Upgrade pytest from 7.3.1 to 7.4.0

Pull Request(s): #22, #23, #24, #25

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.3.2...v2.4.0

Version 2.3.2

Application Changes

• Fix issue with shows with empty details causing Low Scoring and High Scoring show reports to error out

Pull Request(s): #18
Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.3.1...v2.3.2

Version 2.3.1

Application Changes

• Add filter to Panelist Average Scores by Year database query to exclude any NULL values for panelist scores to prevent skewing of results

Pull Request(s): #20

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.3.0...v2.3.1

Version 2.3.0

Application Changes

• Addition of Panelist Average Scores by Year and Panelist Average Scores by Year: All reports
• Modify CSS for Panelist Appearances by Year report to correct column sizes
• Add tooltips to each data cell in the Panelist Appearances by Year report to display the panelist name and year
• Fix issue where printing out Panelist Appearances by Year report from cropping out the table when page scaling is reduced
• Fixed typos in dropdown menus when choosing panelists

Development Changes

• Added tests for Panelist Average Scores by Year and Panelist Average Scores by Year: All reports
• Updated tests for Panelist Appearances by Year and Panelist vs Panelist reports

Pull Request(s): #18, #19

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.2.5...v2.3.0

Version 2.2.5

Component Changes

• Upgrade Flask from 2.2.3 to 2.3.2

Pull Request(s): #17

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.2.4...v2.2.5

Version 2.2.4

Application Changes

• Correct sorting of "All Women Panel" report to sort by date

Component Changes

• Upgrade MySQL Connector/Python from 8.0.30 to 8.0.33
• Upgrade NumPy from 1.23.2 to 1.24.2
• Upgrade pytz from 2022.6 to 2023.3
• Upgrade Markdown from 3.4.1 to 3.4.3

Development Changes

• Move pytest configuration from pytest.ini into pyproject.toml
• Upgrade flake8 from 5.0.4 to 6.0.0
• Upgrade pycodestyle from 2.9.1 to 2.10.0
• Upgrade pytest from 7.2.0 to 7.3.1
• Upgrade black from 22.10.0 to 23.3.0

Pull Request(s): #16

Full Changelog: https://github.com/questionlp/reports.wwdt.me_v2/compare/v2.2.3...v2.2.4