def find_defcon_villages(cls, num):
l = DBSession.query(cls).filter(cls.id == num).join(cls.cve).filter(CVEBase.type == 'village').options(contains_eager('cve')).all()
if len(l) == 0:
return None
return l[0]
def validate_user_password(cls, username, password):
user = DBSession.query(cls).options(noload(cls.groups)).filter(cls.username == username.lower()).first()
if user is None:
return None
manager = BCRYPTPasswordManager()
if manager.check(user.credentials, password):
return user
return None
def find_tickets(cls, cve_id):
return DBSession.query(cls).filter(cls.cve_id == cve_id).order_by(cls.created.asc()).all()
def count_tickets(cls, cve_id):
return DBSession.query(func.count(cls.id)).filter(cls.cve_id == cve_id).all()
def find(cls, type, value):
return DBSession.query(cls).filter(cls.type == type, cls.name == value.lower()).first()
def find_group_by_id(cls, id):
return DBSession.query(cls).get(id)
def find_group(cls, name):
return DBSession.query(cls).filter(cls.name == name).first()
def find_user_by_email(cls, email):
return DBSession.query(cls).filter(cls.email == email.lower()).first()
def find_user_no_groups(cls, username):
return DBSession.query(cls).options(noload(cls.groups)).filter(cls.username == username.lower()).first()
def find_user(cls, username):
return DBSession.query(cls).filter(cls.username == username.lower()).first()
def find_ticket_username(cls, ticket, username):
return DBSession.query(cls).join(User, and_(User.username == username.lower(), User.id == cls.user_id)).filter(cls.ticket == ticket).options(contains_eager('user')).first()
def find_defcon(cls, num):
return DBSession.query(cls).filter(cls.id == num).first()
