repository.py 文件源码

def tweets_for_month(self, year, month_number):
        start_date = arrow.Arrow(year, month_number, 1)
        end_date = start_date.shift(months=+1)

        query = """
           SELECT twitter_id, text, timestamp FROM tweets
                WHERE (timestamp > ?) AND (timestamp < ?)
                ORDER BY twitter_id ASC
        """
        for row in self.query_many(query,
                                   start_date.timestamp,
                                   end_date.timestamp):
            yield self.tweet_from_row(row)