def downgrade():
tag4 = Tag(name='app')
tags = session.query(Tag).filter(Tag.name=='android')
session.add(tag4)
session.delete(tags)
print 'ko'
session.commit()
def author(user_id):
author = session.query(Author).filter_by(id=user_id).first()
if author:
articles = author.articles
return render_template('author.html', articles=articles, author=author)
else:
return u'没有你要找的author'
def post(self):
title = request.form.get('title')
detail = request.form.get('content')
author = request.form.get('author')
tags = request.form.getlist('tag')
print type(tags)
tagmodels = []
for tag_id in tags:
tag_model = session.query(Tag).get(tag_id)
print tag_model
tagmodels.append(tag_model)
authors = session.query(Author).filter(Author.name == author).first()
if not authors:
authors = Author(name=author)
article = Articles(title=title, detail=detail)
article.author = authors
article.tag = tagmodels
session.add(article)
session.commit()
return 'add article successed'
def detail(id):
article = session.query(Articles).filter_by(id=id).first()
if article:
return render_template('detail.html', article=article)
else:
return u'没有你要找的文章'
def get(self):
tags = session.query(Tag).all()
return render_template('pull.html', tags=tags)
def index():
print session
articles = session.query(Articles).all()
context = {'articles': articles}
return render_template('index.html', **context)