Guest User

Untitled

a guest
Apr 23rd, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.52 KB | None | 0 0
  1. Traceback (most recent call last):
  2. File "C:ProgramDataAnaconda3libsite-packagesMySQLdbcursors.py", line 238, in execute
  3. query = query % args
  4. TypeError: not all arguments converted during string formatting
  5.  
  6. During handling of the above exception, another exception occurred:
  7.  
  8. Traceback (most recent call last):
  9. File "D:/Учеба/Диплом/parsers/smartphone/test10.py", line 309, in <module>
  10. start_parse_object()
  11. File "D:/Учеба/Диплом/parsers/smartphone/test10.py", line 177, in start_parse_object
  12. for _ in executor.map(parse_object, object_urls):
  13. File "C:ProgramDataAnaconda3libconcurrentfutures_base.py", line 586, in result_iterator
  14. yield fs.pop().result()
  15. File "C:ProgramDataAnaconda3libconcurrentfutures_base.py", line 432, in result
  16. return self.__get_result()
  17. File "C:ProgramDataAnaconda3libconcurrentfutures_base.py", line 384, in __get_result
  18. raise self._exception
  19. File "C:ProgramDataAnaconda3libconcurrentfuturesthread.py", line 56, in run
  20. result = self.fn(*self.args, **self.kwargs)
  21. File "D:/Учеба/Диплом/parsers/smartphone/test10.py", line 128, in parse_object
  22. row=select_request_db(sql,data)
  23. File "D:/Учеба/Диплом/parsers/smartphone/test10.py", line 295, in select_request_db
  24. cursor.executemany(sql,data)
  25. File "C:ProgramDataAnaconda3libsite-packagesMySQLdbcursors.py", line 283, in executemany
  26. self.rowcount = sum(self.execute(query, arg) for arg in args)
  27. File "C:ProgramDataAnaconda3libsite-packagesMySQLdbcursors.py", line 283, in <genexpr>
  28. self.rowcount = sum(self.execute(query, arg) for arg in args)
  29. File "C:ProgramDataAnaconda3libsite-packagesMySQLdbcursors.py", line 240, in execute
  30. self.errorhandler(self, ProgrammingError, str(m))
  31. File "C:ProgramDataAnaconda3libsite-packagesMySQLdbconnections.py", line 52, in defaulterrorhandler
  32. raise errorclass(errorvalue)
  33. _mysql_exceptions.ProgrammingError: not all arguments converted during string formatting
  34.  
  35. def select_request_db(sql, data):
  36. conn = MySQLdb.connect(host="localhost", user="root", passwd="", db="project")
  37. conn.set_character_set('utf8')
  38. cursor = conn.cursor()
  39. cursor.execute('SET NAMES utf8;')
  40. cursor.execute('SET CHARACTER SET utf8;')
  41. cursor.execute('SET character_set_connection=utf8;')
  42. conn.autocommit(True)
  43. cursor.executemany(sql,data)
  44. row = cursor.fetchall()
  45. conn.close()
  46.  
  47. text = list(sum(row, ()))
  48. return text
  49.  
  50. ....
  51. sql = """SELECT id FROM locality WHERE name=%s"""
  52. data=[(city_address_shop)]
  53. row=select_request_db(sql,data)
Add Comment
Please, Sign In to add comment