Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Back
public setsnmpinterfacekeysoninsert (trigger function)
Modified on 2011/08/27 11:44
by
wikibot
Categorized as
Uncategorized
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Trigger Function''' | public.setsnmpinterfacekeysoninsert |} === Source === {{{{<nowiki> CREATE OR REPLACE FUNCTION public.setsnmpinterfacekeysoninsert() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN -- -- (Used for Trigger insert with old style foreign key) -- This condition keeps the snmpInterfaceId inSync with the composite foreign key of nodeid, ipaddr, ifindex -- This usually happens when a new record is written by our JDBC code (non-Hibernate DAO) for the old JDBC style -- code has no knowledge of the new keys -- IF NEW.snmpInterfaceId IS NULL THEN IF NEW.ifIndex IS NOT NULL THEN SELECT snmpif.id INTO NEW.snmpInterfaceId FROM snmpinterface snmpif WHERE (snmpif.nodeid = NEW.nodeid AND snmpif.snmpIfIndex = NEW.ifIndex); IF NOT FOUND THEN RAISE EXCEPTION 'IpInterface Trigger Notice, Condition 1: No SnmpInterface found for... nodeid: % ifindex: %', NEW.nodeid, NEW.ifIndex; END IF; END IF; -- -- (Used for Insert with new style foreign key) -- This condition keeps the composite foreign key of nodeid, ipaddr, ifindex inSync with the SnmpInterfaceId -- This usually happens when a new record is written by our Hibernate DAOs... these DAOs have no knowledge of -- the composite key columns -- ELSIF NEW.snmpInterfaceId IS NOT NULL AND (NEW.nodeId IS NULL OR NEW.ifIndex IS NULL) THEN SELECT snmpif.nodeid, snmpif.snmpIfIndex INTO NEW.nodeid, NEW.ifIndex FROM snmpinterface snmpif WHERE (snmpif.id = NEW.snmpInterfaceId); IF NOT FOUND THEN RAISE EXCEPTION 'IpInterface Trigger Notice: No SnmpInterface found for snmpInterfaceId: %', NEW.snmpInterfaceId; END IF; END IF; RETURN NEW; END; $function$ </nowiki>}}}}
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.