Library Management System (LMS)

Introduction

This repository is a Mini Python project that I studied in university. which has been assigned to The program requires CRUD (Create, Read, Update, and Delete) and GUI (Graphical User Interface).

• Programming Language : Python
• CRUD : MySQL
• GUI : PyQt6

About development

• OS : Windows
• Python : 3.11.6
  • PyQt6 : 6.4.3
  • pyqt6-tools : 6.4.2.3.3
  • mysql-connector-python : 8.3.0
  • PyYAML : 6.0.1

Config file

config.yaml

REMOTE:
    HOST: "127.0.0.1"
    PORT: 3306
    DATABASE: "LMS_DB"
USER:
    USERNAME: "lms-admin"
    PASSWORD: "pass"

Setup

Database

mysql < .\\db\\create_db.sql
mysql < .\\db\\create_user.sql

LMS

python -m venv venv
.\\venv\\Scripts\\activate
pip install -r requirements-lock.txt

Run

python -m LMS --config config.yaml

Run without config file

python -m LMS --host 127.0.0.1 --port 3306 --db LMS_DB --user lms-admin --passwd pass