def asy_update():
# yield gen.sleep(5)
# http_client = AsyncHTTPClient() #异步HTTP客户端对象
# response = yield http_client.fetch(url) #获取异步结果
# raise gen.Return(response)
posttype_all = session.query(PostType).all()
raise gen.Return(posttype_all)
def get(self, post_id):
posts = session.query(Post).get(post_id)
type_all = session.query(PostType).all()
if not posts:
return self.write_error(404)
return self.render("single.html", posts=posts, type_all=type_all)
def get(self):
posts = session.query(Post).all()
return self.render("index.html", posts=posts)
def asy_update():
# time.sleep(5)
# yield gen.sleep(5)
posttype_all = session.query(PostType).all()
raise gen.Return(posttype_all)
def get(self, post_id): #传入图片对应id
posts = session.query(Post).get(post_id)
type_all = session.query(PostType).all() #查询全部图片标签
if not posts:
return self.write_error(404) #查不到超出的图片id就返回404页面
return self.render("single.html", posts=posts, type_all=type_all)
def get(self):
posts = session.query(Post).all() # 获取所有的图片
# p_type = session.query(PostType).all() #获取文章类型
return self.render("index.html", posts=posts)
def check_username(cls, username):
return session.query(cls).filter_by(username=username).first()
def get(self):
# p = PostType(name="旅行")
# session.add(p)
# session.commit()
posttype_all = session.query(PostType).all()
return self.render("update.html", posttype_all=posttype_all)
def delete_user():
row = session.query(User).filter(User.username == 'which')[0]
session.delete(row)
session.commit()
def update_user():
row = session.query(User).filter(User.username == 'tuple').update(
{User.password: 123})
session.commit()
def query_user():
row1 = session.query(User).all()
row2 = session.query(User).first()
print(row1)
def get_one_citizen_by_unique_pair(import_id, citizen_id):
return (session.query(Citizen).filter(
Citizen.import_id == import_id).filter(
Citizen.citizen_id == citizen_id)).one()
def get_all_citizens_in_import(import_id):
return session.query(Citizen).filter(Citizen.import_id == import_id).all()