Advertisement
Guest User

Computer Cards

a guest
Dec 11th, 2019
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.70 KB | None | 0 0
  1. import sqlite3
  2. conn = sqlite3.connect("computer_cards.db")
  3.  
  4. def create(name, cores, cpu_speed, ram, cost):
  5.     insert_sql = "INSERT INTO computer(name,cores,cpu_speed,ram,cost) VALUES ('{}', {}, {}, {}, {})".format(name, cores, cpu_speed, ram, cost)
  6.    
  7.     conn.execute(insert_sql)
  8.    
  9.     conn.commit()
  10.    
  11. create("My Computers", 4, 1, 4096, 55)
  12.  
  13. print("Enter the details")
  14. name = input("Name >")
  15. cores = input("Cores >")
  16. cpu_speed = input("Speed >")
  17. ram = input("RAM >")
  18. cost = input("Cost >")
  19.  
  20. create(name, cores, cpu_speed, ram, cost)
  21.  
  22. result = conn.execute("Select * from computer")
  23.  
  24. computers = result.fetchall()
  25.  
  26. for computer in computers:
  27.     print(computer)
  28.  
  29. conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement