HCR2 Setups Guide

Changed the tuning parts on setups and search page to icons, reversed the order of setups on the setups page so recently added ones are shown at the top, added a max time limit (32 bit integer limit). Tons of bug fixes: the search filters now handle more than one value, checking “World Records” doesnt wipe other filters, filters arent wiped when the page reloads after searching for a setup, rows per page defaults to 50, fixed the settings returning the error statement if rows per page is empty.

Small tweak to the backend validation for the settings inputs, database path is now relative instead of absolute, added a second SQLAlchemy error catcher on top of the python ones, removed the .venv so a new one is made when the repository is cloned. (now it should be runable)

Changed most of the lists to now use list comprehension, made the error handler handle every error code from 400 to 599. Updated the error page to not break the flow. The app is now fully runable (hopefully) with instructions on the readme.

Added a clear filters button to the insert form, added a shadow to the home page title. Changed the backend for time to not allow times > 32 bit int limit, changed the rows per page setting to be able to type custom amounts while still suggesting 5,10,20,30,40,50 with back end validation. Added a small section in information about insert field parameters. The setups table order is now reversed so new inserts are shown at the top. Settings errors are now shown on pages. Cleaned up some backend validation, the error messages now dont show for empty fields, created a requrements.txt and a readme on how to run the app.

Added a 404 error handler and images of tuning parts to replace the text.

Finished most of the home page, added a information section with a video, added 3 containers with quick navigation links, statistics, and fastest times on the home page, also added a background.

Made the button borders brighter to be more visible, changed the content backgrounds to a gradient. Changed the setups table to look identical to search. Added a delete button to the all setups table to easily delete specific setups.

Big Update:

Moved links to the right and added a settings menu, added a title, made all inputs and filters have hover effects.

Settings menu has a toggle for light/dark theme, and a way to select how many rows are shown in all tables (default is 10).

Changed all of the css colors to variables for the settings.

Search bar now fully supports searching for more than one word.

The player, vehicle, and track filters can all take more than one filter so the search page can now show results from multiple players, vehicles, and tracks.

Revamped the css again, the insert and delete forms are being moved to the setups table. No screenshot until the next devlog because its a mess right now.

Added a leaderboard for the most used part setups, Changed how the parts are submitted, they are now sorted so there cant be multiple setups of the same parts combination but different orders, duplicates will just reuse an already existing one.

Added a script that counts how many wrs every single player has and displays on the leaderboard page.

Made the player field autoselect a name if you type it with wrong capitalization, for example ndwg will autoswitch to Ndwg.

Completely finished styling the search page, also changed the filters to details instead of select so i can use checkboxes inside.

World records filter is fully finished

Finished the backend of the wr filter, the fastest time with x vehicle and y track is highlighted in yellow.

Finally found out about back_populates, players that arent currently in a setup now get deleted.

Styled the filters section, added hover styling for links, buttons, and table data.

Completely restarted the css, started styling the search bar filters and navigation bar.

Changed the filters to only show players,tracks, and vehicles that actually have a setup. Made the vehicle and track filter setups by time (lowest to highes) so the first time (fastest) is at the top.

Added warnings for invalid filters (changed the values using inspect)

Made the filter fields functional but are misssing back end validation

Added a stats/search page and moved the search bar there, also added a way to filter by players and vehicles (unfuctional).

Added a search bar to filter specific setups but still has some bugs (first table is all data, second table is data from the search)

Made the delete table functional and removes rows from setups but not the sub tables where the individual data is.

Added checks for duplicates, missing fields, and times automatically updates if a time that is faster than the previous for a specific setup is submitted. Automatically adds the data to the setups table and puts the individual field data into their respective tables as well.

Added some back end validation checks and added a list to check if the track field matches what can actually be inserted, also used a jinja loop to make options for each individual track in the list for the form.

Basic input form for the database if every field is filled and correct