def login(username): '''查询''' t = datetime.now() print('user:{}login at {} '.format(username,t)) session.query(User).filter_by(name=username).update({User.last_login}) session.commit()
def get_post_for(username): """ 获取用户图片列表 """ user = session.query(User).filter_by(name=username).first() posts = session.query(Post).filter_by(user=user) return posts
def add_id_for_likes(username, post_id): """给likes表添加数据""" p = session.query(User).filter_by(name=username).first() p1 = session.query(Post).filter_by(id=post_id).first() if p.id != p1.user_id: Like.add(user_id=p.id, post_id=post_id) else: return False
def login(username): """ 记录用户登入时间, 并保存的数据库的last_login """ t = datetime.now() print("user: {} login at {}".format(username, t)) user_query = session.query(User).filter_by(name=username) session.query(User).filter_by(name=username).update({User.last_login: t}) session.commit()
def get_user_like_img(username): """通过用户名获得用户关注图片的地址""" u = session.query(User).filter_by(name=username).first() # print(u.id) p = session.query(Like).filter_by(user_id=u.id).all() # print(p) ret = [] for i in p: print(i.post_id) a = session.query(Post).filter_by(id=i.post_id).first() ret.append(a.img_url) return ret
def get_post_for(username): """ 通过用户名获取图片地址及时间 :param username: :return: """ user = session.query(User).filter_by(name=username).first() posts = session.query(Post).order_by(Post.id.desc()).filter_by(user=user, cancel_ud=0) ret = [] for p in posts: ret.append((p.img_url, p.created, p.id)) return ret
def get_img_url(post_id): """通过id获取图片地址""" print(post_id) p = session.query(Post).filter_by(id=post_id).first() print(p) img_url = p.img_url return img_url
def get_all_posts(): """ 得到所有的用户 :return: """ posts = session.query(Post).order_by(Post.id.desc()).all() return posts
def add_post_for(username, image_url, thumb_url): '''保存图片对应的用户信息和存储信息''' user = session.query(User).filter_by(name=username).first() post = Post(image_url=image_url, user=user, thumb_url=thumb_url) session.add(post) session.commit() return post.id
def get_post(post_id): """ 获取指定 id 的 post 对象. :param post_id: :return: """ post = session.query(Post).filter_by(id=post_id).scalar() return post
def get_post(post_id): """ 获取指定id的post :param post_id: :return: """ post = session.query(Post).get(post_id) return post
def add_post_for(username, image_url, thumb_url): """ 保存特定用户的图片 """ user = session.query(User).filter_by(name=username).first() post = Post(image_url=image_url, thumb_url=thumb_url, user=user) session.add(post) session.commit()
def get_post_username_created(post_id): """ 通过id获取用户名及时间 :param post_id: :return: """ p = session.query(Post).filter_by(id=post_id).first() ret = [p.user.name, p.created] print(ret) return ret
def get_like_posts(user): #获取用户喜欢的图片. if user: posts = session.query(Post).filter(Like.user_id == user.id, Post.id == Like.post_id, Post.id != user.id).all() else: posts = [] return posts
def get_post_for(username): """ 获取用户上传的图片. :param username: :return: """ user = session.query(User).filter_by(name=username).first() if user: return user.posts #反向查询. else: return []
def get_thumb_url(): """ 通过id获取缩略图地址 :return: """ thumb_urls = session.query(Post).order_by( Post.id.desc()).filter_by(cancel_ud=0).all() ret = [] for p in thumb_urls: ret.append((p.id, p.thumb_url)) print(ret) return ret
def add_post_for(username, image_url, thumb_url): ''' 保存特定用户的图片 :param username:用户名 :param image_url:上传图片的保存地址(static下的) :param thumb_url:缩略图的保存地址(static下的) :return: ''' user = session.query(User).filter_by(name=username).first() post = Post(image_url=image_url, thumb_url=thumb_url, user=user) session.add(post) session.commit() return post.id
def add_post_for(username, image_url, thumb_url): """ 保存用户上传的图片信息. :param username: :param image_url: :param thumb_url: :return: """ user = session.query(User).filter_by(name=username).first() post = Post(image_url=image_url, thumb_url=thumb_url, user=user) session.add(post) session.commit() return post
def login_time_update(username): t = datetime.now() # print("user:{} login at {}".format(username, t)) session.query(User).filter_by(name=username).update({User.last_login: t})
def query_rows_in_follows(user_id): """查询follows表数据""" rows = session.query(Follows).filter_by(user_id=user_id).all() return rows
def get_rows_in_userdetails(username): """获取userdetails表中行""" ud_row = get_rows_in_users(username) row = session.query(Userdetails).filter_by(user_id=ud_row.id).first() return row
def get_rows_in_users(username): """获取users表中行""" row = session.query(User).filter_by(name=username).first() return row
def is_exist(username, post_id): '''判断数据是否存在,返回True代表存在,反之不存在''' p = session.query(User).filter_by(name=username).first() user_id = p.id return Like.is_exist(user_id=user_id, post_id=post_id)
def drop(username, post_id): """删除likes表数据""" p = session.query(User).filter_by(name=username).first() Like.drop(user_id=p.id, post_id=post_id)
def img_count(post_id): """记录图片的关注次数""" p = session.query(Like).filter_by(post_id=post_id).all() return len(p)
def get_user_row(user_id): user_info = session.query(User).filter_by(id=user_id).first() return user_info
def get_user(username): user = session.query(User).filter_by(name=username).first() return user
def get_all_post(): #获取所有缩略图. posts = session.query(Post).order_by(Post.id.desc()).all() return posts
def get_like_count(post): #获取喜欢一张图片的用户数. count = session.query(Like).filter_by(post_id=post.id).count() return count