Subversion Repositories SmartDukaan

Rev

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

Rev 3280 Rev 3496
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>catalogDC_local</name>
- 
 
 97 
    <server>localhost</server>
- 
 
 98 
    <type>MYSQL</type>
- 
 
 99 
    <access>Native</access>
- 
 
 100 
    <database>catalog</database>
- 
 
 101 
    <port>3306</port>
- 
 
 102 
    <username>root</username>
- 
 
 103 
    <password>Encrypted 2be98afc86aa7f2e4b811a1608cc2fd8a</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>catalogDC_Prod</name>
 121 
    <name>catalogDC_Prod</name>
97 
    <server>192.168.141.43</server>
 122 
    <server>192.168.141.43</server>
98 
    <type>MYSQL</type>
 123 
    <type>MYSQL</type>
99 
    <access>Native</access>
 124 
    <access>Native</access>
100 
    <database>catalog</database>
 125 
    <database>catalog</database>
Line 128... Line 153...
128 
         <partitioning>
 153 
         <partitioning>
129 
           <method>none</method>
 154 
           <method>none</method>
130 
           <schema_name/>
 155 
           <schema_name/>
131 
           </partitioning>
 156 
           </partitioning>
132 
    <connection>catalogDC_Prod</connection>
 157 
    <connection>catalogDC_Prod</connection>
133 
    <sql>SELECT SQL_NO_CACHE item.id, product_group, brand, model_number, model_name,
158 
    <sql>SELECT SQL_NO_CACHE item.id, item.catalog_item_id, product_group, brand, model_number, model_name,
134 
       color, category.label category, parent.label parent_category
 159 
       color, category.label category, parent.label parent_category
135 
FROM item, category, category as parent
160 
FROM item, category, category as parent
136 
where item.category = category.id
161 
where item.category = category.id
137 
and category.parent_category_id = parent.id</sql>
 162 
and category.parent_category_id = parent.id</sql>
138 
    <limit>0</limit>
 163 
    <limit>0</limit>
Line 222... Line 247...
222 
         <partitioning>
 247 
         <partitioning>
223 
           <method>none</method>
 248 
           <method>none</method>
224 
           <schema_name/>
 249 
           <schema_name/>
225 
           </partitioning>
 250 
           </partitioning>
226 
    <fields>      <field>        <name>id</name>
 251 
    <fields>      <field>        <name>id</name>
227 
        <rename>id</rename>
 252 
        <rename/>
228 
        <length>-2</length>
 253 
        <length>-2</length>
229 
        <precision>-2</precision>
 254 
        <precision>-2</precision>
230 
      </field>      <field>        <name>product_group</name>
 255 
      </field>      <field>        <name>product_group</name>
231 
        <rename>product_group</rename>
 256 
        <rename/>
232 
        <length>-2</length>
 257 
        <length>-2</length>
233 
        <precision>-2</precision>
 258 
        <precision>-2</precision>
234 
      </field>      <field>        <name>brand</name>
 259 
      </field>      <field>        <name>brand</name>
235 
        <rename>brand</rename>
 260 
        <rename/>
236 
        <length>-2</length>
 261 
        <length>-2</length>
237 
        <precision>-2</precision>
 262 
        <precision>-2</precision>
238 
      </field>      <field>        <name>model_number</name>
 263 
      </field>      <field>        <name>model_number</name>
239 
        <rename>model_number</rename>
 264 
        <rename/>
240 
        <length>-2</length>
 265 
        <length>-2</length>
241 
        <precision>-2</precision>
 266 
        <precision>-2</precision>
242 
      </field>      <field>        <name>model_name</name>
 267 
      </field>      <field>        <name>model_name</name>
243 
        <rename>model_name</rename>
 268 
        <rename/>
244 
        <length>-2</length>
 269 
        <length>-2</length>
245 
        <precision>-2</precision>
 270 
        <precision>-2</precision>
246 
      </field>      <field>        <name>color</name>
 271 
      </field>      <field>        <name>color</name>
247 
        <rename>color</rename>
 272 
        <rename/>
248 
        <length>-2</length>
 273 
        <length>-2</length>
249 
        <precision>-2</precision>
 274 
        <precision>-2</precision>
250 
      </field>      <field>        <name>category</name>
 275 
      </field>      <field>        <name>category</name>
251 
        <rename>category</rename>
 276 
        <rename/>
252 
        <length>-2</length>
 277 
        <length>-2</length>
253 
        <precision>-2</precision>
 278 
        <precision>-2</precision>
254 
      </field>      <field>        <name>parent_category</name>
 279 
      </field>      <field>        <name>parent_category</name>
- 
 
 280 
        <rename/>
255 
        <rename>parent_category</rename>
 281 
        <length>-2</length>
- 
 
 282 
        <precision>-2</precision>
- 
 
 283 
      </field>      <field>        <name>catalog_item_id</name>
- 
 
 284 
        <rename/>
256 
        <length>-2</length>
 285 
        <length>-2</length>
257 
        <precision>-2</precision>
 286 
        <precision>-2</precision>
258 
      </field>        <select_unspecified>N</select_unspecified>
 287 
      </field>        <select_unspecified>N</select_unspecified>
259 
    </fields>     <cluster_schema/>
 288 
    </fields>     <cluster_schema/>
260 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 289 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>