v3.2.0

Version 3.2.0

Note: In the near future, all reports will require version 4.7 of the Wait Wait Stats Database and all reports that make use of panelist scores will be based on decimal score columns. Code paths that check for use of the decimal scores columns will be updated to remove references to the non-decimal score columns.

Application Changes

• Wrap all report description on Guests, Hosts, Locations, Panelists, Scorekeepers and Shows index pages in p tags for consistency
• Break out the "Best Of/Repeat" column into "Best Of" and "Repeat Of" columns, where the "Repeat Of" column will show the original show date for repeat shows
• Display the original show date instead of True for repeat shows
• For columns that previously displayed True or False, replace False with a hyphen to reduce visual noise
• Adding new or updating existing reports
  • Use Bootstrap Accordion component to streamline reports with multiple, large tables
  • Update report descriptions for more consistent use of terms
  • Match the report descriptions listed each section index page with the description in each report
  • Remove card header for cards that include forms
  • Update margin consistency between report descriptions, form cards and generated report results
  • Guests
    • Fix: Filter out entries with guest slug of none
    • Update: "Not My Job Scoring Exceptions" is now sorted by show date rather than by Not My Job Guest name
    • New Report: "Appearances by Year"
    • New Report: "Not My Job Guests with Missing Scores"
    • New Report: "Wins by Year"
  • Hosts
    • New Report: "Appearance Counts by Year"
    • New Report: "Appearance Counts by Year: Grid"
    • New Report: "Appearances by Year"
    • New Report: "Debuts by Year"
  • Locations
    • Update: Add "Home/Remote Studios" column
    • New Report: "Recording Counts by Year"
    • New Report: "Recordings by Year"
  • Panelists
    • Update: "Appearance Counts by Year: Grid" report now includes both regular and all appearances to match the hosts and scorekeepers reports of the same name
    • Update: "Appearances by Year" report renamed and relocated to "Appearance Counts by Year: Grid" to match the naming convention for the corresponding hosts and scorekeepers reports
    • Update: "Bluff the Listener Statistics by Year" report renamed and relocated to "Bluff the Listener Panelist Statistics by Year"
    • New Report: "Appearances by Year"
    • New Report: "Appearance Counts by Year"
    • New Report: "Bluff the Listener Statistics by Year"
    • New Report: "Highest Average Correct Answers by Year"
    • New Report: "Highest Average Scores by Year"
    • New Report: "Most Chosen Bluff the Listener Story by Year"
    • New Report: "Most Chosen Correct Bluff the Listener Story by Year"
    • New Report: "Most Correct Bluff the Listener Story by Year"
    • New Report: "Most Wins by Year"
    • New Report: "Statistics Summary by Year"
  • Scorekeepers
    • New Report: "Appearance Counts by Year"
    • New Report: "Appearance Counts by Year: Grid"
    • New Report: "Appearances by Year"
    • New Report: "Debuts by Year"
  • Shows
    • Update: Add "Best Of" and "Repeat Of" columns to the following reports:
      • "Show Descriptions"
      • "Show Notes"
    • New Report: "Best Of Shows"
    • New Report: "Repeat Best Of Shows"
    • New Report: "Repeat Shows"
• Add missing configuration handling for the following settings:
  • block_ai_scrapers
  • use_minified_css
• Update change frequency value from daily to weekly in the sitemap.xml templates
• Added reports from version 3.1.0 to the respective sitemap templates

Component Changes

• Update wwdtm-theme submodule to include accordion component styling and customizations

Development Changes

• Upgrade ruff from 0.9.4 to 0.9.6
• Added test case for errors.not_found

---

Pull Request(s): #58

Full Changelog: v3.1.0...v3.2.0

v3.1.0

Version 3.1.0

Application Changes

• Adding new reports
  • Locations
    • Show Locations: Home vs Away
  • Shows
    • Lightning Round All Panelists Answering the Same Number of Questions Correct
    • Shows with a Guest Host and a Guest Scorekeeper

Development Changes

• Upgrade pytest from 8.3.3 to 8.3.4
• Upgrade ruff from 0.7.4 to 0.9.4
• Remove black from required development packages as part of migrating entirely to Ruff
• Ran ruff format to format Python code files using the Ruff 2025 Style Guide

---

Pull Request(s): #57

Full Changelog: v3.0.5...v3.1.0

v3.0.5

Version 3.0.5

Component Changes

• Upgrade Flask from 3.0.3 to 3.1.0
• Upgrade Markdown from 3.5.2 to 3.7.0

---

Pull Request(s): #56

Full Changelog: v3.0.4-post.1...v3.0.5

v3.0.4-post.1

Version 3.0.4-post.1

Component Changes

• Upgrade nanoid from 3.3.7 to 3.3.8 to fix a security vulnerability for a package required to compile, minify and copy generated CSS files

---

Pull Request(s): #55

Full Changelog: v3.0.4...v3.0.4-post.1

v3.0.4

Version 3.0.4

Application Changes

• Update wwdtm-theme to set font weight for header and footer navigation links to 500
• Tweak responsive font sizing for root in wwdtm-theme with a range of 14.5px and 16.75px

---

Pull Request(s): #54

Full Changelog: v3.0.3...v3.0.4

v3.0.3

Version 3.0.3

Application Changes

