数据导入

import pymysql
import time

# 保存数据到数据库  
conn = pymysql.connect(host="localhost",user="root",passwd="820521",db="health",charset="utf8") # 需要配置你的数据库密码


def saveSportsData( data ):

    cur = conn.cursor()
    for name,img,detail in data:
        insert = "INSERT INTO `home_sport`( name, img, video, skill, info) VALUES( '%s', '%s', '%s', '%s','%s')"\
        %(name,  img, detail[0], detail[1], detail[2].replace("'","\'") )
        print(  name,insert )
        cur.execute(insert)
        conn.commit()

    cur.close()
    print("========All Finished==========")



def saveFoodData( catg, data ):
    current_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())  
    cur = conn.cursor()
    for name,img,item in data:
        insert = "INSERT INTO `home_food`(catg_id, name, img, heat,protein,carbon,zhi, detail ) VALUES( %s, '%s', '%s','%s','%s', '%s', '%s','%s')"\
        %(  catg, name, img, item[0], item[1],item[2],item[3],item[4].replace("'","\'") )
        print(  name  )
        cur.execute(insert)
        conn.commit()

    cur.close()
    print("========All Finished==========")