solr delta import and deletedPkQuery example

db-data-config.xml

<dataConfig>
<dataSource name="DATA_SOURCE" driver="com.mysql.jdbc.Driver"
	url="jdbc:mysql://10.10.10.10:3306/rm" user="user" password="pass" />
	<document name="DOC_NAMES">
		<entity name="ENTITY_NAME" dataSource="DATA_SOURCE" pk="serial_no"
  		query = "SELECT nri.id id,
         nri.name name
         FROM rm.nri nri ;"
  		deltaImportQuery="SELECT nri.id id,
         nri.name name
         FROM rm.nri nri where nri.serial_no='${dih.delta.serial_no}'"
  		deltaQuery="select serial_no from rm.nri where modification_date &gt; '${dih.last_index_time}'"
  		deletedPkQuery="SELECT PK_DATA as serial_no from rm.CONTROL 
      						WHERE INSERT_DATE &gt; '${dih.last_index_time}'
      						AND TABLE_NAME = 'rm.nri' 
      						AND ACTION_TYPE IN ('DELETE')"
			   >
		</entity>
	</document>
</dataConfig>