def find_stocks_with_possible_filters(filters, user):
query = Stock.queryNotSoftDeleted()
if 'offererId' in filters:
query = query.filter(
Stock.offererId == dehumanize(filters['offererId']))
_check_offerer_user(query.first_or_404().offerer.query, user)
if 'hasPrice' in filters and filters['hasPrice'].lower() == 'true':
query = query.filter(Stock.price != None)
return query
def find_stocks_of_finished_events_when_no_recap_sent():
return Stock.queryNotSoftDeleted() \
.filter((Stock.bookingLimitDatetime < datetime.utcnow()) &
(Stock.beginningDatetime < datetime.utcnow()) &
(Stock.bookingRecapSent == None))
