Esempio n. 1
0
def storage_mysql():
    # 获取所有数据
    gzbd_all_data = gzbd.gzbd_spider.gzbd_all_data()

    for item in gzbd_all_data:
        epidemic_date = item["日期"]
        # build sql语句:根据时间查询,插入语句
        query_sql = "select * from gzbd_epidemic where date = %s" % (
            epidemic_date, )
        insert_sql = "insert into gzbd_epidemic (region, date, diagnosis, overseas_import, cure, " \
                     "death, therapy, observation) values ('%s', '%s', %s, %s, %s, %s, %s, %s)" % \
                     (item["地区"], item["日期"], item.get("确诊数", None), item.get("境外输入数", None), item.get("治愈数", None),
                      item.get("死亡数", None), item.get("隔离数", None), item.get("观察数", None))
        insert_sql = insert_sql.replace("None", "Null")
        print(insert_sql)
        # 查询数据,判断是否需要插入
        conn, cur = mysql_util.get_connect_cursor()
        result = mysql_util.execute_(query_sql)
        if len(result) == 0:
            # 插入数据
            result = mysql_util.execute_(insert_sql)
            if result > 0:
                print("ok")
            else:
                print("error")
Esempio n. 2
0
def get_gzbd_data():
    sql = "select * from gzbd_epidemic order by date desc"
    return mysql_util.execute_(sql)