Skip to content

gettriggerinfo.md

Latest commit

 

History

History
68 lines (57 loc) · 1.58 KB

gettriggerinfo.md

File metadata and controls

68 lines (57 loc) · 1.58 KB
Raw

gettriggerinfo

Get trigger information.

Request JSON Syntax

Key Description
task task name
token token string encrypted.
dbname database name

Request Sample

{
  "task": "gettriggerinfo",
  "token": "cdfb4c5717170c5ed30ef86644baf8151531ce5adff4a1f9a54711c51e0f50767926f07dd201b6aa",
  "dbname": "demodb"
}

Response JSON Syntax

Key Description
task task name
status execution result, success or failed.
note if failed, a brief description will be given here
dbname database name
triggerlist the list of the triggers of the database, or null when it has none

triggerlist

triggerlist holds one entry with a triggerinfo array; triggerinfo is composed of trigger objects whose keys are the ones of addtrigger: name, conditiontime, eventtype, eventtarget, condition, action, status and priority.

Response Sample

{
   "__EXEC_TIME" : "34 ms",
   "dbname" : "demodb",
   "note" : "none",
   "status" : "success",
   "task" : "gettriggerinfo",
   "triggerlist" : [
      {
         "triggerinfo" : [
            {
               "action" : "REJECT",
               "actiontime" : "BEFORE",
               "condition" : "1=1",
               "conditiontime" : "BEFORE",
               "eventtype" : "STATEMENT UPDATE",
               "name" : "dba.example",
               "priority" : "0.00000",
               "status" : "INACTIVE",
               "target_att" : "score",
               "target_class" : "public.history"
            }
         ]
      }
   ]
}