diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/__init__.py b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/__init__.py new file mode 100644 index 0000000..42d3799 --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/__init__.py @@ -0,0 +1,413 @@ +########################################################################## +# +# pgAdmin 4 - PostgreSQL Tools +# +# Copyright (C) 2013 - 2016, The pgAdmin Development Team +# This software is released under the PostgreSQL Licence +# +########################################################################## +import json +import re +from flask import render_template, make_response, request, jsonify +from flask.ext.babel import gettext +from pgadmin.utils.ajax import make_json_response, \ + make_response as ajax_response, internal_server_error +from pgadmin.browser.utils import PGChildNodeView +from pgadmin.browser.collection import CollectionNodeModule +import pgadmin.browser.server_groups.servers.databases as database +from pgadmin.utils.ajax import precondition_required +from pgadmin.utils.driver import get_driver +from config import PG_DEFAULT_DRIVER +from functools import wraps + +class EventTriggerModule(CollectionNodeModule): + NODE_TYPE = 'event_trigger' + COLLECTION_LABEL = gettext("Event Triggers") + + def __init__(self, *args, **kwargs): + self.min_ver = 90300 + self.max_ver = None + self.server_type = None + + super(EventTriggerModule, self).__init__(*args, **kwargs) + + def get_nodes(self, gid, sid, did): + """ + Generate the event_trigger node + """ + yield self.generate_browser_collection_node(sid) + + @property + def script_load(self): + """ + Load the module script for event_trigger, when any of the database node is + initialized. + """ + return database.DatabaseModule.NODE_TYPE + + +blueprint = EventTriggerModule(__name__) + + +class EventTriggerView(PGChildNodeView): + node_type = blueprint.node_type + + parent_ids = [ + {'type': 'int', 'id': 'gid'}, + {'type': 'int', 'id': 'sid'}, + {'type': 'int', 'id': 'did'} + ] + ids = [ + {'type': 'int', 'id': 'etid'} + ] + + operations = dict({ + 'obj': [ + {'get': 'properties', 'delete': 'delete', 'put': 'update'}, + {'get': 'list', 'post': 'create'} + ], + 'nodes': [{'get': 'node'}, {'get': 'nodes'}], + 'children': [{'get': 'children'}], + 'sql': [{'get': 'sql'}], + 'msql': [{'get': 'msql'}, {'get': 'msql'}], + 'stats': [{'get': 'statistics'}], + 'dependency': [{'get': 'dependencies'}], + 'dependent': [{'get': 'dependents'}], + 'module.js': [{}, {}, {'get': 'module_js'}], + 'fopts': [{'get': 'get_event_funcs'}, {'get': 'get_event_funcs'}] + }) + + def module_js(self): + """ + This property defines (if javascript) exists for this node. + Override this property for your own logic. + """ + return make_response( + render_template( + "event_triggers/js/event_trigger.js", + _=gettext + ), + 200, {'Content-Type': 'application/x-javascript'} + ) + + def check_precondition(f): + """ + This function will behave as a decorator which will checks + database connection before running view, it will also attaches + manager,conn & template_path properties to self + """ + @wraps(f) + def wrap(*args, **kwargs): + # Here args[0] will hold self & kwargs will hold gid,sid,did + self = args[0] + self.manager = get_driver(PG_DEFAULT_DRIVER).connection_manager(kwargs['sid']) + self.conn = self.manager.connection(did=kwargs['did']) + + # If DB not connected then return error to browser + if not self.conn.connected(): + return precondition_required( + gettext( + "Connection to the server has been lost!" + ) + ) + + ver = self.manager.version + if ver >= 90300: + self.template_path = 'event_triggers/sql/9.3_plus' + + return f(*args, **kwargs) + return wrap + + + @check_precondition + def list(self, gid, sid, did): + sql = render_template("/".join([self.template_path, 'properties.sql'])) + status, res = self.conn.execute_dict(sql) + + if not status: + return internal_server_error(errormsg=res) + return ajax_response( + response=res['rows'], + status=200 + ) + + @check_precondition + def nodes(self, gid, sid, did): + sql = render_template("/".join([self.template_path, 'properties.sql'])) + status, res = self.conn.execute_2darray(sql) + if not status: + return internal_server_error(errormsg=res) + + for row in res['rows']: + res.append( + self.blueprint.generate_browser_node( + row['oid'], + did, + row['name'], + icon="icon-%s" % self.node_type + )) + + return make_json_response( + data=res, + status=200 + ) + + @check_precondition + def properties(self, gid, sid, did, etid): + sql = render_template("/".join([self.template_path, 'properties.sql']), etid=etid, conn=self.conn) + status, res = self.conn.execute_dict(sql) + if not status: + return internal_server_error(errormsg=res) + + result = res['rows'][0] + sec_labels = [] + + if 'seclabels' in result and result['seclabels'] is not None: + for sec in result['seclabels']: + sec = re.search(r'([^=]+)=(.*$)', sec) + sec_labels.append({ + 'provider': sec.group(1), + 'securitylabel': sec.group(2) + }) + result.update({"seclabels": sec_labels}) + return ajax_response( + response=result, + status=200 + ) + + @check_precondition + def create(self, gid, sid, did): + """ + This function will creates new the event_trigger object + """ + data = request.form if request.form else json.loads(request.data.decode()) + required_args = { + 'name':'Name', + 'eventowner':'Owner', + 'eventfunname':'Trigger function', + 'enabled':'Enabled status', + 'eventname':'Events' + } + err = [] + for arg in required_args: + if arg not in data: + err.append(required_args.get(arg, arg)) + if err: + return make_json_response( + status=400, + success=0, + errormsg=gettext( + "Couldn't find the required parameter/s %s." % err + ) + ) + try: + sql = render_template("/".join([self.template_path, 'create.sql']), data=data, conn=self.conn) + status, res = self.conn.execute_scalar(sql) + if not status: + return internal_server_error(errormsg=res) + sql = render_template("/".join([self.template_path, 'grant.sql']), data=data, conn=self.conn) + sql = sql.strip('\n').strip(' ') + + status, res = self.conn.execute_scalar(sql) + if not status: + return internal_server_error(errormsg=res) + + sql = render_template("/".join([self.template_path, 'get_oid.sql']), data=data) + status, etid = self.conn.execute_scalar(sql) + if not status: + return internal_server_error(errormsg=etid) + + return jsonify( + node=self.blueprint.generate_browser_node( + etid, + did, + data['name'], + icon="icon-%s" % self.node_type + ) + ) + except Exception as e: + return internal_server_error(errormsg=str(e)) + + @check_precondition + def update(self, gid, sid, did, etid): + """ + This function will update event_trigger object + """ + data = request.form if request.form else json.loads(request.data.decode()) + + try: + sql = self.get_sql(gid, sid, data, did, etid) + sql = sql.strip('\n').strip(' ') + if sql != "": + status, res = self.conn.execute_scalar(sql) + if not status: + return internal_server_error(errormsg=res) + + sql = render_template("/".join([self.template_path, 'get_oid.sql']), data=data) + status, etid = self.conn.execute_scalar(sql) + + return jsonify( + node=self.blueprint.generate_browser_node( + etid, + did, + data['name'], + icon="icon-%s" % self.node_type + ) + ) + else: + return make_json_response( + success=1, + info="Nothing to update", + data={ + 'id': etid, + 'sid': sid, + 'gid': gid, + 'did': did + } + ) + + except Exception as e: + return internal_server_error(errormsg=str(e)) + + + @check_precondition + def delete(self, gid, sid, did, etid): + """ + This function will drop the object + """ + # Below code will decide if it's simple drop or drop with cascade call + if self.cmd == 'delete': + # This is a cascade operation + cascade = True + else: + cascade = False + try: + sql = render_template("/".join([self.template_path, 'delete.sql']), etid=etid) + status, name = self.conn.execute_scalar(sql) + if not status: + return internal_server_error(errormsg=name) + + sql = render_template("/".join([self.template_path, 'delete.sql']), name=name, cascade=cascade) + status, res = self.conn.execute_scalar(sql) + if not status: + return internal_server_error(errormsg=res) + + return make_json_response( + success=1, + info=gettext("Event trigger dropped"), + data={ + 'id': etid, + 'sid': sid, + 'gid': gid, + 'did': did + } + ) + + except Exception as e: + return internal_server_error(errormsg=str(e)) + + @check_precondition + def msql(self, gid, sid, did, etid = None): + """ + This function to return modified SQL + """ + data = {} + for k, v in request.args.items(): + try: + data[k] = json.loads(v) + except ValueError: + data[k] = v + try: + sql = self.get_sql(gid, sid, data, did, etid) + sql = sql.strip('\n').strip(' ') + + return make_json_response( + data=sql, + status=200 + ) + + except Exception as e: + return internal_server_error(errormsg=str(e)) + + def get_sql(self, gid, sid, data, did, etid=None): + """ + This function will generate sql from model data + """ + required_args = [ + 'name' + ] + + if etid is not None: + sql = render_template("/".join([self.template_path, 'properties.sql']), etid=etid) + status, res = self.conn.execute_dict(sql) + if not status: + return internal_server_error(errormsg=res) + old_data = res['rows'][0] + for arg in required_args: + if arg not in data: + data[arg] = old_data[arg] + sql = render_template("/".join([self.template_path, 'update.sql']), data=data, o_data=old_data) + else: + required_args = { + 'name':'Name', + 'eventowner':'Owner', + 'eventfunname':'Trigger function', + 'enabled':'Enabled status', + 'eventname':'Events' + } + err = [] + for arg in required_args: + if arg not in data: + err.append(required_args.get(arg, arg)) + if err: + return make_json_response( + status=400, + success=0, + errormsg=gettext( + "Couldn't find the required parameter/s %s." % err + ) + ) + sql = render_template("/".join([self.template_path, 'create.sql']), data=data) + sql += "\n" + sql += render_template("/".join([self.template_path, 'grant.sql']), data=data) + return sql + + @check_precondition + def sql(self, gid, sid, did, etid): + """ + This function will generate sql for sql panel + """ + try: + sql = render_template("/".join([self.template_path, 'properties.sql']), etid=etid) + status, res = self.conn.execute_dict(sql) + if not status: + return internal_server_error(errormsg=res) + + result = res['rows'][0] + + sql = render_template("/".join([self.template_path, 'create.sql']), data=result, conn=self.conn) + sql += "\n\n" + sql += render_template("/".join([self.template_path, 'grant.sql']), data=result, conn=self.conn) + return ajax_response(response=sql) + + except Exception as e: + return ajax_response(response=str(e)) + + + @check_precondition + def get_event_funcs(self, gid, sid, did, etid=None): + res = [{ 'label': '', 'value': '' }] + sql = render_template("/".join([self.template_path, 'eventfunctions.sql'])) + status, res = self.conn.execute_2darray(sql) + if not status: + return internal_server_error(errormsg=res) + for row in res['rows']: + res.append( + {'label': row['tfname'], 'value': row['tfname']} + ) + return make_json_response( + data=res, + status=200 + ) + +EventTriggerView.register_node_view(blueprint) diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/static/img/coll-event_trigger.png b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/static/img/coll-event_trigger.png new file mode 100644 index 0000000000000000000000000000000000000000..3c339406fa325dad67f59141a6a08a5334debcda GIT binary patch literal 350 zcmeAS@N?(olHy`uVBq!ia0vp^0wB!73?$#)eFPFv5AX?b1=6kiPU=rwT=MDBga5xP z_8ouw|L>&#A2Xj{cR#w-VBI{+?aRZi97(#*xCE$_u_VYZn8D%MjWi&Kv%n*=7)X17 zvD?XPJ0K&^)5S4_<9f0{kWc~xb80dxhx5@;Pr)+*-bQ9j-mAoSvNTT3G+F96CDTtU zys(goD^vGXfVVgEs_XYmg7@y()6wYo{DM|*UmqVUo8r>Dvy9XIn6#3t7H`cGJ>lb~ z`u6T@g>5h9G)5dcu;fSs3qwIU#U}a)#Wn!vrU}|MxFz=n-DijU5`6-!cl@JXEmS7D))h1R3W)KahriZQpYGCkm L^>bP0l+XkKAR%?3 literal 0 HcmV?d00001 diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/static/img/event_trigger.png b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/static/img/event_trigger.png new file mode 100644 index 0000000000000000000000000000000000000000..3b413e4a648c999c0dcc005aaaf02a710be4414b GIT binary patch literal 324 zcmeAS@N?(olHy`uVBq!ia0vp^0wB!73?$#)eFPHF3h)VW1=6kiPU=rwT=MDBssBIz z{{Mgc|Bu?=uTvji_Bye{WYZ$U_4Az$Y>2*ja-Gx8WkA)8B|(0{3=Yq3qyagc1s;*b zK-vS0-A-oP0U3dwE{-7_*OL<(nB7!eIhs%2;5b!K7}#Lo*a4r5?=RWIaqXXEsv zK*Lo_Tq8-UfEKmPptck0#i>q$vR85k~vM;h66vGt;?!=F#Zb zZ{_7j+`X5s+_2Bq>0@|!L|y;4va)YQMPKvs_EKeX=}P-AfLdmo>7uC8zF>|a}0_%=`3<>K}sDCoVn_gfd&*XHK03=LmuYd7cA zdvL>2>S4={E+nQaGTEbw%343W5;d-f{dp#&b*2lcZ1ns=Wr`2LXZ@Y}!gZH&=I zLRA-+#NU!T_D{s!WsY3O^U7b0%|TU)i%;fkeASY}^oDQwY2NeVd+dG)aM5p$oE-1tl3!?oFZs`=O(lN+cwV$Ps+oeiATx_obU^~(ExO-YKdz^NlIc#s#S7P zDv)9@GB7mMH89pSum~|UvNANcGO*M(Ftai+xcqEI5{ic0{FKbJO57S2?H0HP)WG2B L>gTe~DWM4fI7SDA literal 0 HcmV?d00001 diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/js/event_trigger.js b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/js/event_trigger.js new file mode 100644 index 0000000..9278226 --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/js/event_trigger.js @@ -0,0 +1,176 @@ +define( + ['jquery', 'underscore', 'underscore.string', 'pgadmin', 'pgadmin.browser', 'alertify', 'pgadmin.browser.collection'], +function($, _, S, pgAdmin, pgBrowser, alertify) { + + var SecurityLabelModel = pgAdmin.Browser.Node.Model.extend({ + defaults: { + provider: undefined, + securitylabel: undefined + }, + schema: [ + {id: 'provider', label:'Provider', type:'text', group: null, editable: true}, + {id: 'securitylabel', label:'Security Label', type: 'text', group:null, extraHeaderClasses: 'cellwidth-40', editable: true}, + ], + validate: function() { + // Clear any existing errors. + + this.errorModel.clear() + if (_.isUndefined(this.get('provider')) || String(this.get('provider')).replace(/^\s+|\s+$/g, '') == '') { + var msg = '{{ _('Provider can not be empty!') }}'; + this.errorModel.set('provider',msg); + return msg; + } + if (_.isUndefined(this.get('securitylabel')) || String(this.get('securitylabel')).replace(/^\s+|\s+$/g, '') == '') { + var msg = '{{ _('Security Label can not be empty!') }}'; + this.errorModel.set('securitylabel',msg); + return msg; + } + return null; + } + }); + + if (!pgBrowser.Nodes['coll-event_trigger']) { + var databases = pgAdmin.Browser.Nodes['coll-event_trigger'] = + pgAdmin.Browser.Collection.extend({ + node: 'event_trigger', + label: '{{ _('Event Trigger') }}', + type: 'coll-event_trigger' + }); + }; + + if (!pgBrowser.Nodes['event_trigger']) { + pgAdmin.Browser.Nodes['event_trigger'] = pgAdmin.Browser.Node.extend({ + parent_type: 'database', + type: 'event_trigger', + label: '{{ _('Event Trigger') }}', + hasSQL: true, + canDrop: true, + Init: function() { + /* Avoid mulitple registration of menus */ + if (this.initialized) + return; + + this.initialized = true; + + pgBrowser.add_menus([{ + name: 'create_event_trigger_on_coll', node: 'coll-event_trigger', module: this, + applies: ['object', 'context'], callback: 'show_obj_properties', + category: 'create', priority: 4, label: '{{ _('Event Trigger...') }}', + icon: 'wcTabIcon pg-icon-event_trigger', data: {action: 'create'} + },{ + name: 'create_event_trigger', node: 'event_trigger', module: this, + applies: ['object', 'context'], callback: 'show_obj_properties', + category: 'create', priority: 4, label: '{{ _('Event Trigger...') }}', + icon: 'wcTabIcon pg-icon-event_trigger', data: {action: 'create'} + },{ + name: 'move_obj', node: 'event_trigger', module: this, + applies: ['object', 'context'], callback: 'move_obj', + category: 'drop', priority: 3, label: '{{ _('Move Objects...') }}', + icon: 'fa fa-exchange' + } + ]); + }, + model: pgAdmin.Browser.Node.Model.extend({ + defaults: { + oid: undefined, + name: undefined, + eventowner: undefined, + comment: undefined, + enabled: undefined, + eventfuncoid: undefined, + eventfunname: undefined, + eventname: undefined, + when: undefined, + xmin: undefined, + source: undefined, + language: undefined + }, + schema: [{ + id: 'name', label: '{{ _('Name') }}', cell: 'string', + type: 'text' + },{ + id: 'oid', label:'{{ _('OID') }}', cell: 'string', + type: 'text', mode: ['properties'] + },{ + id: 'eventowner', label:'{{ _('Owner') }}', cell: 'string', + type: 'text', mode: ['edit','create'], node: 'role', + control: Backform.NodeListByNameControl + },{ + id: 'comment', label:'{{ _('Comment') }}', type: 'multiline' + },{ + id: 'enabled', label:'{{ _('Enabled status') }}', + type:"radio", group: "Definition", mode: ['edit','create'], + options: [ + {label: "Enable", value: "O"}, + {label: "Disable", value: "D"}, + {label: "Replica", value: "R"}, + {label: "Always", value: "A"} + ] + },{ + id: 'eventfunname', label:'{{ _('Trigger function') }}', + type: 'text', control: 'node-ajax-options', group: "Definition", + url:'fopts' + },{ + id: 'eventname', label:'{{ _('Events') }}', + type:"radio", group: "Definition", cell: 'string', + options: [ + {label: "DDL COMMAND START", value: "DDL_COMMAND_START"}, + {label: "DDL COMMAND END", value: "DDL_COMMAND_END"}, + {label: "SQL DROP", value: "SQL_DROP"} + ] + },{ + id: 'when', label:'{{ _('When') }}', type: 'multiline', group: "Definition", + },{ + id: 'providers', label: 'Security Labels', type: 'collection', group: "Security Labels", + model: SecurityLabelModel, control: 'unique-col-collection', mode: ['edit', 'create'], + canAdd: true, canDelete: true, uniqueCol : ['provider'], + columns: ['provider','securitylabel'] + } + ], + validate: function() { + var msg = undefined; + // Clear any existing error msg. + this.errorModel.clear(); + + if (_.isUndefined(this.get('name')) + || String(this.get('name')).replace(/^\s+|\s+$/g, '') == '') { + msg = '{{ _('Event trigger name can not be empty!') }}'; + this.errorModel.set('name', msg); + return msg; + } + + if (_.isUndefined(this.get('eventowner')) + || String(this.get('eventowner')).replace(/^\s+|\s+$/g, '') == '') { + msg = '{{ _('Event trigger owner can not be empty!') }}'; + this.errorModel.set('eventowner', msg); + return msg; + } + + if (_.isUndefined(this.get('enabled'))) { + msg = '{{ _('Event trigger enabled status can not be empty!') }}'; + this.errorModel.set('enabled', msg); + return msg; + } + + if (_.isUndefined(this.get('eventfunname')) + || String(this.get('eventfunname')).replace(/^\s+|\s+$/g, '') == '') { + msg = '{{ _('Event trigger function can not be empty!') }}'; + this.errorModel.set('eventfunname', msg); + return msg; + } + + if (_.isUndefined(this.get('eventname'))) { + msg = '{{ _('Event trigger event can not be empty!') }}'; + this.errorModel.set('eventname', msg); + return msg; + } + + return null; + } + }) + }); + + } + + return pgBrowser.Nodes['coll-event_trigger']; +}); diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/create.sql b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/create.sql new file mode 100644 index 0000000..0747771 --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/create.sql @@ -0,0 +1,7 @@ +{% if data %} +CREATE EVENT TRIGGER {{ conn|qtIdent(data.name) }} ON {{data.eventname}} +{% if data.when %} +WHEN TAG IN ({{data.when}}) +{% endif %} +EXECUTE PROCEDURE {{data.eventfunname}}(); +{% endif %} \ No newline at end of file diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/delete.sql b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/delete.sql new file mode 100644 index 0000000..244265e --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/delete.sql @@ -0,0 +1,7 @@ +{% if etid %} +SELECT e.evtname AS name FROM pg_event_trigger e +WHERE e.oid={{etid}}::int; +{% endif %} +{% if name %} +DROP EVENT TRIGGER IF EXISTS {{ name }}{% if cascade%} CASCADE{% endif %}; +{% endif %} \ No newline at end of file diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/eventfunctions.sql b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/eventfunctions.sql new file mode 100644 index 0000000..a016586 --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/eventfunctions.sql @@ -0,0 +1,4 @@ +SELECT quote_ident(nspname) || '.' || quote_ident(proname) AS tfname +FROM pg_proc p, pg_namespace n, pg_language l +WHERE p.pronamespace = n.oid AND p.prolang = l.oid AND p.pronargs = 0 AND l.lanname != 'sql' AND prorettype::regtype::text = 'event_trigger' +ORDER BY nspname ASC, proname ASC \ No newline at end of file diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/get_oid.sql b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/get_oid.sql new file mode 100644 index 0000000..262ca93 --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/get_oid.sql @@ -0,0 +1,5 @@ +{# The Sql below will provide oid for newly created event_trigger #} +{% if data %} +SELECT e.oid from pg_event_trigger e +WHERE e.evtname = {{ data.name|qtLiteral }} +{% endif %} \ No newline at end of file diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/grant.sql b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/grant.sql new file mode 100644 index 0000000..f90788c --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/grant.sql @@ -0,0 +1,26 @@ +{% import 'macros/security.macros' as SECLABLE %} +{% if data %} +{% if data.enabled and data.enabled != "O" %} +ALTER EVENT TRIGGER {{ conn|qtIdent(data.name) }} +{% if data.enabled == "D" %} +DISABLE; +{% elif data.enabled == "R" %} +ENABLE REPLICA; +{% elif data.enabled == "A" %} +ENABLE ALWAYS; +{% endif %} +{% endif %} + +{% if data.comment %} +COMMENT ON EVENT TRIGGER {{ conn|qtIdent(data.name) }} + IS {{ data.comment|qtLiteral }}; +{% endif %} +{% if data.providers and data.providers|length > 0 %} + +{% for r in data.providers %} +{{ SECLABLE.APPLY(conn, 'EVENT TRIGGER', data.name, r.provider, r.securitylabel) }} +{% endfor %}{% endif %} + +ALTER EVENT TRIGGER {{ conn|qtIdent(data.name) }} +OWNER TO {{data.eventowner}}; +{% endif %} \ No newline at end of file diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/properties.sql b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/properties.sql new file mode 100644 index 0000000..0df12b3 --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/properties.sql @@ -0,0 +1,17 @@ +SELECT e.oid, e.xmin, e.evtname AS name, upper(e.evtevent) AS eventname, +pg_catalog.pg_get_userbyid(e.evtowner) AS eventowner, +e.evtenabled AS enabled, +e.evtfoid AS eventfuncoid, quote_ident(n.nspname) || '.' || e.evtfoid::regproc AS eventfunname, +array_to_string(array(select quote_literal(x) from unnest(evttags) as t(x)), ', ') AS when, + pg_catalog.obj_description(e.oid, 'pg_event_trigger') AS comment, + (SELECT array_agg(provider || '=' || label) FROM pg_shseclabel sl1 WHERE sl1.objoid=e.oid) AS seclabels, + p.prosrc AS source, p.pronamespace AS schemaoid, l.lanname AS language + FROM pg_event_trigger e + LEFT OUTER JOIN pg_proc p ON p.oid=e.evtfoid + LEFT OUTER JOIN pg_language l ON l.oid=p.prolang, + pg_namespace n + WHERE p.pronamespace = n.oid +{% if etid %} + AND e.oid={{etid}}::int +{% endif %} + ORDER BY e.evtname diff --git a/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/update.sql b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/update.sql new file mode 100644 index 0000000..9b60224 --- /dev/null +++ b/web/pgadmin/browser/server_groups/servers/databases/event_triggers/templates/event_triggers/sql/9.3_plus/update.sql @@ -0,0 +1,66 @@ +{% import 'macros/security.macros' as SECLABLE %} +{% if data %} +{% if (data.eventfunname and data.eventfunname != o_data.eventfunname) or + (data.eventname and data.eventname != o_data.eventname) or + (data.when and data.when != o_data.when) %} +DROP EVENT TRIGGER IF EXISTS {{ conn|qtIdent(o_data.name) }}; + +CREATE EVENT TRIGGER {{ conn|qtIdent(data.name) if data.name else conn|qtIdent(o_data.name) }} ON {{ data.eventname if data.eventname else o_data.eventname }} +{% if data.when or o_data.when %} +WHEN TAG IN ({{ data.when if data.when else o_data.when }}) +{% endif %} +EXECUTE PROCEDURE {{ data.eventfunname if data.eventfunname else o_data.eventfunname }}(); +{% else %} + +{% if data.name and data.name != o_data.name %} +ALTER EVENT TRIGGER {{ conn|qtIdent(o_data.name) }} +RENAME TO {{ conn|qtIdent(data.name) }}; +{% endif %} +{% endif %} + +{% if data.comment and data.comment != o_data.comment %} +COMMENT ON EVENT TRIGGER {{ conn|qtIdent(data.name) }} + IS '{{ data.comment }}'; +{% endif %} + +{% if data.enabled and data.enabled != o_data.enabled %} +ALTER EVENT TRIGGER {{ conn|qtIdent(data.name) }} +{% if data.enabled == "O" %} +ENABLE; +{% elif data.enabled == "D" %} +DISABLE; +{% elif data.enabled == "R" %} +ENABLE REPLICA; +{% elif data.enabled == "A" %} +ENABLE ALWAYS; +{% endif %} +{% endif %} +{% endif %} + +{% if data.providers and + data.providers|length > 0 +%}{% set seclabels = data.providers %} +{% if 'deleted' in seclabels and seclabels.deleted|length > 0 %} + +{% for r in seclabels.deleted %} +{{ SECLABLE.DROP(conn, 'EVENT TRIGGER', data.name, r.provider) }} +{% endfor %} +{% endif %} +{% if 'added' in seclabels and seclabels.added|length > 0 %} + +{% for r in seclabels.added %} +{{ SECLABLE.APPLY(conn, 'EVENT TRIGGER', data.name, r.provider, r.securitylabel) }} +{% endfor %} +{% endif %} +{% if 'changed' in seclabels and seclabels.changed|length > 0 %} + +{% for r in seclabels.changed %} +{{ SECLABLE.APPLY(conn, 'EVENT TRIGGER', data.name, r.provider, r.securitylabel) }} +{% endfor %} +{% endif %} +{% endif %} + +{% if data.eventowner and data.eventowner != o_data.eventowner %} +ALTER EVENT TRIGGER {{ conn|qtIdent(data.name) }} +OWNER TO {{data.eventowner}}; +{% endif %} \ No newline at end of file