From e493c10e498df3cdb9be4fd8f639586df83e8552 Mon Sep 17 00:00:00 2001
From: chengkang <1412950785@qq.com>
Date: Tue, 24 Jul 2018 10:47:28 +0800
Subject: [PATCH] use queryone() instead of query()

---
 demos/blog/blog.py | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

diff --git a/demos/blog/blog.py b/demos/blog/blog.py
index 96d511ea4..ee8e92c52 100755
--- a/demos/blog/blog.py
+++ b/demos/blog/blog.py
@@ -183,10 +183,11 @@ class ComposeHandler(BaseHandler):
         text = self.get_argument("markdown")
         html = markdown.markdown(text)
         if id:
-            entry = await self.query("SELECT * FROM entries WHERE id = %s", int(id))
-            if not entry:
+            try:
+                entry = await self.queryone("SELECT * FROM entries WHERE id = %s", int(id))
+            except NoResultError:
                 raise tornado.web.HTTPError(404)
-            slug = entry[0].slug
+            slug = entry.slug
             await self.execute(
                 "UPDATE entries SET title = %s, markdown = %s, html = %s "
                 "WHERE id = %s", title, text, html, int(id))
-- 
2.47.2