def by_email(cls, email):
return dbSession.query(cls).filter_by(email=email).first()
def all(cls):
return dbSession.query(cls).all() # 查询所有
def by_tret_id(cls, tret_id):
return dbSession.query(cls).filter_by(tret_id=tret_id).first() # 通过字段查询
def by_category(cls, category):
return dbSession.query(cls).filter_by(category_content=category).all()
def by_uuid(cls, uuid):
return dbSession.query(cls).filter_by(uuid=uuid).first()
def by_category(cls, category_id):
return dbSession.query(cls).filter_by(category_id=category_id).all()
def by_hash(cls, other_dates_hash):
return dbSession.query(cls).filter_by(
_file_hash=other_dates_hash).first()
def by_name(cls, name):
return dbSession.query(cls).filter_by(
username=name).first() #filter_by = where
def by_password(cls, password):
return dbSession.query(cls).filter_by(_password=password).first()
def by_id(cls, id):
return dbSession.query(cls).filter_by(id=id).one()
def by_mobile_one(cls, mobile):
return dbSession.query(cls).filter_by(phone_number=mobile)
def by_hous_id(cls, id):
return dbSession.query(cls).filter_by(hous_id=id).first()
def by_IDcard(cls, IDcard):
return dbSession.query(cls).filter_by(IDcard=IDcard).first() # 通过字段查询
def by_doctor(cls, doctor):
return dbSession.query(cls).filter_by(doctor=doctor)
def by_tag(cls, tag_id):
article = dbSession.query(Tag).filter(Tag.id == tag_id).first()
return article.articles
def get_contact_list(self):
contact = Contact.all()
count = dbSession.query(func.count(Contact.id)).scalar()
return contact, count
def all_createtime_desc(cls):
return dbSession.query(cls).order_by(cls.createtime.desc()).all()
def by_id(cls, id):
try:
return dbSession.query(cls).filter_by(id=id).first()
except Exception as e:
pass
def by_userid(cls, user_id):
return dbSession.query(cls).filter_by(user_id=user_id).all()
def get_list_lib(self):
all_set = dbSession.query(Setting).order_by(
Setting.createtime.desc()).first()
return all_set
def display_file_list(cls):
return dbSession.query(cls).filter(cls._locked == False).all()
def Commnets_list_lib(self):
counts = dbSession.query(func.count(Comment.id)).scalar()
Comments = Comment.all()
return counts, Comments
def get_bolg_list_lib(self):
blogs = Blog.all()
count = dbSession.query(func.count(Blog.id)).scalar()
return count, blogs
def order_by(cls, args):
return dbSession.query(cls).order_by(args).all()
def by_name(cls, name):
return dbSession.query(cls).filter_by(name=name).first()
def get_article_list_lib(self):
counts = dbSession.query(func.count(Article.id)).scalar()
articles = Article.all()
return articles, counts
def by_id(cls, id):
return dbSession.query(cls).filter_by(id=id).first() # 通过字段查询
def get_user_info(self):
"""获取用户信息"""
user = User.all()
counts = dbSession.query(func.count(User.id)).scalar()
return user,counts
