lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Koji Sekiguchi (JIRA)" <j...@apache.org>
Subject [jira] Created: (SOLR-2252) when child entity is the root in nested entities, delta-import doesn't work
Date Thu, 25 Nov 2010 13:41:14 GMT
when child entity is the root in nested entities, delta-import doesn't work
---------------------------------------------------------------------------

                 Key: SOLR-2252
                 URL: https://issues.apache.org/jira/browse/SOLR-2252
             Project: Solr
          Issue Type: Bug
          Components: contrib - DataImportHandler
    Affects Versions: 1.4.1
            Reporter: Koji Sekiguchi
            Priority: Minor
             Fix For: 3.1, 4.0


sample data-config.xml:

{code}
<dataConfig>
  <dataSource driver="org.postgresql.Driver"
              url="jdbc:postgresql://localhost/exercise" user="solr" password="solr" />
  <document>
    <entity name="team" query="select * from team" pk="team_id" rootEntity="false"
            deltaQuery="select team_id from team where last_modified > '${dih.last_index_time}'"
            deltaImportQuery="select * from team where team_id='${dih.delta.team_id}'">
      <field column="team_name" name="team"/>
      <field column="team_yard" name="yard"/>
      <entity name="team_athlete" pk="team_id" rootEntity="false"
              query="select athlete_id from team_athlete where team_athlete.team_id=${team.team_id}"
              deltaQuery="select distinct team_id from team_athlete where last_modified >
'${dih.last_index_time}'"
              deltaImportQuery="select athlete_id from team_athlete where team_athlete.team_id=${dih.delta.team_id}"
              parentDeltaQuery="select team_id from team where team_id=${team_athlete.team_id}">
        <entity name="athlete" pk="athlete_id" rootEntity="true"
                query="select athlete_name from athlete where athlete_delflag='N' AND athlete.athlete_id=${team_athlete.athlete_id}"
                deletedPkQuery="select athlete_id from athlete where athlete_delflag='Y' AND
last_modified > '${dih.last_index_time}'"
                deltaQuery="select athlete_id from athlete where athlete_delflag='N' AND 
last_modified > '${dih.last_index_time}'"
                deltaImportQuery="select athlete_name from athlete where athlete_delflag='N'
AND athlete.athlete_id=${dih.delta.athlete_id}"
                parentDeltaQuery="select team_id from team_athlete where athlete_id=${athlete.athlete_id}">
          <field column="athlete_name" name="name"/>
        </entity>
      </entity>
    </entity>
  </document>
</dataConfig>
{code}


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message