| body |
{"product": {"category_meta_splitter": null, "meta_category": ["N/A"], "origin_url": null, "rating": 4.6, "rating_count": 762, "brand": "Nescafe", "name": "Nescafe Clasico Dark Roast Instant Coffee - 7oz", "description": "NESCAF\u00c9 CL\u00c1SICO Dark Roast Instant Coffee delivers rich, bold flavor on the go and in an instant with quality you know and love in every sip. This distinctive and oh-so-delicious dark roast is crafted with 100% real coffee. We use only the finest-quality, respectfully grown Robusta and Arabica coffee beans, carefully roasting them to capture each blend's flavor and aroma for you to enjoy sip after sip. Savor an irresistible cup of coffee instantly with the world\u2019s best-selling coffee brand,* NESCAF\u00c9. Start your day strong and make your world with NESCAF\u00c9 CL\u00c1SICO. *Based on 2023 global retail sales data reported by Euromonitor.\u200b\n •PREMIUM INSTANT COFFEE: Savor rich and bold flavor in an instant with the pure coffee taste of NESCAF\u00c9 CL\u00c1SICO Dark Roast Instant Coffee<br>•EXCEPTIONAL TASTE: NESCAF\u00c9 invites you to elevate the taste of the coffee in your cup with our bolder, richer taste that's crafted to perfection<br>•HIGH QUALITY: Crafted with high-quality coffee beans from around the world, NESCAF\u00c9 is proud to be the world\u2019s best-selling coffee brand*<br>•EASY TO PREPARE: It's never been easier to get a perfect cup of coffee. Simply scoop 1 teaspoon of NESCAF\u00c9 CL\u00c1SICO instant coffee, add 6 fluid ounces of hot water, stir and enjoy\u200b<br>•MAKES UP TO 100 CUPS: When prepared as directed, this 7-ounce jar makes up to 100 cups of real, premium NESCAF\u00c9 instant coffee that satisfies with every sip, whether you like your coffee black or with coffee syrup or cream and sugar\u200b", "data": {"dataFacets": []}, "categories": ["Grocery > Beverages > Coffee > Instant Coffee"], "gender": "N/A", "location": "OxfordValley;Neshaminy;PhiladelphiaRooseveltBlvd;AbingtonTownship;PhiladelphiaCottman", "product_images": [], "market_id": 84, "remote_code": "13481368", "is_lost": 0, "variants": [{"remote_code": "13481368", "upc": "028000466312", "remote_url": "https://www.target.com/p/~/-/A-13481368", "size": "N/A", "origin_color": "N/A", "price": 10.79, "price_full": null, "variant_images": ["https://target.scene7.com/is/image/Target/GUEST_f0653f2c-b32b-4fd1-a75f-cacb0751f66c?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_5b2e9d0d-245e-4253-b914-f82316acf3ab?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_0f037b39-81bd-4cbe-86aa-d5e9b0ad5b80?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_4c6659c8-3af6-483e-b42c-638aac23774e?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_98f5517c-78fe-48f7-8a3a-1015be23ff28?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_cb91a68c-191f-4f1b-a1af-261a48ebceca?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_41a1958a-90d2-4c56-ad8d-b49aeb518aa6?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_39bd63e9-999f-4e22-8a92-7fb4a44a7506?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_becb302d-0b0d-43b8-958a-de7a1717337e?wid=1200&hei=1200"], "stock_count": 1, "data": ["transfer"], "image_url": "https://target.scene7.com/is/image/Target/GUEST_f0653f2c-b32b-4fd1-a75f-cacb0751f66c", "description": "Color: N/A; Size: N/A", "colors": ["N/A"]}]}, "remote_url": "https://www.target.com/p/~/-/A-13481368", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '13481368' - 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 2237, in _execute_internal
conn = self._connection_for_bind(bind)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2106, in _connection_for_bind
return trans._connection_for_bind(engine, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<string>", line 2, in _connection_for_bind
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1189, in _connection_for_bind
conn = bind.connect()
^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3278, in connect
return self._connection_cls(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 148, in __init__
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2442, in _handle_dbapi_exception_noconnection
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 146, in __init__
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3302, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/impl.py", line 308, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 674, in __init__
self.__connect()
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
with util.safe_reraise():
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 621, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|