Betsy Marketplace is aonline platform for selling and purchasing a variety of products. The platform is designed as a web marketplace where users can list and sell homemade goods, making it an ideal testbed for database modeling, SQL joins, and the implementation of functional programming using Python and Peewee ORM.
- Python 3.6 or higher
- Peewee ORM
- SQLite database
- Clone the repository.
- Ensure Python 3.6+ is installed.
- Install Peewee ORM:
pip install peewee. - Run the
main.pyscript to start the application.
Betsy Marketplace employs an SQLite database, with the following models managed through the Peewee ORM:
- Represents users with attributes like name, address, and billing information.
- Users can own multiple products and make purchases.
- Includes details such as product name, description, price, and stock quantity.
- Products are owned by users and can be tagged with various descriptors.
- Provides a system for tagging products, ensuring unique identification.
- Tracks purchases made on the marketplace, linking buyers with products and quantities.
The main.py file contains several key functionalities:
- Registering and Managing Users: Create and handle user accounts, including their personal and billing information.
- Adding and Removing Products: Users can list new products and remove existing ones.
- Updating Product Details: Modify product information like price and stock quantity.
- Purchase Processing: Record and manage the buying and selling transactions between users.
- Product Tagging: Assign tags to products for better categorization and searchability.
- Product Search: Implement a case-insensitive search for products based on names.
- View Products by User: Display all products listed by a specific user.
- Products by Tag: Retrieve products associated with a given tag.
- The
populate_test_database.pyscript is used to fill the database with example data, ensuring the smooth functionality of queries and operations.
- Advanced Search: Enhance search functionality to include product descriptions and handle spelling variations.
- Performance Optimization: Implement product indexing for faster query execution.
- Complex SQL Joins: Further develop the querying system to handle more intricate database relationships, particularly in transactions.
- The project has undergone rigorous debugging and iterative development to ensure robust performance and user-friendly interfaces.
Betsy Marketplace serves as a dynamic platform demonstrating advanced database operations, ORM usage, and Python programming capabilities. The project is an ongoing endeavor with potential for further enhancements and optimizations.
Please refer to the provided license file for detailed licensing information.
This README.md is designed to offer a clear and concise overview of the Betsy Marketplace project, highlighting its features, structure, and future development directions. Adjust and expand as necessary to align with your project's specifics.