import pdb;
for i in range(1,10):
pdb.set_trace()
print(i)
Now press F5, the program will execute and press n for keyboard, and u will get the desired result

pip install mysql-connector
pip install mysql-connector-python
pip install pymysql
pip install sqlalchemy
pip install tabulate
pip3 install mysql-connector-python

	
import mysql.connector
from tabulate import tabulate
from datetime import datetime


mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="wecan123",
  database="stones",
  charset = "utf8"
)

mycursor = mydb.cursor()




def StonesManufacturing():


  def inputNumber(message):
   while True:
     try:
        userInput = int(input(message))       
     except ValueError:
        print("Only Integer in Mobile No.")
        continue
     else:
       return userInput
       break

    
  CuttingType = input("Enter Cutting Type :")
  PolishType = input("Enter Polish Type :")
  ManufactureDate = input("Enter Manufacture date(dd-mm-yyyy) :")
  #After Getting date from user side we have to convert date in YYYY-MM-DD format because SQL can accept date in YYYY-MM-DD format only
  changeFORMAT = ManufactureDate[6:] + "-" + ManufactureDate[3:5] + "-" + ManufactureDate[:2]
  ShapeType = input('Enter Shape :')
  ColorType = input("Enter Color :")
  SizeType = input("Enter Size :")
  

  if CuttingType.isdigit():
    print('Integer are not allowed in Cutting Type')
  elif PolishType.isdigit() :
    print("Integer are not allowed in Polish Type")
  elif ShapeType.isdigit():
    print("Integers are not allowed in Polish Type")
  elif ColorType.isdigit():
    print("Integers are not allowed in Color Type")
  else:
   sql = "INSERT INTO manufacturing(cuttingtype,polishtype,manufacturedate,shapetype,colortype,sizetype)VALUES(%s,%s,%s,%s,%s,%s)"
   val = (CuttingType,PolishType,changeFORMAT,ShapeType,ColorType,SizeType)
   mycursor.execute(sql, val)

   mydb.commit()    
   print("Data entered successfully")
   main()




def ShowStonesManufacturing():
  mycursor.execute("SELECT * FROM manufacturing")
  myresult = mycursor.fetchall()
  """
  #This code is used when we want to show the result not in Tabular format , this code is right
  for x in myresult:
    print(x)
  """
  
  OR
  '''
  data = [["Alice", 24], ["Bob", 19]]
  headers = ["Name", "Age"]
  print(tabulate(data, headers=headers, tablefmt="grid"))
  '''
  
  print(tabulate(myresult, headers=['Manufacture ID','Cutting Type','Polish Type','Manufacture Date','Shape type','Color Type','Shape Type'], tablefmt='psql'))
  mydb.commit()
  main()



def StonePurchasing():
  StoneQuality = input('Enter Stone Quality :')
  StoneWeight = input('Enter Stone Weight ;')
  PurchaseDate = input("Enter Manufacture date(dd-mm-yyyy) :")
  #After Getting date from user side we have to convert date in YYYY-MM-DD format because SQL can accept date in YYYY-MM-DD format only
  changeFORMAT = PurchaseDate[6:] + "-" + PurchaseDate[3:5] + "-" + PurchaseDate[:2]
  Enterdate = input("Enter Date : (dd-mm-yyyy) ")
    try:
        datetime.strptime(Enterdate, "%d-%m-%Y")
        print("Valid Date")
    except ValueError:
        print("Invalid Date")
  Size = int(input('Enter size '))
  Color = input("Enter Color :")


  InsertMarks_Query = "INSERT INTO stonepurchasing(stonequality,stoneweight,purchasedate,colortype,sizetype)VALUES(%s,%s,%s,%s,%s)"
  InsertMarksval = (StoneQuality,StoneWeight,changeFORMAT,Size,Color)
  mycursor.execute(InsertMarks_Query, InsertMarksval)
  print('Data Entered Successfully...')
  mydb.commit()
  main()




def ShowStonesPurchasing():
  mycursor.execute("SELECT * FROM stonepurchasing")
  myresult = mycursor.fetchall()
  """
  #This code is used when we want to show the result not in Tabular format , this code is right
  for x in myresult:
    print(x)
  """
  
  print(tabulate(myresult, headers=['Stone ID','Stone Quality','Purchase Date','Color Type','Size Type'], tablefmt='psql'))
  mydb.commit()
  main()


