i0ddlmZmZmZddlmZddlmZGddeZGdd eZ Gd d eZ Gd d eZ GddeZ dS))CallableOptionalUnion) BaseMetaClass connectionceZdZdZedZedefdZeddZ ede fdZ ede fdZ ede fd Zede fd Zede fd Zede fd Zede fd Zede fdZede fdZ dde deeeefde fdZede fdZdS) Subscriptioncd|jdS)Nzrselfs _/var/www/html/Pagina-Ingenieria-Requisitos/venv/lib/python3.11/site-packages/oracledb/subscr.py__repr__zSubscription.__repr__'s@DO@@@@c>||}||_|SN)__new___impl)clsimplsubscrs r _from_implzSubscription._from_impl*sS!!  rreturnc|jjS)z~ This read-only attribute returns the callback that was registered when the subscription was created. )rcallbackrs rrzSubscription.callback0 z""rconnection.Connectionc|jjS)z This read-only attribute returns the connection that was used to register the subscription when it was created. )rr rs rr zSubscription.connection8s z$$rc|jjS)a  This read-only attribute returns the value of REGID found in the database view USER_CHANGE_NOTIFICATION_REGS or the value of REG_ID found in the database view USER_SUBSCR_REGISTRATIONS. For AQ subscriptions, this value is *0*. )ridrs rr"zSubscription.id@sz}rc|jjS)z This read-only attribute returns the IP address used for callback notifications from the database server. If not set during construction, this value is *None*. )r ip_addressrs rr$zSubscription.ip_addressJz$$rc|jS)z> Deprecated. Use property ip_address instead. )r$rs r ipAddresszSubscription.ipAddressS rc|jjS)zz This read-only attribute returns the name used to register the subscription when it was created. )rnamers rr*zSubscription.nameZs zrc|jjS)z This read-only attribute returns the namespace used to register the subscription when it was created. )r namespacers rr,zSubscription.namespacebs z##rc|jjS)z This read-only attribute returns the operations that will send notifications for each table or query that is registered using this subscription. )r operationsrs rr.zSubscription.operationsjr%rc|jjS)z This read-only attribute returns the port used for callback notifications from the database server. If not set during construction, this value is *0*. )rportrs rr0zSubscription.portsszrc|jjS)z~ This read-only attribute returns the protocol used to register the subscription when it was created. )rprotocolrs rr2zSubscription.protocol|rrc|jjS)z This read-only attribute returns the quality of service flags used to register the subscription when it was created. )rqosrs rr4zSubscription.qoss z~rN statementargsc|+t|ttfstd|j||S)a  Registers the query for subsequent notification when tables referenced by the query are changed. This behaves similarly to :meth:`Cursor.execute()` but only queries are permitted and the ``args`` parameter, if specified, must be a sequence or dictionary. If the ``qos`` parameter included the flag :data:`oracledb.SUBSCR_QOS_QUERY` when the subscription was created, then the ID for the registered query is returned; otherwise, *None* is returned. Nz)expecting args to be a dictionary or list) isinstancelistdict TypeErrorrregister_query)rr5r6s r registerqueryzSubscription.registerquerysD  JtdD\$B$B GHH Hz((D999rc|jjS)z This read-only attribute returns the timeout (in seconds) that was specified when the subscription was created. A value of *0* indicates that there is no timeout. )rtimeoutrs rr?zSubscription.timeoutsz!!r)rrr)__name__ __module__ __qualname__r classmethodrpropertyrrr intr"strr$r'r*r,r.r0r2r4rrr9r:r=r?rrr r &sTAAA[ #(###X#%%%X%CX%C%%%X%3X cX$3$$$X$%C%%%X%cX#####X#SXCG:::$,U4:->$?: ::::"""""X"""rr ) metaclassceZdZdeddfdZedeedffdZedeedffdZ edeedffdZ edee dffdZ ede d fd Zedeedffd Zedeedffd Zedefd ZedefdZede dfdZedee dffdZedefdZdS)Message subscriptionrNc||_d|_d|_g|_d|_d|_g|_d|_d|_d|_ dS)NFr) _subscription_consumer_name_dbname_queries _queue_name _registered_tables_txid_type_msgid)rrKs r__init__zMessage.__init__sP)"       rc|jS)a& This read-only attribute returns the name of the consumer which generated the notification. It will be populated if the subscription was created with the namespace :data:`oracledb.SUBSCR_NAMESPACE_AQ` and the queue is a multiple consumer queue. )rNrs r consumer_namezMessage.consumer_names ""rc|jS)zA Deprecated. Use property consumer_name instead. )rYrs r consumerNamezMessage.consumerNames !!rc|jS)zt This read-only attribute returns the name of the database that generated the notification. )rOrs rdbnamezMessage.dbnames |rc|jS)z This read-only attribute returns the message id of the AQ message that generated the notification. It will only be populated if the subscription was created with the namespace :data:`oracledb.SUBSCR_NAMESPACE_AQ`. )rVrs rmsgidz Message.msgids {r MessageQueryc|jS)a\ This read-only attribute returns a list of message query objects that give information about query result sets changed for this notification. This attribute will be an empty list if the ``qos`` parameter did not include the flag :data:`~oracledb.SUBSCR_QOS_QUERY` when the subscription was created. )rPrs rquerieszMessage.queriess }rc|jS)z This read-only attribute returns the name of the queue which generated the notification. It will only be populated if the subscription was created with the namespace :data:`oracledb.SUBSCR_NAMESPACE_AQ`. )rQrs r queue_namezMessage.queue_names rc|jS)z> Deprecated. Use property queue_name instead. )rdrs r queueNamezMessage.queueNamer(rc|jS)a This read-only attribute returns whether the subscription which generated this notification is still registered with the database. The subscription is automatically deregistered with the database when the subscription timeout value is reached or when the first notification is sent (when the quality of service flag :data:`oracledb.SUBSCR_QOS_DEREG_NFY` is used). )rRrs r registeredzMessage.registereds rc|jS)z} This read-only attribute returns the subscription object for which this notification was generated. )rMrs rrKzMessage.subscriptions !!r MessageTablec|jS)aN This read-only attribute returns a list of message table objects that give information about the tables changed for this notification. This attribute will be an empty list if the ``qos`` parameter included the flag :data:`~oracledb.SUBSCR_QOS_QUERY` when the subscription was created. rSrs rtableszMessage.tabless |rc|jS)zu This read-only attribute returns the id of the transaction that generated the notification. )rTrs rtxidz Message.txid zrc|jS)zb This read-only attribute returns the type of message that has been sent. )rUrs rtypez Message.typerpr)r@rArBr rWrDrrFrYr[r]bytesr_r9rbrdrfboolrhrKrmrorErrrGrrrJrJsS \ d    #uS$Y/###X#"eCI."""X" c4i(XuUD[)Xn-X E#t),   X 5d+X   D    X  "l"""X"^,XeE4K(XcXrrJcveZdZddZedefdZedefdZededfdZ dS) r`rNc0d|_d|_g|_dSNr)_id _operationrSrs rrWzMessageQuery.__init__$s rc|jS)z This read-only attribute returns the query id of the query for which the result set changed. The value will match the value returned by :meth:`Subscription.registerquery()` when the related query was registered. )rxrs rr"zMessageQuery.id)s xrc|jS)z This read-only attribute returns the operation that took place on the query result set that was changed. Valid values for this attribute are :data:`~oracledb.EVENT_DEREG` and :data:`~oracledb.EVENT_QUERYCHANGE`. ryrs r operationzMessageQuery.operation3s rrjc|jS)z This read-only attribute returns a list of message table objects that give information about the table changes that caused the query result set to change for this notification. rlrs rrmzMessageQuery.tables<s |rrN) r@rArBrWrDrEr"r}r9rmrGrrr`r`#s CX3X^,Xrr`c^eZdZddZedefdZedeedffdZ dS) MessageRowrNc"d|_d|_dSrw)ry_rowidrs rrWzMessageRow.__init__Gs rc|jS)zu This read-only attribute returns the operation that took place on the row that was changed. r|rs rr}zMessageRow.operationK rc|jS)zY This read-only attribute returns the rowid of the row that was changed. )rrs rrowidzMessageRow.rowidSs {rr) r@rArBrWrDrEr}rrFrrGrrrrFs3XuS$Y'XrrceZdZddZedeedffdZedefdZ ede dfdZ dS) rjrNc0d|_d|_g|_dSrw)_namery_rowsrs rrWzMessageTable.__init__\s  rc|jS)zb This read-only attribute returns the name of the table that was changed. )rrs rr*zMessageTable.namearprc|jS)zw This read-only attribute returns the operation that took place on the table that was changed. r|rs rr}zMessageTable.operationirrrc|jS)aE This read-only attribute returns a list of message row objects that give information about the rows changed on the table. This value is only filled in if the ``qos`` parameter to the :meth:`Connection.subscribe()` method included the flag :data:`~oracledb.SUBSCR_QOS_ROWIDS`. )rrs rrowszMessageTable.rowsqs zrr) r@rArBrWrDrrFr*rEr}r9rrGrrrjrj[s eCI&X3Xd<(XrrjN) typingrrrbaserr r rJr`rrjrGrrrsTB-,,,,,,,,,~"~"~"~"~"]~"~"~"~"Byyyyy yyyyx     ]    F=*]r