
    :gEi                        d dl mZmZ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  e       Zej!                  dee         d d	 ee      fd
ededefd       Zej!                  de       ee      fdedefd       Zy)    )	APIRouterDependsHTTPExceptionstatus)Session)get_db)Publication)PublicationResponse)List/)response_model   skiplimitdbc                    |j                  t              j                  t        j                  dk(        j	                  t        j
                  j                               j                  |       j                  |      j                         }|S )uS   
    Obtenir toutes les publications publiées, les plus récentes en premier.
    T)
queryr	   filteris_publishedorder_bypublished_atdescoffsetr   all)r   r   r   publicationss       I/home/www/lebenam.kofcorporation.com/app/api/v1/endpoints/publications.pyget_published_publicationsr      se     88K(//  D(h{'',,./tUU5\##%      z/{publication_id}publication_idc                     |j                  t              j                  t        j                  | k(  t        j                  dk(        j                         }|st        t        j                  d      |S )u<   
    Obtenir une seule publication publiée par son ID.
    Tu   Publication non trouvée)status_codedetail)	r   r	   r   idr   firstr   r   HTTP_404_NOT_FOUND)r   r   publications      r   get_published_publicationr'      sb     ((;'...(  D( eg  (A(AJdeer   N)fastapir   r   r   r   sqlalchemy.ormr   app.db.sessionr   app.models.publicationr	   app.schemas.publicationr
   typingr   routergetintr   r'    r   r   <module>r2      s    = = " ! . 7 	C%8 9:&/
 	 ; 0CD &/ Er   