title: Commiting data from Tweepy to a sqlite3 database, no matter what I do, db remains empty
body: <p>Code:</p>
  
  <pre><code>import time
  import tweepy
  import sqlite3
  
  class Listener(tweepy.StreamListener):
  
      conn = sqlite3.connect('/home/daniel/Desktop/activeSites/djeep/djeep.db')
  
      def on_status(self, status):
          try:
              c = self.conn.cursor()
              c.execute("""insert into feed_post values (%r,'%s','%s',%d)""") % (status.id, status.text, status.author.screen_name, status.created_at)
              self.conn.commit()
          except:
              pass
  
  
      def on_error(self, status_code):
          print 'An error has occured! Status code = %s' % status_code
          return True  # keep stream alive
  
      def on_timeout(self):
          print 'timeout...'
  
  def main():
      auth = tweepy.OAuthHandler('C_KEY', 'C_SECRET') 
      auth.set_access_token('ACCESS_TOKEN', 'ACCESS_SECRET') 
      stream = tweepy.Stream(auth=auth, listener=Listener())     
      stream.filter(track=('baseball',)) 
  
  if __name__=="__main__":
      try:
          main()
      except KeyboardInterrupt:
          print "See ya!"
  </code></pre>
  
  <p>I've gone back and added one line of the database related code at a time to try and find out what breaks it, and it seems to be the addition of the <code>c.execute()</code> line.  I just can't figure out what I'm missing!</p>