lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bertie Shen <bertie.s...@gmail.com>
Subject Question about DIH execution order
Date Sun, 01 Nov 2009 18:29:59 GMT
Hi folks,

  I have the following data-config.xml. Is there a way to
let transformation take place after executing SQL "select comment from
Rating where Rating.CourseId = ${Course.CourseId}"?  In MySQL database,
column CourseId in table Course is integer 1, 2, etc;
template transformation will make them like Course:1, Course:2; column
CourseId in table Rating is also integer 1, 2, etc.

  If transformation happens before executing "select comment from Rating
where Rating.CourseId = ${Course.CourseId}", then there will no match for
the SQL statement execution.

 <document>
     <entity name="Course" transformer="TemplateTransformer" query="select *
from Course">
      <field
column="CourseId" template="Course:${Course.CourseId}" name="id"/>
      <entity name="Rating" query="select comment from Rating where
Rating.CourseId = ${Course.CourseId}">
        <field column="comment" name="review"/>
      </entity>
    </entity>
  </document>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message