疫情可视化大屏的实现

主要是对热搜榜的词进行爬取。

# -*- coding:utf-8 -*-

import time
import pymysql
import string
from jieba.analyse import extract_tags

def get_time():
    time_str = time.strftime("%Y{}%m{}%d{} %X")
    return time_str.format("年","月","日")

# 连接数据库
def get_conn():
    conn = pymysql.connect(
        host="localhost",
        user="root",
        password="12345678",
        db="yiqing",
        charset="utf8",
        port=3306,
    )
    # 创建游标：
    cursor = conn.cursor()
    return conn, cursor

def close_conn(conn, cursor):
    if cursor:
        cursor.close()
    if conn:
        conn.close()

def query(sql, *args):
    '''
    :param sql:
    :param args:
    :return:返回结果，((),())形式
    '''
    conn, cursor= get_conn()
    cursor.execute(sql, args)
    res = cursor.fetchall() # 获取结果
    close_conn(conn, cursor)
    return res

def get_c1_data():
    sql = "select sum(confirm)," \
    "(select suspect from history order by ds desc limit 1)," \
    "sum(he