def StoneSelling():
  PricePercarrot = input('Enter Price Per Carrot :')
  ShapeType = input('Enter Shape Type :')
  QualityType = input('Enter Quality :')
  SellDate = input("Enter Selling date(dd-mm-yyyy) :")
  #After Getting date from user side we have to convert date in YYYY-MM-DD format because SQL can accept date in YYYY-MM-DD format only
  changeFORMAT = SellDate[6:] + "-" + SellDate[3:5] + "-" + SellDate[:2]
  SizeType = int(input('Enter Size :'))
  ColorType = input("Enter Color Type :")
  
  InsertMarks_Query = "INSERT INTO stoneselling(pricepercarot,shape,quality,sellingdate,size,color)VALUES(%s,%s,%s,%s,%s,%s)"
  InsertMarksval = (PricePercarrot,ShapeType,QualityType,changeFORMAT,SizeType,ColorType)
  mycursor.execute(InsertMarks_Query, InsertMarksval)
  print('Date Entered Successfully..')
  mydb.commit()
  main()

  
  


def ShowStoneSelling():
  mycursor.execute("SELECT * FROM stoneselling")
  myresult = mycursor.fetchall()
  """
  #This code is used when we want to show the result not in Tabular format , this code is right
  for x in myresult:
    print(x)
  """
  '''
  data = [
        [1, "Keyboard", 500],
        [2, "Mouse", 300],
        [3, "Monitor", 5000]
    ]

    print("+-------+-------------------------+-------+")
    print("| S.No  | Particulars             | Price |")
    print("+-------+-------------------------+-------+")

    for row in data:
        print(f"| {row[0]:<5} | {row[1]:<23} | {row[2]:>5} |")

    print("+-------+-------------------------+-------+")
    
	
	  name = "Ram"
	  age = 25
	  print(f"My name is {name} and my age is {age}")
	
  '''
  
  
  print(tabulate(myresult, headers=['Stone selling ID','Price per Carrot','Shape','Quality', 'Selling Date','Size','Color'], tablefmt='psql'))
  mydb.commit()
  main()
  



def main():
    print("""
    STONES IMPORT & EXPORT MANAGEMENT SYSTEM
    
    1. STONES MANUFACTURING 
    2. SHOW STONES MANUFACTURING
    3. STONES PURCHASING
    4. SHOW STONE PURCHASING
    5. STONE SELLING
    6. SHOW STONE SELLING
    """)
    choice=input("Enter Your Choice :")
    while True:
      if(choice=='1'):
          StonesManufacturing()
      elif(choice=='2'):
          ShowStonesManufacturing()
      elif(choice=='3'):
          StonePurchasing()
      elif(choice=='4'):
          ShowStonesPurchasing()
      elif(choice=='5'):
          StoneSelling()
      elif(choice=='6'):
        ShowStoneSelling()
      else:
          print("Invalid Entry.....")
    main()
main()

	
import mysql.connector
from tabulate import tabulate


mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="",
  database="school"
)

mycursor = mydb.cursor()




def StudentRegistration():

  def inputNumber(message):
    while True:
      try:
        userInput = int(input(message))       
      except ValueError:
        print("Only Integer in Mobile No.")
        continue
      else:
       return userInput 
       break 
    
  StudentName = input("Enter Student Name :")
  FatherName = input("Enter Father Name :")
  Class = input("Enter Class :")
  DOB = input("Enter Date of Birth(dd-mm-yyyy) :")
  #After Getting date from user side we have to convert date in YYYY-MM-DD format because SQL can accept date in YYYY-MM-DD format only
  changeFORMAT = DOB[6:] + "-" + DOB[3:5] + "-" + DOB[:2]
  Aadharno = input("Enter Aadhar No. :")
  MobileNo = inputNumber("Enter Your Mobile Number")
  Address = input("Enter Address :")
  genderInput = input("Enter 'M' for Male or 'F' for Female\n").upper()
  if genderInput == "M":
    gender = "Male"
    #print(gender)
  elif genderInput == "F":
    gender= "Female"

  if StudentName.isdigit():
    print('Integer are not allowed on Student Name')
  elif genderInput != "M" and genderInput != "F" :
    print("Invalid Entry for Gender")
  else:
   sql = "INSERT INTO studentregistration(studentname,fathername,class,dateofbirth,aadharno,mobileno,address,gender)VALUES(%s,%s,%s,%s,%s,%s,%s,%s)"
   val = (StudentName,FatherName,Class,changeFORMAT,Aadharno,MobileNo,Address,gender)
   mycursor.execute(sql, val)

   mydb.commit()    
   print("Data entered successfully")
   main()




def ShowStudents():
  mycursor.execute("SELECT * FROM studentregistration")
  myresult = mycursor.fetchall()
  """
  This code is used when we want to show the result not in Tabular format , this code is right
  for x in myresult:
    print(x)
  """
  print(tabulate(myresult, headers=['Student ID','Student Name','Father Name','Class','Date of Birth','Aadhar No','Mobile No','Address','Gender'], tablefmt='psql'))
  mydb.commit()
  main()



