Allow Supervisor Role Title

A very minor release to allow a "Supervisor" role through the pipeline as discovered by the King County instance: https://github.com/CouncilDataProject/king-county/runs/5874063516?check_suite_focus=true

What's Changed

• admin/fix-build by @JacksonMaxfield in #178
• feature/add-supervisor-role-title by @JacksonMaxfield in #180

Full Changelog: v3.0.11...v3.0.12

More Indexes for People Page and URL Trial Functions

This release contains what we hope is the final index needed for the coming people page and a first contribution from Liam Murphy to move the project along on trying multiple URLs for metadata (https first and http second in hopes we can find a URL).

What's Changed

• feature/https-or-http-func by @liamphmurphy in #176
• feature/add-role-index-trio-for-people-page by @JacksonMaxfield in #177

New Contributors

• @liamphmurphy made their first contribution in #176

Full Changelog: v3.0.10...v3.0.11

Indexes for Person Page Sponsorship List and People Page Card Render

Two new indexes:

1. Allow matter sponsor data additions on the individual person page
2. Allow for selecting down to the most recent seats / roles on the people navigation page -> person cards

What's Changed

• feature/add-person_ref-and-matter_ref-index by @tohuynh in #174
• admin/roll-seat-ref-and-end-datetime-index by @JacksonMaxfield in #175

Full Changelog: v3.0.9...v3.0.10

Setup for Voting Record Pagination

To setup our backend to enable individual person voting records pagination, we needed to add a few more indexes. This adds all the variants we want and more importantly need!

Frontend release to actually use pagination coming soon.

What's Changed

• feature/add-matter-ref-person-ref-vote-index by @JacksonMaxfield in #173

Full Changelog: v3.0.8...v3.0.9

YouTube Download and Processing Import Bugfix

Fix from v3.0.7, move the yt-dlp import to within the youtube_copy function to avoid dependency import failure during infrastructure management.

What's Changed

• bugfix/move-yt-dlp-import-to-within-youtube-copy-func by @JacksonMaxfield in #171

Full Changelog: v3.0.7...v3.0.8

Allow Dowloading Videos from YouTube

A quick patch to add functionality to download and process videos from YouTube URLs.

What's Changed

• feature/downloading-youtube-videos by @Shak2000 in #169

Full Changelog: v3.0.6...v3.0.7

Contributors

@Shak2000
@JacksonMaxfield
@isaacna

Indexing Ignores Pictograms

This patch fixes the indexing pipeline that has been failing for Seattle for a while: https://github.com/CouncilDataProject/seattle-staging/actions?query=workflow%3A%22Event+Index%22

The bug was caused by a pictogram / emoji in the transcript, as such, during indexing, we strip all pictogram like characters:
bugfix/clean-pictograms-from-transcripts-before-indexing by @JacksonMaxfield in #165

Database Model Validation Fix

This fixes a bug introduced in the v3.0.4.

See: bugfix/revert-validator-fixes by @JacksonMaxfield in #164

Programmatic UX Improvements

A lot of these changes simply make it easier to use this library (and the data) in Python (and other systems). However notably, this PR is shipping with a new database change that isn't required but is recommended. See the "running-extra-scripts.md" file in the admin-docs/ directory after updating your deployment repository with the latest changes from cookiecutter.

What's Changed

• feature/truncate-sentences-in-transcript-str by @isaacna in #153
• bug/catch-timeout-in-event-gather by @isaacna in #157
• feature/store-session-content-hash-in-session-db-model by @isaacna in #158
• feature/script-for-retroactive-session-content-hashing by @isaacna in #159
• feature/role-title-constants by @dphoria in #155
• feature/remove-is-required-from-constant-validator by @isaacna in #163

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

Google Speech-to-Text Improvements

This patch release is actually a minor improvement to Google Speech-to-Text. While we don't have exact improvement measures, it is apparent and details can be seen in #150.

We will be working on an actual word-error-rate calculation soon to measure these improvements in the future.