| body |
{"product": {"rating": null, "rating_count": null, "brand": "COACH\u00ae", "name": "Waverly Bag", "description": " Suede and refined calf leather\n\n Inside snap pocket\n\n Zip-top closure, regenerative cotton lining\n\n Detachable chain strap with 10 3/4\" drop\n\n Detachable short strap with 10 3/4\" drop\n\n Detachable long strap with 21 1/2\" drop for shoulder or crossbody wear\n\n 9 1/2\" (L) x 5 1/2\" (H) x 3 1/4\" (W)", "data": {"dataFacets": []}, "categories": ["Coach > Women > Bags > Shoulder Bags"], "gender": "Women", "product_images": [], "market_id": 91, "remote_code": "CDD78", "is_lost": 0, "variants": [{"remote_code": "CEM79-B4Z38", "upc": "198685182859", "email_meta": "cem79_b4z38_a0", "remote_url": "https://www.coach.com/products/waverly-bag/CEM79%20B4Z38.html", "size": "N/A", "origin_color": "Brass/Khaki Light Peach - B4Z38", "price": 295.0, "variant_images": ["https://coach.scene7.com/is/image/Coach/cem79_b4z38_a0", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a92", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a61", "https://assets.coach.com/na/media/pdp/spin_cem79_b4z38_v2_p3.mp4", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a8", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a6", "https://assets.coach.com/na/media/pdp/waverlysigjacq_cem79_b4z38_v1_p2.mp4", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a88", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a3", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a5", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a10", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a99", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a21", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a62", "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a93"], "stock_count": 1, "data": ["transfer"], "image_url": "https://coach.scene7.com/is/image/Coach/cem79_b4z38_a0", "description": "Color: Brass/Khaki Light Peach - B4Z38; Size: N/A", "colors": ["Brass/Khaki Light Peach - B4Z38"]}, {"remote_code": "CDZ20-B4MPL", "upc": "198685166095", "email_meta": "cdz20_b4mpl_a0", "remote_url": "https://www.coach.com/products/waverly-bag/CDZ20%20B4MPL.html", "size": "N/A", "origin_color": "Brass/Maple - B4MPL", "price": 295.0, "variant_images": ["https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a0", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a92", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a61", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a8", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a6", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a88", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a3", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a5", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a10", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a99", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a21", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a62", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a93"], "stock_count": 1, "data": ["transfer"], "image_url": "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a0", "description": "Color: Brass/Maple - B4MPL; Size: N/A", "colors": ["Brass/Maple - B4MPL"]}, {"remote_code": "CDZ20-B4/BK", "upc": "198685158977", "email_meta": "cdz20_b4bk_a0", "remote_url": "https://www.coach.com/products/waverly-bag/CDZ20%20B4%2FBK.html", "size": "N/A", "origin_color": "Brass/Black - B4/BK", "price": 295.0, "variant_images": ["https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a0", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a92", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a61", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a8", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a6", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a88", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a3", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a5", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a10", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a99", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a21", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a62", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a93", "https://coach.scene7.com/is/image/Coach/en_US-ToroImg_cdz20_b4bk_a101"], "stock_count": 1, "data": ["transfer"], "image_url": "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a0", "description": "Color: Brass/Black - B4/BK; Size: N/A", "colors": ["Brass/Black - B4/BK"]}, {"remote_code": "CDD78-B4/AY", "upc": "198685159912", "email_meta": "cdd78_b4ay_a0", "remote_url": "https://www.coach.com/products/waverly-bag/CDD78%20B4%2FAY.html", "size": "N/A", "origin_color": "Brass/Clay - B4/AY", "price": 250.0, "variant_images": ["https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a0", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a92", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a61", "https://assets.coach.com/na/media/pdp/spin_cdd78_b4ld_v2_p3.mp4", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a8", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a6", "https://assets.coach.com/na/media/pdp/waverlysuede_cdd78_b4ld_v1_p2.mp4", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a88", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a3", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a5", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a10", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a99", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a21", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a62", "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a93"], "stock_count": 1, "data": ["transfer"], "image_url": "https://coach.scene7.com/is/image/Coach/cdd78_b4ay_a0", "description": "Color: Brass/Clay - B4/AY; Size: N/A", "colors": ["Brass/Clay - B4/AY"]}, {"remote_code": "CCC38-B4YDT", "upc": "196395963812", "email_meta": "ccc38_b4ydt_a0", "remote_url": "https://www.coach.com/products/waverly-bag/CCC38%20B4YDT.html", "size": "N/A", "origin_color": "Brass/Maple - B4YDT", "price": 250.0, "variant_images": ["https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a0", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a92", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a61", "https://assets.coach.com/na/media/pdp/spin_ccc38_b4ydt_v2_p3.mp4", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a8", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a6", "https://assets.coach.com/na/media/pdp/waverlyccsig_ccc38_b4ydt_v1_p2.mp4", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a88", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a3", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a5", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a10", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a99", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a21", "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a93"], "stock_count": 1, "data": ["transfer"], "image_url": "https://coach.scene7.com/is/image/Coach/ccc38_b4ydt_a0", "description": "Color: Brass/Maple - B4YDT; Size: N/A", "colors": ["Brass/Maple - B4YDT"]}, {"remote_code": "CCC36-B4/BK", "upc": "196395963706", "email_meta": "cdz20_b4bk_a0", "remote_url": "https://www.coach.com/products/waverly-bag/CCC36%20B4%2FBK.html", "size": "N/A", "origin_color": "Brass/Black - B4/BK", "price": 250.0, "variant_images": ["https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a0", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a92", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a61", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a8", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a6", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a88", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a3", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a5", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a10", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a99", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a21", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a62", "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a93", "https://coach.scene7.com/is/image/Coach/en_US-ToroImg_cdz20_b4bk_a101"], "stock_count": 1, "data": ["transfer"], "image_url": "https://coach.scene7.com/is/image/Coach/cdz20_b4bk_a0", "description": "Color: Brass/Black - B4/BK; Size: N/A", "colors": ["Brass/Black - B4/BK"]}, {"remote_code": "CCC36-B4MPL", "upc": "196395963720", "email_meta": "cdz20_b4mpl_a0", "remote_url": "https://www.coach.com/products/waverly-bag/CCC36%20B4MPL.html", "size": "N/A", "origin_color": "Brass/Maple - B4MPL", "price": 250.0, "variant_images": ["https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a0", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a92", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a61", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a8", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a6", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a88", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a3", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a5", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a10", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a99", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a21", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a62", "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a93"], "stock_count": 1, "data": ["transfer"], "image_url": "https://coach.scene7.com/is/image/Coach/cdz20_b4mpl_a0", "description": "Color: Brass/Maple - B4MPL; Size: N/A", "colors": ["Brass/Maple - B4MPL"]}]}, "remote_url": "https://www.coach.com/products/product/CDD78.html", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'CDD78' - 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)
|