def feed(csv): # You'll obviously need fr_FR.utf-8 for this to work. locale.setlocale(locale.LC_TIME, 'fr_FR.UTF-8') session = connect_sql() for line in csv.readlines(): add_line(session, line) session.close()
def post_random_tweet(self): session = connect_sql() quote = random_quote(session) quote.used = True session.commit() try: tweet(quote.to_tweet_string()) except: logging.error("Could not tweet : %s, too long." % quote.to_tweet_string()) finally: session.close()
def answer_when(self, tweet_id): q_tweet = get_tweet_by_id(tweet_id) quote = q_tweet[q_tweet.find(u'«')+1:q_tweet.find(u'»')].strip() session = connect_sql() try: logging.info("Looking for quote %s" % quote) quote= session.query(Quote).filter_by(content=quote).one() answer = quote.to_date_string() logging.info("Found it ! %s" % answer) except Exception as exc: logging.error("Could not find it. Error : %s" % exc) answer = None finally: session.close() return answer