# Cards update

import sqlite3
import pprint
conn = sqlite3.connect("computer_cards.db")

#INSERT INTO table(field_a, field_b) VALUES(value_a,value_b)

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

create("My computer", 4, 3.6, 16000, 800 )

name = input("Name > ")
cores = input("Cores > ")
speed = input("CPU Speed > ")
ram = input("RAM > ")
cost = input("Cost > ")
create(name,cores,speed,ram,cost)

# Display all cards

result = conn.execute("SELECT * FROM computer")
computers = result.fetchall()
for pc in computers:
    print(pc)

conn.close