Relational Database Manager with SQL

 import sqlite3

con = sqlite3.connect("./e-commerce/e-commerce.db")
cur = con.cursor()

print("Welcome to E-commerce DB!")
print("Select action:")
print()
print("Add data to customers (1)")
print("Add data to orders (2)")
print("Add data to shipping (3)")
print("Delete data from customers (4)")
print("Delete data from orders (5)")
print("Delete data from shipping (6)")
print("Get data from customers (7)")
print("Get data from orders (8)")
print("Get data from shipping (9)")
print("Get data from products (10)")
print()
selectionPrompt = input("Selection: ")

if selectionPrompt == "1":  
    customerName = input("Input your name: ")
    customerAge = int(input("Input your age: "))
    customerAddress = input("Input your home address: ")
    customerPaymentInfo = input("Enter your payment info: ")
    customerEmail = input("Input your email: ")

    cur.execute(f"""INSERT INTO customers(customerName,
customerAge, customerAddress, customerPaymentInfo, customerEmail)
VALUES("{customerName}", {customerAge}, "{customerAddress}", "{customerPaymentInfo}",
"{customerEmail}")""")
    con.commit()

    print()
    print("Data has been added to the customers table!")

elif selectionPrompt == "2":
    productID = int(input("Please enter your productID: "))
    customerID = int(input("Please enter your customerID: "))
   
    cur.execute(f"""INSERT INTO orders(productID, customerID)
VALUES({productID}, {customerID})""")
    con.commit()

    print()
    print("Data has been added to the orders table!")

elif selectionPrompt == "3":
    orderID = int(input("Please enter your orderID: "))
    customerID = int(input("Please enter your customerID: "))
   
    cur.execute(f"""INSERT INTO shipments(orderID, customerID)
VALUES({orderID}, {customerID})""")
    con.commit()

    print()
    print("Data has been added to the shipments table!")


elif selectionPrompt == "4":
    customerID = input("Enter a customerID: ")

    cur.execute(f"""DELETE FROM customers WHERE customerID={customerID}""")
    con.commit()

    print()
    print("Data has been deleted from the customers table!")

elif selectionPrompt == "5":
    orderID = input("Enter your orderID: ")

    cur.execute(f"""DELETE FROM orders WHERE orderID={orderID}""")
    con.commit()

    print()
    print("Data has been deleted from the orders table!")

elif selectionPrompt == "6":
    shippingID = input("Enter your shippingID: ")

    cur.execute(f"""DELETE FROM shippings WHERE orderID={shippingID}""")
    con.commit()

    print()
    print("Data has been deleted from the shippings table!")

elif selectionPrompt == "7":
    customerID = int(input("Enter your customerID: "))

    cur.execute(f"""SELECT FROM customers WHERE customerID={customerID}""")
    print()
    print(cur.fetchone())









Comments

Post a Comment

Popular posts from this blog

OSA Summer 2023 Mock - Task 1, Assignment 1

Image
  OSA Summer 2023 Mock – Task 1           Legal requirements   The company must ensure they are compliant with the correct legislation whilst the project is undertaken.   If any person is working at height, the correct safety measures to prevent injury or death must be imposed under The Work at Height Regulations 2005. They must have an appropriate safety harness on and hazardous areas at height should be i dentified in the risk assessment.   By storing data internally on a local file server, the business is responsible for maintaining the confidentiality, availability and integrity of that data. They must comply with The Data Protection Act 2018 and General Data Protection Regulations.   Display screen equipment regulations (DSE) should be considered when installing workstations. Ergonomic and posture-friendly chairs should be installed and employees given appropriate breaks from working around screens.     Data p...
Read more

OSA Assignment 1 - Task 1 GUIDE

  OSA Assignment 1 – Task 1 Guide     Exam parameters   Time length – 3 hours   Marks available – 20     Task 1: Planning   In this task you are required to submit :   A project plan   Gantt chart showing th e critical path   Explanation of legal requirements   Physical and digital threat countermeasures   Annotated floor plan     Gantt Chart   The Gantt Chart is the first document you should create. This details each phase of the project alongside the timescale to complete it.   Ensure you make a note of the deadline for the project along with any pre-requisites such as cabling. This should all be implemented into your Gantt Chart.   You can follow a layout like this:   Project:   Pre considerations (Gathering project timescale, risk assessments, ...)   Planning (Devising project plan, identifying budget, ...)   Design (Research hardware, identify topology, ...)   Pre ...
Read more

Useful Core A Acronyms

  Useful core A acronyms     NGO – Non governmental organisation   KPI – Key performance indicator   USP – Unique selling point   CRM – Customer relationship management   Saas – Software as a service   CAB – Change advisory board   SMARTER – Specific, measurable, accurate , realistic, time-bound, evaluate, re-evaluate   IPO – Intellectual property office   RCD – Registered community designs   UCD – Unregistered community designs   TNA – Training needs analysis   PRR – Post project reviews   COBC – Code of business conduct   BCS – British computing society   ML – Machine learning   CVS – Computer vision syndrome   RSI – Repetitive strain injury   DSE – Display screen equipment   HSE – Health and safety executive   ODD – Optical disk drive   RPM – Revolutions per minute   CPU – Central processing unit   RAM – Random access memory   EMI – Electromagnetic inter...
Read more