"SQLodge " - Accommodation Booking Platform

Overview

SQLodge is a functional accommodation booking platform developed as part of a group project for IT2002.

The platform enables users to create accounts, browse and book accommodations with advanced filters and sorting, manage their own listings, and configure user profiles and settings. Additionally, the platform includes an administration interface for managing user data and listings.

More information, including the ER Diagram for the database, is found in IT2002_Report.pdf.

Key Features

1. Account creation and login
2. Accommodation booking with customizable filters and sorting options
3. Listings management for users to add, edit, or remove accommodations
4. User profile management and settings configuration
5. Administration interface for data oversight and management

Technologies Used

• HTML for the front-end
• PostgreSQL for the database
• Flask as the back-end framework

Dataset

The initial dataset was generated from the San Diego Airbnb Listings found on Kaggle: https://www.kaggle.com/datasets/thedevastator/san-diego-airbnb-listings-august-2019. The dataset consisted of over 500 rows regarding the properties and owners data.

Additional data was generated using Mockaroo to simulate guest profiles and bookings.

Running the Application

To run the model, follow these steps:

Install Dependencies:

pip install -r requirements.txt

Run the Application:

python main.py

Access the Platform:

Visit http://localhost:5016 in your web browser.

Usage

Log in with the following email and password to test out functionalities:

Email: alevett65@wufoo.com Password: NOOlabAC

Additional Notes

If you encounter any issues or have suggestions, please refer to Issues section or submit a pull request.