h."JddlZddlZddlZddlZddlmZmZddlmZddl m Z ddl m Z ejeje ejddZejd d Zejd d Zej&d eeeZdZddZy)N) BotoCoreError ClientError)get_db_connection) load_dotenv) send_message)levelAWS_ACCESS_KEY_IDAKIAUWPMKLMSD556YYR5AWS_SECRET_ACCESS_KEY(yOku358ASGrJPRdTWYfyKnUAVH6QN1qlR2fQO7KD AWS_REGIONz eu-north-1zbedrock-runtime) service_name region_nameaws_access_key_idaws_secret_access_keyzamazon.nova-lite-v1:0cH t}|j}|r |d}|d}nd}d}|jd|d|f|j}|D]}|d}t j d|d |r|dd nd d |r|j d k(rt jd|Zd|d} t j d|d | dddddd| igdgd} t j dtj| tjtddtj| } | djjd} t j d|d | d } | r|tj| }|j!d ij!d!ij!d"g}|r3t#|t$r#|d#j!dd j } | s&t j&d$|t)d%|| j+d&r1| j-d&d j-d'd j } n1| j+d'r | j-d'd j } | j-d(d j } t j d)|d |  tj| }tj|j!d,g}tj|j!d-g}tj|j!d.g}|j!d/d }tj|j!d0g}tj|j!d1i}t j d2|d3|d4|d5|d6|d7|d8||jd9|d:||||| ||||f |j3t5||t j d;||j=|j=y#tj.$rB}t j&d*|d t1|t j&d+| d}~wwxYw#t6t8tj.t(f$rU}t j&d<|d t1|t j&d=d"t;vr nd>Yd}~d}~wwxYw)?N_sarvamresponse_calls7417_sarvamresponse 7417_callszSELECT * FROM z! WHERE callid = %s AND status = 1u%🔍 Retrieved transcript for callid z: dNonez...u+⚠️ Empty or null transcript for callid aE Analyze the following customer call transcript and return the following in JSON format: 1. Top 5 Keywords 2. Overall Sentiment with all (Positive, Negative, Neutral) with percentage 3. Detected Emotions (e.g., Happy, Angry, Frustrated) 4. Summary of the Call 5. Sales Intent (High, Medium, Low) 6. Customer Details (name, phone, email if available) Transcript: "z" zSending prompt for callid igffffff?g?)max_new_tokens temperaturetop_pusertext)rolecontent)inferenceConfigmessageszRequest body: zapplication/json)modelId contentTypeacceptbodyr'zutf-8zRaw response body for callid outputmessager!rz"Empty content received for callid z8Empty content received from Bedrock response for callid z```jsonz``` z$Cleaned response content for callid zJSON decode error for callid zInvalid content: zTop 5 KeywordszOverall SentimentzDetected EmotionszSummary of the Callz Sales IntentzCustomer DetailszParsed data for callid z : Keywords: z , Sentiment: z , Emotions: z , Summary: z , Sales: z , Customer: z UPDATE aa SET status = 2, keywords = %s, sentiments = %s, emotions = %s, summary = %s, sand_logic_response = %s, sales_intent = %s, transcripts = %s, customer_details = %s WHERE callid = %s u✅ Bedrock processed callid u❌ Bedrock error for callid u⚠️ Failed content: zNo content available)rcursorexecutefetchalllogginginfostripwarningjsondumpsbedrock invoke_modelMODEL_IDreaddecodeloadsget isinstancelisterror ValueError startswithreplaceJSONDecodeErrorstrcommitrrrlocalsclose)call_idbidconnr+sarvam_response_table calls_tablecallscall transcriptpromptr'response raw_responser! response_body content_listparsedekeywords sentimentemotionssummary salesintentcustomer_detailss CC:\Users\pc\OneDrive\Desktop\local2\rabbitmqsarvam\openai_helper.pysend_openai_analysisr\ks0  D [[]F #&% 7Vn 5"  NN^$9#::[\_f^hi OO E!W   $**T*:);< =++ .)ZZ% ,H$F+00299'BL LL8 L>R SG $ < 8 ,002>BB9bQUUV_acd J|T$B*1o11&"=CCEG B7)LM #[\c[d!eff!!),!//)R8@@KQQS##E*!//%4::<oodB/557G LL?y7)T U G, zz&**-=r"BCH 6::.A2#FGIzz&**-@""EFHjj!6;G**VZZ%CDK#zz&**5G*LM  LL27)<zQ^_h^iiuv~u@KLSKTT]^i]jjvwGvHI J NN #} %  Ix';PZ\lnuv x KKM # & LL8 B CMX LLNJJLK''  =gYbQQR 1';< @{D,@,@*M t MM9'"SVHM N MM3yFH?TGZp3qr s s ts?!G.R)Q%ER)R&$=R!!R&&R))#T! A TT!)N)osr2r.boto3botocore.exceptionsrr db_configrdotenvrmessage_helperr basicConfigINFOgetenvr r r clientr4r6r\r[risb  :''',,' BII13IJ! "9;ef RYY|\ 2 %,,"'/   #|rh