tupilabs / asf_releases_aggregator Goto Github PK

Seems broken at the moment.

The messages in Markmail, and returned from the Python API, are in America/Los_Angeles time.
The server running the bot is in UTC.
The Markmail API also returns Today, Yesterday, and n days ago, as the date. Even though the API is handling that, it needs further work to properly convert it to UTC.

DEBUG 2016-06-17 22:22:36,749 New/old message found: [ANN] Apache Tomcat 9.0.0.M8 available
DEBUG 2016-06-17 22:22:36,749 New/old message date: 2016-06-14 00:00:00
DEBUG 2016-06-17 22:22:36,749 Composing new tweet for [Apache Tomcat 9.0.0.M8 available]
INFO 2016-06-17 22:22:36,749 Tweeting new release: Apache Tomcat 9.0.0.M8 available
DEBUG 2016-06-17 22:22:37,097 Updating execution time
CRITICAL 2016-06-17 22:22:37,098 Error setting last execution time and subject
ERROR 2016-06-17 22:22:37,098 near "c": syntax error
Traceback (most recent call last):
File "markmail_consumer.py", line 217, in main
set_last_execution_time_and_subject(last_subject_used, tweet_counter, args.dryrun, conn)
File "markmail_consumer.py", line 44, in set_last_execution_time_and_subject
c.execute("c.execute('INSERT INTO executions(last_execution, subject, count) VALUES(?, ?, ?)", (date, subject, tweet_counter))
sqlite3.OperationalError: near "c": syntax error

At the moment there is a brittle part of the code, where we persist the last execution date and title. We can use sqlite for that.

Need to fix the sqlite query.

Add support to Python 3.

Wiki and/or code comments.