eternalgoldenbraid / daily Goto Github PK

Add a calendar for submitting date **
** Streamline description input.
see: https://blog.miguelgrinberg.com/post/the-flask-mega-tutorial-part-xiv-ajax
and https://flask.palletsprojects.com/en/1.1.x/patterns/jquery/

• Rendering events for a day/rating needs formatting. Currently all rendered in one go

Add a datepicker for inputting daily events. See for example https://stackoverflow.com/questions/26057710/datepickerwidget-with-flask-flask-admin-and-wtforms

"SAWarning: Dialect sqlite+pysqlite does not support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage."

Consider storing as integers instead and convert by a factor of 10^n

• Streamline error handling:
  - https://flask.palletsprojects.com/en/1.1.x/errorhandling/
  - https://blog.miguelgrinberg.com/post/the-flask-mega-tutorial-part-vii-error-handling

Problem arises when a tag entry like päärä is posted to server and a tag entry paara exists already.
Find confgs for language encodings.

• Add user_id columns to many-to-many tables rating_events and event_tags.
  Issues that arose after adding the column manually filling the column values with the single user's user_id and applying foreign key constraints after that:
  • New rows in rating couldn't be added with the current code in main.index. The code does not include the addition of user_id in the respective association table. See commit commit 5a35fb29d26667d3a9632cc20312c8f2dcd128bd

Enforce foreign key constraints
https://www.scrygroup.com/tutorial/2018-05-07/SQLite-foreign-keys/

Study SQLAlchemy events:
https://docs.sqlalchemy.org/en/13/core/event.html#sqlalchemy.event.listens_for
https://docs.sqlalchemy.org/en/13/core/event.html

Perhaps memory issues on site? No problem in development.

Root cause: #31

Should old entries be cleared?

The latter could be safely removed, shouldn't be referencing anything.