Skip to content

Latest commit

 

History

History
65 lines (47 loc) · 1.08 KB

README.md

File metadata and controls

65 lines (47 loc) · 1.08 KB
Raw

Library Management System (LMS)

logo

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