關(guān)于抓取回來的網(wǎng)頁數(shù)據(jù)保存失敗問題???
獲取保存的頁面數(shù)據(jù)
content?=?soup.find_all('div',{'class':'single-content'})
pymysqlcon?=?pymysql.connect( ????????host='127.0.0.1', ????????user='root', ????????password='root', ????????db='spider', ????????charset="utf8mb4" ????)
try: ????with?pymysqlcon.cursor()?as?cursor: ????????sql?=?"insert?into?`content`(`content`)?values(%s)" ????????cursor.execute(sql,(content)) ????????pymysqlcon.commit() finally: ????pymysqlcon.close()
報錯以下:
Traceback (most recent call last):
? File "D:/pycharm/index.py", line 33, in <module>
? ? cursor.execute(sql,(content))
? File "D:\Python\lib\site-packages\pymysql\cursors.py", line 168, in execute
? ? query = self.mogrify(query, args)
? File "D:\Python\lib\site-packages\pymysql\cursors.py", line 147, in mogrify
? ? query = query % self._escape_args(args, conn)
? File "D:\Python\lib\site-packages\pymysql\cursors.py", line 122, in _escape_args
? ? return tuple(conn.literal(arg) for arg in args)
? File "D:\Python\lib\site-packages\pymysql\cursors.py", line 122, in <genexpr>
? ? return tuple(conn.literal(arg) for arg in args)
? File "D:\Python\lib\site-packages\pymysql\connections.py", line 846, in literal
? ? return self.escape(obj, self.encoders)
? File "D:\Python\lib\site-packages\pymysql\connections.py", line 839, in escape
? ? return converters.escape_item(obj, self.charset, mapping=mapping)
? File "D:\Python\lib\site-packages\pymysql\converters.py", line 27, in escape_item
? ? val = encoder(val, mapping)
? File "D:\Python\lib\site-packages\pymysql\converters.py", line 118, in escape_unicode
? ? return u"'%s'" % _escape_unicode(value)
? File "D:\Python\lib\site-packages\pymysql\converters.py", line 73, in _escape_unicode
? ? return value.translate(_escape_table)
TypeError: 'NoneType' object is not callable
2018-06-13
我覺得應(yīng)該是數(shù)據(jù)類型問題,請問要怎么處理