AV Media Booking System

Basic tab system for sorting the equipment cards based on category :)

Created a CSV parser with pandas (first time using!) which I can incorperate into the admin interface later on. Sorted out a lot of logicial tough questions such as how do you iterate through a 2D array to create records?

Changed html + js so that the studio booking page allows for div cards w/ photos for each studio space instead of a boring form like structure

(css not fixed yet!)

Added comments to all my code + implemented Flask-Login. POV u came back to coding after like a month and realized you don’t understand what you wrote…comments for future me now. As for Flask-login, I implemented it cuz it makes sense to use it instead of manualy building login functions

(in screenshot - goodbye manual login functions woop)

Finally have a functioning studio booking system with an HTML form that submits data to my mySQL db (form has frontend + backend validation too)!!

Also created a student_home.html page, linked it to successful booking page.

• asked AI for tempoary functional css styling so that my page is easier to read (will change css to something less AI later on!)

Stuff I’ve learned for the first time to use:

• Flatpickr date picker
• understanding how blueprints & routes work
• HTML templates and Jinja2 syntax
• Querying from database with sqlalchemy select

Added Google OAuth login!

Created database tables with SQLAlchemy for the first time