&h0ddlZddlZddlZddlZddlmZmZddlmZddl m Z ej ej e ej dejdZd Zd ZdS) N) BotoCoreError ClientError)get_db_connection) load_dotenv)levelzbedrock-runtime AWS_REGION) service_name region_namezRarn:aws:bedrock:eu-north-1:003900767884:inference-profile/eu.amazon.nova-lite-v1:0c t}|}|d|f|}|D]}|d}d|d}t jd|d|ddd d d d |igd gd} t jdt j|t tddt j|}|d d} t jd|d| d} | rt j | } | dididg} | rCt| t r.| dd d} | s)t jd|t'd|| dr=| dddd} n=| dr(| dd} | dd} t jd|d|  t j | } nV#t j$rD}t jd |dt/|t jd!| d}~wwxYwt j| d"g}t j| d#g}t j| d$g}| d%d}t j| d&g}t jd'|d(|d)|d*|d+|d,| |d-||||| |||f|t jd.| #t2t4t jt&f$r[}t jd/|dt/|t jd0dt7vr| nd1Yd}~d}~wwxYw||dS)2NzBSELECT * FROM 6840_sarvamresponse WHERE callid = %s AND status = 1a 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) Transcript: "z" zSending prompt for callid z: igffffff?g?)max_new_tokens temperaturetop_pusertext)rolecontent)inferenceConfigmessageszRequest body: zapplication/json)modelId contentTypeacceptbodyrzutf-8zRaw response body for callid outputmessagerrz"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 IntentzParsed data for callid z : Keywords: z , Sentiment: z , Emotions: z , Summary: z,slaes:a\ UPDATE 7417_calls SET status = 2, keywords = %s, sentiments = %s, emotions = %s, summary = %s, sand_logic_response = %s, sales_intent = %s, transcripts = %s WHERE callid = %s u✅ Bedrock processed callid u❌ Bedrock error for callid u⚠️ Failed content: zNo content available)rcursorexecutefetchalllogginginfojsondumpsbedrock invoke_modelMODEL_IDreaddecodeloadsget isinstanceliststriperror ValueError startswithreplaceJSONDecodeErrorstrcommitrrlocalsclose)call_idconnrcallscall transcriptpromptrresponse raw_responser response_body content_listparsedekeywords sentimentemotionssummary salesintents -C:\wamp64\www\rabbitmqsarvam\openai_helper.pysend_openai_analysisrJds   D [[]]F NNWZaYcddd OO  E`t`t!W  &     E'EEVEEFFF#'"  # &/0   A t L<$*T*:*:<< = = =++ .)Z%% ,H$F+002299'BBL LRRRLRR S S SG F $ < 8 8 ,002>>BB9bQQUUV_acdd FJ|T$B$BF*1o11&"==CCEEG g L7LLMMM !e\c!e!efff!!),, =!//)R88@@KKQQSS##E** =!//%44::<<oodB//5577G LTTT7TT U U U G,,'    QgQQQQQRRR ;';;<<<  z&**-=r"B"BCCH 6::.A2#F#FGGIz&**-@""E"EFFHjj!6;;G*VZZ%C%CDDK Li7iiii_hiiv~iiLSii\gii j j j NN Ix';PZ\cd f f f KKMMM LBBB C C C C{D,@*M t t t MM'MMSVVMM N N N MryFHH?T?TGGZprr s s s s s s s s t LLNNNJJLLLLLs? HrVsb  ::::::::''''''','''' %," ,''    `jjjjjrU