Advertisement
Guest User

Untitled

a guest
Jul 7th, 2015
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. import sys
  2. import sqlite3
  3.  
  4. d = {}
  5.  
  6. d['img'] = 'test'
  7. d['num'] = 1
  8. d['rare'] = 3
  9. d['name'] = 'tira'
  10.  
  11. con = sqlite3.connect("test.db")
  12. print(con)
  13. cursor = con.cursor()
  14. cursor.execute("CREATE TABLE monster(img_path string, num int, rare int, name string)")
  15. cursor.execute("INSERT INTO monster VALUES (:img, :num, :rare, :name)", d)
  16. con.commit()
  17.  
  18. cursor.execute("SELECT * FROM monster")
  19.  
  20. for row in cursor:
  21. print(row)
  22.  
  23. con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement