寻求帮助qwq，Python爬虫数据不能上传到mysql中

爬虫代码

from selenium import webdriver
from selenium.webdriver.chrome.service import Service
from selenium.webdriver.common.by import By
import csv
import os
import time
import json
import django
import pandas as pd
os.environ.setdefault('DJANGO_SETTINGS_MODULE','boss直聘毕业设计.settings')
django.setup()
from myApp.models import JobInfo

# service = Service('./chromedriver.exe')
# options = webdriver.ChromeOptions()
# options.add_experimental_option('excludeSwitches',['enable-automation'])
# brower = webdriver.Chrome(service=service,options=options)

class spider(object):
    def __init__(self,type,page):
        self.type = type # 岗位关键字
        self.page = page # 页码数
        self.spiderUrl = 'https://www.zhipin.com/web/geek/job?query=%s&city=100010000&page=%s'

    def startBrower(self):
        service = Service('./chromedriver.exe')
        options = webdriver.ChromeOptions()
        # options.add_experimental_option('debuggerAddress','localhost:9222')
        options.add_experimental_option('excludeSwitches',['enable-automation'])
        brower = webdriver.Chrome(service=service,options=options)
        return brower

    def main(self,page):
        if self.page > page:return
        brower = self.startBrower()
        print("正在爬取页面路径:" + self.spiderUrl % (self.type,self.page))
        brower.get(self.spiderUrl % (self.type,self.page))
        time.sleep(15)
        job_list = brower.find_elements(by=By.XPATH,value='//ul[@class="job-list-box"]/li') # 30个li
        for index,job in enumerate(job_list):
            try:
                jobData = []
                print('正在爬取第 %d 个数据' % (index + 1))
                # title
                title = job.find_element(by=By.XPATH,value=".//a[@class='job-card-left']/div[contains(@class,'job-title')]/span[@class='job-name']").text
                # print(title)
                # address
                addresses =job.find_element(by=By.XPATH,value=".//a[@class='job-card-left']/div[contains(@class,'job-title')]/span[@class='job-area-wrapper']/span").text.split('·')
                address = addresses[0]
                # dist
                if len(addresses) != 1:
                    dist=addresses[1]
                else:
                    dist = ''

                # print(address,dist)
                # type
                type = self.type

                tag_list = job.find_elements(by=By.XPATH,value=".//a[@class='job-card-left']/div[contains(@class,'job-info')]/ul[@class='tag-list']/li")
                if len(tag_list) == 2:
                    # educational
                    educational = tag_list[1].text
                    # workExperience
                    workExperience = tag_list[0].text
                else:
                    # educational
                    educational = tag_list[2].text
                    # workExperience
                    workExperience = tag_list[1].text

                # hrName
                hrName = job.find_element(by=By.XPATH,value=".//a[@class='job-card-left']/div[contains(@class,'job-info')]/div[@class='info-public']").text
                # hrWork
                hrWork = job.find_element(by=By.XPATH,value=".//a[@class='job-card-left']/div[contains(@class,'job-info')]/div[@class='info-public']/em").text

                # print(educational,workExperience,hrName,hrWork)

                # workTag
                workTag = job.find_elements(by=By.XPATH,value='./div[contains(@class,"job-card-footer")]/ul[@class="tag-list"]/li')
                workTag = json.dumps(list(map(lambda x:x.text,workTag)))

                # pratice
                pratice = 0


                salaries = job.find_element(by=By.XPATH,value=".//a[@class='job-card-left']/div[contains(@class,'job-info')]/span[@class='salary']").text
                if salaries.find('K') != -1:
                    salaries = salaries.split('·')
                    if len(salaries) == 1:
                        # salary
                        salary = list(map(lambda x: int(x) *1000,salaries[0].replace('K','').split('-')))
                        # salaryMonth
                        salaryMonth = '0薪'
                    else:
                        salary = list(map(lambda x: int(x) *1000,salaries[0].replace('K', '').split('-')))
                        # salaryMonth
                        salaryMonth = salaries[1]
                else:
                    # salary
                    salary = list(map(lambda x: int(x), salaries.replace('元/天', '').split('-')))
                    # salaryMonth
                    salaryMonth = '0薪'
                    pratice = 1
                # print(workTag,salary,salaryMonth,pratice)

                # companyTitle
                companyTitle = job.find_element(by=By.XPATH,value=".//div[@class='job-card-right']/div[@class='company-info']/h3/a").text
                # companyAvatar
                companyAvatar = job.find_element(by=By.XPATH,value=".//div[@class='job-card-right']/div[@class='company-logo']/a/img").get_attribute("src")

                cmopanyInfos = job.find_elements(by=By.XPATH,value=".//div[@class='job-card-right']/div[@class='company-info']/ul[@class='company-tag-list']/li")
                if len(cmopanyInfos) == 3:
                    # companyNature
                    companyNature = cmopanyInfos[0].text
                    # companyStatus
                    companyStatus = cmopanyInfos[1].text
                    # companyPeople
                    companyPeople = cmopanyInfos[2].text
                    if cmopanyInfos != '10000人以上':
                        companyPeople = list(map(lambda x: 10000 if x == '10000以上' else int(x), cmopanyInfos[2].text.replace('人', '').split('-')))
                    else:
                        companyPeople = [0,10000]
                else:
                    # companyNature
                    companyNature = cmopanyInfos[0].text
                    # companyStatus
                    companyStatus = '未融资'
                    # companyPeople
                    companyPeople = cmopanyInfos[1].text
                    if cmopanyInfos != '10000人以上':
                        companyPeople = list(map(lambda x: int(x), cmopanyInfos[1].text.replace('人', '').split('-')))
                    else:
                        companyPeople = [0, 10000]

                # companyTags
                companyTags = job.find_element(by=By.XPATH,value='./div[contains(@class,"job-card-footer")]/div[@class="info-desc"]').text
                if not companyTags:
                    companyTags = '无'
                else:
                    companyTags = json.dumps(companyTags.split('，'))

                # detailUrl
                detailUrl = job.find_element(by=By.XPATH,value=".//a[@class='job-card-left']").get_attribute('href')

                # companyUrl
                companyUrl = job.find_element(by=By.XPATH,value=".//div[@class='job-card-right']/div[@class='company-info']/h3/a").get_attribute('href')

                # print(companyTitle,companyAvatar,companyNature,companyStatus,companyPeople,companyTags,detailUrl,companyUrl)

                # print(title,address,type,educational,workExperience,workTag,salary,salaryMonth,
                #       companyTags,hrWork,hrName,pratice,companyTitle,companyAvatar,companyNature,
                #       companyStatus,companyPeople,detailUrl,companyUrl,dist)

                jobData.append([title])
                jobData.append([address])
                jobData.append([type])
                jobData.append([educational])
                jobData.append([workExperience])
                jobData.append([workTag])
                jobData.append([salary])
                jobData.append([salaryMonth])
                jobData.append([companyTags])
                jobData.append([hrWork])
                jobData.append([hrName])
                jobData.append([pratice])
                jobData.append([companyTitle])
                jobData.append([companyAvatar])
                jobData.append([companyNature])
                jobData.append([companyStatus])
                jobData.append([companyPeople])
                jobData.append([detailUrl])
                jobData.append([companyUrl])
                jobData.append([dist])


                self.save_to_csv(jobData)

            except:
                pass

        self.page += 1
        self.main(page)

    def clear_csv(self):
        df = pd.read_csv('./temp.csv')
        df.dropna(inplace=True)
        df.drop_duplicates(inplace=True)
        df['salaryMonth'] = df['salaryMonth'].map(lambda x:x.replace('薪',''))
        print("总数据为%d" % df.shape[0])
        return df.values

    def save_to_sql(self):
        data = self.clear_csv()
        for job in data:
            JobInfo.objects.create(
                title=job[0],
                address=job[1],
                type=job[2],
                educational=job[3],
                workExperience=job[4],
                workTag=job[5],
                salary=job[6],
                salaryMonth=job[7],
                companyTags=job[8],
                hrWork=job[9],
                hrName=job[10],
                pratice=job[11],
                companyTitle=job[12],
                companyAvatar=job[13],
                companyNature=job[14],
                companyStatus=job[15],
                companyPeople=job[16],
                detailUrl=job[17],
                companyUrl=job[18],
                dist=job[19]
            )
            os.remove("./temp.csv")



    def save_to_csv(self,rowData):
        with open('./temp.csv','a',newline='',encoding='utf8') as wf:
            writer = csv.writer(wf)
            writer.writerow(rowData)

    def init(self):
        if not os.path.exists('./temp.csv'):
            with open('./temp.csv','a',newline='',encoding='utf8') as wf:
                writer = csv.writer(wf)
                writer.writerow(
                    ["title","address","type","educational","workExperience","workTag","salary","salaryMonth",
                     "companyTags","hrWork","hrName","pratice","companyTitle","companyAvatar","companyNature",
                     "companyStatus","companyPeople","detailUrl","companyUrl","dist"])

