lucene-solr-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Solr Wiki] Update of "DataImportHandler" by HossMan
Date Mon, 16 Aug 2010 20:48:08 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Solr Wiki" for change notification.

The "DataImportHandler" page has been changed by HossMan.
The comment on this change is: use xml escaped '>' so people don't try to use raw '<'
equivilently.
http://wiki.apache.org/solr/DataImportHandler?action=diff&rev1=249&rev2=250

--------------------------------------------------

  	    <entity name="item" pk="ID"
                  query="select * from item"
                  deltaImportQuery="select * from item where ID='${dataimporter.delta.id}'"
- 		deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
+ 		deltaQuery="select id from item where last_modified &gt; '${dataimporter.last_index_time}'">
              <entity name="feature" pk="ITEM_ID"
                      query="select description as features from feature where item_id='${item.ID}'">
              </entity>
@@ -269, +269 @@

  				or id in
  				(select item_id as id from item_category where item_id in
  				    (select id as item_id from category where last_modified > '${dataimporter.last_index_time}')
- 				or last_modified > '${dataimporter.last_index_time}')
+ 				or last_modified &gt; '${dataimporter.last_index_time}')
- 				or last_modified > '${dataimporter.last_index_time}'"
+ 				or last_modified &gt; '${dataimporter.last_index_time}'"
  }}}
   * Writing a huge deltaQuery like the above one is not a very enjoyable task, so we have
an alternate mechanism of achieving this goal.
  {{{
@@ -279, +279 @@

      <document>
  	    <entity name="item" pk="ID" query="select * from item"
                  deltaImportQuery="select * from item where ID=='${dataimporter.delta.id}'"
- 		deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
+ 		deltaQuery="select id from item where last_modified &gt; '${dataimporter.last_index_time}'">
                  <entity name="feature" pk="ITEM_ID"
  		    query="select DESCRIPTION as features from FEATURE where ITEM_ID='${item.ID}'"
  		    deltaQuery="select ITEM_ID from FEATURE where last_modified > '${dataimporter.last_index_time}'"
@@ -292, +292 @@

  		    parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
                  <entity name="category" pk="ID"
  			query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'"
- 			deltaQuery="select ID from category where last_modified > '${dataimporter.last_index_time}'"
+ 			deltaQuery="select ID from category where last_modified &gt; '${dataimporter.last_index_time}'"
  			parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}"/>
  	    </entity>
          </entity>

Mime
View raw message