问题!我的脚本工作了一次,然后产生了这样一个错误
IntegrityError at /index/
UNIQUE constraint failed: scraping_vacancy.title
Request Method: GET
Request URL: http://127.0.0.1:8000/index/
Django Version: 3.0.5
Exception Type: IntegrityError
Exception Value:
UNIQUE constraint failed: scraping_vacancy.title
Exception Location: /Users/dmitrigornakov/Documents/Django/parser/venv/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py in execute, line 396
Python Executable: /Users/dmitrigornakov/Documents/Django/parser/venv/bin/python
Python Version: 3.8.2
代码源:https://github.com/visualGravitySense/parser
views.py文件中的代码:
from django.shortcuts import render
from scraping.utils import *
from scraping.models import *
def home(request):
jobs = djinni()
city = City.objects.get(name='Kyiv')
speciality = Speciality.objects.get(name='Python')
v = Vacancy.objects.filter(city=city, speciality=speciality).values('url')
url_list = [i['url'] for i in v]
for job in jobs:
if job['href'] not in url_list:
vacancy = Vacancy(city=city, speciality=speciality, url=job['href'], title=job['title'], description=job['descript'], company=job['company'])
vacancy.save()
return render(request, 'base.html', {'jobs': jobs})
如果不需要标题的唯一约束,请在刮取文件夹中的models.py中将其删除:
更改后,不要忘记执行
python manage.py makemigrations
在
python manage.py migrate scraping 00XX
之后(其中00XX是make migrations提供的迁移数)相关问题 更多 >
编程相关推荐