Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sys
- import sqlite3
- d = {}
- d['img'] = 'test'
- d['num'] = 1
- d['rare'] = 3
- d['name'] = 'tira'
- con = sqlite3.connect("test.db")
- print(con)
- cursor = con.cursor()
- cursor.execute("CREATE TABLE monster(img_path string, num int, rare int, name string)")
- cursor.execute("INSERT INTO monster VALUES (:img, :num, :rare, :name)", d)
- con.commit()
- cursor.execute("SELECT * FROM monster")
- for row in cursor:
- print(row)
- con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement