GenericRetriever - Revision history

G.dimaio at 13:55, 22 May 2012

2012-05-22T13:55:28Z

G.dimaio at 13:53, 22 May 2012

2012-05-22T13:53:51Z

Anonymous: /* {{GVESB}} configuration */

2012-03-30T16:38:05Z

‎{{GVESB}} configuration

Anonymous: /* {{GVESB}} configuration */

2012-03-30T16:33:48Z

‎{{GVESB}} configuration

Anonymous: Created page with "==Description== The GenericRetriever element allows you to define a helper to use into the XSL transformations. We define the functions that run SQL select statement and return..."

2012-03-30T16:33:10Z

Created page with "==Description== The GenericRetriever element allows you to define a helper to use into the XSL transformations. We define the functions that run SQL select statement and return..."

New page

==Description==

The GenericRetriever element allows you to define a helper to use into the XSL transformations.

We define the functions that run SQL select statement and return the first field of the first record.

The statement to be executed can contain metadata resolved at runtime.

=={{GVESB}} configuration==

GenericRetriever element is used by [[RetrieverConfig]].

The following table shows its attributes:
{|class="gvtable"
! Attribute !! Type !! Description
|-
| type || fixed || retriever (unmodifiable)
|-
| class || fixed || it.greenvulcano.gvesb.datahandling.utils.GenericRetriever
|}

Might contain the sub-elements:
* [[Description]]
* [[DataRetriever]]

@@ Line 29: / Line 29: @@
 Define the following GenericRetriever:
 <syntaxhighlight lang="XML">
-<GenericRetriever class="it.greenvulcano.gvesb.datahandling.utils.GenericRetriever"
+    <GenericRetriever class="it.greenvulcano.gvesb.datahandling.utils.GenericRetriever" type="retriever">
-                                              type="retriever">
+        <DataRetriever cacheable="true" method="getCityID"   signature="NAME">
-       <DataRetriever cacheable="true" method="getCityID"   signature="NAME">
+             select ID from CITY
-                 select ID from CITY
+             where NAME=‘@{{NAME}}’
          </DataRetriever>
-</GenericRetriever>
+        <DataRetriever method="getPersonID" signature="NAME,CITY">
 </syntaxhighlight>

@@ Line 45: / Line 45: @@
 to be applied to the transformation:
 <syntaxhighlight lang="XML">
-<xsl:variable name="name" select="/PersonsData/PersonData/Name"/>
+    <xsl:variable name="name" select="/PersonsData/PersonData/Name"/>
      <xsl:variable name="city" select="/PersonsData/PersonData/City"/>
      <xsl:element name="col">
-         <xsl:value-of select="java:it……utils.GenericRetriever.getData
+         <xsl:value-of select="java:it.greenvulcano.gvesb.datahandling.utils.GenericRetriever.getData('getPersonID',concat($name,';',$city))"/>
      </xsl:element>
 </syntaxhighlight>

@@ Line 9: / Line 9: @@
 =={{GVESB}} configuration==
-GenericRetriever element is used by [[Retriever_config|RetrieverConfig]].
+GenericRetriever element is used by [[Retriever_Config|RetrieverConfig]].
 The following table shows its attributes:
@@ Line 23: / Line 23: @@
 * [[Description]]
 * [[DataRetriever]]