| body |
{"product": {"rating": null, "rating_count": null, "brand": "Bark & Whiskers", "name": "GI Support for Dogs and Cats", "description": "PureFormulas is an authorized retailer of Bark & Whiskers products. You can shop with confidence, knowing that all products purchased from PureFormulas are authentic, and sourced directly from the brand. Formerly Dr. Mercola Healthy Pets\u201a this reinvented line\u201a Bark & Whiskers\u2122\u201a brings the same veterinarian-formulated products you know and love with a touch of playfulness \u2013 because who says wholesome health can\u2019t be fun? Heart conditions have become a top concern among veterinarians\u201a ranking as the most common cause of sudden death in cats and the number two cause of deaths among dogs. Hidden cardiovascular concerns can be present at birth or develop slowly as part of the normal aging process. The good news is\u201a you can take steps right now to help support your pet\u2019s heart health. Bark & Whiskers\u2122 Heart Health contains 12 active ingredients\u201a including taurine\u201a glycine and L-carnitine\u201a in a pet-friendly organic cheddar cheese base to support cardiovascular health. This unique formula was designed to support optimal heart health in these groups of cats and dogs: \u2022 High-risk breeds (start when your pet is still a kitten or puppy) \u2022 Athletic and hard-working pets \u2022 All cats and dogs over the age of 7 \u2022 Any cat or dog with a heart health concern \u2022 Any cat or dog eating kibble (and semi-moist pouched food) \u2022 If your pet falls into one of these higher risk categories\u201a act now to provide the cardiovascular support she may need. Give your pet this specially targeted formula to keep his heart healthy so you can enjoy many happy years together\u201a and order Bark & Whiskers\u2122 Heart Health today. Even though it's a new look\u201a we hope Bark & Whiskers\u2122 still feels like home. These statements have not been evaluated by the Food and Drug Administration (FDA). These products are not meant to diagnose\u201a treat or cure any disease or medical condition. Please consult your doctor before starting any exercise or nutritional supplement program or before using these or any product during pregnancy or if you have a serious medical condition. Report incorrect product information", "data": {"dataFacets": [], "product_id": "1000058302", "repository_id": "1000058302", "route": "/product/gi-support-for-dogs-and-cats-by-bark-whiskers/1000058302", "part_number": null, "parent_category_id_path": "rootCategory>pet-veterinary>cats>cats-gastrointestinal-digestive-support", "product_type": "Product", "tags": [], "highlights": [], "main_ingredient": null}, "categories": ["Pet Veterinary > Cats > Cats Gastrointestinal Digestive Support"], "gender": null, "product_images": ["https://www.pureformulas.com/img/no-image.jpg"], "market_id": 144, "remote_code": "1000058302", "is_lost": 0, "variants": [{"remote_code": "DRM1382", "upc": "810487032919", "remote_url": "https://www.pureformulas.com/product/gi-support-for-dogs-and-cats-by-bark-whiskers/1000058302?skuId=DRM1382", "size": "3.17 oz (90 Grams)", "origin_color": "Default", "price": 39.99, "email_meta": "DRM1382", "variant_images": ["https://www.pureformulas.com/file/v5797273416648019632/products/heart-health-for-dogs-cats-3-17-oz-90-grams-by-bark-whiskers.jpg", "https://www.pureformulas.com/file/v4906081339532933921/products/heart-health-for-dogs-cats-3-17-oz-90-grams-by-bark-whiskers-extra1.jpg", "https://www.pureformulas.com/file/v2084674237741434713/products/heart-health-for-dogs-cats-3-17-oz-90-grams-by-bark-whiskers-extra2.jpg", "https://www.pureformulas.com/file/v4026901793592487496/products/heart-health-for-dogs-cats-3-17-oz-90-grams-by-bark-whiskers-extra3.jpg", "https://www.pureformulas.com/file/v8595420740679431493/products/heart-health-for-dogs-cats-3-17-oz-90-grams-by-bark-whiskers-extra4.jpg", "https://www.pureformulas.com/file/v5256800293786389302/products/heart-health-for-dogs-cats-3-17-oz-90-grams-by-bark-whiskers-extra5.jpg", "https://www.pureformulas.com/img/no-image.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.pureformulas.com/file/v5797273416648019632/products/heart-health-for-dogs-cats-3-17-oz-90-grams-by-bark-whiskers.jpg", "description": "Size: 3.17 oz (90 Grams)", "colors": ["Default"], "additional_upc": "1000058302", "weight": 272}, {"remote_code": "DRM1383", "upc": "810487032063", "remote_url": "https://www.pureformulas.com/product/gi-support-for-dogs-and-cats-by-bark-whiskers/1000058302?skuId=DRM1383", "size": "2.90 oz (84 Grams)", "origin_color": "Default", "price": 24.99, "email_meta": "DRM1383", "variant_images": ["https://www.pureformulas.com/file/v4469053131978846734/products/gi-support-for-dogs-and-cats-2-90-oz-84-grams-by-bark-whiskers.jpg", "https://www.pureformulas.com/file/v1350764520508724412/products/gi-support-for-dogs-and-cats-2-90-oz-84-grams-by-bark-whiskers-extra1.jpg", "https://www.pureformulas.com/file/v6705438443523279120/products/gi-support-for-dogs-and-cats-2-90-oz-84-grams-by-bark-whiskers-extra2.jpg", "https://www.pureformulas.com/file/v8341866634088982858/products/gi-support-for-dogs-and-cats-2-90-oz-84-grams-by-bark-whiskers-extra3.jpg", "https://www.pureformulas.com/file/v8646374535695981105/products/gi-support-for-dogs-and-cats-2-90-oz-84-grams-by-bark-whiskers-extra4.jpg", "https://www.pureformulas.com/file/v2786389225692922209/products/gi-support-for-dogs-and-cats-2-90-oz-84-grams-by-bark-whiskers-extra5.jpg", "https://www.pureformulas.com/img/no-image.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.pureformulas.com/file/v4469053131978846734/products/gi-support-for-dogs-and-cats-2-90-oz-84-grams-by-bark-whiskers.jpg", "description": "Size: 2.90 oz (84 Grams)", "colors": ["Default"], "additional_upc": "1000058302", "weight": 390}]}, "remote_url": "https://www.pureformulas.com/product/gi-support-for-dogs-and-cats-by-bark-whiskers/1000058302", "type_parsing": "full", "parsing_type": "full", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '1000058302' - 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)
|