DBOBuilder - Revision history

G.dimaio at 13:07, 13 May 2014

2014-05-13T13:07:46Z

2012-04-02T12:06:35Z

2012-04-02T10:33:34Z

2012-04-02T10:23:41Z

‎{{GVESB}} configuration

2012-04-02T10:21:08Z

‎{{GVESB}} configuration

2012-04-02T10:20:34Z

‎{{GVESB}} configuration

2012-04-02T10:19:10Z

‎{{GVESB}} configuration

2012-04-02T10:05:02Z

‎{{GVESB}} configuration

2012-04-02T10:02:27Z

‎{{GVESB}} configuration

2012-04-02T09:41:37Z

‎{{GVESB}} configuration

← Older revision		Revision as of 13:07, 13 May 2014
Line 111:		Line 111:

	* [[#DBOs\|DBOs]]		* [[#DBOs\|DBOs]]
		+	<div class="version_ge3.4">
		+	* [[XMLMerge]]: replace the old Merge element
		+	</div>

	====DBOs====		====DBOs====

@@ Line 110: / Line 110: @@
 *** ''value'': variable value
-* [[#DBO|DBO]]
+* [[#DBOs|DBOs]]
-====DBO====
+====DBOs====
-The DBO elements represent the elementary operations of DataHandler that can be combined in a service. Those are:
+The DBO elements represent the elementary operations of [[DataHandler]] that can be combined in a service. Those are:
 * [[DBOSelect]]

@@ Line 1: / Line 1: @@
 ==Description==
-The DBOBuilder element represents a DataHandler service.
+[[File:DBOBuilder.jpg|thumb|DBOBuilder with VulCon]]The DBOBuilder element represents a [[DataHandler]] service.
 Might contain more [[#DBO|DBOs]] that represent all the elementary [[DataHandler]] operations that can be combined in a service.
@@ Line 13: / Line 9: @@
 The statements used in the [[DBOBuilder#DBO|DBOs]] may contain metadata resolved at runtime that allows you to customize the actual command to be sent to the database.
 The properties of the [[GVBuffer]] object can be referenced with the metadata <nowiki>@{{name}}</nowiki>.
 The body of the [[GVBuffer]] object, if any, is passed to the processing engine or data transformation engine, or it will be populated with the service output.
@@ Line 34: / Line 29: @@
 |}
-[[DBOBuilder]] has the following attributes:
+The following table shows its attributes:
 {|class="gvtable"
 ! Attribute !! Type !! Description
@@ Line 68: / Line 66: @@
                select NAME from CITY where ID=@{{ID}}
           </DataRetriever>
-          <DataRetriever method="getPersonID" signature="NAME,CITY">
+          <DataRetriever>...
-              select ID from PERSON
+          <DataRetriever>...
-              where NAME='@{{NAME}}'
+          <DataRetriever>...
         </GenericRetriever>
      </RetrieverConfig>

@@ Line 17: / Line 17: @@
 The body of the [[GVBuffer]] object, if any, is passed to the processing engine or data transformation engine, or it will be populated with the service output.
-The following table shows the output [[GVBuffer]] returned by [[DBOBuilder]] containing parameters with statistics about the operations done:
+The following table shows the parameters included into the [[DBOBuilder]] output [[GVBuffer]] containing statistics about the operations done:
 {| class="gvtable"
 ! Parameter !! Description

@@ Line 30: / Line 30: @@
 |-
 | REC_DISCARD || number of discarded records
+|-
 | REC_DISCARD_CAUSE || Report about discarded records
 |}

@@ Line 5: / Line 5: @@
 =={{GVESB}} configuration==
-The DBOBuilder element is used by [[dh-call]] and [[GVDataHandlerConfiguration]]. May contain more [[DBO|DBOs]] that represent all the elementary [[DataHandler]] operations that can be combined in a service.
+The DBOBuilder element is used by [[dh-call]] and [[GVDataHandlerConfiguration]].
 These [[#DBO|DBO]]s will be executed in order of definition. By default returns the output as a result of the last [[#DBO|DBO]].
 The output of a [[#DBO|DBO]] can be used as input of the next.

@@ Line 41: / Line 41: @@
 |}
-The following example shows who to configure [[DBOBuilder]] combined with the retrievers (see [[RetrieverConfig]]) and the use of metadata inside the statement:
+The following example shows who to configure [[DBOBuilder]] combined with the retrievers (see [[Retriever_Config|RetrieverConfig]]) and the use of metadata inside the statement:
 <syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
 <dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"

@@ Line 41: / Line 41: @@
 |}
-For example:
+The following example shows who to configure [[DBOBuilder]] combined with the retrievers (see [[RetrieverConfig]]) and the use of metadata inside the statement:
 <syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
 <dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"
-          name="TestInsertXML" type="call">
+          name="DataHandler" type="call">
-  <DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
+    <RetrieverConfig>
-              jdbc-connection-name="" name="" type="dbobuilder">
+       <GenericRetriever class="it.greenvulcano.gvesb.datahandling.utils.GenericRetriever" type="retriever">
-      <DBOSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOSelect"
+         <DataRetriever cacheable="true" method="getCityID" signature="NAME">
-                 name="" type="dbo">
+              select ID from CITY where NAME='@{{NAME}}'
-           <statement type="select"/>
+         </DataRetriever>
-      </DBOSelect>
+         <DataRetriever cacheable="true" method="getCityName" signature="ID">
-  </DBOBuilder>
+              select NAME from CITY where ID=@{{ID}}
 </dh-call>
 </syntaxhighlight>

@@ Line 12: / Line 12: @@
 DBOBuilder returns the following statistics about the operations done:
-* Records read
+* REC_TOTAL           : founded records
-* Records inserted
+* REC_READ            : read records
-* Records updated
+* REC_INSERT          : inserted records
-* Records discarded
+* REC_UPDATE          : updated records
-* Report about discarded records
+* REC_DISCARD         : discarded records
 It has the following attributes:
@@ Line 53: / Line 55: @@
 </syntaxhighlight>
-DBOBuilder accepts as children:
+DBOBuilder has the following sub-element:
 * [[Description]]
-* DHAliasList: List of aliases for a given DataHandler service. It contains
+* DHAliasList: List of aliases for a given [[DataHandler]] service. It contains
-** DHAlias: Alias for a DataHandler service with its Description
+** DHAlias: Alias for a [[DataHandler]] service with its Description
-* DHVariables: List of default values for DataHandler service's variables. It contains
+* DHVariables: List of default values for [[DataHandler]] service's variables. It contains
-** DHVariable: Default value for DataHandler service's variable including the parameters
+** DHVariable: Default value for [[DataHandler]] service's variable including the parameters
 *** Description
 *** ''name'': variable name