| body |
{"product": {"rating": null, "rating_count": null, "brand": "HAUS LABS BY LADY GAGA", "name": "Atomic Shake High-Shine Longwear Lip Lacquer Lipstick", "description": "<p><strong>What it is:\u00a0</strong>A high-performance, long-wearing lip lacquer that combines shine with transfer-proof color for an irresistible glossy lip that lasts up to eight hours.</p><p><strong><br>Finish:\u00a0</strong>High Shine</p><p><strong><br>Skin Type:\u00a0</strong>Normal, Oily, Dry, Combination</p><p><strong><br>Highlighted Ingredients:\u00a0<br></strong>- Marine Algae Extract: Smooths and nourishes lips.</p><p>- Shine Boost: Provides high shine and adherence.</p><p>- Flexible Film Forming Polymers: For a breathable, weightless feel.</p><p><br></p><p><strong>Ingredient Callouts:</strong> Free of parabens, formaldehydes, formaldehyde-releasing agents, phthalates, mineral oil, retinyl palmitate, oxybenzone, coal tar, hydroquinone, sulfates SLS & SLES, triclocarban, triclosan, and contains less than one percent synthetic fragrance. It is also vegan, gluten-free, and cruelty-free.</p><p><br></p><p><strong>What Else You Need to Know:</strong> This innovative, high-shine, long-wearing lip formula delivers transfer-proof, waterproof performance with a lacquer-like finish. Experience color and shine that lasts up to eight hours and maintains lip moisture all day in an ultra-thin, weightless formula that does not fade. Application is easy in just three steps: Shake well. Apply a thin layer to parted lips and keep lips apart for 15 seconds to set. Shine all day.</p><p><br></p><p><strong>Clinical Results:\u00a0</strong>In a consumer perception study with 50 panelists:</p><p>- 8 hour long wear, high shine, and color</p><p>- Visibly enhances lips for a fuller look</p><p>- Feather and bleed-proof</p>", "data": {"dataFacets": []}, "categories": ["Makeup > Lip > Liquid Lipstick"], "gender": "Female", "product_images": [], "market_id": 51, "remote_code": "P522531", "is_lost": 0, "variants": [{"remote_code": "2977858", "upc": "", "remote_url": "https://www.sephora.com/product/P522531?skuId=2977858", "size": "Standard", "origin_color": "High Shine Mahogany", "price": 28.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2977858-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2977858-av-1202603112039434040700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-12202603112039532890700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-2202603112039481690700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-3202603112039520890700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-4202603112039513420700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-5202603112039443860700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-6202603112039478810700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-7202603112039484710700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-8202603112039517230700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977858-av-9202603112039492940700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2977858-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: High Shine Mahogany; Size: Standard", "colors": ["High Shine Mahogany"]}, {"remote_code": "2977890", "upc": "", "remote_url": "https://www.sephora.com/product/P522531?skuId=2977890", "size": "Standard", "origin_color": "High Shine Maroon", "price": 28.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2977890-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2977890-av-1202603112040270280700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-12202603112040338000700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-2202603112040315000700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-3202603112040332530700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-4202603112040359430700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-5202603112040318340700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-6202603112040297630700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-7202603112040390030700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-8202603112040386000700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977890-av-9202603112040356510700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2977890-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: High Shine Maroon; Size: Standard", "colors": ["High Shine Maroon"]}, {"remote_code": "2977866", "upc": "", "remote_url": "https://www.sephora.com/product/P522531?skuId=2977866", "size": "Standard", "origin_color": "High Shine Ruby", "price": 28.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2977866-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2977866-av-1202603112040014430700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-12202603112040093310700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-2202603112040047540700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-3202603112040086890700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-4202603112040054290700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-5202603112039546350700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-6202603112040017150700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-7202603112040051000700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-8202603112040044730700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977866-av-9202603112040090460700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2977866-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: High Shine Ruby; Size: Standard", "colors": ["High Shine Ruby"]}, {"remote_code": "2977882", "upc": "", "remote_url": "https://www.sephora.com/product/P522531?skuId=2977882", "size": "Standard", "origin_color": "High Shine Berry", "price": 28.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2977882-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2977882-av-1202603112040180170700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-12202603112040253590700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-2202603112040215410700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-3202603112040363560700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-4202603112040208060700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-5202603112040197110700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-6202603112040199960700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-7202603112040211240700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-8202603112040217900700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977882-av-9202603112040311910700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2977882-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: High Shine Berry; Size: Standard", "colors": ["High Shine Berry"]}, {"remote_code": "2977841", "upc": "", "remote_url": "https://www.sephora.com/product/P522531?skuId=2977841", "size": "Standard", "origin_color": "High Shine Dusty Rose", "price": 28.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2977841-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2977841-av-12-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-1202603112039304140700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-2202603112039315990700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-3202603112039509820700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-4-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-5202603112039387470700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-6202603112039339740700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-7202603112039350900700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-8202603112039404030700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977841-av-9202603112039420140700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2977841-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: High Shine Dusty Rose; Size: Standard", "colors": ["High Shine Dusty Rose"]}, {"remote_code": "2977833", "upc": "", "remote_url": "https://www.sephora.com/product/P522531?skuId=2977833", "size": "Standard", "origin_color": "High Shine Sheer Sienna", "price": 28.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2977833-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2977833-av-1202603112039213820700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-12202603112039273960700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-2202603112039235150700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-3202603112039396720700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-4202603112039232610700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-5202603112039229590700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-6202603112039264520700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-7202603112039308410700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-8202603112039244120700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977833-av-9202603112039248830700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2977833-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: High Shine Sheer Sienna; Size: Standard", "colors": ["High Shine Sheer Sienna"]}, {"remote_code": "2977874", "upc": "", "remote_url": "https://www.sephora.com/product/P522531?skuId=2977874", "size": "Standard", "origin_color": "High Shine Sheer Blush", "price": 28.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2977874-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2977874-av-1202603112040099900700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-12202603112040154960700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-2202603112040133950700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-3202603112040176570700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-4202603112040143870700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-5202603112040103090700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-6202603112040122600700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-7202603112040137430700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-8202603112040130260700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977874-av-9202603112040172660700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2977874-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: High Shine Sheer Blush; Size: Standard", "colors": ["High Shine Sheer Blush"]}, {"remote_code": "2977908", "upc": "", "remote_url": "https://www.sephora.com/product/P522531?skuId=2977908", "size": "Standard", "origin_color": "High Shine Sheer Petal", "price": 28.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2977908-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2977908-av-1202603112040382350700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-12202603112040412340700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-2202603112040392170700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-3202603112040482720700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-4202603112040487440700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-5202603112040367570700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-6202603112040409520700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-7202603112040441880700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-8202603112040415710700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2977908-av-9202603112040423200700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2977908-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: High Shine Sheer Petal; Size: Standard", "colors": ["High Shine Sheer Petal"]}]}, "remote_url": "https://www.sephora.com/product/P522531", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'P522531' - parsed successfully. additional_error_text=''"} |
| error_text |
Traceback (most recent call last):
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)
psycopg2.errors.SqlclientUnableToEstablishSqlconnection: could not establish connection for write forwarding
DETAIL: fe_sendauth: no password supplied
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/working_folder/middlewares/catch_errors_middleware/catch_500_errors.py", line 35, 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 535, 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)
sqlalchemy.exc.OperationalError: (psycopg2.errors.SqlclientUnableToEstablishSqlconnection) could not establish connection for write forwarding
DETAIL: fe_sendauth: no password supplied
[SQL: SELECT product_history.id AS product_history_id, product_history.remote_code AS product_history_remote_code, product_history.market_id AS product_history_market_id, product_history.history AS product_history_history, product_history.date_created AS product_history_date_created, product_history.date_modified AS product_history_date_modified
FROM product_history
WHERE product_history.market_id = %(market_id_1)s AND product_history.remote_code = %(remote_code_1)s
LIMIT %(param_1)s FOR UPDATE]
[parameters: {'market_id_1': 51, 'remote_code_1': 'P522531', 'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|