def search(self, keywords):
criteria = []
for keyword in keywords.split():
keyword = '%' + keyword + '%'
criteria.append(db.or_(Machine.name.ilike(keyword),
Machine.description.ilike(keyword),
Machine.id.ilike(keyword)))
q = reduce(db.and_, criteria)
return self.filter(q).distinct()
def search(self, keywords):
criteria = []
for keyword in keywords.split():
keyword = '%' + keyword + '%'
criteria.append(
db.or_(User.username.ilike(keyword), User.email.ilike(keyword),
User.id.ilike(keyword)))
q = reduce(db.and_, criteria)
return self.filter(q).distinct()
def search(self, keywords):
criteria = []
for keyword in keywords.split():
keyword = '%' + keyword + '%'
criteria.append(db.or_(User.username.ilike(keyword),
User.email.ilike(keyword),
User.id.ilike(keyword)))
q = reduce(db.and_, criteria)
return self.filter(q).distinct()
def search(self, keywords):
criteria = []
for keyword in keywords.split():
keyword = '%' + keyword + '%'
criteria.append(db.or_(Code.name.ilike(keyword),
Code.description.ilike(keyword),
Code.id.ilike(keyword),
Code.related_module.ilike(keyword)))
q = reduce(db.and_, criteria)
return self.filter(q).distinct().order_by(Code.id.desc())
def search(self, keywords):
criteria = []
for keyword in keywords.split():
keyword = '%' + keyword + '%'
criteria.append(
db.or_(Machine.name.ilike(keyword),
Machine.description.ilike(keyword),
Machine.id.ilike(keyword)))
q = reduce(db.and_, criteria)
return self.filter(q).distinct()
def search(self, keywords):
criteria = []
for keyword in keywords.split():
keyword = '%' + keyword + '%'
criteria.append(
db.or_(Code.name.ilike(keyword),
Code.description.ilike(keyword), Code.id.ilike(keyword),
Code.related_module.ilike(keyword)))
q = reduce(db.and_, criteria)
return self.filter(q).distinct().order_by(Code.id.desc())
def authenticate(self, login, password):
user = self.filter(db.or_(User.username == login,
User.email == login)).first()
if user and user.status:
authenticated = user.check_password(password)
else:
authenticated = False
return user, authenticated
def authenticate(self, login, password):
user = self.filter(db.or_(User.username == login,
User.email == login)).first()
if user and user.status:
authenticated = user.check_password(password)
else:
authenticated = False
return user, authenticated
def search(self, keywords, user=None):
criteria = []
if user and user.is_moderator:
for keyword in keywords.split():
keyword = '%' + keyword + '%'
criteria.append(db.or_(Case.title.ilike(keyword),
Case.description.ilike(keyword),
Case.id.ilike(keyword)))
else:
for keyword in keywords.split():
keyword = '%' + keyword + '%'
criteria.append(db.or_(db.and_(db.or_(Case.title.ilike(keyword),
Case.description.ilike(keyword),
Case.id.ilike(keyword)),
Case.access == Case.PUBLIC),
db.and_(db.or_(Case.title.ilike(keyword),
Case.description.ilike(keyword),
Case.id.ilike(keyword)),
Case.author_id == user.id)))
q = reduce(db.and_, criteria)
return self.filter(q).distinct().order_by(Case.id.desc())