def FirstTermMarks():
  StudentID = int(input('Enter StudentID :'))
  mycursor.execute("SELECT * FROM studentregistration WHERE studentID = %s",(StudentID,))
  mycursor.fetchall()
  row_count = mycursor.rowcount
  #print("number of affected rows: {}".format(row_count))
  if row_count == 0:
    print("Invalid ID, Please Try Again...")
  else:
    Economics_MARKS = int(input('Enter Economics Marks :'))
    PoliticalScience_MARKS = int(input('Enter Political Science Marks :'))
    ComputerScience_MARKS = int(input('Enter Computer Science Marks :'))
    Total_MARKS = Economics_MARKS + PoliticalScience_MARKS + ComputerScience_MARKS
    Percentage = (Total_MARKS * 100)/300
    Division = ""
    if (Percentage>=60):
      Division = "I Division"
    elif (Percentage>=45 and Percentage<=59):
      Division = "II Division"
    elif (Percentage>=36 and Percentage<=44):
      Division = "III Division"
    else:
      Division = "Fail.."
      
    InsertMarks_Query = "INSERT INTO firsttermmarks(FK_studentid,Economics,polscience,cs,totalmarks,percentage,division)VALUES(%s,%s,%s,%s,%s,%s,%s)"
    InsertMarksval = (StudentID,Economics_MARKS,PoliticalScience_MARKS,ComputerScience_MARKS,Total_MARKS,Percentage,Division)
    mycursor.execute(InsertMarks_Query, InsertMarksval)
    print('Marks Entered Successfully..')
    mydb.commit()
    main()


def ShowFirstTermMarks():
  StudentID = int(input('Enter StudentID :'))
  mycursor.execute("SELECT Economics,polscience,cs,totalmarks,percentage,division FROM firsttermmarks WHERE fk_studentID = %s",(StudentID,))
  myresult = mycursor.fetchall()
  row_count = mycursor.rowcount
  #print("number of affected rows: {}".format(row_count))
  if row_count == 0:
    print("Invalid ID, Please Try Again...")
  else:
    print(tabulate(myresult, headers=['Economics','Political Science','Computer Science','Total Marks','Percentage','Division'], tablefmt='psql'))
    mydb.commit()
    main()
  


def SecondTermMarks():
  StudentID = int(input('Enter StudentID :'))
  mycursor.execute("SELECT * FROM studentregistration WHERE studentID = %s",(StudentID,))
  mycursor.fetchall()
  row_count = mycursor.rowcount
  #print("number of affected rows: {}".format(row_count))
  if row_count == 0:
    print("Invalid ID, Please Try Again...")
  else:
    Economics_MARKS = int(input('Enter Economics Marks :'))
    PoliticalScience_MARKS = int(input('Enter Political Science Marks :'))
    ComputerScience_MARKS = int(input('Enter Computer Science Marks :'))
    Total_MARKS = Economics_MARKS + PoliticalScience_MARKS + ComputerScience_MARKS
    Percentage = (Total_MARKS * 100)/300
    Division = ""
    if (Percentage>=60):
      Division = "I Division"
    elif (Percentage>=45 and Percentage<=59):
      Division = "II Division"
    elif (Percentage>=36 and Percentage<=44):
      Division = "III Division"
    else:
      Division = "Fail.."
      
    InsertMarks_Query = "INSERT INTO secondtermmarks(FK_studentid,Economics,polscience,cs,totalmarks,percentage,division)VALUES(%s,%s,%s,%s,%s,%s,%s)"
    InsertMarksval = (StudentID,Economics_MARKS,PoliticalScience_MARKS,ComputerScience_MARKS,Total_MARKS,Percentage,Division)
    mycursor.execute(InsertMarks_Query, InsertMarksval)
    print('Marks Entered Successfully..')
    mydb.commit()
    main()

  
  


def ShowSecondTermMarks():
  StudentID = int(input('Enter StudentID :'))
  mycursor.execute("SELECT Economics,polscience,cs,totalmarks,percentage,division FROM secondtermmarks WHERE fk_studentID = %s",(StudentID,))
  myresult = mycursor.fetchall()
  row_count = mycursor.rowcount
  #print("number of affected rows: {}".format(row_count))
  if row_count == 0:
    print("Invalid ID, Please Try Again...")
  else:
    print(tabulate(myresult, headers=['Economics','Political Science','Computer Science','Total Marks','Percentage','Division'], tablefmt='psql'))
    mydb.commit()
    main()
  

