Library Management System

Description

Library Management System is a comprehensive application designed to manage library operations efficiently. It provides functionalities for book management, user management, book rentals, returns, generating reports and generating QR codes for books. The application is built using Python and Tkinter for the GUI, with MySQL as the database backend.

Technologies Used

• Python
• Tkinter
• MySQL
• tkcalendar
• pymysql
• pathlib

Features

User Management

• Add Reader: Allows librarians to add new readers to the system.
• Search User: Provides functionality to search for users in the database.

Book Management

• Add Book: Enables librarians to add new books to the library.
• Search Book: Allows searching for books in the library.
• Book Overview: Displays detailed information about a selected book.

Rental Management

• Add Rental: Facilitates the process of renting out books to readers.
• Return Book: Manages the return of rented books.
• Email Notifications: Sends confirmation emails for book rentals and returns.

Reports and Backup

• Generate QR Code: Generates QR codes for books.
• Generate Report: Creates reports on various library metrics.
• Backup: Backs up the library database.

Prerequisites

Before running the application, ensure you have the following installed:

• Python >3.11
• MySQL Server
• Required Python packages (listed in requirements.txt)

Installation and Setup

1. Clone the Repository

   git clone https://github.com/WinterWollf/Library.git
   cd Library

2. Install Required Packages

   pip install -r requirements.txt

3. Set Up the Database

   • Create a MySQL database named library.
   • Execute the SQL commands in src/Assets/Starting Commands (English).sql to set up the necessary tables and initial data.

4. Configure Email Sending

   • Open the file src/mail.py.
   • Locate the send_email function.
   • Set the sender_email and sender_password variables with your email credentials.
   • Set the receiver_email and receiver_email_2 variables with the recipient email addresses.

   Example:

   sender_email = "your_email@gmail.com"
   sender_password = "your_password"
   
   receiver_email = "recipient1@example.com"
   receiver_email_2 = "recipient2@example.com"

5. Run the Application

   python src/main.py

Screenshots

Here are some screenshots showcasing the main features of the application:

Login Page

Dashboard

Add Book

Book Overview

Book Search

Mail

QR Code

Report

Backup

License

This project is licensed under the Creative Commons Attribution-NonCommercial 4.0 International (CC BY-NC 4.0) License - see the LICENSE file for details.

Contact

For any inquiries or feedback, feel free to reach out to the project author:

• GitHub: WinterWollf

---