search

natbat / pillarpointstewards

Website for pillarpointstewards.com
Apache License 2.0
7 stars 0 forks source link

Rework calculator code to use Python not SQL (to fix weird Laguna Beach bug) #298

Open simonw opened 4 weeks ago

simonw commented 4 weeks ago

Gave back one event that goes backwards in time from 7am to 6:30am:

CleanShot 2024-08-14 at 15 27 26@2x

This team wants to have 180 minute shifts, and bumping up to 180 minutes lead to all sorts of other weird things too.

simonw commented 4 weeks ago

It may be time to move on from doing this all in one big scary SQL query:

https://github.com/natbat/pillarpointstewards/blob/f7dd81f05838b39d1d49911d5067df5b4ece0be5/pillarpointstewards/shifts/views.py#L398-L480

A better approach may be to load in the low tides and sunrise/sunset for every day in the next 365 days and then use unit-tested Python code to apply the calculator settings.