# Add record to 'computer' table - Tony Goodhew 15 Nov 19
import sqlite3
conn = sqlite3.connect("d:\\User Profile\Mr Goodhew\Documents\code with mu\Itsybitsy\SQL Databases\computer_cards.db")

def create(name, cores, cpu_speed, ram, cost):
    insert_sql = "INSERT INTO computer(name, cores, cpu_speed, ram, cost) VALUES ('{}', {}, {}, {}, {})".format(name, cores, cpu_speed, ram, cost)
    conn.execute(insert_sql)
    conn.commit()

print("Enter the details:")

name = input("Name > ")
cores = input("Cores > ")
cpu_speed = input("cpu_speed >")
ram = input("ram >")
cost = input("cost >")
create(name, cores, cpu_speed, ram, cost)

conn.close()