Upgrade database to Sqlalchemy to v2

Added

• database cleanup command that removes unused songs

Changed

• by default hides clips that don't have an existing MP3 file
• upgraded sqlalchemy to v2.0.35
• upgraded mypy to v1.11
• upgraded pylint to v3.3.1
• migrated .eslintrc to new flat config format

Migrated from Create React App to Vite

Changed

• replaced Create React App with Vite
• upgraded React to v18
• upgraded Redux to v8

Calendar showing when theme was last used

Added

• table showing when each theme was last used
• calendar showing when each theme was last used
• drop-down menus in menu nav panel

Changed

• replaced date-time picker on edit game page
• split "Previous Games" into 4 pages

New ticket sort options

Added

• option to sort tickets by order in which they win
• page numbers on bottom of each page of ticket PDF file

Removed

• page number from each ticket

Adds unit tests for client JavaScript application

Added

• unit tests for client JavaScript application
• github action to build client
• inject git revision information into index.html page

Changed

• allow privacy policy to be viewed when not logged in
• default branch name to "main"
• relaxed username rules to allow dot and hyphens
• use CHANGELOG.md file to set app version rather than git tag

First server release

This release provides both an app that can be run on your local computer, which allows Bingo games and music quizzes to be created. It also allows clips to be created from sections of songs, and a server that provides an HTML JavaScript application that can be run from any web browser. This web app allows multiple people to play Music Bingo together on-line.

It supports Python versions v3.6 to v3.11.

Changes from the previous release:

• multi-user HTML application
• database to store songs, tracks, games, tickets and users
• new Schema for the gameTracks.json file
• database management commands to import and export from database
• CloudFormation scripts to deploy server to AWS
• support for various page sizes
• support for between 2 and 6 cards per page
• new colour schemes:
  • Christmas
  • Cyan
  • Pink
  • Magenta

Initial release 0.1.0

First release based upon a fork of the original Music Bingo source code.

New features added in this release:

• upgrade code to use Python v3
• add audio playback to the GUI
• add a title to each Bingo game
• an INI file to store default options
• support for ffmpeg for encoding and playing MP3 files
• using multiple threads to search directories
• allowing changing number of rows and columns in a Bingo ticket
• mypy static type checking
• pylint style checking
• add a pride colour scheme scheme