
    `3h                     z   d dl mZmZmZ d dlmZ d dlZd dlmZ d dl	m	Z	  ee
      Z eedddii	       d
 Zej                  ddg      d        Zej                  ddg      d        Zej                  ddg      d        Zej                  ddg      d        Ze
dk(  rej%                  ddd       yy)    )Flaskjsonifyrequest)CORSN)Error)datetimez/api/*origins*)	resourcesc                      	 t        d       t        j                  j                  dddd      } t        d       | S # t        $ r}t        d|        Y d }~y d }~ww xY w)	Nz$Attempting to connect to database...157.173.210.15roottechn0l0vMasterAdm1n
TestAgent1)hostuserpassworddatabasezDatabase connection successful!z$Error connecting to MySQL Database: )printmysql	connectorconnectr   )
connectiones     6/home/kushmeetdev/apache_webroot/flask_project1/app.pycreate_db_connectionr      si    45__,,!+!	 - 

 	/0 4QC89s   := 	AAAz/api/requestsGET)methodsc                     	 t               } | r| j                  d      }|j                  d       |j                         }|j	                          | j	                          t        d|d      }|j                  j                  dd       |S t        dd	d
      dfS # t        $ r#}t        dt        |      d
      dfcY d }~S d }~ww xY w)NT
dictionaryz
                SELECT BUID, RequestID, ToDept, FromRoomNo, RequestDescp, BotResponse,
                    Status, RequestCreatedAt, LastUpdatedAt, AttendedBy, GuestName, Notes 
                FROM t_Requests
                successstatusdataAccess-Control-Allow-Originr
   errorDatabase connection failedr$   message  
r   cursorexecutefetchallcloser   headersaddr   strr   r-   r%   responser   s        r   get_all_requestsr6      s    D)+
&&$&7FNN   ??$DLLN)TBCH  !>DOg:VWXZ]]] D'c!f=>CCDs$   B
B B 	C	&C>C	C	z,/api/requests/department/<string:department>c                    	 t               }|r|j                  d      }|j                  d| f       |j                         }|j	                          |j	                          t        d|d      }|j                  j                  dd       |S t        dd	d
      dfS # t        $ r#}t        dt        |      d
      dfcY d }~S d }~ww xY w)NTr    z
                SELECT BUID, RequestID, ToDept, FromRoomNo, RequestDescp, BotResponse,
                       Status, RequestCreatedAt, LastUpdatedAt, AttendedBy, GuestName, Notes
                FROM t_Requests WHERE ToDept = %s
            r"   r#   r&   r
   r'   r(   r)   r+   r,   )
departmentr   r-   r%   r5   r   s         r   get_requests_by_departmentr9   5   s    D)+
&&$&7FNN  	  ??$DLLN9d CDH  !>DOg:VWXZ]]] D'c!f=>CCDs$   BB B 	C(C CCz!/api/requests/<string:request_id>PUTc                    	 t         j                  }|st        ddd      dfS t               }|rZ|j	                         }|j                  d| f       |j                         s0|j                          |j                          t        ddd      dfS g }g }g d}|D ]/  }||v s|j                  | d	       |j                  ||          1 |j                  d
       |j                  t        j                         j                  d             |j                  |        |r7ddj                  |       d}|j                  ||       |j                          |j                          |j                          t        ddd      S t        ddd      dfS # t        $ r#}	t        dt        |	      d      dfcY d }	~	S d }	~	ww xY w)Nr'   zNo data providedr)   i  z5SELECT RequestID FROM t_Requests WHERE RequestID = %szRequest not foundi  )	BUIDToDept
FromRoomNoRequestDescpBotResponseStatus
AttendedBy	GuestNameNotesz = %szLastUpdatedAt = %sz%Y-%m-%d %H:%M:%SzUPDATE t_Requests SET z, z WHERE RequestID = %sr"   zRequest updated successfullyr(   r+   )r   jsonr   r   r-   r.   fetchoner0   appendr   nowstrftimejoincommitr   r3   )

request_idr%   r   r-   update_fieldsvaluesfieldsfieldqueryr   s
             r   update_requestrR   O   s   3D|| g:LMNPSSS)+
&&(F NNRU_Tab??$  "'>QRSUXXX MFF
   /D=!((E7%9MM$u+./   !56MM(,,.112EFG MM*%0=1I0JJ_`uf-!!#LLNi<Z[\\g:VWXZ]]] D'c!f=>CCDs6   !F A/F F &C$F F 	G$G<GGz
/api/usersc                     	 t               } | r| j                  d      }|j                  d       |j                         }t	        d|        |j                          | j                          t        d|d      }|j                  j                  dd       |S t        d	d
d      dfS # t        $ r#}t        d	t        |      d      dfcY d }~S d }~ww xY w)NTr    zSELECT * FROM t_UserszData from t_Users: r"   r#   r&   r
   r'   r(   r)   r+   )r   r-   r.   r/   r   r0   r   r1   r2   r   r3   r4   s        r   get_all_usersrT      s    D)+
&&$&7FNN23??$D'v./LLN)TBCH  !>DOg:VWXZ]]] D'c!f=>CCDs$   BB+ B+ +	C4CCC__main__r   i  T)r   portdebug)flaskr   r   r   
flask_corsr   mysql.connectorr   r   r   __name__appr   router6   r9   rR   rT   run     r   <module>ra      s    ) )   ! Ho SYC 01 2  ?UG,D -D2 9E7KD LD2 .@4D A4Dl <%)D *D$ zGG!DG9 r`   