This is a full stack website project. We created a library network that allows users to rent or reserve books out of a database of books. It has login and signup capabilities. You can also rate and comment on the titles available for you.
Most of the data was generated randomly and the books where scrapped from a website.
-Python -Jupyter -Flask -MySQL -XAMPP -CSS -Javascript
Install MySQL Server and XAMPP
Use the package manager pip to install all packages.
pip3 install flask,flask_login,flask_mysqldb,mysql,mysql.connector,werkzeug Clone our repository.
git clone https://github.com/Se7enBit/DatabasesProject.gitOpen a terminal and start a MySQL Server instance. Source the run.sql file on the running instance.
source SQL_code/new_and_improved/run.sql;This initializes the database with all insertions.
Now on the root directory of the file try you can run main.py
python3 main.pyEach user of the application has the ability to login or sign up for the application.
As a student or teacher you can rent or reserve books that are shown in the catalog.
Once you've picked a book that you like, you're redirected to the book's home page where you can rent or reserve it, view more information on it, comment and rate it.
Finally you can view your rentals and reservations from your main page.
As a School Administrator you can publish comments that the users post, allow for rentals or reservations and also activate or deactive users. You will also be notified if a user hasn't returned a book on time.
The school admin can manage all users and their statuses.
He also has a complete overview of their rentals and reservations
The general admin can add school admins and schools to the Database
He can create a backup of the database and also has some special tools.
