import sqlite3
database = 'sqlite.db'
def create_design(designation, price, max_speed, designe):
conn = sqlite3.connect(database)
c = conn.cursor()
try:
# Execute an SQL command to insert data into a table
c.execute("INSERT INTO cars (designation, price, max_speed) VALUES (?, ?, ?, ?)",
(designation, price, max_speed))
# Commit the changes to the database
conn.commit()
print(f"A new user record {designation} has been created with the data:")
print((designation, price, max_speed))
except sqlite3.Error as error:
print("Error while executing the INSERT:", error)
c.close()
conn.close()
create_design("Tesla 2022 model 3", 38999, 162, "Lockheed")
def read_design(id):
# Connect to the database file
conn = sqlite3.connect(database)
# Create a cursor object to execute SQL queries
c = conn.cursor()
# Execute a SELECT statement to retrieve data from a table
results = c.execute('SELECT * FROM cars').fetchall()
# Print the results
if len(results) == 0:
print("Table is empty")
else:
for row in results:
if row[0] == id:
print(row)
# Close the cursor and connection objects
c.close()
conn.close()
read_design(1)
def update_design(design_id, designation=None, price=None, max_speed=None):
conn = sqlite3.connect(database)
c = conn.cursor()
update_dict = {}
if designation is not None:
update_dict["designation"] = designation
if price is not None:
update_dict["price"] = price
if max_speed is not None:
update_dict["max_speed"] = max_speed
update_str = ", ".join([f"{col}=? " for col in update_dict.keys()])
c.execute(f"UPDATE cars SET {update_str} WHERE id=?", (*update_dict.values(), design_id))
conn.commit()
print(read_design(design_id))
c.close()
conn.close()
update_design(2, None, None, 498)
def delete_design(design_id):
conn = sqlite3.connect(database)
c = conn.cursor()
print(read_design(design_id))
c.execute("DELETE FROM planes WHERE id=?", (design_id,))
conn.commit()
conn.close()
delete_design(2)
This function takes a design ID as an argument and deletes the record from the "designs" table that matches that ID.
def menu():
operation = input("Enter: (C)reate (R)ead (U)pdate or (D)elete or (S)chema")
if operation.lower() == 'c':
create()
elif operation.lower() == 'r':
read()
elif operation.lower() == 'u':
update()
elif operation.lower() == 'd':
delete()
elif operation.lower() == 's':
schema()
elif len(operation)==0: # Escape Key
return
else:
print("Please enter c, r, u, or d")
menu() # recursion, repeat menu
try:
menu() # start menu
except:
print("Perform Jupyter 'Run All' prior to starting menu")