I am attempting to use nested entities to populate documents from
different tables and verbose/debug output is showing repeated queries
on import.  The doc number repeats the sqls.

"verbose-output":
[ "entity:parent",
..
[ "document#5", [
...
"entity:nested1", [
"query", "SELECT body AS nested1 FROM table WHERE p_id = '1234'",
"query", "SELECT body AS nested1 FROM table WHERE p_id = '1234'",
"query", "SELECT body AS nested1 FROM table WHERE p_id = '1234'",
"query", "SELECT body AS nested1 FROM table WHERE p_id = '1234",
"query", "SELECT body AS nested1 FROM table WHERE p_id = '1234",
"time-taken", "0:0:0.1",
"time-taken", "0:0:0.1",
"time-taken", "0:0:0.1",
"time-taken", "0:0:0.1",
"time-taken", "0:0:0.1" ],


The counts appears to be correct?
Requests: 61 , Fetched: 20 , Skipped: 0 , Processed: 20


I have a config like:

<entity
  dataSource="database"
  name="parent"
  pk="id"
  query="SELECT .."
  deltaImportQuery="SELECT.."
  deltaQuery="SELECT.."
  >
  <entity
    name="child1"
    query="SELECT body AS nested1 FROM table WHERE p_id = '${parent.id}'
    deltaQuery=...
    parentDeltaQuery=...
    etc
  >
  </entity>
  <entity
    name="child2"
    query="SELECT body AS nested2 FROM table WHERE p_id = '${parent.id}'
    deltaQuery=...
    parentDeltaQuery=...
    etc
  >
  </entity>
  <entity
    name="child3"
    query="SELECT body AS nested3 FROM table WHERE p_id = '${parent.id}'
    deltaQuery=...
    parentDeltaQuery=...
    etc
  >
  </entity>


</entity>

Reply via email to