def get_user_info(): value = int(request.args['value']) # 根据用户昵称或易号查询对应的用户 data = User.query.filter( or_(User.user_no == value, User.user_nick_name == value)).first() if data: data = data.to_json() else: data = Ylgroup.query.filter_by(group_no=value).first() if data: data = data.to_json() else: return ret_error('用户或群不存在') return ret_sucess('获取成功', data)
def search(cls, query): """ Search a resource by 1 or more fields. :param query: Search query :type query: str :return: SQLAlchemy filter """ if not query: return '' search_query = '%{0}%'.format(query) search_chain = (Synset.id == query, Synset.unitsstr.ilike(search_query)) return or_(*search_chain)
def search(cls, query): """ Search a resource by 1 or more fields. :param query: Search query :type query: str :return: SQLAlchemy filter """ if not query: return '' search_query = '%{0}%'.format(query) search_chain = (UnitAndSynsetTracker.sense_id.ilike(search_query), UnitAndSynsetTracker.synset_id.ilike(search_query)) return or_(*search_chain)
def search(cls, query): """ Search a resource by 1 or more fields. :param query: Search query :type query: str :return: SQLAlchemy filter """ if not query: return '' search_query = '%{0}%'.format(query) search_chain = (Tracker.datetime.ilike(search_query), Tracker.user.ilike(search_query)) return or_(*search_chain)
def search(cls, query): """ Search a resource by 1 or more fields. :param query: Search query :type query: str :return: SQLAlchemy filter """ if not query: return '' search_query = '%{0}%'.format(query) search_chain = (SynsetTracker.definition.ilike(search_query), SynsetTracker.comment.ilike(search_query), SynsetTracker.owner.ilike(search_query), SynsetTracker.unitstr.ilike(search_query)) return or_(*search_chain)