+
    }j-                     D    ^ RI HtHt ^ RIHt ^ RIHtHt ^ RIH	t	 R t
R# )    )requestjsonify)get_db)error_responsesuccess_response)admin_requiredc                     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/admin/sensitive-wordsGET)methodsc                     \        4       p V P                  4       p VP                  R 4       VP                  4       pV Uu. uF  p\	        V4      NK  	  pp\        V4      V P                  4        # u upi   T P                  4        i ; i)z6SELECT * FROM sensitive_words ORDER BY created_at DESC)r   cursorexecutefetchalldictr   close)connr   rowsrowitemss        !backend/routes/sensitive_words.pyget_sensitive_words;register_sensitive_word_routes.<locals>.get_sensitive_words   sn     x	NNST??$D*./$3T#Y$E/5>JJL 0 JJLs   %A7 A2A7 2A7 7B	POSTc                  v   \         P                  p V P                  R 4      ;'       g    RP                  4       pV'       g   \	        R4      # \        V4      ^28  d   \	        R4      # \        4       pVP                  4       p VP                  RV34       VP                  4        \        RVP                  R VRR/4      VP                  4        #   \         dH   pTP                  4        R\        T4      9   d!   \	        R	4      u R
p?TP                  4        # ThR
p?ii ; i  TP                  4        i ; i)word u   敏感词不能为空u   敏感词不能超过50个字z-INSERT INTO sensitive_words (word) VALUES (?)idsuccessTUNIQUEu   该敏感词已存在N)r   jsongetstripr   lenr   r   r   commitr   	lastrowidr   	Exceptionrollbackstr)datar   r   r   es        r   create_sensitive_word=register_sensitive_word_routes.<locals>.create_sensitive_word   s     || &&B--/!"9::t9r>!"ABBx
	NNJTGTKKMD&"2"2FD)TRS JJL  	MMO3q6!%&=>> JJL G		 JJLs6   =C D#*DD#D& DD##D& &D8z(/api/admin/sensitive-words/<int:word_id>DELETEc                    \        4       pVP                  4       p VP                  R V 34       VP                  4        VP                  ^ 8X  d   \        R4      VP                  4        # \        RRRR/4      VP                  4        #   \         d   pTP                  4        ThRp?ii ; i  TP                  4        i ; i)z(DELETE FROM sensitive_words WHERE id = ?u   敏感词不存在r   Tmessageu   删除成功N)
r   r   r   r$   rowcountr   r   r   r&   r'   )word_idr   r   r*   s   &   r   delete_sensitive_word=register_sensitive_word_routes.<locals>.delete_sensitive_word,   s     x
	NNEzRKKM!#%&:; JJL ItYGH
 JJL	  	MMOG	 JJLs)   >B
 +B
 
B,B''B,,B/ /CN)router   )appr   r+   r2   s   &   r   register_sensitive_word_routesr6      s    YY+eWY=	  >	 	YY+fXY>  ?, 	YY9H:YN  O    N)flaskr   r   utils.databaser   utils.helpersr   r   
utils.authr   r6    r7   r   <module>r=      s    " ! : %5r7   