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