def get_users_query_with_keywords(query, keywords):
keywords_filter = create_filter_matching_all_keywords_in_any_model(
user_ts_filter, keywords)
query = query.outerjoin(UserTag)\
.outerjoin(Tag)\
.filter(keywords_filter)
return query
def get_reviews_query_with_keywords(query, keywords):
keywords_filter = create_filter_matching_all_keywords_in_any_model(
review_ts_filter,
keywords
)
query = query.filter(keywords_filter)
return query
def keep_verdict_with_keywords(query, keywords):
query = query.outerjoin(VerdictTag) \
.outerjoin(Tag) \
.join(User)
keywords_filter = create_filter_matching_all_keywords_in_any_model(
VERDICT_TS_FILTER, keywords)
query = query.filter(keywords_filter)
return query
def _filter_bookings_with_keywords_string(query : Query, keywords_string: str) -> Query:
keywords_filter = create_filter_matching_all_keywords_in_any_model(
get_filter_matching_ts_query_for_booking,
keywords_string
)
query = query \
.outerjoin(Product) \
.outerjoin(Venue) \
.filter(keywords_filter) \
.reset_joinpoint()
return query
def filter_offers_with_keywords_string(query, keywords_string):
get_filter_matching_ts_query_for_offer = create_get_filter_matching_ts_query_in_any_model(
Offer,
Venue,
Offerer
)
keywords_filter = create_filter_matching_all_keywords_in_any_model(
get_filter_matching_ts_query_for_offer,
keywords_string
)
query = query.filter(keywords_filter)
query = _order_by_offer_name_containing_keyword_string(keywords_string, query)
return query
def keep_contents_with_keywords(query, keywords):
keywords_filter = create_filter_matching_all_keywords_in_any_model(
CONTENT_TS_FILTER, keywords)
query = query.filter(keywords_filter)
return query
def filter_offerers_with_keywords_string(query, keywords_string):
keywords_filter = create_filter_matching_all_keywords_in_any_model(
get_filter_matching_ts_query_for_offerer, keywords_string)
query = query.filter(keywords_filter)
return query
