model.py 文件源码

def get_bikes_for_week(cls, dbsession, station_id):
        """as method name describes.
        similar to methods above but averaged over week."""
        station = [("Day", "Available Bikes")]
        station_data = dbsession.query(func.weekday(cls.last_update),
                                       func.avg(cls.available_bikes)) \
            .filter(cls.station_id == station_id) \
            .group_by(func.weekday(cls.last_update)) \
            .all()

        # this section parses the query return into a readable list.
        # from docs:extend() appends the contents of seq to list.
        if station_data:
            station.extend([(days[a], float(b)) for a, b in station_data])
        else:
            station.extend([(0,0)])

        return station