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
