创建 SOAP 端点

作者:

fjf2002

PostgREST 支持 媒体类型处理程序。经过一些努力，SOAP 端点就成为可能。

最小示例

此示例将简单地返回请求主体，位于标签 therequestbodywas 内。

将以下函数添加到您的 PostgreSQL 数据库中

create domain "text/xml" as pg_catalog.xml;

CREATE OR REPLACE FUNCTION my_soap_endpoint(xml) RETURNS "text/xml" AS $$
DECLARE
  nsarray CONSTANT text[][] := ARRAY[
    ARRAY['soapenv', 'http://schemas.xmlsoap.org/soap/envelope/']
  ];
BEGIN
  RETURN xmlelement(
    NAME "soapenv:Envelope",
    XMLATTRIBUTES('http://schemas.xmlsoap.org/soap/envelope/' AS "xmlns:soapenv"),
    xmlelement(NAME "soapenv:Header"),
    xmlelement(
      NAME "soapenv:Body",
      xmlelement(
        NAME theRequestBodyWas,
        (xpath('/soapenv:Envelope/soapenv:Body', $1, nsarray))[1]
      )
    )
 );
END;
$$ LANGUAGE plpgsql;

不要忘记刷新 PostgREST 模式缓存。

使用 curl 进行第一次测试

curl http://localhost:3000/rpc/my_soap_endpoint \
    --header 'Content-Type: text/xml' \
    --header 'Accept: text/xml' \
    --data-binary @- <<XML
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
  <soapenv:Header/>
  <soapenv:Body>
    <mySOAPContent>
      My SOAP Content
    </mySOAPContent>
  </soapenv:Body>
</soapenv:Envelope>
XML

输出应包含 therequestbodywas 实体中的原始请求主体，并且应大致如下所示

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
  <soapenv:Header/>
  <soapenv:Body>
    <therequestbodywas>
      <soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
        <mySOAPContent>
          My SOAP Content
        </mySOAPContent>
      </soapenv:Body>
    </therequestbodywas>
  </soapenv:Body>
</soapenv:Envelope>

更详细的示例

这里我们有一个 SOAP 服务，它将分数转换为十进制值，并将 PostgreSQL 错误传递到 SOAP 响应中。请注意，在生产环境中，您可能不应该传递可能泄露内部信息的普通数据库错误，而应该直接处理错误。

-- helper function
CREATE OR REPLACE FUNCTION _soap_envelope(body xml)
 RETURNS xml
 LANGUAGE sql
AS $function$
  SELECT xmlelement(
    NAME "soapenv:Envelope",
    XMLATTRIBUTES('http://schemas.xmlsoap.org/soap/envelope/' AS "xmlns:soapenv"),
    xmlelement(NAME "soapenv:Header"),
    xmlelement(NAME "soapenv:Body", body)
  );
$function$;

-- helper function
CREATE OR REPLACE FUNCTION _soap_exception(
  faultcode text,
  faultstring text
)
 RETURNS xml
 LANGUAGE sql
AS $function$
  SELECT _soap_envelope(
    xmlelement(NAME "soapenv:Fault",
      xmlelement(NAME "faultcode", faultcode),
      xmlelement(NAME "faultstring", faultstring)
    )
  );
$function$;

CREATE OR REPLACE FUNCTION fraction_to_decimal(xml)
 RETURNS "text/xml"
 LANGUAGE plpgsql
AS $function$
DECLARE
  nsarray CONSTANT text[][] := ARRAY[
    ARRAY['soapenv', 'http://schemas.xmlsoap.org/soap/envelope/']
  ];
  exc_msg text;
  exc_detail text;
  exc_hint text;
  exc_sqlstate text;
BEGIN
  -- simulating a statement that results in an exception:
  RETURN _soap_envelope(xmlelement(
    NAME "decimalValue",
    (
      (xpath('/soapenv:Envelope/soapenv:Body/fraction/numerator/text()', $1, nsarray))[1]::text::int
      /
      (xpath('/soapenv:Envelope/soapenv:Body/fraction/denominator/text()', $1, nsarray))[1]::text::int
    )::text::xml
  ));
EXCEPTION WHEN OTHERS THEN
  GET STACKED DIAGNOSTICS
    exc_msg := MESSAGE_TEXT,
    exc_detail := PG_EXCEPTION_DETAIL,
    exc_hint := PG_EXCEPTION_HINT,
    exc_sqlstate := RETURNED_SQLSTATE;
  RAISE WARNING USING
    MESSAGE = exc_msg,
    DETAIL = exc_detail,
    HINT = exc_hint;
  RETURN _soap_exception(faultcode => exc_sqlstate, faultstring => concat(exc_msg, ', DETAIL: ', exc_detail, ', HINT: ', exc_hint));
END
$function$;

让我们用非法值测试 fraction_to_decimal 服务

curl http://localhost:3000/rpc/fraction_to_decimal \
  --header 'Content-Type: text/xml' \
  --header 'Accept: text/xml' \
  --data-binary @- <<XML
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
  <soapenv:Header/>
  <soapenv:Body>
    <fraction>
      <numerator>42</numerator>
      <denominator>0</denominator>
    </fraction>
  </soapenv:Body>
</soapenv:Envelope>
XML

输出应该大致如下

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
  <soapenv:Header/>
  <soapenv:Body>
    <soapenv:Fault>
      <faultcode>22012</faultcode>
      <faultstring>division by zero, DETAIL: , HINT: </faultstring>
    </soapenv:Fault>
  </soapenv:Body>
</soapenv:Envelope>

参考资料

有关 PostgREST 的更多信息，请参见。

有关 SOAP 的参考，请访问