
    +h/                        d dl mZmZmZ d dlmZ d dlmZ d dlZ ee	      Z
 ee
       d Ze
j                  d      d        Ze
j                  d      d	        Ze
j                  d
      d        Ze
j#                  d      d        Ze
j'                  d
      d        Ze
j+                  d
      d        Ze	dk(  r. e ej0                  dd            Ze
j5                  ded       yy)    )Flaskrequestjsonify)CORS)get_connNc           	          | j                   D cg c]  }|d   	 }}| j                         D cg c]  }t        t        ||             c}S c c}w c c}w )Nr   )descriptionfetchalldictzip)cursorccolsrows       !/var/www/missy/furry-files/app.pyrows_to_dictsr   
   sJ     ,,-QAaD-D-,2OO,=>SDT3 >> .>s
   AA/c                       y)NzHello World! r       r   hello_worldr      s    r   z	/api/petsc                      t               } 	 | j                         }|j                  d       t        t	        |            | j                          S # | j                          w xY w)Nz-SELECT * FROM PetDetails ORDER BY pet_id DESC)r   r   executer   r   close)conncurs     r   	list_petsr      sF    :DkkmCD}S)*



s   4A A#z/api/pets/<int:pet_id>c                     t               }	 |j                         }|j                  d| f       t        |      }|rt	        |d         nddidf	 |j                          S # |j                          w xY w)Nz(SELECT * FROM PetDetails WHERE pet_id=%sr   errorz	not foundi  )r   r   r   r   r   r   )pet_idr   r   rowss       r   get_petr"      sd    :Dkkm>	JS!#'wtAww.Dc-JJ



s   AA! !A3c                     t        j                  d      xs i } d| vrddidfS g d}|D cg c]  }| j                  |       }}t               }	 |j	                         }dj                  d	gt        |      z        }|j                  d
dj                  |       d| dt        |             |j                          d|j                  idf|j                          S c c}w # |j                          w xY w)NTforcepet_namer   zpet_name required  
r&   date_of_birthdate_of_deathcause_of_deathgenderspeciesbreedmicrochippedmicrochip_vendormicrochip_number,z%szINSERT INTO PetDetails (z
) VALUES ()r       )r   get_jsongetr   r   joinlenr   tuplecommit	lastrowidr   )datafieldsfvaluesr   r   placeholderss          r   
create_petrA   &   s    $'-2D,-s22F $**adhhqk*F*:DkkmxxV 45.sxx/?.@
<.XYZ\abh\ij#--(#-

 + 	

s   C!A>C& &C8c                    t        j                  d      xs i }g d}|D cg c]  }||v s| d }}|sddidfS |D cg c]  }||v s||    }}|j                  |        t               }	 |j	                         }|j                  dd	j                  |       d
t        |             |j                          ddi|j                          S c c}w c c}w # |j                          w xY w)NTr$   r(   z=%sr   znothing to updater'   zUPDATE PetDetails SET z, z WHERE pet_id=%sok)
r   r5   appendr   r   r   r7   r9   r:   r   )r    r<   allowedkr=   r?   r   r   s           r   
update_petrG   ;   s    $'-2DG "&6Ag3i6F6,-s22#4!qG|d1g4F4
MM&:Dkkm,TYYv->,??OPRWX^R_`d|

 7 5 	

s#   	CC	CC1AC C/c                     t               }	 |j                         }|j                  d| f       |j                          ddi|j	                          S # |j	                          w xY w)Nz&DELETE FROM PetDetails WHERE pet_id=%srC   T)r   r   r   r:   r   )r    r   r   s      r   
delete_petrI   R   sM    :Dkkm<viHd|



s   6A A%__main__
FLASK_PORTi  z0.0.0.0T)hostportdebug)flaskr   r   r   
flask_corsr   dbr   os__name__appr   router   r6   r   r"   postrA   putrG   deleterI   intgetenvrM   runr   r   r   <module>r\      s   ) )   	Ho S	? 3    	!" # + ( 	!" #, $% & zyryyt,-D GGTG2 r   