def get_result(self, now): """ get category by content numbers """ sql = "select count(*) as content_num, category_id as categoryId from news_info_201710\ where create_time > \'%s\' group by categoryId" % (now) try: with session_cpu_cc() as session: results = session.execute(sql).fetchall() if results is not None: return results except Exception as e: self.logger.exception("get_results %s" % str(e))
def get_result(self, now): """ get news number by online """ sql = "select count(*) as \ newsnum from news_info\ where create_time > \'%s\' and status =3"\ %(now) print sql try: with session_cpu_cc() as session: results = session.execute(sql).fetchall() if results is not None: return results except Exception as e: self.logger.exception("get_results %s" % str(e))
def get_result(self, now): """ get news number by source name """ sql = "select content_num, source_name from (select count(*) as \ content_num, source_name from news_info_201710\ where create_time > \'%s\' and status =3 group by source_name) as b order \ by content_num desc limit 100"\ %(now) print sql try: with session_cpu_cc() as session: results = session.execute(sql).fetchall() if results is not None: return results except Exception as e: self.logger.exception("get_results %s" % str(e))
def get_quality(self, now): """ get content numbers by quality_level with copyright """ sql = "select count(*) as content_num, quality_level from \ (select news_info.id, news_profile.quality_level \ from news_info join news_profile on \ news_info.id = news_profile.news_id where news_info.has_copyright = 1 and \ news_info.create_time > \'%s\') as b group by quality_level"\ %(now) try: with session_cpu_cc() as session: results = session.execute(sql).fetchall() if results is not None: return results except Exception as e: self.logger.exception("get_quality %s" % str(e))