title: Python: How to check if an entry already exists in a sql database?
body: <p>I'm new to python and even newer to sql, but I have been trying to make this work all morning and I cannot seem to figure it out. I have a table setup called POSTS(id). I'm trying to check if a number is already in the id column, but it doesn't matter what number postid is because data never returns none even if postid is set to a number not in the database. </p>
  
  <pre><code>import sqlite3 as lite
  import sys
  
  con = lite.connect('post.db')
  postid = '52642'
  
  cur = con.cursor()
  cur.execute("select id from POSTS where id=?", (postid,))
  data = cur.fetchall()
  if data is None:
          print ('not found')
  else:
          print ('found')
  </code></pre>