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))