def update_shout_counts():
"""
Counts total # of shouts for each user and each venue.
:return: None
:rtype: None
"""
venue_subquery = Checkin.select(pw.fn.COUNT(Checkin.id)).where(Checkin.venue == Venue.id)
venue_update = Venue.update(shout_count=venue_subquery)
venue_update.execute()
user_subquery = Checkin.select(pw.fn.COUNT(Checkin.id)).where(Checkin.user == User.id)
user_update = User.update(shout_count=user_subquery)
user_update.execute()
