
    zoi                     *   S SK JrJrJr  S SKJr  S SKJrJr  S SK	J
r
Jr  S SKrS SKrS SKJrJrJrJr  S SKJr  S SKJr  S S	KJr  \" S
\SS9r\R5                  SS/S9S 5       r\R5                  SS/S9S 5       r\R5                  S5      S 5       rg)    )	Blueprintrequestjsonify)error_response)SelectDelete)ORGANISED_FILE_PATHQUESTION_DATAN)ConceptTableSubConceptTableQuestionTableAvatarTable)db)SchoolTable)avatar_dictadminz/admin)
url_prefixz/bulk_add_questionPOST)methodsc                  	    [         R                  " 5       n U R                  S5      nU R                  S5      nU(       a  U(       d  [        SS5      $ [	        [
        SSS9 n[        R                  " U5      nXB   SU 3   R                  5        GHe  u  pV[        [        5      R                  [        R                  U:H  [        R                  U:H  [        R                  UR                  5       :H  [        R                   U S	U S
UR                  5        S3:H  5      n["        R$                  R'                  U5      R)                  5       nU(       dn  [        UUUR                  5       U S	U S
UR                  5        S3S9n["        R$                  R+                  U5        ["        R$                  R-                  5         UR                  S5      n	UR                  S5      n
U	R                  5        GH  u  pUR                  S5      n[        [.        5      R                  [.        R0                  UR2                  :H  [.        R                  U:H  [.        R                  U:H  [.        R                  U:H  5      n["        R$                  R'                  U5      R)                  5       nU(       da  [/        UR2                  UUUR                  5       S9n["        R$                  R+                  U5        ["        R$                  R-                  5         [4        R6                  R9                  [:        USU 3X5      n[	        USSS9 n[        R                  " U5      nS S S 5        WR                  S/ 5      nU Hv  n[=        UR2                  UR                  SS5      UR                  S5      UR                  S5      UR                  S5      S9n["        R$                  R+                  U5        Mx     GM     GMh     S S S 5        ["        R$                  R?                  5         [A        SSS.5      S4$ ! , (       d  f       N= f! , (       d  f       NM= f! [B         a$  n[A        SS[E        U5      S.5      S4s S nA$ S nAff = f) NgradestreamzPayload required  rzutf-8)encodinggrade_z concept for Grade z (z).)namer   r   descriptionsubconceptsfolder_namefile)
concept_idr   r   r   	questions
difficultyeasyquestionoptionscorrect_answer)subconcept_idr$   r&   r'   r(   TzAll workingsuccessmessage   FInternal server errorr+   r,   error  )#r   get_jsongetr   openr	   jsonloaditemsr   r   wherer   r   r   upperr   r   sessionexecutescalar_one_or_noneaddflushr   r"   idospathjoinr
   r   commitr   	Exceptionstr)bodyr   r   forg_conceptconceptconcept_valstmt_find_concept
db_conceptr   concept_foldersub_namesub_val	file_namestmt_find_subconceptdb_subconcept	full_path	ques_data	data_fileall_quesqnew_qes                          9D:\beyond school\05_solvesmart\server\src\routes\admin.pyadd_quesr[      s   J!!(#F!"4c::%sW=))A,K(3(;fUG<L(M(S(S(U$$*<$8$>$> %%0 &&%/ ''6<<>9 ,,7);NugUWX^XdXdXfWggi0jj	%!  ZZ//0ABUUW
!!-& %!')0	1DUG2fllnM]]_&`	"J JJNN:.JJ$$&)oom<!,!?)4):):)<%H 'F 3I+1/+B+H+H'22jmmC',,8'--6'..&8	,( %'JJ$6$67K$L$_$_$aM((7)3#+$)%+\\^	) 

}5

((* "]FfUGDTVd pIiw?9$(IIi$8	 @(}}["=H% -*7*:*:'(uu\6'B%&UU:%6$%EE)$4+,551A+B! 

u- &- *=- )V >p 	

$
   	 @?W >=z  .V
  	 	sV   AQ Q "K"QP1	B Q;5Q 1
P?;Q
QQ 
RQ<6R<Rz/add-schoolc                      [         R                  " 5       n U R                  S5      nU R                  S5      nU(       a  U(       d  [        SS5      $ [	        UUSS9n[
        R                  R                  U5        [
        R                  R                  5         [        SSUR                  UR                  S	.5      $ ! [         a$  n[        S
S[        U5      S.5      S4s S nA$ S nAff = f)Nschool_name	school_idzpayload requiredr   CBSE)r]   r^   r   TzSchool added)r+   r,   zschool namez	school idFr.   r/   r1   )r   r2   r3   r   r   r   r:   r=   rC   r   r]   r^   rD   rE   )rF   r]   r^   
new_schoolrY   s        rZ   
add_schoolra   ^   s    !hh}-HH[)	)!"4c:: #


 	

z"


%&22#--	
  	  .V
  	 	s%   AB? A+B? ?
C-	C("C-(C-z/add_avatarc                      [         R                  R                  [        [        5      5        [         R                  R                  5         [         H6  n [	        U S   U S   U S   S9n[         R                  R                  U5        M8     [         R                  R                  5         [        SSS.5      $ ! [         a$  n[        SS	[        U5      S
.5      S4s S nA$ S nAff = f)Nr?   avatarprice)r?   rc   rd   TzAll avatars added successfully!r*   Fr.   r/   r1   )r   r:   r;   r   r   rC   r   r=   r   rD   rE   )avtnew_avtrY   s      rZ   
add_avatarrg   ~   s    


6+./


C!t98}'lG
 JJNN7#  	

8
  	
  .V
  	 	s   B5B8 8
C&C!C&!C&)flaskr   r   r   src.utils.responser   
sqlalchemyr   r   envr	   r
   r5   r@   
src.modelsr   r   r   r   srcr   r   src.utils.avatarr   __name__admin_bprouter[   ra   rg        rZ   <module>rt      s    - - - % 2  	 P P  " (Wh8< 
$vh7K 8K\ 
x0 1> 
 rs   