public void AddCriterionsToQuery(IAuditReaderImplementor versionsReader)
{
if (hasCriterions() || hasOrders() || hasProjections())
{
if (_auditConfiguration.EntCfg.IsVersioned(_entityName))
{
var verEntCfg = _auditConfiguration.AuditEntCfg;
var auditEntityName = verEntCfg.GetAuditEntityName(_entityName);
_queryBuilder.AddFrom(auditEntityName, _alias, false);
// owner.reference_id = target.originalId.Id
var originalIdPropertyName = verEntCfg.OriginalIdPropName;
var idMapperTarget = _auditConfiguration.EntCfg[_entityName].IdMapper;
var prefix = _alias + "." + originalIdPropertyName;
_ownerAssociationIdMapper.AddIdsEqualToQuery(_queryBuilder.RootParameters, _ownerAlias, idMapperTarget, prefix);
//filter reference of target entity
var revisionPropertyPath = verEntCfg.RevisionNumberPath;
var referencedIdData = new MiddleIdData(
verEntCfg,
_auditConfiguration.EntCfg[_entityName].IdMappingData,
prefix: null,
_entityName,
_auditConfiguration.EntCfg.IsVersioned(_entityName));
_auditConfiguration.GlobalCfg.AuditStrategy.AddEntityAtRevisionRestriction(_queryBuilder, _parameters, revisionPropertyPath, verEntCfg.RevisionEndFieldName, true, referencedIdData, revisionPropertyPath, originalIdPropertyName, _alias, _queryBuilder.GenerateAlias());
}
else
{
_queryBuilder.AddFrom(_entityName, _alias, false);
//owner.reference_id = target.id
var idMapperTarget = _auditConfiguration.EntCfg.GetNotVersionEntityConfiguration(_entityName).IdMapper;
_ownerAssociationIdMapper.AddIdsEqualToQuery(_queryBuilder.RootParameters, _ownerAlias, idMapperTarget, _alias);
}
foreach (var criterion in _criterions)
{
criterion.AddToQuery(_auditConfiguration, versionsReader, _entityName, _queryBuilder, _parameters);
}
foreach (var sub in _associationQueries)
{
sub.AddCriterionsToQuery(versionsReader);
}
}
}
public OneAuditEntityQueryGenerator(GlobalConfiguration globalCfg, AuditEntitiesConfiguration verEntCfg,
MiddleIdData referencingIdData, String referencedEntityName,
IIdMapper referencedIdMapper)
{
this.referencingIdData = referencingIdData;
/*
* The query that we need to create:
* SELECT new list(e) FROM versionsReferencedEntity e
* WHERE
* (only entities referenced by the association; id_ref_ing = id of the referencing entity)
* e.id_ref_ing = :id_ref_ing AND
* (selecting e entities at revision :revision)
* e.revision = (SELECT max(e2.revision) FROM versionsReferencedEntity e2
* WHERE e2.revision <= :revision AND e2.id = e.id) AND
* (only non-deleted entities)
* e.revision_type != DEL
*/
String revisionPropertyPath = verEntCfg.RevisionNumberPath;
String originalIdPropertyName = verEntCfg.OriginalIdPropName;
String versionsReferencedEntityName = verEntCfg.GetAuditEntityName(referencedEntityName);
// SELECT new list(e) FROM versionsEntity e
QueryBuilder qb = new QueryBuilder(versionsReferencedEntityName, "e");
qb.AddProjection("new list", "e", false, false);
// WHERE
Parameters rootParameters = qb.RootParameters;
// e.id_ref_ed = :id_ref_ed
referencingIdData.PrefixedMapper.AddNamedIdEqualsToQuery(rootParameters, null, true);
// SELECT max(e.revision) FROM versionsReferencedEntity e2
QueryBuilder maxERevQb = qb.NewSubQueryBuilder(versionsReferencedEntityName, "e2");
maxERevQb.AddProjection("max", revisionPropertyPath, false);
// WHERE
Parameters maxERevQbParameters = maxERevQb.RootParameters;
// e2.revision <= :revision
maxERevQbParameters.AddWhereWithNamedParam(revisionPropertyPath, "<=", "revision");
// e2.id = e.id
referencedIdMapper.AddIdsEqualToQuery(maxERevQbParameters,
"e." + originalIdPropertyName, "e2." + originalIdPropertyName);
// e.revision = (SELECT max(...) ...)
rootParameters.AddWhere(revisionPropertyPath, false, globalCfg.getCorrelatedSubqueryOperator(), maxERevQb);
// e.revision_type != DEL
rootParameters.AddWhereWithNamedParam(verEntCfg.RevisionTypePropName, false, "!=", "delrevisiontype");
StringBuilder sb = new StringBuilder();
qb.Build(sb, EmptyDictionary <String, object> .Instance);
queryString = sb.ToString();
}
public OneAuditEntityQueryGenerator(GlobalConfiguration globalCfg, AuditEntitiesConfiguration verEntCfg,
MiddleIdData referencingIdData, String referencedEntityName,
IIdMapper referencedIdMapper)
{
this.referencingIdData = referencingIdData;
/*
* The query that we need to create:
* SELECT new list(e) FROM versionsReferencedEntity e
* WHERE
* (only entities referenced by the association; id_ref_ing = id of the referencing entity)
* e.id_ref_ing = :id_ref_ing AND
* (selecting e entities at revision :revision)
* e.revision = (SELECT max(e2.revision) FROM versionsReferencedEntity e2
* WHERE e2.revision <= :revision AND e2.id = e.id) AND
* (only non-deleted entities)
* e.revision_type != DEL
*/
String revisionPropertyPath = verEntCfg.RevisionNumberPath;
String originalIdPropertyName = verEntCfg.OriginalIdPropName;
String versionsReferencedEntityName = verEntCfg.GetAuditEntityName(referencedEntityName);
// SELECT new list(e) FROM versionsEntity e
QueryBuilder qb = new QueryBuilder(versionsReferencedEntityName, "e");
qb.AddProjection("new list", "e", false, false);
// WHERE
Parameters rootParameters = qb.RootParameters;
// e.id_ref_ed = :id_ref_ed
referencingIdData.PrefixedMapper.AddNamedIdEqualsToQuery(rootParameters, null, true);
// SELECT max(e.revision) FROM versionsReferencedEntity e2
QueryBuilder maxERevQb = qb.NewSubQueryBuilder(versionsReferencedEntityName, "e2");
maxERevQb.AddProjection("max", revisionPropertyPath, false);
// WHERE
Parameters maxERevQbParameters = maxERevQb.RootParameters;
// e2.revision <= :revision
maxERevQbParameters.AddWhereWithNamedParam(revisionPropertyPath, "<=", "revision");
// e2.id = e.id
referencedIdMapper.AddIdsEqualToQuery(maxERevQbParameters,
"e." + originalIdPropertyName, "e2." + originalIdPropertyName);
// e.revision = (SELECT max(...) ...)
rootParameters.AddWhere(revisionPropertyPath, false, globalCfg.getCorrelatedSubqueryOperator(), maxERevQb);
// e.revision_type != DEL
rootParameters.AddWhereWithNamedParam(verEntCfg.RevisionTypePropName, false, "!=", "delrevisiontype");
StringBuilder sb = new StringBuilder();
qb.Build(sb, EmptyDictionary<String, object>.Instance);
queryString = sb.ToString();
}
public void AddMiddleEqualToQuery(Parameters parameters, string prefix1, string prefix2)
{
_delegat.AddIdsEqualToQuery(parameters, prefix1, _delegat, prefix2);
}
