+
    `}j	                     @    ^ RI HtHt ^ RIHt ^ RIHt ^ RIHt R t	R# )    )requestjsonify)get_db)error_response)admin_requiredc                    V P                  R R.R7      R 4       pV P                  R R.R7      \        R 4       4       pV P                  RR.R7      \        R 4       4       pV P                  RR	.R7      \        R
 4       4       pR# )z/api/carouselsGET)methodsc                      \        4       p V P                  4       pVP                  R 4       VP                  4       pV P	                  4        V Uu. uF  p\        V4      NK  	  pp\        V4      # u upi )z/SELECT * FROM carousels ORDER BY sort_order ASC)r   cursorexecutefetchallclosedictr   )connr   rowsrowitemss        F   E:\Work\靠谱人脉\软件相关\BangBang\backend\routes\carousels.pyget_carousels/register_carousel_routes.<locals>.get_carousels   s]    xHI 

&*+dscd+u~ ,s   A1POSTc            
         \         P                  p V P                  R 4      '       g   \        R4      # \	        4       pVP                  4       pVP                  RV P                  RR4      V P                  R 4      V P                  RR4      V P                  R^ 4      34       VP                  pVP                  4        VP                  4        \        RVR	R
/4      # )	image_url   图片地址不能为空zx
            INSERT INTO carousels (page_type, image_url, link_url, sort_order)
            VALUES (?, ?, ?, ?)
        	page_type	task_listlink_url 
sort_orderidsuccessT)r   jsongetr   r   r   r   	lastrowidcommitr   r   )datar   r   carousel_ids       r   create_carousel1register_carousel_routes.<locals>.create_carousel   s     ||xx$$!"<==x  HH[+.HH[!HHZ$HH\1%	
	 &&

k9d;<<    z /api/carousels/<int:carousel_id>PUTc           
         \         P                  pVP                  R 4      '       g   \        R4      # \	        4       pVP                  4       pVP                  RVP                  RR4      VP                  R 4      VP                  RR4      VP                  R^ 4      V 34       VP                  4        VP                  4        \        RR	/4      # )
r   r   z
            UPDATE carousels SET
                page_type = ?,
                image_url = ?,
                link_url = ?,
                sort_order = ?
            WHERE id = ?
        r   r   r   r   r    r"   T)
r   r#   r$   r   r   r   r   r&   r   r   )r(   r'   r   r   s   &   r   update_carousel1register_carousel_routes.<locals>.update_carousel,   s     ||xx$$!"<==x  HH[+.HH[!HHZ$HH\1%
	 	

	4())r+   DELETEc                     \        4       pVP                  4       pVP                  R V 34       VP                  4        VP	                  4        \        RRRR/4      # )z"DELETE FROM carousels WHERE id = ?r"   Tmessageu   删除成功)r   r   r   r&   r   r   )r(   r   r   s   &  r   delete_carousel1register_carousel_routes.<locals>.delete_carouselJ   sM     x;k^L

	4NCDDr+   N)router   )appr   r)   r.   r3   s   &    r   register_carousel_routesr7      s    YY%Y1 2 	YY&Y2=  3=0 	YY1E7YC*  D*8 	YY1H:YFE  GEr+   N)
flaskr   r   utils.databaser   utils.helpersr   
utils.authr   r7    r+   r   <module>r=      s    " ! ( %MEr+   