if __name__ == "__main__":
    spiderObj = spider('java',1)
    # spiderObj.init()
    # spiderObj.main(10)
    spiderObj.save_to_sql()

modles代码

from django.db import models

# Create your models here.

class JobInfo(models.Model):
    id = models.AutoField('id',primary_key=True)
    title = models.CharField('岗位名字',max_length=255,default='')
    address = models.CharField('省会',max_length=255,default='')
    type = models.CharField('岗位',max_length=255,default='')
    educational = models.CharField('学历',max_length=255,default='')
    workExperience = models.CharField('工作经验',max_length=255,default='')
    workTag = models.CharField('工作标签',max_length=2555,default='')
    salary = models.CharField('薪资',max_length=255,default='')
    salaryMonth = models.CharField('年终奖',max_length=255,default='')
    companyTags = models.CharField('公司福利',max_length=2555,default='')
    hrWork = models.CharField('人事职位',max_length=255,default='')
    hrName = models.CharField('人事名字',max_length=255,default='')
    pratice = models.BooleanField('是否是实习单位',max_length=255,default='')
    companyTitle = models.CharField('公司名称',max_length=255,default='')
    companyAvatar = models.CharField('公司头像',max_length=255,default='')
    companyNature = models.CharField('公司性质',max_length=255,default='')
    companyStatus = models.CharField('公司状态',max_length=255,default='')
    companyPeople = models.CharField('公司人数',max_length=255,default='')
    detailUrl = models.CharField('详情地址',max_length=2555,default='')
    companyUrl = models.CharField('公司详情地址',max_length=2555,default='')
    creatTime = models.DateField('创建时间',auto_now_add=True)
    dist = models.CharField('行政区',max_length=255,default='')

    is_valid = models.BooleanField(default=False)
    class Meta:
        db_table = "jobInfo"

class User(models.Model):
    id = models.AutoField('id',primary_key=True)
    username = models.CharField('用户名',max_length=255,default='')
    password = models.CharField('密码',max_length=255,default='')
    educational = models.CharField('学历',max_length=255,default='')
    workExpirence = models.CharField('工作经验',max_length=255,default='')
    address = models.CharField('意向城市',max_length=255,default='')
    work = models.CharField('意向岗位',max_length=255,default='')
    avatar = models.FileField('用户头像',upload_to="avatar",default='avatar/default.png')
    creatTime = models.DateField('创建时间',auto_now_add=True)

    class Meta:
        db_table = "user"

class History(models.Model):
    id = models.AutoField('id',primary_key=True)
    job = models.ForeignKey(JobInfo,on_delete=models.CASCADE)
    user = models.ForeignKey(User,on_delete=models.CASCADE)
    count = models.IntegerField("点击次数",default=1)
    class Meta:
        db_table = "histroy"