DBOFlatSelect - Revision history

G.dimaio at 14:07, 24 June 2013

2013-06-24T14:07:40Z

Anonymous at 13:01, 12 November 2012

2012-11-12T13:01:48Z

Anonymous at 12:59, 12 November 2012

2012-11-12T12:59:56Z

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

2012-11-12T12:59:16Z

‎{{GVESB}} configuration

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

2012-03-30T16:00:57Z

‎{{GVESB}} configuration

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

2012-03-30T15:50:24Z

‎{{GVESB}} configuration

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

2012-03-30T15:49:39Z

‎{{GVESB}} configuration

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

2012-03-30T15:35:06Z

‎{{GVESB}} configuration

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

2012-03-30T13:34:53Z

‎{{GVESB}} configuration

Anonymous: Created page with "==Description== The DBOFlatSelect element represents the DBO optimized for select operations and conversion in CSV rows. =={{GVESB}} configuration== [[File:DBOFlatSelect.jpg|th..."

2012-03-29T08:04:53Z

Created page with "==Description== The DBOFlatSelect element represents the DBO optimized for select operations and conversion in CSV rows. =={{GVESB}} configuration== [[File:DBOFlatSelect.jpg|th..."

New page

==Description==

The DBOFlatSelect element represents the DBO optimized for select operations and conversion in CSV rows.

=={{GVESB}} configuration==
[[File:DBOFlatSelect.jpg|thumb|DBOFlatSelect with VulCon]]
DBOFlatSelect might contain the following sub-elements:
* [[Description]]
* [[DHVariables]]
* [[FieldFormatters]]
* [[statement]]

Its attributes are:

* ''type'': dbo
* ''class'': it.greenvulcano.gvesb.datahandling.dbo.DBOFlatSelect
* ''name''
* ''force-mode'' (caller|xml2db): Force mode of the DBO, can be used in [[DBOBuilder]] whit more heterogeneous DBO. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> db2xml - data extraction mode
* ''jdbc-connection-name'': DataSource JNDI name. <br/> Override connection defined in [[DBOBuilder]].
* ''ignore-input'' (true|false): Tell the engine do not use the input data.
* ''output-data'': The default is the value of @name-Output.

For example:
<syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
<DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
jdbc-connection-name="ds.gv_cama" make-dump="none" name="Partners_FinalReport" type="dbobuilder">
<DBOFlatSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOFlatSelect" name="Partners_FinalReport-select" type="dbo">
<FieldFormatters id="0">
<FieldFormatter field-id="1,2,3" terminator-char="," type="field-formatter"/>
<FieldFormatter date-format="yyyyMMddHHmmssSSS" field-id="4" type="field-formatter"/>
</FieldFormatters>
<statement id="0" type="select">SELECT m.CAMPAIGN, c.MSISDN, c.EVENT_TIME, c.EVENT
FROM CAMA.CDR_EVENT c, CAMA.MESSAGES m, CAMA.PARTNERS p
where m.ID = c.MSG_ID, ...</statement>
</DBOFlatSelect>
</DBOBuilder>
</syntaxhighlight>

@@ Line 36: / Line 36: @@
                 name="Partners_FinalReport-select" type="dbo">
     <FieldFormatters id="0">
-        <FieldFormatter field-id="1,2,3" terminator-char=","  type="field-formatter"/>
+        <FieldFormatter field-id="1,2" terminator-char=","  type="field-formatter"/>
-        <FieldFormatter date-format="yyyyMMddHHmmssSSS"
+        <FieldFormatter date-format="yyyyMMddHHmmssSSS" terminator-char=","
-                        field-id="4" type="field-formatter"/>
+                        field-id="3" type="field-formatter"/>
     </FieldFormatters>
     <statement id="0" type="select">
@@ Line 54: / Line 55: @@
 will generate the output:
 <syntaxhighlight lang="XML">
