
    CTh                         d dl Z d dlmZ d dlZd dlZ ej
                  d ej                  d               ej                  ej                          e ej                  d            Z	d Z
y)    N)OpenAIzOPENAI_API_KEY is: OPENAI_API_KEY)level)api_keyc                     	 t        j                  ddddd      }|j                         }|j                  d| f       |j	                         }|syg }|D ]+  \  }}|j                  d	|      }|j                  ||d
       - t        j                  j                  j                  d|      }	|	j                  d   j                  j                  S # t        $ r"}
t        j                   d|
        Y d }
~
yd }
~
ww xY w)N	localhostopenai_userz,IOyg76H2l%252BewRX2xhsDJAo7qnfVDHtx9RB%253D%openai_promptsutf8mb4)hostuserpasswddbcharsetzr
            SELECT role, content FROM prompt_messages
            WHERE prompt_id = %s ORDER BY sequence
        z$Prompt not found or has no messages.z{user_input})rolecontentzgpt-4)modelmessagesr   zOpenAI or DB error: zError generating response.)MySQLdbconnectcursorexecutefetchallreplaceappendclientchatcompletionscreatechoicesmessager   	Exceptionloggingerror)	prompt_id
user_inputconnr   rowsr   r   r   filledresponsees              -/var/www/html/decompression/prompt_manager.pycall_openai_promptr-      s   %,
 A
   \	  9! 	?MD'__^Z@FOOTf=>	? ;;**11 2 
 "**222 ,,QC01+,s   AC A?C 	C=C88C=)r   openair   osr#   infogetenvbasicConfigINFOr   r-        r,   <module>r6      se      	  "9299-=#>"?@ A   ',, '
 
			"23	4&,r5   