我正在尝试将产品描述保存到MySQL数据库中。到目前为止,我已经尝试将数据类型更改为BLOB、LONGBLOB、TEXT、LONGTEXT,但不起作用。
import bs4
from urllib.request import urlopen as uReq
from bs4 import BeautifulSoup as soup
import mysql.connector
cnx = mysql.connector.connect(user='root', password='Kradz579032!!',
host='127.0.0.1',
database='aliexpressapidb')
cursor = cnx.cursor()
add_data = ("INSERT INTO productdetails"
"(description) "
"VALUES (%s)")
my_url = 'https://www.aliexpress.com/item/Cheap-Necklace-Jewelry-Alloy-Men-Vintage-Personality-Pendant-Creativity-Simple-Accessories-Symbol-Necklace-Wholesale-Fashion/32879629913.html?spm=a2g01.11147086.layer-iabdzn.4.4a716140Ix00VA&scm=1007.16233.91830.0&scm_id=1007.16233.91830.0&scm-url=1007.16233.91830.0&pvid=acdbf117-c0fb-458f-b8a9-ea73bc0d174b'
uClient = uReq(my_url)
page_html = uClient.read()
uClient.close()
page_soup = soup(page_html, "html.parser")
description = page_soup.findAll("div", {"class": "ui-box-body"})
#print(description)
data_insert = description
cursor.execute(add_data, data_insert)
cnx.commit()
cursor.close()
cnx.close()
不断收到错误:
文件类型第160行,返回getattr( to_mysql,“_{0}_to_mysql”.format(Type_name))(值) AttributeError:'MySQLConverter‘对象没有属性'_tag_to_mysql’"MySQL type".format(type_name)) TypeError: Python 'tag‘无法转换为MySQL类型
发布于 2018-06-07 05:48:08
根据@MicahB的建议,通过将html数据转换为字符串解决了问题。
tostring =str(数据)
发布于 2020-04-29 19:43:47
maindiv = str(soup.find("body"))
这将以字符串形式返回body标记html。
sql = "UPDATE `abc` SET `html` = %s WHERE `abc`.`id` = %s"
val = (maindiv,1)
mycursor.execute(sql, val)
mydb.commit()
上面的代码更新记录
https://stackoverflow.com/questions/50728615
复制相似问题