scipiguy

FutureLearn Files - Computer DB with 5 inputs

Nov 26th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.52 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.     conn.execute(insert_sql)
  7.     conn.commit()
  8.  
  9. print("Enter the details:")
  10. name = input("Name > ")
  11. cores = input("Cores > ")
  12. cpu_speed = input("CPU Speed > ")
  13. ram = input("RAM > ")
  14. cost = input("Cost > ")
  15.  
  16.  
  17. create(name, cores, cpu_speed, ram, cost)
  18.  
  19. conn.close()
Add Comment
Please, Sign In to add comment