def Attendance():
  StudentID = int(input('Enter StudentID :'))
  mycursor.execute("SELECT * FROM studentregistration WHERE studentID = %s",(StudentID,))
  mycursor.fetchall()
  row_count = mycursor.rowcount
  #print("number of affected rows: {}".format(row_count))
  if row_count == 0:
    print("Invalid ID, Please Try Again...")
  else:
    TotalNoofDays = 365
    PresentDay = int(input("Enter Number of Present Day :"))
    PresentDayInPercentage = (PresentDay *100)/TotalNoofDays
    AbsentDayInPercentage = 100 - PresentDayInPercentage
    sql = "INSERT INTO attendance(FK_studentID,totalnoofdays,presentday,presentdayinpercentage,absentdayinpercentage)VALUES(%s,%s,%s,%s,%s)"
    val = (StudentID,TotalNoofDays,PresentDay,PresentDayInPercentage,AbsentDayInPercentage)
    mycursor.execute(sql, val)
    mydb.commit()    
    print("Data entered successfully")
    main()
  


def ShowAttendance():
  StudentID = int(input('Enter StudentID :'))
  mycursor.execute("SELECT totalnoofdays,presentday,presentdayinpercentage,absentdayinpercentage FROM attendance WHERE fk_studentID = %s",(StudentID,))
  myresult = mycursor.fetchall()
  row_count = mycursor.rowcount
  #print("number of affected rows: {}".format(row_count))
  if row_count == 0:
    print("Invalid ID, Please Try Again...")
  else:
    print(tabulate(myresult, headers=['totalnoofdays','presentday','presentdayinpercentage','absentdayinpercentage'], tablefmt='psql'))
    mydb.commit()
    main()
  
  

def ShowRecordByID():
  GetID = input('Enter Sutdent ID : ')
  if not GetID.isdigit():
    print('Only number allowed ')
    return
  GetID = int(GetID)
  mycursor.execute("select * from datastore where id = %s",(GetID,))
  GetSingleRow = mycursor.fetchone()
  if(GetSingleRow is None):
    print('Invalid ID, pls try again later ')
  else:
    print('ID','Name')
    print(GetSingleRow[0],GetSingleRow[1])
  main()




def main():
    print("""
    1. STUDENT REGISTRATION
    2. ENTER FIRST TERM MARKS
    3. SHOW FIRST TERM MARKS
    4. ENTER SECOND TERM MARKS
    5. SHOW SECOND TERM MARKS
    6. ENTER ATTENDANCE
    7. SHOW ATTENDANCE
    8. SHOW ALL STUDENTS
	9. SHOW STUDENT BY ID
    """)
    choice=input("Enter Your Choice :")
    while True:
      if(choice=='1'):
          StudentRegistration()
      elif(choice=='2'):
          FirstTermMarks()
      elif(choice=='3'):
          ShowFirstTermMarks()
      elif(choice=='4'):
          SecondTermMarks()
      elif(choice=='5'):
          ShowSecondTermMarks()
      elif(choice=='6'):
          Attendance()
      elif(choice=='7'):
          ShowAttendance()
      elif(choice=='8'):
          ShowStudents()
	  elif(choice=='9'):
	      ShowRecordByID()
      else:
          print("Invalid Entry.....")
    main()
main()

	

Before starting, note it that we have to install software SQlLite from internet, and in this some queries are differernt from 
Mysql Example

Some points to be Remember

1. CarCollection.db file and python file both are in the same folder

create table carsave(carid integer primary key autoincrement, carname varchar(50));


2. To start this, Go Start Menu → DB Browser for SQLite 



import sqlite3
from tabulate import tabulate



mydb = sqlite3.connect("CarCollection.db")
mycursor = mydb.cursor()


def RegisterCar():
    EnterCarname = input('Enter Car name : ')
    mycursor.execute("INSERT INTO carsave(carname) VALUES(?)",(EnterCarname,))
    mydb.commit()
    print('Car saved ',EnterCarname)
    


def ShowCar():
    mycursor.execute("SELECT * FROM carsave")
    myresult = mycursor.fetchall()
    if len(myresult) == 0:
        print("No car record found")
    else:
        print(tabulate(
            myresult,
            headers=['Car ID', 'Car Name'],
            tablefmt='psql'
        ))



def ShowCarByID():
    EnterCarid = int(input('Enter Car ID: '))
    mycursor.execute("select * from carsave where carid = ?",(EnterCarid,))
    GetResult = mycursor.fetchone()
    if GetResult is None:
        print("Invalid Car ID")
    else:
        print(GetResult[0],GetResult[1])
    



def main():
    while True:
        print("""
        # C A R #  # C O L L E C T I O N #

        1. Car Register
        2. Show Data
        3. Show Car by ID
        4. Exit
        """)

        ch = input("Enter Choice : ")
        if ch == '1':
            RegisterCar()
        elif ch == '2':
            ShowCar()
        elif ch == '3':
            ShowCarByID()
        elif ch == '4':
            print("Program Closed")
            break
        else:
            print('Invalid Entry.')


main()