Exemple #1
0
 def get_latest_videos(self, total=6):
     """
     :param total: 需要的数量
     :return: 获取到的图
     """
     sql = 'SELECT * FROM bai_video ORDER BY publishTime DESC LIMIT {0}'.format(
         total)
     CrawlerLogger.logger.info("get latest {0} videos SQL: {1}".format(
         str(total), sql))
     MysqlLogger.logger.info("get latest {0} videos SQL: {1}".format(
         str(total), sql))
     video_records = self.db.query(sql)
     videos = Video.to_videos(video_records)
     if len(videos) < total:
         CrawlerLogger.logger.warning(
             'Not enough videos, all videos have been gotten.')
         MysqlLogger.logger.info(
             'Not enough videos, all videos have been gotten.')
     # print '===first video===\n', videos[0].__str__(), '\n======',
     return videos  # <type 'list'>