Pasted

import sqlite3
 
 
def get_input_data(name):
    first = True
    resp = ''
    while resp == '':
        if not first:
            print("data missing please enter the data")
        resp = input("{0:10}: ".format(name))
        resp = resp.strip()
        first = False
    return resp
 
 
def create(connection, name, cores, cpu_speed, ram, cost):
    # field names/types of table computer
    # name      : text
    # cores     : integer
    # cpu_speed : real
    # ram       : real
    # cost      : real
 
    insert_sql = "INSERT INTO computer(name, cores, cpu_speed, ram, cost) VALUES ('{}', {}, {}, {}, {})".format(name, cores, cpu_speed, ram, cost)
    # print("SQL:>>>>>" + insert_sql + "<<<<<")
 
    connection.execute(insert_sql)
    connection.commit()
 
 
conn = sqlite3.connect("computer_cards.db")
 
resp = "Y"
while resp in ["Y","y",""]:
    print("")
    print("Enter the details:")
    name = get_input_data("Name")
    cores = get_input_data("Cores")
    cpu_speed = get_input_data("CPU speed")
    ram = get_input_data("RAM")
    cost = get_input_data("Price")
 
    create(conn, name, cores, cpu_speed, ram, cost)
    resp = input("Add another card?[y/n]: ")
 
print("")
print("Dump of table computer:")
result = conn.execute("SELECT * FROM computer")
computers = result.fetchall()
 
for computer in computers:
    print(computer)
 
conn.close()