ausstaterankings's Introduction

Australian State/Territory Speedcubing Rankings

This is a site to keep track of Australian state and territory WCA rankings. Contributors are greatly appreciated. Please contact me if you are familiar with Flask and/or the WCA API.

Setup

Clone this repository
Install Flask

pip install Flask

Navigate to project directory and install NPM dependencies

cd .../ausstaterankings
npm install

Create Postgres database and configure .env

touch .env

SECRET_KEY=ERWArfC+T3A32qFYyilbmw==

# OAuth
CLIENT_ID=[Contact to request access]
CLIENT_SECRET=[Contact to request access]

DATABASE_URI=postgresql://[url]

Start Tailwind

npm run tailwind

Configure and run the app

flask --app app run --debug

ausstaterankings's People

Contributors

Stargazers

Watchers

ausstaterankings's Issues

Delete all existing results before scheduled results refresh

Existing results should be removed from the database before results are updated.

Average rankings query results in 500 response

Querying averages where there are null results results in the following error when the template is rendered:

TypeError: unsupported operand type(s) for *: 'NoneType' and 'float'

Null averages should be excluded from queries to prevent this.

Minute display not working with zeros

when a time is shown with format XX:0X:XX, it is displayed as XX:X:XX, when it should be displayed as XX:0X:XX.

Scheduling result updates

Currently scheduled result updates do not execute as expected every Wednesday. The updates should be scheduled as cron jobs, but the app must be run from the app.py file directly, which will not work in production.

Recommend Projects