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
