
    lhj                         d dl m Z mZ d dlmZ d dlmZmZ d dlmZ d dl	m
Z
 d dlmZ d dlmZ d dlmZ d d	lmZ d d
lmZ dedefdZy)    )datetimetimezone)Session)HTTPExceptionstatus)QueryPaginator)Country)UUID)IntegrityError)Optional)WineDb)APIExceptiondbreturnc                 2  K   	 | j                  t        j                        j                         j	                         }|D cg c]  }|d   s	|d    }}|S c c}w # t
        $ r-}t        ddt        |      it        j                  d      d }~ww xY ww)Nr   get_sweetnesses	exceptionzFailed to fetch sweetnesses.)moduleerrorstatus_codemessage)
queryr   	sweetnessdistinctall	Exceptionr   strr   HTTP_500_INTERNAL_SERVER_ERROR)r   sweetnessesssweetness_listes        Z/var/www/html/wine-match-dev/backend/winematch-backend/src/apps/base/services/sweetness.pyr   r      s     

hhv//099;??A(3<1qt!A$<< = 
$A'==2	
 	

s@   B?A 
AAA BA 	B'(BBBN)r   r   sqlalchemy.ormr   fastapir   r   src.utils.paginationr   src.apps.base.models.countryr	   uuidr
   sqlalchemy.excr   typingr   src.apps.wine.wine.models.winer   src.core.exceptionsr   listr        r#   <module>r0      s6    ' " ) / 0  )  1 ,
g 
$ 
r/   