yatu360/ticketmanagement-python ? reverse-engineered prompt

Build me a simple event ticket management web app in Python with Flask and Jinja templates.

It should let me create tickets from a browser, show them in a clean dashboard, and let me redeem a ticket by its id. I want a couple of easy web routes I can visit directly, one for adding a ticket with a name and one for redeeming a ticket, and the page should update so I can see what changed right away. Use a small database so the tickets persist between refreshes, and keep the app easy to run from a single main file.

Please make the interface straightforward and lightweight, with basic styling and clear messages for success or errors. If you need anything current from Flask or SQLAlchemy docs, look it up online. Also include whatever setup is needed so I can open the app locally and test the ticket flow without much fuss.