Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. from user_names import *
  2. import sqlite3
  3.  
  4. # user_names.py
  5. names = ["dani", "eric", "dinna", "tamir", "edan", "daniel", "tomer",
  6. "noa", "shalev", "tom", "shir"]
  7. phones = ["0432", "5415166255", "61467254", "6146758", "5889482"]
  8.  
  9. connection = sqlite3.connect("")
  10. cursor = connection.cursor()
  11.  
  12.  
  13. cursor.execute("""CREATE TABLE Employee(Name text, Phone int)""")
  14. acc = {}
  15.  
  16. for k, v in zip(names, phones):
  17. #acc[k] = v
  18. cursor.execute("""INSERT INTO Employee VALUES({0},
  19. {1})""".format(k, v))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement