lundi 9 février 2015

IntegrityError: datatype mismatch in Python using praw

I am trying to write a reddit bot that takes the word "fuck" and see how many people say that on reddit. Here is the code:



import praw
import time
import re
import sqlite3

username = "LewisTheRobot"
password = "lewismenelaws"

conn = sqlite3.connect('reddit')
c = conn.cursor()
r = praw.Reddit(user_agent = "Reddit bot")

word_to_match = [r'\bfuck\b', r'\bfucking\b', r'\bfucks\b']

storage = []

r.login(username, password)

def run_bot():
subreddit = r.get_subreddit("all")
print("Grabbing subreddit!")
comments = subreddit.get_comments(limit=200)
print("Grabbing comments!")
for comment in comments:
comment_text = comment.body.lower()
isMatch = any(re.search(string, comment_text) for string in word_to_match)
if comment.id not in storage and isMatch and comment.author not in storage:
print("We have found a fuck boy. Storing username: " + str(comment.author) + "into database.")
storage.append(comment.author)
c.execute("INSERT INTO users (id, Username, subreddit, comment) VALUES(?,?,?,?)", (str(comment.id), str(comment.author), str(comment.subreddit), str(comment.body)))
conn.commit()

print("There are currently " + str(len(storage)) + " fuck boys on reddit at the moment.")



while True:
run_bot()
time.sleep(2)


Whenever I run the bot it crashes whenever it finds a match and gives me this error.enter image description here


From what I understand it means that something in the database isnt the right datatype to be inserted into my database. I am pretty sure it is the str(comment.body) section of the SQL setting. My SQLITE database has the comment field as a text field. Thanks for the help.


Here are the database credentials shown in DB Browser. enter image description here


Aucun commentaire:

Enregistrer un commentaire