def dynamicMyBlogEdit():
t = Tags().query.all()
tags = []
for i in t:
tags.append((i.id, i.tag_name))
MyBlogEdit.tags = SelectField('Tag', choices=tags, coerce=int)
return MyBlogEdit
def get_all_entries():
with sqlite3.connect("./daily-journal.db") as conn:
conn.row_factory = sqlite3.Row
db_cursor = conn.cursor()
db_cursor.execute("""
SELECT
a.id,
a.concept,
a.entry,
a.date,
a.moodId,
m.label label_mood
FROM entries a
JOIN moods m
ON m.id = a.moodId
""")
entries = []
dataset = db_cursor.fetchall()
for row in dataset:
entry = Entries(row['id'], row['concept'], row['entry'],
row['date'], row['moodId'])
mood = Moods(row['id'], row['label_mood'])
entry.mood = mood.__dict__
entries.append(entry.__dict__)
db_cursor.execute(
"""
SELECT
t.id,
t.name,
e.entry_id
FROM entry_tag e
JOIN tags t ON t.id = e.tag_id
WHERE e.entry_id = ?
""", (row['id'], ))
tagset = db_cursor.fetchall()
tags = []
for tag in tagset:
each_tag = Tags(tag['id'], tag['name'])
tags.append(each_tag.__dict__)
entry.tags = tags
return json.dumps(entries)
def update_article(self):
inputs = self.get_input()
if web.ctx.method == "GET":
article_id = inputs.get("article_id")
category_list = Categories.select().where(Categories.status == 0)
article = Articles.get_or_none(Articles.id == article_id)
print(article.id)
self.private_data["article"] = article
self.private_data["category_list"] = category_list
return self.display("admin/update_article")
else:
article_id = inputs.get("article_id")
name = inputs.get('name')
content = inputs.get('content')
summary = inputs.get("summary")
category_id = inputs.get("category_id")
source_url = inputs.get("source_url", "")
keywords = str(inputs.get("keywords", "")).strip()
article = Articles.get_or_none(Articles.id == article_id)
try:
tags_list = keywords.split("，") if keywords else []
if tags_list:
got_tags = Tags.select().where(Tags.name.in_(tags_list))
tmp_list = []
for tag in got_tags:
tmp_list.append(tag.name)
for tag_str in tags_list:
tag_str.strip()
if tag_str not in tmp_list:
t = Tags(name=tag_str)
t.save()
db = TinyDB('settings/db.json')
db.truncate()
db.close()
article.update(name=name,
content=content,
summary=summary,
category_id=category_id,
original_address=source_url,
keywords=keywords,
updateTime=time()).where(
Articles.id == article_id).execute()
self.private_data["update_success"] = True
return web.seeother(self.make_url('articles'))
except Exception as e:
log.error('update article failed %s' % traceback.format_exc())
log.error('input params %s' % inputs)
self.private_data["update_success"] = False
return web.seeother(self.make_url('update_article'))
def get_all_tags():
with sqlite3.connect("./daily-journal.db") as conn:
conn.row_factory = sqlite3.Row
db_cursor = conn.cursor()
db_cursor.execute("""
SELECT
t.id,
t.name
FROM tags t
""")
tags = []
dataset = db_cursor.fetchall()
for row in dataset:
tag = Tags(row['id'], row['name'])
tags.append(tag.__dict__)
return json.dumps(tags)
def tags():
tag = Tags()
tagList = tag.query.all()
return render_template('index/tags.html', tagList=tagList)
def topicList():
t = Tags()
tagList = t.query.all()
return render_template('admin/topicList.html', tagList=tagList)
