gpt4 book ai didi

mysql - PYTHON/MySQL : Check if Record exist. 如果存在则不插入,如果不存在则插入

转载 作者:行者123 更新时间:2023-11-29 21:57:17 24 4
gpt4 key购买 nike

首先检查网站的链接,然后获取所有链接。我需要帮助检查mysql,如果链接已经存在,如果存在则不要插入它们,如果其中一些不存在,则插入它们。

  created_at = time.strftime("%Y/%d/%m/ %H:%M:%S")
afdelings = 'it-support'

url = 'www.careerjet.dk/sog/jobs?s=L%C3%A6rling&l=Danmark'
r = requests.get("http://" +url)
data = r.text
soup = BeautifulSoup(data, "html.parser")
side1 = "http://www.careerjet.dk/"
cur = connect.cursor()

for link in soup.select('.title > a'):
linkfrom = side1 + (link.get('href'))
f = string.split(linkfrom, '\n')
for line in f:
if ("""SELECT count(*) from jobtest WHERE link = %s""", (line)) == 0:
cur.execute("""INSERT INTO jobtest (afdeling, dato, link) VALUES (%s, %s, %s)""", (afdelings, created_at, line))

with connect:
connect.commit()

connect.close()

请提供任何帮助,我们深表感谢。

最佳答案

您需要先执行选择。

像这样的事情

 created_at = time.strftime("%Y/%d/%m/ %H:%M:%S")
afdelings = 'it-support'

url = 'www.careerjet.dk/sog/jobs?s=L%C3%A6rling&l=Danmark'
r = requests.get("http://" +url)
data = r.text
soup = BeautifulSoup(data, "html.parser")
side1 = "http://www.careerjet.dk/"
cur = connect.cursor()

for link in soup.select('.title > a'):
linkfrom = side1 + (link.get('href'))
f = string.split(linkfrom, '\n')
for line in f:

#-------ADDED CODE
data_tmp = """SELECT count(*) from jobtest WHERE link = %s""", (line)
data_tmp = cur.fetchall()
#-------END ADDED CODE

if (data_tmp == 0 ) :
cur.execute("""INSERT INTO jobtest (afdeling, dato, link) VALUES (%s, %s, %s)""", (afdelings, created_at, line))

with connect:
connect.commit()

connect.close()

关于mysql - PYTHON/MySQL : Check if Record exist. 如果存在则不插入,如果不存在则插入,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/33016069/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com