Flask Hotel is a paperless room booking system built using Flask. It demonstrates how small accommodation providers can manage customer bookings without relying on paper-based systems. This project was created for the Level 5 Diploma in Web Application Development, under Project 3: Back-End Development.
- Secure user registration and login with hashed passwords (bcrypt)
- Booking system that prevents overlapping bookings
- View, edit, and delete personal bookings
- Date validation for check-in and check-out
- Flash messaging for user feedback
- Auth-protected routes
- GitHub-integrated webhook for automatic deployment
- Backend Framework: Flask
- Database: SQLite
- ORM: SQLAlchemy
- Form Handling: WTForms
- Templating Engine: Jinja2
- Styling: Bootstrap 5
- Deployment: PythonAnywhere
- Version Control: Git and GitHub
The application uses a simple relational structure with the following tables:
User...registered users who can book roomsRoom...predefined rooms available for bookingBooking...links users to rooms with selected dates
A visual diagram of the schema is shown below:
To run the app locally:
-
Clone the repository:
git clone https://github.com/dailafing/FlaskHotel.git cd FlaskHotel -
Create a virtual environment:
python3 -m venv venv source venv/bin/activate # on Linux/macOS # OR venv\Scripts\activate # on Windows
-
Install the required packages:
pip install -r requirements.txt
-
Start the development server:
flask run
-
Open your browser and visit:
http://127.0.0.1:5000/
The site is live at:
https://dailafing.pythonanywhere.com/
Deployment is handled using a GitHub webhook. On push, the server pulls the latest code and touches the WSGI file to reload the app. Secrets (like SECRET_KEY) are stored in an environment file on the server.
Manual test cases, including screenshots, are available in:
→ TestPlan
Each test documents the expected behaviour for key user actions and system responses.
- Semantic HTML used throughout (e.g.
<main>,<nav>,<section>) - Form inputs are paired with matching
<label for="">elements - Flash messages wrapped in
aria-live="polite"container - Using role="note" where relevant for the given context
- Using aria-describedby to help screen readers
- Colour contrast checked for compliance
- Custom
404.htmlpage is rendered when a page is not found - Custom
500.htmlis shown for server errors - Both templates provide consistent branding and user guidance
- Flask app includes error handler functions in
__init__.py
- Passwords are hashed using bcrypt before storing
- CSRF protection is enabled on all forms
- Sensitive keys (e.g.
SECRET_KEY) are not committed to repo - Production server runs with
DEBUG = False - Session cookies are configured with
SecureandHttpOnlyflags
- PEP8 Compliance: Python code follows PEP8 style guidelines with consistent naming, indentation, and line length
- HTML Validation: All HTML templates validated using W3C Markup Validator, ensuring clean semantic structure
- CSS Validation: Custom CSS validated using W3C CSS Validator, ensuring proper syntax and cross-browser compatibility
- Code Comments: Complex logic documented with explanatory comments for maintainability
The application demonstrates proficiency in Python through:
- Data Types: Strings, integers, floats, booleans, dates, and datetime objects
- Collections: Lists (room queries), dictionaries (form data), tuples, and sets
- Control Structures: if/elif/else conditions, for loops, while loops, and nested logic
- Functions: Modular functions with parameters, return values, and compound statements
- Object-Oriented Programming: Classes, inheritance, and method definitions
- Error Handling: Try/except blocks and proper exception management
- Git used for version control
- Clear commit history maintained on GitHub
.gitignoreexcludes sensitive files (DB, venv, cache)