• Fix issue where Umami Analytics configuration was not read in properly, thus causing the snippet to be added to the rendered page when enabled
• Removed utility.format_umami_analytics() as it is no longer in use

---

Pull Request(s): #53

Full Changelog: v3.0.2...v3.0.3

v3.0.2

Version 3.0.2

Application Changes

• Re-add responsive font sizing for :root in wwdtm-theme with a range of 14px and 16.5px

---

Pull Request(s): #52

Full Changelog: v3.0.1...v3.0.2

v3.0.1

Version 3.0.1

Application Changes

• Remove responsive font sizing for :root in wwdtm-theme.

Development Changes

• Upgrade ruff from 0.7.0 to 0.7.4

---

Pull Request(s): #51

Full Changelog: v3.0.0...v3.0.1

v3.0.0

Version 3.0.0

Application Changes

• Frontend code refactor due to switching from Pure CSS to Bootstrap
  • Replacing Pure CSS frontend toolkit with Bootstrap
  • Refactor the frontend structure to use Bootstrap frontend components and conventions
  • Include the required IBM Plex web fonts with the application to remove use of Google Fonts
• User interface changes
  • Switch the design to match that of the Wait Wait Stats Page and the Wait Wait Graphs Site
  • Make use of Bootstrap's responsive design functionality for a more consistent experience across mobile and desktop
  • Remove "Home" from all navigational breadcrumbs
  • Clean up the home page to only provide a table of contents and only display report descriptions on the index page for each section
  • Remove shading for table cells that do not contain data
  • Add tooltips to certain columns in Panelist Bluff the Listener and Show Panel Gender Mix reports to provide additional information
• Link to the corresponding location page on the Wait Wait Stats Page for each listed location in the "Locations: Average Scores" report
• Updating report method names, report template filenames and URLs for consistency
  • The following table lists the reports that have been renamed and/or had their URLs changed
  • Add the necessary redirects and update sitemap generation
  • Update test scripts to reflect new method names, routes and redirects

Guests

Original Report Name	Original Report URL	New Report Name (if applicable)	New Report URL
Best Of Not My Job Guests	/guests/best-of-only	N/A	/guests/best-of-only-not-my-job-guests
Not My Job Scoring Exceptions	/guests/scoring-exceptions	N/A	/guests/not-my-job-scoring-exceptions
Not My Job Three Pointers	/guests/three-pointers	N/A	/guests/not-my-job-three-pointers

Locations

Original Report Name	Original Report URL	New Report Name (if applicable)	New Report URL
Average Score by Location	/locations/average-scores	Average Scores by Location	/locations/average-scores-by-location

Panelists

Original Report Name	Original Report URL	New Report Name (if applicable)	New Report URL
Bluff the Listener Statistics	/panelists/bluff-stats	N/A	/panelists/bluff-the-listener-statistics
Bluff the Listener Statistics by Year	/panelists/bluff-stats-by-year	N/A	/panelists/bluff-the-listener-statistics-by-year
Debut by Year	/panelists/debut-by-year	Debuts by Year	/panelists/debuts-by-year
Panelist vs Panelist	/panelists/panelist-pvp	N/A	/panelists/panelist-vs-panelist
Panelist vs Panelist: All	/panelists/panelist-pvp/all	N/A	/panelists/panelist-vs-panelist/all
Perfect Score Counts	/panelists/perfect-scores	N/A	/panelists/perfect-score-counts
Statistics by Gender	/panelists/gender-stats	N/A	/panelists/statistics-by-gender
Statistics Summary	/panelists/stats-summary	N/A	/panelists/statistics-summary

Scorekeepers

Original Report Name	Original Report URL	New Report Name (if applicable)	New Report URL
Introductions	/scorekeepers/introductions	Scorekeeper Introductions	/scorekeepers/scorekeeper-introductions

Shows

Original Report Name	Original Report URL	New Report Name (if applicable)	New Report URL
High Scoring Shows	/shows/high-scoring	N/A	/shows/high-scoring-shows
Low Scoring Shows	/shows/low-scoring	N/A	/shows/low-scoring-shows
Not My Job Guests vs Bluff the Listener Win Ratios	/shows/not-my-job-vs-bluffs	N/A	/shows/not-my-job-guests-vs-bluff-the-listener-win-ratios
Search Shows by Multiple Panelists	/shows/search-multiple-panelists	N/A	/shows/search-shows-by-multiple-panelists
Show Counts by Year	/shows/counts-by-year	N/A	/shows/show-counts-by-year
Show Descriptions	/shows/descriptions	N/A	/shows/show-descriptions
Show Notes	/shows/notes	N/A	/shows/show-notes
Shows with a Guest Host	/shows/guest-host	N/A	/shows/shows-with-guest-host
Shows with a Guest Scorekeeper	/shows/guest-scorekeeper	N/A	/shows/shows-with-guest-scorekeeper
Shows with Perfect Panelist Scores	/shows/perfect-panelist-scores	N/A	/shows/shows-with-perfect-panelist-scores

Component Changes

• Replace Pure CSS 3.0.0 with Bootstrap 5.3.3
  • Existing Pure CSS files will be preserved to prevent cached versions of the application from breaking
  • Files related to Pure CSS will be removed in a future release

---

Pull Request(s): #50

Full Changelog: v2.14.1...v3.0.0

v2.14.0

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: v2.13.0...v2.14.0