
    Ah                     b   d dl Zd dlZd dlZd dlZddddddZdZdZd	Zd
Z	dZ
ddZd Zedk(  rd dlZdZ eej                         dkD  rej                   d   Z ede        n ed        ed        ee      Zer! ee        ed ee       dexs d        y edexs d        yy)    Nz
10.0.0.109i  voicebot_clusteradminzmcube@admin123)hostportdatabaseuserpassword
audio_jobsmcubez
mcube@0121vGadminc                    	 t        j                  j                  di t        }|j	                         }| r|  d}nd}d| d}|j                  |       |j                         }|j                          |j                          |S # t         j                  j                  $ r-}t        d|        t        j                  d       Y d }~y d }~ww xY w)N_calls
7417_callszSELECT callid, bid FROM z WHERE status = 0zError:     )mysql	connectorconnect	DB_CONFIGcursorexecutefetchallcloseErrorprintsysexit)bid
connectionr   calls_tablequerycallserrs          sC:\Users\pc\OneDrive\Desktop\new development\voicebot_full_code\voicebot final copy\local2\rabbitmqsarvam\rabbit.pyget_unprocessed_callsr%      s    __,,9y9
""$  E.K&K +;-7HIu! 	??   uos   BB C%#CCc           	         	 t        j                  t        t              }t        j                  t        j
                  t        t        |            }|j                         }|j                  t        d       | D ]]  \  }}||d}t        j                  |      }|j                  dt        |t        j                  d             t        d	| d
|        _ |j!                          t        d       y # t         j"                  j$                  $ r-}t        d|        t'        j(                  d       Y d }~y d }~ww xY w)N)r   virtual_hostcredentialsT)queuedurable)callidr       )delivery_mode)exchangerouting_keybody
propertiesu   ➡️ Queued callid: z, bid: u#   ✅ Done queuing unprocessed calls.zError connecting to RabbitMQ: r   )pikaPlainCredentialsRABBITMQ_USERRABBITMQ_PASSBlockingConnectionConnectionParametersRABBITMQ_HOSTRABBITMQ_VHOSTchannelqueue_declareRABBITMQ_QUEUEjsondumpsbasic_publishBasicPropertiesr   r   
exceptionsAMQPConnectionErrorr   r   )	r"   r(   r   r;   r+   r   message_datamessager#   s	            r$   send_to_rabbitmqrF   0   s%   $++M=I,,%%"+'

 $$& 	NDA !KFC L jj.G!!*//"#	 "  *6('#?@ !" 	34??.. .se45s   C5C8 8E#D==E__main__r   u1   📤 Fetching unprocessed calls for business ID: u5   📤 Fetching unprocessed calls from default table...u@   💡 Usage: python rabbit.py <bid> (e.g., python rabbit.py 6840)u   ✅ Queued z calls for business: defaultz)No unprocessed calls found for business: )N)mysql.connectorr   r3   r   r>   r   r9   r=   r5   r6   r:   r%   rF   __name__r   lenargvr   r"   r       r$   <module>rN      s      
  " 	 4&P z C
388}qhhqkA#GHEFPQ!#&ECJ<'<S=MI<NOP9#:J9KLM# rM   