Subversion Repositories SmartDukaan

Rev

Rev 6554 | Rev 6560 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6554 Rev 6557
Line 91... Line 91...
91 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
 91 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
92 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
 92 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
93 
    </attributes>
 93 
    </attributes>
94 
  </connection>
 94 
  </connection>
95 
  <connection>
 95 
  <connection>
- 
 
 96 
    <name>Prod_trans</name>
- 
 
 97 
    <server>192.168.190.113</server>
- 
 
 98 
    <type>MYSQL</type>
- 
 
 99 
    <access>Native</access>
- 
 
 100 
    <database>transaction</database>
- 
 
 101 
    <port>3306</port>
- 
 
 102 
    <username>pentaho</username>
- 
 
 103 
    <password>Encrypted 2be98afc86aa7f2e4cb79ac798cc2fd8a</password>
- 
 
 104 
    <servername/>
- 
 
 105 
    <data_tablespace/>
- 
 
 106 
    <index_tablespace/>
- 
 
 107 
    <attributes>
- 
 
 108 
      <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
- 
 
 109 
      <attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute>
- 
 
 110 
      <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
- 
 
 111 
      <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
- 
 
 112 
      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
- 
 
 113 
      <attribute><code>PORT_NUMBER</code><attribute>3306</attribute></attribute>
- 
 
 114 
      <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
- 
 
 115 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
- 
 
 116 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
- 
 
 117 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
- 
 
 118 
    </attributes>
- 
 
 119 
  </connection>
- 
 
 120 
  <connection>
96 
    <name>sales_local</name>
 121 
    <name>sales_local</name>
97 
    <server>localhost</server>
 122 
    <server>localhost</server>
98 
    <type>MYSQL</type>
 123 
    <type>MYSQL</type>
99 
    <access>Native</access>
 124 
    <access>Native</access>
100 
    <database>sales</database>
 125 
    <database>sales</database>
Line 147... Line 172...
147 
    <copies>1</copies>
 172 
    <copies>1</copies>
148 
         <partitioning>
 173 
         <partitioning>
149 
           <method>none</method>
 174 
           <method>none</method>
150 
           <schema_name/>
 175 
           <schema_name/>
151 
           </partitioning>
 176 
           </partitioning>
152 
    <connection>local_tran</connection>
 177 
    <connection>Prod_trans</connection>
153 
    <sql>select b.id as orderId,
178 
    <sql>select b.id as orderId,
154 
b.userId,
179 
b.userId,
155 
1 as orderType,
180 
1 as orderType,
156 
datediff(b.creationTimestamp, &apos;20101231&apos;) as dateId,
 181 
datediff(b.creationTimestamp, &apos;20101231&apos;) as dateId,
157 
0 as repeatType,
182 
0 as repeatType,
158 
0 as repeatFrequency,
183 
0 as repeatFrequency,
159 
b.transaction_id as transactionId,
184 
1000000000 + b.transaction_id as transactionId,
160 
case when b.totalAmount&lt;250 then 0 when b.totalAmount&lt;500 then 1 when b.totalAmount&lt;1000 then 2
185 
case when b.totalAmount&lt;250 then 0 when b.totalAmount&lt;500 then 1 when b.totalAmount&lt;1000 then 2
161 
			 when b.totalAmount&lt;2000 then 3 when b.totalAmount &lt; 5000 then 4 when b.totalAmount &lt; 10000 then 5 when b.totalAmount &lt; 15000 then 6
186 
			 when b.totalAmount&lt;2000 then 3 when b.totalAmount &lt; 5000 then 4 when b.totalAmount &lt; 10000 then 5 when b.totalAmount &lt; 15000 then 6
162 
			 when b.totalAmount &lt;20000 then 7 when b.totalAmount &lt; 50000 then 8 else 9 end as amount,
 187 
			 when b.totalAmount &lt;20000 then 7 when b.totalAmount &lt; 50000 then 8 else 9 end as amount,
