triggers.js

api.factory('Trigger', ["SQLClient", function (SQLClient) {
  return function (triggerFromDB) {
    angular.extend(this, triggerFromDB);

    this.api = new SQLClient();
  };
}]);

cdbmanager.service("triggers", ["SQLClient", "Trigger", function (SQLClient, Trigger) {
  let self = this;

  this.api = new SQLClient();

  this.get = function (table, action, error, extraQuery) {
    let _action = function () {
      if (self.api && self.api.items) {
        for (let i = 0; i < self.api.items.length; i++) {
          self.api.items[i] = new Trigger(self.api.items[i], self);
        }
      }

      if (action) {
        action();
      }
    };

    let query = "select * from pg_trigger where tgrelid = " + table._oid;

    if (extraQuery) {
      query += " " + extraQuery;
    }

    self.api.send(query, _action, error);
  };
}]);