PRODUCT MANAGEMENT SYSTEM USING PYTHON

 

 PRODUCT MANAGEMENT SYSTEM USING PYTHON

 

 File Name :"product_crud_opertion.py"

import mysql.connector

myconn = mysql.connector.connect(
    host = "localhost",
    user = "root",
    password = "5044",
    database = "prod_info"
    )
cur = myconn.cursor()

def add_prod():

    pid = input("\n\t\tEnter Prodcut ID : ")
    pnm = input("\t\tEnter Product Name : ")
    pprice = input("\t\tEnter Product Price :")
    pstk = input("\t\tEnter Product Stock : ")
    
    data = (pid, pnm, pprice, pstk)
    sql = "INSERT INTO prod_tbl values(%s, %s, %s, %s)"  

    cur.execute(sql,data)

    myconn.commit()

def display_prod():
    cur.execute("select * from prod_tbl")
    rec = cur.fetchall()

    print("\n\t\tPID\tPNAME\tPRICE\tPSTOCK")
    for row in rec:
        print("\t\t",row[0],"\t",row[1],"\t",row[2],"\t",row[3])

def display_specific_prod():
    pid=input("Enter Product ID you want to Display=")
    data=(pid)
    cur.execute("select * from prod_tbl where pid ="+data)
    rec = cur.fetchall()

    print("\n\t\tPID\tPNAME\tPRICE\tPSTOCK")
    for row in rec:
        print("\t\t",row[0],"\t",row[1],"\t",row[2],"\t",row[3])    

def update_prod():
    
    pid = input("\n\t\tEnter Prodcut ID : ")
    pnm = input("\t\tEnter Product Name : ")
    pprice = input("\t\tEnter Product Price :")
    pstk = input("\t\tEnter Product Stock : ")

    data = (pid, pnm, pprice, pstk)
    sql = "UPDATE prod_tbl SET pname = %s, pprice = %s, pstock = %s WHERE pid = %s"

    cur.execute(sql,data)
    myconn.commit()

def delete_prod():
    
    pid = input("\n\t\tEnter Prodcut ID you want to delete : ")
    data = (pid)
    sql = "DELETE FROM prod_tbl WHERE pid ="
    cur.execute(sql+ data)
    myconn.commit()

 

 

File Name : "prod_ui"

import prod_crud_operations as crud
import os

while True:
    os.system("cls")

    print("\t\t 0.Exit")
    print("\t\t 1.Add Product : ")
    print("\t\t 2.Display Product : ")
    print("\t\t 3.Display Product : ")
    print("\t\t 4.Update Product : ")
    print("\t\t 5.Delete Product : ")
    
    ch = input("\n\tEnter Your Choice : ")

    if ch == '0':
        break
    
    elif ch == '1':
        crud.add_prod()
        input()
        
    elif ch == '2':
        crud.display_prod()
        input()

    elif ch == '3':
        crud.display_specific_prod()
        input()

    elif ch == '4':
        crud.update_prod()
        input()

    elif ch == '5':
        crud.delete_prod()
        input()
        
    else:
        print("\t\t----Please enter valid choice")