pitmairen / training_application

Group project in the course data modelling and database applications at Aalesund university college.

Training application

Group project in the course "Data modelling and database applications" at Aalesund university college.

Project description
https://docs.google.com/document/d/19lPlr0IW1F7k5TdGKeuXsXS5BDLac1ciilVdYkyJyg0/edit?pli=1#heading=h.psbr84uoq6t9

Project requirements specifications
https://docs.google.com/document/d/1IcTMSxlXSPyHaJWm_bkbE2i9R0rCTJTfv7Ag0ZsVUUI/edit?ts=5613e9a8#heading=h.5lvqcllwfwq6

Application overview
https://www.draw.io/?state={%22ids%22:[%220B9_cvlT9lotxRlEzbDktNWhMQ3M%22],%22action%22:%22open%22,%22userId%22:%22106937719102961622838%22}#G0B9_cvlT9lotxRlEzbDktNWhMQ3M

System documentation
https://docs.google.com/document/d/1FbEeyrEbC_D11LhIArFMzAKyRDkKjHBoTvVvmjKDuMc/edit?ts=56419d01#heading=h.ywquehfw0vik

training_application's Issues

The Workout page does not check that the workout is in the user's training program

Currently the workout page does not check that the workout is part of the current logged in user's training program. This means that a logged in user can update any customer's workouts.

The current code in master does not implement the data source interface

The data source implementation is currently missing a method.

Crash on bad input in form data

Currently the AccountInfo page will crash on bad form input. Eg. when non integer data is sent where integers are expected it cases a crash. This should be handled gracefully and an error message should be displayed to the user indicating what was wrong with the data.

Validation error messages can be added by using the addValidationError method defined on the FormRoute class. They can be displayed in the template by including the "partials/validation-errors" template. An example can be seen in the "admin/edit-program" template.

Also to get access to the form data in the java code the "name" attribute must be defined on the input element in the html form.

Incorrect password check in AccountInfo page

The old password check in the AccountInfo page is incorrect. The correct way to check the password is by using the Security.checkPassword method.

The workout page silently ignores bad input

Currently the workout page silently ignores bad input values. On bad input the code should abort and display an error message to the user indicating what was wrong with the input data. In the case of an validation error the form should be repopulated with the form data that was submitted in the request so that the user don't have to re-input the data that was valid.

Validation error messages can be added by using the addValidationError method defined on the FormRoute class. They can be displayed in the template by including the "partials/validation-errors" template. An example can be seen in the "admin/edit-program" template.

Also currently the code will execute unnecessary db queries when bad input is encountered. The input data should be validated before any db queries are executed.