🔗PythonMysql_Connection

MysqlPythonConnection

About The Project

MySQL Connector Python is used to access MySQL databases from Python using this repo.
Student databases will be utilized in this project.

Features

main.py program will be able to

1. Insert Book
2. Insert Student
3. Insert Borrowing

Step 1 : Run studentDb.sql file in command prompt.
studentDb.sql

• How to Run MySQL

  mysql -u root -p

• Give the path of .sql file as:

  mysql> source <sql Path.sql>

Step 2: Run main.py file
main.py

from secrets import choice
from tkinter import W
import mysql.connector as c # import the mysql connector
con = c.connect(host="localhost", user="root", password="root", database="studentdatabase") # connect to the database

print('*'*50)
print("Welcome to the Student Database")
print('*'*50)

cursor = con.cursor() # create a cursor
while True:
    choice= int(input("1-> Insert Book\n2-> Insert Student\n3-> insert Borrowing\n4-> Exit\n Your Choice: "))
    if choice == 1:
        book_name = input("Enter the book name: ")
        author = input("Enter the author name: ")
        isbn = input("Enter the isbn number: ")
        query = "INSERT INTO books (book_name, author_name, isbn_number) VALUES (%s, %s, %s)"
        values = (book_name, author, isbn)
        cursor = con.cursor()
        cursor.execute(query, values)
        con.commit()
        print("Book inserted successfully")
    elif choice == 2:
        name = input("Enter the name: ")
        roll = input("Enter the roll number: ")
        query = "INSERT INTO students (student_name, roll_number) VALUES (%s, %s)"
        values = (name, roll)
        cursor = con.cursor()
        cursor.execute(query, values)
        con.commit()
        print("Student inserted successfully")
    elif choice == 3:
        roll = input("Enter the roll number: ")
        book_name = input("Enter the book name: ")
        query = "INSERT INTO borrowings (roll_number, book_name) VALUES (%s, %s)"
        values = (roll, book_name)
        cursor = con.cursor()
        cursor.execute(query, values)
        con.commit()
        print("Borrowing inserted successfully")
    elif choice == 4:
        break
    else:
        print("Invalid choice") 
cursor.close()
con.close()
print("Connection closed")