maya.public

Parameters

Name	Type	Mode
in_serialnumber	character varying	IN
descriptive	boolean	IN

Definition

WITH q as (select dc.iddeviceconf,dc.configname,dc.defaultval,cd.configval client_configval, ddc.configval dev_configval
FROM deviceconf dc LEFT JOIN device d ON d.idmodeldevice = dc.idmodeldevice
LEFT JOIN  device_deviceconf ddc ON ddc.iddevice =  d.iddevice and ddc.iddeviceconf = dc.iddeviceconf
LEFT JOIN technicalaccount t ON t.idtechnicalaccount = d.idtechnicalaccount
LEFT JOIN client_deviceconf cd ON cd.idclient = t.idclient AND dc.iddeviceconf = cd.iddeviceconf
WHERE d.serialnumber = $1 order by 1),
q1 as
(SELECT iddeviceconf,configname,defaultval,client_configval, dev_configval,
CASE WHEN length(client_configval)> 0 THEN client_configval ELSE defaultval END effective_val
, CASE WHEN length(client_configval)> 0 THEN 'client_deviceconf' ELSE 'deviceconf' END src_val
FROM q) ,q2 as
(SELECT string_agg(iddeviceconf||'=>'||coalesce(quote_ident(effective_val),'null'),',') res,
        string_agg('src_'||iddeviceconf::varchar||'=>'||coalesce(quote_ident(src_val),'null'),',') res1 FROM q1)
select hstore(res)||hstore(res1) from q2

ot_ro_get_device_defaultconf(character varying, boolean)

Parameters

Definition