| body |
{"product": {"partial_update": 0, "variant_remote_code": null, "rating": 5.0, "rating_count": 1, "brand": "Timberland", "seller_name": "Timberland", "author": null, "name": "Timberland Men's Oval Logo Sweatpant", "description": "At the heart of Timberland's story is a community - several communities - stepping outside, to work hard together and move the world forward. With a grit and relentless dedication to problem solving, these bold doers embrace the adventures on their path.\n \n \n \n Fabric type\n \n 85% Cotton, 15% Polyester\n \n Care instructions\n \n Machine Wash\n \n Origin\n \n Imported\n \n Closure type\n \n Pull On\n \n \n \n About this item \nMade with regeneratively grown cotton\n \nPockets: Side pockets\n \nHidden drawcord\n \nOval patch logo\n \nSee more \nAbout this item\n ", "data": {"dataFacets": []}, "categories": ["Clothing, Shoes & Jewelry > Men > Clothing > Active > Active Pants > Sweatpants"], "gender": "Men", "product_images": [], "market_id": 37, "remote_code": "B0CN9G64MC", "is_lost": 0, "variants": [{"remote_code": "B0CN9H9M7M", "upc": "197641043609", "additional_upc": "B0CN9H9M7M", "remote_url": "https://www.amazon.com/dp/B0CN9H9M7M?th=1&psc=1", "delivery_days": 5.0, "size": "3X-Large", "origin_color": "Angora", "price": 38.94, "variant_images": ["https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Dl2tsulEL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/51h+l6r+TzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71udm2utYzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81uJzLzlByL._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Angora; Size: 3X-Large", "colors": ["Angora"], "weight": "", "combo_key": "3X-LargeAngora"}, {"remote_code": "B0CN9GV8S9", "upc": "197641043036", "additional_upc": "B0CN9GV8S9", "remote_url": "https://www.amazon.com/dp/B0CN9GV8S9?th=1&psc=1", "delivery_days": 5.0, "size": "Large", "origin_color": "Angora", "price": 46.78, "variant_images": ["https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Dl2tsulEL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/51h+l6r+TzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71udm2utYzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81uJzLzlByL._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Angora; Size: Large", "colors": ["Angora"], "weight": "", "combo_key": "LargeAngora"}, {"remote_code": "B0CN9JLJQ1", "upc": "197641043265", "additional_upc": "B0CN9JLJQ1", "remote_url": "https://www.amazon.com/dp/B0CN9JLJQ1?th=1&psc=1", "delivery_days": 5.0, "size": "X-Large", "origin_color": "Angora", "price": 20.65, "variant_images": ["https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Dl2tsulEL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/51h+l6r+TzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71udm2utYzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81uJzLzlByL._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Angora; Size: X-Large", "colors": ["Angora"], "weight": "", "combo_key": "X-LargeAngora"}, {"remote_code": "B0CN9GBL96", "upc": "197641043104", "additional_upc": "B0CN9GBL96", "remote_url": "https://www.amazon.com/dp/B0CN9GBL96?th=1&psc=1", "delivery_days": 7.0, "size": "Medium", "origin_color": "Angora", "price": 49.64, "variant_images": ["https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Dl2tsulEL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/51h+l6r+TzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71udm2utYzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81uJzLzlByL._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Angora; Size: Medium", "colors": ["Angora"], "weight": "", "combo_key": "MediumAngora"}, {"remote_code": "B0CN9H65KC", "upc": "197641043371", "additional_upc": "B0CN9H65KC", "remote_url": "https://www.amazon.com/dp/B0CN9H65KC?th=1&psc=1", "delivery_days": 5.0, "size": "X-Small", "origin_color": "Angora", "price": 43.0, "variant_images": ["https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Dl2tsulEL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/51h+l6r+TzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71udm2utYzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81uJzLzlByL._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Angora; Size: X-Small", "colors": ["Angora"], "weight": "", "combo_key": "X-SmallAngora"}, {"remote_code": "B0CN9JH2MB", "upc": "197641043180", "additional_upc": "B0CN9JH2MB", "remote_url": "https://www.amazon.com/dp/B0CN9JH2MB?th=1&psc=1", "delivery_days": 5.0, "size": "Small", "origin_color": "Angora", "price": 43.41, "variant_images": ["https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Dl2tsulEL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/51h+l6r+TzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71udm2utYzL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81uJzLzlByL._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/715qxWY6PUL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Angora; Size: Small", "colors": ["Angora"], "weight": "", "combo_key": "SmallAngora"}, {"remote_code": "B0CN9HL9PV", "upc": "197641043012", "additional_upc": "B0CN9HL9PV", "remote_url": "https://www.amazon.com/dp/B0CN9HL9PV?th=1&psc=1", "delivery_days": 5.0, "size": "Small", "origin_color": "Chocolate Brown", "price": 22.77, "variant_images": ["https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81DLAnKWmnL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81MIq8ru1tL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Ul88osM4L._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/61nSzrIYyyL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/91S7shTwC0L._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Chocolate Brown; Size: Small", "colors": ["Chocolate Brown"], "weight": "", "combo_key": "SmallChocolate Brown"}, {"remote_code": "B0CN9K373P", "upc": "197641043166", "additional_upc": "B0CN9K373P", "remote_url": "https://www.amazon.com/dp/B0CN9K373P?th=1&psc=1", "delivery_days": 6.0, "size": "X-Small", "origin_color": "Chocolate Brown", "price": 27.14, "variant_images": ["https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81DLAnKWmnL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81MIq8ru1tL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Ul88osM4L._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/61nSzrIYyyL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/91S7shTwC0L._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Chocolate Brown; Size: X-Small", "colors": ["Chocolate Brown"], "weight": "", "combo_key": "X-SmallChocolate Brown"}, {"remote_code": "B0CN9J2PY3", "upc": "197641043098", "additional_upc": "B0CN9J2PY3", "remote_url": "https://www.amazon.com/dp/B0CN9J2PY3?th=1&psc=1", "delivery_days": 5.0, "size": "X-Large", "origin_color": "Chocolate Brown", "price": 47.4, "variant_images": ["https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81DLAnKWmnL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81MIq8ru1tL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Ul88osM4L._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/61nSzrIYyyL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/91S7shTwC0L._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Chocolate Brown; Size: X-Large", "colors": ["Chocolate Brown"], "weight": "", "combo_key": "X-LargeChocolate Brown"}, {"remote_code": "B0CN9HFJRC", "upc": "197641042978", "additional_upc": "B0CN9HFJRC", "remote_url": "https://www.amazon.com/dp/B0CN9HFJRC?th=1&psc=1", "delivery_days": 5.0, "size": "Medium", "origin_color": "Chocolate Brown", "price": 28.5, "variant_images": ["https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81DLAnKWmnL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81MIq8ru1tL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Ul88osM4L._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/61nSzrIYyyL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/91S7shTwC0L._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Chocolate Brown; Size: Medium", "colors": ["Chocolate Brown"], "weight": "", "combo_key": "MediumChocolate Brown"}, {"remote_code": "B0CN9GHFNC", "upc": "197641042923", "additional_upc": "B0CN9GHFNC", "remote_url": "https://www.amazon.com/dp/B0CN9GHFNC?th=1&psc=1", "delivery_days": 6.0, "size": "Large", "origin_color": "Chocolate Brown", "price": 44.16, "variant_images": ["https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81DLAnKWmnL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/81MIq8ru1tL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/71Ul88osM4L._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/61nSzrIYyyL._AC_SL1500_.jpg", "https://m.media-amazon.com/images/I/91S7shTwC0L._AC_SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/7162wgtusFL._AC_SL1500_._AC_SY300.jpg", "description": "Color: Chocolate Brown; Size: Large", "colors": ["Chocolate Brown"], "weight": "", "combo_key": "LargeChocolate Brown"}]}, "remote_url": "https://www.amazon.com/dp/B0CN9G64MC?th=1&psc=1", "parsing_type": "refresh", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'B0CN9G64MC' - parsed successfully. additional_error_text=''"} |
| error_text |
File "/opt/working_folder/middlewares/catch_errors_middleware/catch_500_errors.py", line 15, in dispatch
response = await call_next(request)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 84, in call_next
raise app_exc
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 70, in coro
await self.app(scope, receive_or_disconnect, send_no_error)
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/cors.py", line 83, in __call__
await self.app(scope, receive, send)
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 79, in __call__
raise exc
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 68, in __call__
await self.app(scope, receive, sender)
File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 20, in __call__
raise e
File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 17, in __call__
await self.app(scope, receive, send)
File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 718, in __call__
await route.handle(scope, receive, send)
File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 276, in handle
await self.app(scope, receive, send)
File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 66, in app
response = await func(request)
^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 274, in app
raw_response = await run_endpoint_function(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 193, in run_endpoint_function
return await run_in_threadpool(dependant.call, **values)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/starlette/concurrency.py", line 41, in run_in_threadpool
return await anyio.to_thread.run_sync(func, *args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/anyio/to_thread.py", line 33, in run_sync
return await get_asynclib().run_sync_in_worker_thread(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 877, in run_sync_in_worker_thread
return await future
^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 807, in run
result = context.run(func, *args)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/working_folder/api/logging_router/api/product_logging.py", line 495, in log_product_upload
add_product_history(db, market_id, remote_code, json_data)
File "/opt/working_folder/api/logging_router/api/product_logging.py", line 319, in add_product_history
.first()
^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2728, in first
return self.limit(1)._iter().first() # type: ignore
^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2827, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2362, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2247, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 305, in orm_execute_statement
result = conn.execute(
^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1418, in execute
return meth(
^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute
cursor.execute(statement, parameters)
|