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
