
    5h
                     8   S SK JrJrJrJrJrJrJr  S SKJ	r	  S SK
Jr  S SKJr  \" S\5      r\R!                  S5      S 5       r\R!                  SS	S
9\S 5       5       rSS jr\R!                  SS	S
9\S 5       5       r\R!                  SSS
9\S 5       5       rg)    )	Blueprintflashgredirectrender_templaterequesturl_for)abort)login_required)get_dbblog/c                      [        5       R                  5       n U R                  S5        U R                  5       n[	        SUS9$ )NzzSELECT p.id, title, body, created, author_id, username FROM post p JOIN user u ON p.author_id = u.id ORDER BY created DESCzblog/index.html)posts)r   cursorexecutefetchallr   )dbr   s     //Users/jbastos/public_html/wsgi/Uploadr/blog.pyindexr      s<    		BJJ	!
 KKME,E::    z/create)GETPOST)methodsc                     [         R                  S:X  a  [         R                  S   n [         R                  S   nS nU (       d  SnUb  [        U5        Oa[	        5       nUR                  5       R                  SX[        R                  S   45        UR                  5         [        [        S5      5      $ [        S5      $ )	Nr   titlebodyTitle is required.z=INSERT INTO post (title, body, author_id) VALUES (%s, %s, %s)id
blog.indexzblog/create.html)r   methodformr   r   r   r   r   usercommitr   r	   r   )r   r   errorr   s       r   creater&      s     ~~W%||F#(E%LBIIK'affTl+
 IIKGL122-..r   c                     [        5       R                  5       nUR                  SU 45        UR                  5       nUc  [	        SSU  S35        U(       a%  US   [
        R                  S   :w  a  [	        S5        U$ )NztSELECT p.id, title, body, created, author_id, username FROM post p JOIN user u ON p.author_id = u.id WHERE p.id = %si  zPost id z doesn't exist.	author_idr   i  )r   r   r   fetchoner
   r   r#   )r   check_authorr   posts       r   get_postr,   1   sp    		BJJ	 
	 ;;=D|cXbT12[)QVVD\9c
Kr   z/<int:id>/updatec                 t   [        U 5      n[        R                  S:X  a  [        R                  S   n[        R                  S   nS nU(       d  SnUb  [	        U5        OP[        5       nUR                  5       R                  SX#U 45        UR                  5         [        [        S5      5      $ [        SUS9$ )	Nr   r   r   r   z3UPDATE post SET title = %s, body = %s WHERE id = %sr    zblog/update.html)r+   )r,   r   r!   r"   r   r   r   r   r$   r   r	   r   )r   r+   r   r   r%   r   s         r   updater.   C   s     B<D~~W%||F#(E%LBIIK!b!
 IIKGL122-D99r   z/<int:id>/delete)r   c                     [        U 5        [        5       nUR                  5       R                  SU 45        UR	                  5         [        [        S5      5      $ )NzDELETE FROM post WHERE id = %sr    )r,   r   r   r   r$   r   r	   )r   r   s     r   deleter0   ^   sD     RL	BIIK82%@IIKGL)**r   N)T)flaskr   r   r   r   r   r   r	   werkzeug.exceptionsr
   flaskr.authr   	flaskr.dbr   __name__bprouter   r&   r,   r.   r0    r   r   <module>r9      s      & & vx #; ; )_-/  ./0$ 
o6:  7:2 
i0+  1+r   