-TEST_1000130000,+10020000000,20111222170000000
+TEST_1000130000,+10020000000,20111222170000000,N
-TEST_1000130000,+10020000001,20111222170000000
+TEST_1000130000,+10020000001,20111222170000000,N
-TEST_1000130000,+10020000002,20111222170000000
+TEST_1000130000,+10020000002,20111222170000000,N
-TEST_1000130000,+10020000003,20111222170000000
+TEST_1000130000,+10020000003,20111222170000000,N
-TEST_1000130000,+10020000004,20111222170000000
+TEST_1000130000,+10020000004,20111222170000000,N
-TEST_1000130000,+10020000005,20111222170000000
+TEST_1000130000,+10020000005,20111222170000000,N
-TEST_1000130000,+10020000006,20111222170000000
+TEST_1000130000,+10020000006,20111222170000000,N
 </syntaxhighlight>

@@ Line 68: / Line 68: @@
 * [[DHVariables]]
 * [[FieldFormatters]]
-* [[statement_s|statement]]
+* [[statement|statement]]

@@ Line 68: / Line 68: @@
 * [[DHVariables]]
 * [[FieldFormatters]]
-* [[statement|statement]]
+* [[statement_s|statement]]

@@ Line 47: / Line 47: @@
         and p.ID = @{{PARTNER_ID}}
         and c.EVENT_TIME <= to_timestamp('@{{MIN_REPG_TIME}}','YYYY-MM-DD HH24:MI:SS')
-        and c.EVENT_TIME <  to_timestamp('@{{MAX_REPG_TIME}}','YYYY-MM-DD HH24:MI:SS')
+        and c.EVENT_TIME >  to_timestamp('@{{MAX_REPG_TIME}}','YYYY-MM-DD HH24:MI:SS')
     </statement>
 </DBOFlatSelect>

@@ Line 9: / Line 9: @@
 Must be defined for each field the FieldFormatter, that allows you to force the formatting of the values extracted from the database
-Its attributes are:
+It is used by [[DBOBuilder]].
 For example:

@@ Line 8: / Line 8: @@
 Must be defined for each field the FieldFormatter, that allows you to force the formatting of the values extracted from the database
 Its attributes are:
@@ Line 27: / Line 21: @@
 For example:
 <syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
- <DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
+<DBOFlatSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOFlatSelect"
-            jdbc-connection-name="ds.gv_cama" make-dump="none" name="Partners_FinalReport" type="dbobuilder">
+               name="Partners_FinalReport-select" type="dbo">
-       <DBOFlatSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOFlatSelect" name="Partners_FinalReport-select" type="dbo">
+   <FieldFormatters id="0">
-            <FieldFormatters id="0">
+       <FieldFormatter field-id="1,2,3" terminator-char=","  type="field-formatter"/>
-                  <FieldFormatter field-id="1,2,3" terminator-char=","  type="field-formatter"/>
+       <FieldFormatter date-format="yyyyMMddHHmmssSSS"
-                  <FieldFormatter date-format="yyyyMMddHHmmssSSS" field-id="4" type="field-formatter"/>
+                       field-id="4" type="field-formatter"/>
-            </FieldFormatters>
+   </FieldFormatters>
-            <statement id="0" type="select">SELECT m.CAMPAIGN, c.MSISDN, c.EVENT_TIME, c.EVENT
+   <statement id="0" type="select">
-                  FROM CAMA.CDR_EVENT c, CAMA.MESSAGES m, CAMA.PARTNERS p
+       SELECT m.CAMPAIGN, c.MSISDN, c.EVENT_TIME, c.EVENT
-                  where m.ID = c.MSG_ID, ...</statement>
+       FROM CAMA.CDR_EVENT c, CAMA.MESSAGES m, CAMA.PARTNERS p
-       </DBOFlatSelect>
+       where m.ID = c.MSG_ID
- </DBOBuilder>
+       and p.ID = m.PARTNER_ID
 </syntaxhighlight>

@@ Line 5: / Line 5: @@
 =={{GVESB}} configuration==
 [[File:DBOFlatSelect.jpg|thumb|DBOFlatSelect with VulCon]]
-DBOFlatSelect might contain the following sub-elements:
+DBOFlatSelect allows you to run a select on the database. The result of the select will be a CSV document.
 * [[Description]]
 * [[DHVariables]]