session11.py

import mysql.connector


# DAO : Data Access Object
class DBHelper:

    def saveCustomerInDB(self, customer):

        # 1. Create SQL Statement
        sql = "insert into Customer values(null, '{}', '{}', '{}')".format(customer.name, customer.phone, customer.email)

        # 2. Create Connection with Database
        con = mysql.connector.connect(user="root", password="",host="127.0.0.1", database="AyuDB")

        # 3. Obtain Cursor ro execute SQL Statements
        cursor = con.cursor()
        cursor.execute(sql)
        con.commit()

        print(customer.name," Saved !!")

# Model
class Customer:

    def __init__(self, name, phone, email):
        self.name = name
        self.phone = phone
        self.email = email

    def showCustomerDetails(self):
        print(">> Name: {} Phone: {} Email:{}".format(self.name, self.phone, self.email))

print("Options:")
print("1. Create New Customer")

choice = int(input("Enter Choice: "))

if choice == 1:
    cRef = Customer(None, None, None)
    cRef.name = input("Enter Customer Name:")
    cRef.phone = input("Enter Customer Phone:")
    cRef.email = input("Enter Customer Email:")

    cRef.showCustomerDetails()

    save = input("Would you like to save Customer(yes/no)")
    if save == "yes":
        db = DBHelper()
        db.saveCustomerInDB(cRef)