|
1
|
$if(update)$
|
|
2
|
$if(value)$
|
|
3
|
$if(preserveOriginal)$
|
|
4
|
UPDATE apicollections SET (edited, accessparam) = ($value$, $accessParam$) WHERE api=$ifaceId$ AND lower(param)=lower($field$);
|
|
5
|
$else$
|
|
6
|
UPDATE apicollections SET (original, edited, accessparam) = ($value$, NULL, $accessParam$) WHERE api=$ifaceId$ AND lower(param)=lower($field$);
|
|
7
|
$endif$
|
|
8
|
$else$
|
|
9
|
UPDATE apicollections SET (edited, accessparam) = (NULL, $accessParam$) WHERE api=$ifaceId$ AND lower(param)=lower($field$);
|
|
10
|
$endif$
|
|
11
|
$else$
|
|
12
|
INSERT INTO apicollections(param, original, api, accessparam) VALUES ($field$, $value$, $ifaceId$, $accessParam$);
|
|
13
|
$endif$
|
|
14
|
|
|
15
|
-- FIX
|
|
16
|
UPDATE apicollections SET _dnet_resource_identifier_ = api||'@@'||param WHERE api = $ifaceId$ AND lower(param)=lower($field$);
|