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()