mercredi 24 décembre 2014

Python - OperationalError in SQLite3

When I insert in DB, I get this error:



sqlite3.OperationalError: near "word": syntax error


Code:



con = sqlite3.connect('films.db')
cur = con.cursor()
cur.execute('CREATE TABLE films (id INTEGER PRIMARY KEY, name VARCHAR(100), ' +
'img BLOB, imbd VARCHAR(30), country_year VARCHAR(50))')
con.commit()

for i in range(97):
cur.execute('INSERT INTO films (name, img, imbd) VALUES(' + names[i].text_content() + ', ' + str(urllib.request.urlopen(img[i].get('src')).read()) + ', ' + imbd[i].text_content() + ' )')
con.commit()
print(cur.lastrowid)


This string "word" from "name".


How can I fix it?


Aucun commentaire:

Enregistrer un commentaire