events_handlers

0 rows


Description

This table is for storing which components requests what type of event, and the location of the responsible handlers. For example, the assignment registers ‘grade_updated’ event with a function assignment_grade_handler() that should be called event time an ‘grade_updated’ event is triggered by grade_update() function.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
events_queue_handlers.handlerid evenqueuhand_han2_fkR
eventname VARCHAR 166

name of the event, e.g. ‘grade_updated’
component VARCHAR 166

e.g. moodle, mod_forum, block_rss_client
handlerfile VARCHAR 255

path to the file of the function, eg /grade/export/lib.php
handlerfunction LONGTEXT 2147483647 √ null

serialized string or array describing function, suitable to be passed to call_user_func()
schedule VARCHAR 255 √ null

‘cron’ or ‘instant’.
status BIGINT 19 0

number of failed attempts to process this handler
internal TINYINT 3 1

1 means standard plugin handler, 0 indicates if event handler sends data to external systems, this is used for example to prevent immediate sending of events from pending db transactions

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
evenhand_evecom_uix Must be unique Asc/Asc eventname + component

Relationships

Close relationships within degrees of separation