163 
case when b.totalAmount&lt;250 then 0 when b.totalAmount&lt;500 then 1 when b.totalAmount&lt;1000 then 2
188 
case when b.totalAmount&lt;250 then 0 when b.totalAmount&lt;500 then 1 when b.totalAmount&lt;1000 then 2
164 
			 when b.totalAmount&lt;2000 then 3 when b.totalAmount &lt; 5000 then 4 when b.totalAmount &lt; 10000 then 5 when b.totalAmount &lt; 15000 then 6
189 
			 when b.totalAmount&lt;2000 then 3 when b.totalAmount &lt; 5000 then 4 when b.totalAmount &lt; 10000 then 5 when b.totalAmount &lt; 15000 then 6
Line 196... Line 221...
196 
    <copies>1</copies>
 221 
    <copies>1</copies>
197 
         <partitioning>
 222 
         <partitioning>
198 
           <method>none</method>
 223 
           <method>none</method>
199 
           <schema_name/>
 224 
           <schema_name/>
200 
           </partitioning>
 225 
           </partitioning>
201 
    <connection>local_tran</connection>
 226 
    <connection>Prod_trans</connection>
202 
    <sql>select o.id as orderId,
227 
    <sql>select o.id as orderId,
203 
o.customer_id as userId,
228 
o.customer_id as userId,
204 
0 as orderType,
229 
0 as orderType,
205 
case when o.originalOrderId is null then datediff(o.created_timestamp, &apos;20101231&apos;)
 230 
case when o.originalOrderId is null then datediff(o.created_timestamp, &apos;20101231&apos;)
206 
	else datediff((select created_timestamp from `order` where id = o.originalOrderId), &apos;20101231&apos;) end as dateId ,
231 
	else datediff((select created_timestamp from `order` where id = o.originalOrderId), &apos;20101231&apos;) end as dateId ,
Line 319... Line 344...
319 
        <grouping_symbol/>
 344 
        <grouping_symbol/>
320 
        <currency_symbol/>
 345 
        <currency_symbol/>
321 
        <storage_type/>
 346 
        <storage_type/>
322 
      </meta>      <meta>        <name>transactionId</name>
 347 
      </meta>      <meta>        <name>transactionId</name>
323 
        <rename>transactionId</rename>
 348 
        <rename>transactionId</rename>
324 
        <type>-</type>
 349 
        <type>Integer</type>
325 
        <length>9</length>
 350 
        <length>11</length>
326 
        <precision>0</precision>
 351 
        <precision>0</precision>
327 
        <conversion_mask/>
 352 
        <conversion_mask/>
328 
        <date_format_lenient>false</date_format_lenient>
 353 
        <date_format_lenient>false</date_format_lenient>
329 
        <encoding/>
 354 
        <encoding/>
330 
        <decimal_symbol/>
 355 
        <decimal_symbol/>
Line 647... Line 672...
647 
        <grouping_symbol/>
 672 
        <grouping_symbol/>
648 
        <currency_symbol/>
 673 
        <currency_symbol/>
649 
        <storage_type/>
 674 
        <storage_type/>
650 
      </meta>      <meta>        <name>transactionId</name>
 675 
      </meta>      <meta>        <name>transactionId</name>
651 
        <rename>transactionId</rename>
 676 
        <rename>transactionId</rename>
652 
        <type>-</type>
 677 
        <type>Integer</type>
653 
        <length>9</length>
 678 
        <length>11</length>
654 
        <precision>0</precision>
 679 
        <precision>0</precision>
655 
        <conversion_mask/>
 680 
        <conversion_mask/>
656 
        <date_format_lenient>false</date_format_lenient>
 681 
        <date_format_lenient>false</date_format_lenient>
657 
        <encoding/>
 682 
        <encoding/>
658 
        <decimal_symbol/>
 683 
        <decimal_symbol/>