def search_by_name(cls, venue_name): venues = cls.query.filter(cls.name.ilike(f'%{venue_name}%')).all() return [{ "id": venue.id, "name": venue.name, "num_upcoming_shows": Show.count_upcoming_by_venue_id(venue.id) } for venue in venues]
def get_by_city_state(cls, state, city): state_venues = cls.query.filter_by(city=city, state=state).all() venues = [{ "id": venue.id, "name": venue.name, "num_upcoming_shows": Show.count_upcoming_by_venue_id(venue.id) } for venue in state_venues] return venues