Triggers

Triggers are identified by name, which can be a string, integer, float, or a few other datatypes. The name must be unique, however you may have infinite triggers.

Creating

You can add a trigger something like this:

import time
def handler(db, datapoint, table, event):
            print("Handler being called on event " + event + " on datapoint " + str(datapoint) + " in table " + table)
            db.Save(str(time.time()),table)
db.AddTrigger("Trigger Name", "AFTER UPDATE", "Table name", handler)

That will make any update to something in the “Table name” table print a message and make a new savepoint. Beware that this will run for each individual datapoint.

You may also use lambda expressions.

Valid events are "BEFORE INSERT", "AFTER INSERT", "BEFORE DELETE", "AFTER DELETE", "BEFORE UPDATE" and "AFTER UPDATE"

With INSERT and DELETE, the same datapoint is passed to both BEFORE and AFTER handlers. With UPDATE, the old and new datapoints are passed to the BEFORE and AFTER handlers, respectively.

You may have multiple triggers for a single event.

Checking

Check if a trigger exists like this:

db.TriggerExists("Trigger name")

Listing

List triggers like this:

db.ListTriggers()

Removing

Remove like this:

db.RemoveTrigger("Trigger name")