glints
.analytics
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_action_logs_summary()
Parameters
Name
Type
Mode
IN
Definition
DECLARE row_count integer; BEGIN row_count := ( SELECT count(*) FROM analytics."ActionLogSummary" WHERE object = NEW.object AND action = NEW.action AND collection = NEW.collection ); IF (row_count > 0) THEN UPDATE analytics."ActionLogSummary" SET count = analytics."ActionLogSummary".count + 1 WHERE object = NEW.object AND action = NEW.action AND collection = NEW.collection; ELSE INSERT INTO analytics."ActionLogSummary"( object, action, collection, count ) VALUES ( NEW.object, NEW.action, NEW.collection, ( SELECT count(*) FROM public."ActionLogs" WHERE object = NEW.object AND action = NEW.action AND collection = NEW.collection ) ); END IF; RETURN NULL; END