This project implements a database system for managing concerts, bands, and venues using raw SQL queries in Python. It includes functionalities to create, retrieve, update, and delete records related to bands, venues, and concerts.
- Bands Table: Stores information about bands including name and hometown.
- Venues Table: Stores information about venues including title and city.
- Concerts Table: Manages concerts, establishing relationships between bands and venues with a date column.
- Object Relationship Methods: Includes methods to retrieve related data such as concerts for a venue, bands performing at a venue, etc.
- Aggregate and Relationship Methods: Implements methods like determining hometown shows, creating new concerts for bands, finding the most performing band, etc.
To clone and run this project locally, follow these steps:
-
Clone the repository:
git clone https://github.com/rushionsdomain/Concerts.git
-
Navigate into the directory:
cd Concerts -
Setup Database:
- Ensure you have SQLite installed or adjust database configuration as necessary.
- Run migrations and setup tables using appropriate SQL commands in your preferred DBMS.
-
Run the application:
- Execute the Python scripts containing your application logic, ensuring database connections are correctly established.
- Modify and extend the functionalities as per project requirements.
- Use Python's database libraries like
sqlite3orpsycopg2for executing SQL commands. - Implement additional prompts and features as specified in the assignment guidelines.
- Rushion Gachuri (https://github.com/rushionsdomain) - Main Developer
This project is licensed under the MIT License - see the LICENSE file for details.