I have 1:n relation between my main entity(PackageVersion) and its tag in
my DB.

I add a new tag with this date to the db at the timestamp and I run delta
import command.
the select retrieves the line but i dont see any other sql.
Here are my data-config.xml configurations:

<entity name="PackageVersion" pk="PackageVersionId"
        query=  "select ...
                from [dbo].[Package] Package inner join
[dbo].[PackageVersion] PackageVersion on Package.Id =
PackageVersion.PackageId"
        deltaQuery = "select PackageVersion.Id PackageVersionId
                      from [dbo].[Package] Package inner join
[dbo].[PackageVersion] PackageVersion on Package.Id =
PackageVersion.PackageId
                      where Package.LastModificationTime >
'${dataimporter.last_index_time}' OR PackageVersion.Timestamp >
'${dataimporter.last_index_time}'"
        deltaImportQuery="select ...
                          from [dbo].[Package] Package inner join
[dbo].[PackageVersion] PackageVersion on Package.Id =
PackageVersion.PackageId
                          Where PackageVersionId=='${dih.delta.id}'" >

                <entity name="PackageTag" pk="ResourceId"
processor="CachedSqlEntityProcessor" cacheKey="ResourceId"
cacheLookup="PackageVersion.PackageId"
                        query=  "SELECT ResourceId,[Text] PackageTag
                                 from [dbo].[Tag] Tag"
                        deltaQuery="SELECT ResourceId,[Text] PackageTag
                                    from [dbo].[Tag] Tag
                                    Where Tag.TimeStamp >
'${dataimporter.last_index_time}'"
                        parentDeltaQuery="select PackageVersion.PackageVersionId
                                    from [dbo].[Package]
                                    where
Package.Id=${PackageVersion.PackageVersionId}">
                </entity>
</entity>

Reply via email to