Subversion Repositories SmartDukaan

Rev

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

Rev 2519 Rev 2532
Line 92... Line 92...
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>catalogDC_Prod</name>
 96 
    <name>catalogDC_Prod</name>
97 
    <server>192.168.141.43</server>
 97 
    <server>localhost</server>
98 
    <type>MYSQL</type>
 98 
    <type>MYSQL</type>
99 
    <access>Native</access>
 99 
    <access>Native</access>
100 
    <database>catalog</database>
 100 
    <database>catalog</database>
101 
    <port>3306</port>
 101 
    <port>3306</port>
102 
    <username>pentaho</username>
 102 
    <username>root</username>
103 
    <password>Encrypted 2be98afc86aa7f2e4cb79ac798cc2fd8a</password>
 103 
    <password>Encrypted 2be98afc86aa7f2e4b811a1608cc2fd8a</password>
104 
    <servername/>
 104 
    <servername/>
105 
    <data_tablespace/>
 105 
    <data_tablespace/>
106 
    <index_tablespace/>
 106 
    <index_tablespace/>
107 
    <attributes>
 107 
    <attributes>
108 
      <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
 108 
      <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
Line 128... Line 128...
128 
         <partitioning>
 128 
         <partitioning>
129 
           <method>none</method>
 129 
           <method>none</method>
130 
           <schema_name/>
 130 
           <schema_name/>
131 
           </partitioning>
 131 
           </partitioning>
132 
    <connection>catalogDC_Prod</connection>
 132 
    <connection>catalogDC_Prod</connection>
133 
    <sql>SELECT id, product_group, brand, model_number, model_name, color FROM item</sql>
 133 
    <sql>SELECT item.id, product_group, brand, model_number, model_name,
- 
 
 134 
       color, category.label category, parent.label parent_category
- 
 
 135 
FROM item, category, category as parent
- 
 
 136 
where item.category = category.id
- 
 
 137 
and category.parent_category_id = parent.id</sql>
134 
    <limit>0</limit>
 138 
    <limit>0</limit>
135 
    <lookup/>
 139 
    <lookup/>
136 
    <execute_each_row>N</execute_each_row>
 140 
    <execute_each_row>N</execute_each_row>
137 
    <variables_active>N</variables_active>
 141 
    <variables_active>N</variables_active>
138 
    <lazy_conversion_active>N</lazy_conversion_active>
 142 
    <lazy_conversion_active>N</lazy_conversion_active>
139 
     <cluster_schema/>
 143 
     <cluster_schema/>
140 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 144 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
141 
      <xloc>142</xloc>
 145 
      <xloc>144</xloc>
142 
      <yloc>164</yloc>
 146 
      <yloc>166</yloc>
143 
      <draw>Y</draw>
 147 
      <draw>Y</draw>
144 
      </GUI>
 148 
      </GUI>
145 
    </step>
 149 
    </step>
146 
 
 150 
 
147 
  <step>
 151 
  <step>
Line 170... Line 174...
170 
    <tablename_field/>
 174 
    <tablename_field/>
171 
    <tablename_in_table>Y</tablename_in_table>
 175 
    <tablename_in_table>Y</tablename_in_table>
172 
    <return_keys>N</return_keys>
 176 
    <return_keys>N</return_keys>
173 
    <return_field/>
 177 
    <return_field/>
174 
    <fields>
 178 
    <fields>
- 
 
 179 
        <field>
- 
 
 180 
          <column_name>id</column_name>
- 
 
 181 
          <stream_name>id</stream_name>
- 
 
 182 
        </field>
- 
 
 183 
        <field>
- 
 
 184 
          <column_name>product_group</column_name>
- 
 
 185 
          <stream_name>product_group</stream_name>
- 
 
 186 
        </field>
- 
 
 187 
        <field>
- 
 
 188 
          <column_name>brand</column_name>
- 
 
 189 
          <stream_name>brand</stream_name>
- 
 
 190 
        </field>
- 
 
 191 
        <field>
- 
 
 192 
          <column_name>model_number</column_name>
- 
 
 193 
          <stream_name>model_number</stream_name>
- 
 
 194 
        </field>
- 
 
 195 
        <field>
- 
 
 196 
          <column_name>model_name</column_name>
- 
 
 197 
          <stream_name>model_name</stream_name>
- 
 
 198 
        </field>
- 
 
 199 
        <field>
- 
 
 200 
          <column_name>color</column_name>
- 
 
 201 
          <stream_name>color</stream_name>
- 
 
 202 
        </field>
- 
 
 203 
        <field>
- 
 
 204 
          <column_name>category</column_name>
- 
 
 205 
          <stream_name>category</stream_name>
- 
 
 206 
        </field>
175 
    </fields>
 207 
    </fields>
176 
     <cluster_schema/>
 208 
     <cluster_schema/>
177 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 209 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
178 
      <xloc>435</xloc>
 210 
      <xloc>435</xloc>
179 
      <yloc>166</yloc>
 211 
      <yloc>166</yloc>
Line 213... Line 245...
213 
        <precision>-2</precision>
 245 
        <precision>-2</precision>
214 
      </field>      <field>        <name>color</name>
 246 
      </field>      <field>        <name>color</name>
215 
        <rename>color</rename>
 247 
        <rename>color</rename>
216 
        <length>-2</length>
 248 
        <length>-2</length>
217 
        <precision>-2</precision>
 249 
        <precision>-2</precision>
- 
 
 250 
      </field>      <field>        <name>category</name>
- 
 
 251 
        <rename>category</rename>
- 
 
 252 
        <length>-2</length>
- 
 
 253 
        <precision>-2</precision>
- 
 
 254 
      </field>      <field>        <name>parent_category</name>
- 
 
 255 
        <rename>parent_category</rename>
- 
 
 256 
        <length>-2</length>
- 
 
 257 
        <precision>-2</precision>
218 
      </field>        <select_unspecified>N</select_unspecified>
 258 
      </field>        <select_unspecified>N</select_unspecified>
219 
    </fields>     <cluster_schema/>
 259 
    </fields>     <cluster_schema/>
220 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 260 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
221 
      <xloc>304</xloc>
 261 
      <xloc>304</xloc>
222 
      <yloc>166</yloc>
 262 
      <yloc>167</yloc>
223 
      <draw>Y</draw>
 263 
      <draw>Y</draw>
224 
      </GUI>
 264 
      </GUI>
225 
    </step>
 265 
    </step>
226 
 
 266 
 
227 
  <step_error_handling>
 267 
  <step_error_handling>