maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_setjpodbus(character varying, integer)
Parameters
Name
Type
Mode
in_serialnumber
character varying
IN
in_bus
integer
IN
Definition
/* to set the bus 1 = j1939, 2 = j1708 to extract EMS info de the DW */ DECLARE _idport int := 0; _iddevice int := 0; BEGIN SELECT s.idport INTO _idport FROM device d JOIN port p ON p.iddevice = d.iddevice JOIN serialcfg s ON s.idport = p.idport WHERE s.serialport_devicetype = 1 /* ECM */ and d.serialnumber = in_serialnumber; IF FOUND THEN UPDATE serialcfg set bus = in_bus WHERE idport = _idport; ELSE SELECT iddevice INTO _iddevice FROM device WHERE serialnumber = in_serialnumber; WITH q AS (INSERT INTO port(iddevice,idport) VALUES(_iddevice,nextval('sec_port')) RETURNING idport) SELECT idport INTO _idport FROM q; INSERT INTO serialcfg(idport,serialport_devicetype,bus) VALUES(_idport,1,in_bus); END IF; RETURN true; END;