/Z.ht ddlmZmZmZddlmZddlZddlmZddl m Z ee Z ee dddii d Z e jd d g dZe jdd g dZe jdd g dZe jddg dZe jdd g dZe dk(re j'dddyy))Flaskjsonifyrequest)CORSN)Error)datetimez/api/*origins*) resourcesc tdtjjdddd}td|S#t$r}td|Yd}~yd}~wwxYw) Nz$Attempting to connect to database...157.173.210.15roottechn0l0vMasterAdm1n RoyalOrchid)hostuserpassworddatabasezDatabase connection successful!z$Error connecting to MySQL Database: )printmysql connectorconnectr) connectiones &/home/kushmeetdev/Regenta/Flask/app.pycreate_db_connectionr si  45__,,!+" - /0  4QC89s:= AAAz/api/timezone/GET)methodsc t}|r1|jd}|jd|f|j}|s0|j |j t ddddfS|d}|jd |f|j}|s0|j |j t dd ddfS|d }|jd |f|j}|j |j |st dd ddfSt d||||dddSt ddddfS#t $r#}t dt|ddfcYd}~Sd}~wwxYw)NT dictionaryzN SELECT organization_id FROM t_BU WHERE BUID = %s errorzBUID not foundstatusmessageorganization_idzS SELECT Timezone_id FROM t_organizations WHERE id = %s zOrganization not found Timezone_idzZ SELECT Timezone_Name FROM config_timezone_self WHERE id = %s zTimezone not foundsuccess Timezone_Name)buidr' timezone_id timezone_namer$dataDatabase connection failed)rcursorexecutefetchonecloserrstr) r+rr2 org_resultr' tz_resultr,tz_name_resultrs rget_timezone_for_buidr:s7D)+ &&$&7F NN  *J   "'>NOPRUUU():;O NN!# %)I   "'>VWXZ]]]#M2K NN !$__.N LLN    !'>RSTVYYY# '6#.%3O%D  g:VWXZ]] ] D'c!f=>CCDs8A3E6AEAE*EE E<E71E<7E<z /api/requestsc t}|r|jd}|jd|j}|j |j t d|d}|j jdd|St dd d d fS#t$r#}t dt|d d fcYd}~Sd}~wwxYw) NTr z SELECT BUID, RequestID, ToDept, FromRoomNo, RequestDescp, BotResponse, Status, RequestCreatedAt, LastUpdatedAt, AttendedBy, GuestName, Notes FROM t_Requests r)r.Access-Control-Allow-Originr r"r0r#r1 rr2r3fetchallr5rheadersaddrr6rr2r/responsers rget_all_requestsrCWsD)+ &&$&7F NN  ??$D LLN    )TBCH    !> DOg:VWXZ]] ] D'c!f=>CCDs$B B B C &C>C C z,/api/requests/department/c t}|r|jd}|jd|f|j}|j |j t d|d}|j jdd|St dd d d fS#t$r#}t dt|d d fcYd}~Sd}~wwxYw) 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"r0r#r1r=) departmentrr2r/rBrs rget_requests_by_departmentrFpsD)+ &&$&7F NN  ??$D LLN    9d CDH    !> DOg:VWXZ]] ] D'c!f=>CCDs$B BB C (CC C z!/api/requests/PUTc tj}|stddddfSt}|rZ|j }|j d|f|j s0|j|jtddddfSg}g}gd}|D]/}||vs|j|d |j||1|jd |jtjjd |j||r7d d j|d}|j |||j|j|jtdddStddddfS#t$r#} tdt| ddfcYd} ~ Sd} ~ wwxYw)Nr"zNo data providedr#iz5SELECT RequestID FROM t_Requests WHERE RequestID = %szRequest not foundr&) BUIDToDept FromRoomNo RequestDescp BotResponseStatus AttendedBy GuestNameNotesz = %szLastUpdatedAt = %sz%Y-%m-%d %H:%M:%SzUPDATE t_Requests SET z, z WHERE RequestID = %sr)zRequest updated successfullyr0r1)rjsonrrr2r3r4r5appendrnowstrftimejoincommitrr6) request_idr/rr2 update_fieldsvaluesfieldsfieldqueryrs rupdate_requestr^s3D||g:LMNPSS S)+ &&(F NNRU_Ta b??$   "'>QRSUXXXMFF   /D=!((E7%9MM$u+. /  !5 6 MM(,,.112EF G MM* %0=1I0JJ_`uf-!!# LLN    iCCDs6!FA/FF&C$F F G$G<GGz /api/usersc t}|r|jd}|jd|j}t d||j |j t d|d}|jjdd|St d d d d fS#t$r#}t d t|d d fcYd}~Sd}~wwxYw) NTr zSELECT * FROM t_UserszData from t_Users: r)r.r<r r"r0r#r1) rr2r3r>rr5rr?r@rr6rAs r get_all_usersr`sD)+ &&$&7F NN2 3??$D 'v. / LLN    )TBCH    !> DOg:VWXZ]] ] D'c!f=>CCDs$BB+B++ C4C CC__main__r iT)rportdebug)flaskrrr flask_corsrmysql.connectorrrr__name__apprrouter:rCrFr^r`runrrms))! HoSYC 012   %w78D88Dv?UG,D-D0 9E7KDLD2 .@4DA4Dl<%)D*D$ zGG!DG9rl