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] Updated: (SOLR-2252) when child entity is the root in nested entities, delta-import doesn't work
Date Sat, 27 Nov 2010 12:25:14 GMT

     [ https://issues.apache.org/jira/browse/SOLR-2252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Koji Sekiguchi updated SOLR-2252:
---------------------------------

    Attachment: SOLR-2252.patch

I added tests. All tests pass.
I'll commit in a few days if no one objects.

> 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
>
>         Attachments: SOLR-2252.patch, SOLR-2252.patch
>
>
> 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