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
京东自动入会获取京豆

京东入会领京豆 要求 有一定的电脑知识 or 有耐心爱折腾 需要Chrome(推荐)、Edge(Chromium)、Firefox 操作系统需是Mac(本人没在m1上测试)、Linux(在deepin上测试过)、Windows 安装方法 脚本采用Selenium遍历京东入会有礼界面,由于遍历了200

Vanke Anton 500 Dec 22, 2022
dbt adapter for Firebolt

dbt-firebolt dbt adapter for Firebolt dbt-firebolt supports dbt 0.21 and newer Installation First, download the JDBC driver and place it wherever you'

23 Dec 14, 2022
Projects using the Tkinter module in Python!

Tkinter projects This repository includes some Tkinter projects made by me. All of these are simple to understand. I create apps with good functionali

Amey 0 Sep 24, 2021
Painel simples com consulta de cep,CNPJ,placa e ip

Painel mpm Um painel simples com consultas de IP, CNPJ, CEP e PLACA Início 🌐 apt update && apt upgrade -y pkg i python git pip install requests Insta

8 Feb 27, 2022
A simplified python interface to COPASI.

BasiCO This project hosts a simplified python interface to COPASI. While all functionality from COPASI is exposed via automatically generated SWIG wra

COPASI 8 Dec 21, 2022
In this repo i inherit the pos module and added QR code to pos receipt

odoo-pos-inherit In this repo i inherit the pos module and added QR code to pos receipt 1- Create new Odoo Module using command line $ python odoo-bin

5 Apr 09, 2022
Team Hash Brown Science4Cast Submission

Team Hash Brown Science4Cast Submission This code reproduces Team Hash Brown's (@princengoc, @Xieyangxinyu) best submission (ee5a) for the competition

3 Feb 02, 2022
Beancount Importers for DKB (Deutsche Kredit Bank) CSV Exports

Beancount DKB Importer beancount-dkb provides an Importer for converting CSV exports of DKB (Deutsche Kreditbank) account summaries to the Beancount f

Siddhant Goel 24 Aug 06, 2022
🦋 hundun is a python library for the exploration of chaos.

hundun hundun is a python library for the exploration of chaos. Please note that this library is in beta phase. Example Import the package's equation

kosh 7 Nov 07, 2022
A series of basic programs written in Python

Primeros programas en Python Una serie de programas básicos escritos en Python

Madirex 1 Feb 15, 2022
Integration between the awesome window manager and the firefox web browser.

Integration between the awesome window manager and the firefox web browser.

contribuewwt 3 Feb 02, 2022
A Bot that adds YouTube views to your video of choice

YoutubeViews Free Youtube viewer bot A Bot that adds YouTube views to your video of choice Installation git clone https://github.com/davdtheemonk/Yout

ProbablyX 5 Dec 06, 2022
CuraMultiplyByGrid - Cura Плагин для размножения детали сеткой на весь стол автоматически без поворота

CuraMultiplyByGrid Cura Плагин для размножения детали сеткой на весь стол автоматически без поворота. Размножение в куре настолько ужасно реализовано,

3 Dec 02, 2022
Simple Python tool to check if there is an Office 365 instance linked to a domain.

o365chk.py Simple Python script to check if there is an Office365 instance linked to a particular domain.

Steven Harris 37 Jan 02, 2023
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
Retrying is an Apache 2.0 licensed general-purpose retrying library, written in Python, to simplify the task of adding retry behavior to just about anything.

Retrying Retrying is an Apache 2.0 licensed general-purpose retrying library, written in Python, to simplify the task of adding retry behavior to just

Ray Holder 1.9k Dec 29, 2022
For Tok-k passages that have passed through the Bi-Encoder Retrival, ReRank is performed using CrossEncoder.

Cross-Encoder-with-Bi-Encoder For Tok-k passages that have passed through the Bi-Encoder Retrival, ReRank is performed using CrossEncoder. Data Data u

7 Feb 09, 2022
Different steganography methods with examples and my own small image database

literally-the-most-useless-project [Different steganography methods with examples and my own small image database] This project currently contains thr

Kamyishka 1 Dec 09, 2022
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
addons to the turtle package that help you drew stuff more quickly

TurtlePlus addons to the turtle package that help you drew stuff more quickly --------------

1 Nov 18, 2021