From d4023dcd0bcb2cea41ccee75cb78432a9eef920f Mon Sep 17 00:00:00 2001 From: Thibaut Horel Date: Wed, 14 Nov 2012 12:35:03 +0100 Subject: Add a link to the news page in the email --- famille.py | 21 +++++++++++++-------- 1 file changed, 13 insertions(+), 8 deletions(-) (limited to 'famille.py') diff --git a/famille.py b/famille.py index ab47090..32528bf 100644 --- a/famille.py +++ b/famille.py @@ -118,6 +118,14 @@ def add_news(): content = request.form['content'] content_cache = rstify(content) if 'Add' in request.form: + cur = g.db.execute("INSERT INTO news " + "('title', 'content', 'user_id', 'content_cache') " + "VALUES (?, ?, ?, ?)", + (request.form['title'], content, + session['user_id'], content_cache)) + news_id = cur.lastrowid + g.db.commit() + # send email emails = query_db("SELECT email from users where notify=1") emails = [email["email"] for email in emails] @@ -125,16 +133,13 @@ def add_news(): message = Message(request.form['title'], sender="news.horel@gmail.com") message.html = content_cache - message.recipients = list(emails) + url = url_for('show_news', news_id=news_id, _external=True) + message.html += "

Vous pouvez "\ + "Lire cette nouvelle sur le site de la famille.

".\ + format(url) + message.recipients = emails mail.send(message) - cur = g.db.execute("INSERT INTO news " - "('title', 'content', 'user_id', 'content_cache') " - "VALUES (?, ?, ?, ?)", - (request.form['title'], content, - session['user_id'], content_cache)) - news_id = cur.lastrowid - g.db.commit() return redirect(url_for('show_news', news_id=news_id)) else: news = {'content': content,'content_cache': content_cache, -- cgit v1.2.3-70-g09d2