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