Library management using python & MySQL

Overview

Library management using python & MySQL


Dev/Editor: Pavan Ananth Sharma & MK Akash

Introduction:

This is an intermediate project which is a user-friendly library management system that allows you to:

  • Add book with details
  • Delete books
  • View listed books
  • Issue books to students/anyone
  • Return books

Output:


Dependencies:

  • tkinter
  • pillow
  • pymysql
  • MySQL should be instaled

Code to download dependencies:

pip install tk
pip install pillow
pip install pymysql

Note: we need to install tk which is tkinter and pillow which is PIL, so dont worry and install these dependencies using the above code.


IMPORTANT STEP

  • Make sure you have installed MySQL for your OS, if not follow this video : https://www.youtube.com/watch?v=N3B3OonC2AU&t=343s Not sponcered
  • Follow the above video carefully and we recommend to use the password as root
  • After you have successfully installed and tested now you will need to run a few commands before running the main.py
  • Open MySQL 8.0(or any version) Command Line Client using windows key and searching it if you use windows
  • Enter the password in this case we use root
  • then we run show databases; to show the existing databases
  • We add our data based which we will call db code for it : create database db;
  • Then we run : create table books(bid varchar(20) primary key, title varchar(30), author varchar(30), status varchar(30));
  • Last but not the least we enter: create table books_issued(bid varchar(20) primary key, issuedto varchar(30));
  • So basically we created 2 tables inside a database named db with multiple access elements
  • Now to enter into the database you have created use teh code: use db;
  • Now to ckeck the tables you have created you can say ener : show tablesl;
  • To see the elements inside the tables (for example books) code: select * from books;
  • Similarly to use the elements insie the table books_issued run the code: select * from books_issued;

Usecase / run:

if you want to run the code you will need to run : main.py
  • If you have followed all the steps correctly as soon as you run main.py the UI will popup then as as soon as you add a book by filling the information(case sensitive), you can now get to the CLI of MYSql and run: select * from books; and this will display if you have added any book into the database.
  • Similarly after you have deleted any book you can run the same code to verify if it has been deleted from the database system.
  • When you issue a book then if you want to check who have you given it to enter the code: select * fom books_issued; to find the name and book ID (bid).
  • After you have created a book and then issued it to anyone you can see the status of the book change by again going into the books_issued table for that we use the code: select * from books; if you have followed you shouold see the change in the status of the book(if Avail before now it would have updated to issued).
  • If you have got all of them then congratulations you have done an amazing job

Wallet: 0x592eF244F8924be9F3F8803f8d639392f465Ac51

Instagram: pavan_ananth


Owner
Pavan Ananth Sharma
Ethereum 2.0
Pavan Ananth Sharma
Watcher for systemdrun user scopes

Systemctl Memory Watcher Animated watcher for systemdrun user scopes. Usage Launch some process in your GNU-Linux or compatible OS with systemd-run co

Antonio Vanegas 2 Jan 20, 2022
A simple program which gets a file(CSV/Excel) with tasks and creates different variants

TestMakerProject A simple program which gets a file(CSV/Excel) with tasks and creates different variants The main program is QTengine.py You only have

George 3 Nov 18, 2021
Webcash is an experimental e-cash (electronic cash)

Webcash Webcash is an experimental new electronic cash ("e-cash") that enables decentralized and instant payments to anyone, anywhere in the world. Us

Mark Friedenbach 0 Feb 26, 2022
reproduces experiments from

Installation To enable importing of modules, from the parent directory execute: pip install -e . To install requirements: python -m pip install requir

Meta Research 15 Aug 11, 2022
Open source book about making Python packages.

Python packages Tomas Beuzen & Tiffany Timbers Python packages are a core element of the Python programming language and are how you create organized,

Python Packages 169 Jan 06, 2023
LibreMind is a free meditation app made in under 24 hours. It has various meditation, breathwork, and visualization exercises.

libreMind Meditation exercises What is it? LibreMind is a free meditation app made in under 24 hours. It has various meditation, breathwork, and visua

1 May 24, 2022
Never get kicked for inactivity ever again!

FFXIV AFK Bot Tired of getting kicked from games due to inactivity? This Bot will make random movements in random intervals to prevent you from gettin

5 Jan 12, 2022
BDD base project: Python + Behave

BDD base project: Python + Behave Basic example of using Python with Behave (BDD). This Gherkin example includes: Basic Scenario Scenario Outline Tagg

eccanto 1 Dec 08, 2021
Python meta class and abstract method library with restrictions.

abcmeta Python meta class and abstract method library with restrictions. This library provides a restricted way to validate abstract methods. The Pyth

Morteza NourelahiAlamdari 8 Dec 14, 2022
📙 Super lightweight function registries for your library

catalogue: Super lightweight function registries for your library catalogue is a tiny, zero-dependencies library that makes it easy to add function (o

Explosion 139 Jan 02, 2023
Tensorboard plugin 3d with python

tensorboard-plugin-3d Overview In this example, we render a run selector dropdown component. When the user selects a run, it shows a preview of all sc

KitwareMedical 26 Nov 14, 2022
Change ACLs for QNAP LXD unprivileged container.

qnaplxdunpriv If Advanced Folder Permissions is enabled in QNAP NAS, unprivileged LXD containers won't start. qnaplxdunpriv changes ACLs of some Conta

1 Jan 10, 2022
ThinkPHP全日志扫描工具,命令行版和BurpSuite插件版

ThinkPHP3和5日志扫描工具,提供命令行版和BurpSuite插件版,尽可能全的发掘网站日志信息 命令行版 安装 git clone https://github.com/r3change/TPLogScan.git cd TPLogScan/ pip install -r requireme

119 Dec 27, 2022
Solve various integral equations using numerical methods in Python

Solve Volterra and Fredholm integral equations This Python package estimates Volterra and Fredholm integral equations using known techniques. Installa

Matthew Wildrick Thomas 18 Nov 28, 2022
Sigma coding youtube - This is a collection of all the code that can be found on my YouTube channel Sigma Coding.

Sigma Coding Tutorials & Resources YouTube • Facebook Support Sigma Coding Patreon • GitHub Sponsor • Shop Amazon Table of Contents Overview Topics Re

Alex Reed 927 Jan 08, 2023
tox-gh is a tox plugin which helps running tox on GitHub Actions with multiple different Python versions on multiple workers in parallel

tox-gh is a tox plugin which helps running tox on GitHub Actions with multiple different Python versions on multiple workers in parallel. This project is inspired by tox-travis.

tox development team 19 Dec 26, 2022
Demo of patching a python context manager

patch-demo-20211203 demo of patching a python context manager poetry install poetry run python -m my_great_app to run the code poetry run pytest to te

Brad Smith 1 Feb 09, 2022
KeyBrowser: A program launches a browser and a keylogger at the same time, is used to retrieve a person's personal information

KeyBrowser: A program launches a browser and a keylogger at the same time, is used to retrieve a person's personal information

3 Oct 16, 2022
Cairo-integer-types - A library for bitwise integer types (e.g. int64 or uint32) in Cairo, with a test suite

The Cairo bitwise integer library (cairo-bitwise-int v0.1.1) The Cairo smart tes

27 Sep 23, 2022
ERPNext Easy Letterhead

ERPNext Easy Letterhead Intro Quality letterheads are a problem for non-technical users. So we've built (really hacked together) a slightly easier sol

Bantoo 3 Jan 02, 2023