ks-malik / enlightenment-bibliotheca

School project- library management system using python and mySQL

Enlightenment

Library Management System using Python and mySQL.

Objective

This project aims to simulate a small functioning library management system with python and mySQL.

It has functions to show all books, and add, issue or return them, upon logging in. It uses the graphical library tkinter for the GUI. Also has custom error and info popups, instead of using the built-in ones.

Requirements

• Your device should have python installed.
• It should have mySQL installed in the same directory as python.
• mySQL Connector for python should also be installed in the same drive or folder.
• Your device should have reasonably good free memory, required to create the databases and update it in the backend.

External assets used

• Fonts:

  • Montserrat
  • Lato
  • Poiret One

• python modules:

  • tkinter
  • mysql.connector
  • random
  • subprocess
  • webbrowser

Files in repo

• /achetz:

  • add_book.png
  • added_icon.png
  • display_book.png
  • email_icon.png
  • error_icon.png
  • exists_icon.png
  • home_book.png
  • issue_book.png
  • issued_icon.png
  • login_icon.png
  • match_icon.png
  • read_icon.png
  • returned_book.png
  • server_icon.png
  • stack_book.png
  • show_book.png

• /popups:

  • blank_error.py (64)
  • connect_error.py (62)
  • added_info.py (62)
  • exists_error.py (64)
  • issued_info.py (62)
  • issued_book.py (55)
  • mail_error.py (64)
  • match_error.py (64)
  • read_error.py (64)
  • returned_info.py (62)

• credentials.txt

• login.py (176)

• home.py (391)

• add_page.py (186)

• issue_page.py (300)

• return_book.py (282)

• show_page.py (223)

Total lines of code: 2181. (omg)

Credit Flaticon for the images used, and myself for the code.

Screenshots