def _format_message_from_db_row(self, entry): date_formater.init_date() message = {} message["imapid"] = entry[0] message["fulltext"] = entry[1] message["encoding"] = entry[2] message["subject"] = entry[3] addr = email_utils.parseaddr(entry[4]) message["sender"] = addr message["seen"] = entry[5] message["date"] = date_formater.format_date(entry[6], True) message["mailbox"] = entry[7] encoding = "utf-8" # is this encoding stuff *really* necessary? if message["fulltext"] is not None: # yay, we even have the content!! if message["encoding"] is not None: encoding = message["encoding"] else: m = self.mailbox if message["mailbox"] != m: self.load_mailbox(message["mailbox"]) message["fulltext"] = self._load_message_body(message["imapid"]) self.load_mailbox(m) else: message["fulltext"] = self._load_message_body(message["imapid"]) email_message = email.message_from_string(message["fulltext"].encode(encoding)) content = self.get_content_from_message(email_message)[0] message["body"] = unicode(content) return message
def load_threads_searched(self, start, end, token): date_formater.init_date() cur = self.db.execute('select imapid, subject, seen, sender, date from threads' + self._get_where() + (" and subject like '%s' " % ("%" + token + "%")) + self._get_order_by() + ' limit %s,%s' % (start, end)) entries = [dict(imapid=row[0], subject=row[1], seen=row[2], sender=self.parse_emails(row[3]), date=date_formater.format_date(row[4]) ) for row in cur.fetchall()] return entries
def before_request(): g.db = sqlite3.connect(app.config['DATABASE']) import rss_db g.al = rss_db.FeedsDatabase() date_formater.init_date()
def ajax_full_view(article): save_view_mode(1) date_formater.init_date() cur = g.al.get_articles_for_feed(article) feeds = [dict(sender=(art.name, feed.url, art.url), imapid=art.id, seen=art.seen, body=art.content + "<div class=\"clearer\"></div>", date=date_formater.format_date(art.pubDate), feedid=art.feed) for art, feed in cur] return jsonify(content=render_template("rss/rss-ajax-thread.html", thread=feeds))
def ajax_full_view_unread(): save_view_mode(1) date_formater.init_date() cur = g.db.execute("select feeds.url, articles.name, articles.id, articles.content, articles.seen, feeds.name, articles.pubDate, articles.url, articles.feed from articles, feeds where feeds.id = articles.feed and seen = 0 order by articles.pubDate desc") feeds = [dict(sender=(row[1], row[5], row[7]), imapid=row[2], seen=row[4], body=row[3] + "<div class=\"clearer\"></div>", date=date_formater.format_date(row[6]), feedid=row[8]) for row in cur.fetchall()] return jsonify(content=render_template("rss/rss-ajax-thread.html", thread=feeds))