Subscription Object

Note

This object is an extension the DB API and is only available in Oracle 10g Release 2 and higher.

Subscription.callback

This read-only attribute returns the callback that was registered when the subscription was created.

Subscription.connection

This read-only attribute returns the connection that was used to register the subscription when it was created.

Subscription.cqqos

This read-only attribute returns the cqqos used to register the subscription when it was created.

Subscription.id

This read-only attribute returns the registration ID returned by the database when this subscription was created. Support for this attribute requires Oracle 11g or higher.

Subscription.namespace

This read-only attribute returns the namespace used to register the subscription when it was created.

Subscription.operations

This read-only attribute returns the operations that will send notifications for each table or query that is registered using this subscription.

Subscription.port

This read-only attribute returns the port used for callback notifications from the database server. If not set during construction, this value is zero.

Subscription.protocol

This read-only attribute returns the protocol used to register the subscription when it was created.

Subscription.qos

This read-only attribute returns the qos used to register the subscription when it was created.

Subscription.registerquery(statement[, args])

Register the query for subsequent notification when tables referenced by the query are changed. This behaves similarly to cursor.execute() but only queries are permitted and the arguments must be a sequence or dictionary. If the cqqos parameter included the flag cx_Oracle.SUBSCR_CQ_QOS_QUERY when the subscription was created then the queryid for the registeredquery is returned.

Note

Query result set change notification is only available in Oracle 11g and higher.

Subscription.rowids

This read-only attribute returns True or False specifying if rowids will be included in notifications sent using this subscription.

Subscription.timeout

This read-only attribute returns the timeout (in seconds) used to register the subscription when it was created. A timeout value of 0 indicates that there is no timeout.

Message Objects

Note

This object is created internally when notification is received and passed to the callback procedure specified when a subscription is created.

Message.dbname

This read-only attribute returns the name of the database that generated the notification.

Message.queries

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 None if the cqqos parameter did not include the flag cx_Oracle.SUBSCR_CQ_QOS_QUERY when the subscription was created.

Message.subscription

This read-only attribute returns the subscription object for which this notification was generated.

Message.tables

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 None if the cqqos parameter included the flag cx_Oracle.SUBSCR_CQ_QOS_QUERY when the subscription was created.

Message.type

This read-only attribute returns the type of message that has been sent. See the constants section on database change notification for additional information.

Message Table Objects

Note

This object is created internally for each table changed when notification is received and is found in the tables attribute of message objects, and the tables attribute of message query objects.

MessageTable.name

This read-only attribute returns the name of the table that was changed.

MessageTable.operation

This read-only attribute returns the operation that took place on the table that was changed.

MessageTable.rows

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 rowids argument to the Connection.subscribe() method is True.

Message Row Objects

Note

This object is created internally for each row changed on a table when notification is received and is found in the rows attribute of message table objects.

MessageRow.operation

This read-only attribute returns the operation that took place on the row that was changed.

MessageRow.rowid

This read-only attribute returns the rowid of the row that was changed.

Message Query Objects

Note

This object is created internally for each query result set changed when notification is received and is found in the queries attribute of message objects.

Note

Query result set change notification is only available in Oracle 11g and higher.

MessageQuery.id

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 Subscription.registerquery when the related query was registered.

MessageQuery.operation

This read-only attribute returns the operation that took place on the query result set that was changed. Valid values for this attribute are cx_Oracle.EVENT_DEREG and cx_Oracle.EVENT_QUERYCHANGE.

MessageQuery.tables

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.