U
    ˱}j-                     @   sD   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 Z
dS )    )requestjsonify)get_db)error_responsesuccess_response)admin_requiredc                 C   sX   | j ddgdtdd }| j ddgdtdd }| j d	d
gdtdd }d S )Nz/api/admin/sensitive-wordsGET)methodsc                  S   sJ   t  } |  }z,|d | }dd |D }t|W S |   X d S )Nz6SELECT * FROM sensitive_words ORDER BY created_at DESCc                 S   s   g | ]}t |qS  )dict).0rowr
   r
   DD:\Project\Python Project\BangBang\backend\routes\sensitive_words.py
<listcomp>   s     zOregister_sensitive_word_routes.<locals>.get_sensitive_words.<locals>.<listcomp>)r   cursorcloseexecutefetchallr   )connr   rowsitemsr
   r
   r   get_sensitive_words   s    
z;register_sensitive_word_routes.<locals>.get_sensitive_wordsPOSTc               
   S   s   t j} | dpd }|s$tdS t|dkr8tdS t }| }zz.|	d|f |
  t|j|ddW W TS  tk
r } z0|  d	t|krtd
 W Y W S |W 5 d }~X Y nX W 5 |  X d S )Nword u   敏感词不能为空2   u   敏感词不能超过50个字z-INSERT INTO sensitive_words (word) VALUES (?)T)idr   successZUNIQUEu   该敏感词已存在)r   jsongetstripr   lenr   r   r   r   commitr   	lastrowid	Exceptionrollbackstr)datar   r   r   er
   r
   r   create_sensitive_word   s$    z=register_sensitive_word_routes.<locals>.create_sensitive_wordz(/api/admin/sensitive-words/<int:word_id>DELETEc              
   S   s   t  }| }zvzB|d| f |  |jdkr@tdW W HS tdddW W 4S  tk
r } z|	  |W 5 d }~X Y nX W 5 |  X d S )Nz(DELETE FROM sensitive_words WHERE id = ?r   u   敏感词不存在Tu   删除成功)r   message)
r   r   r   r   r"   rowcountr   r   r$   r%   )Zword_idr   r   r(   r
   r
   r   delete_sensitive_word,   s    
z=register_sensitive_word_routes.<locals>.delete_sensitive_word)router   )appr   r)   r-   r
   r
   r   register_sensitive_word_routes   s    r0   N)flaskr   r   Zutils.databaser   Zutils.helpersr   r   Z
utils.authr   r0   r
   r
   r
   r   <module>   s   