public void ExtractAndSyncEntity_NoParam_Tests() { string Sql = @"SELECT Id, Name FROM Product"; IList <MetaEntity> metaEntities = metaEntityManager.ExtractEntity(MetaEntityType.Product, Sql); metaEntities.Count.ShouldBe(45); }
public async Task AssignTag_Tests() { string Sql1 = @"SELECT Id, Name FROM Product"; IList <MetaEntity> metaEntities1 = metaEntityManager.ExtractEntity(MetaEntityType.Product, Sql1); MetaEntitySyncResult result1 = metaEntityManager.SyncEntityToTarget(metaEntities1); string Sql2 = @"SELECT Id, Name FROM Product WHERE VisibleIndividually = @param"; IList <MetaEntity> metaEntities2 = metaEntityManager.ExtractEntity(MetaEntityType.Product, Sql2, new { param = 0 }); MetaEntitySyncResult result2 = metaEntityManager.SyncEntityToTarget(metaEntities2); // Root 1 CreateTagDto createRoot1TagDto = new CreateTagDto { Name = "Root1" }; var root1TagDto = await tagAppService.Create(createRoot1TagDto); // Sub 11 CreateTagDto createSub11TagDto = new CreateTagDto { Name = "Sub11", ParentId = root1TagDto.Id }; var sub11TagDto = await tagAppService.Create(createSub11TagDto); // Leaf 111 CreateTagDto createLeaf111TagDto = new CreateTagDto { Name = "Leaf111", ParentId = sub11TagDto.Id }; var leaf111TagDto = await tagAppService.Create(createLeaf111TagDto); AssignTagDto assignTagDto = new AssignTagDto() { Type = MetaEntityType.Product, Sql = @"SELECT Id, Name FROM Product WHERE VisibleIndividually = @param", Param = "{ \"param\": 0 }", TagId = leaf111TagDto.Id }; tagTargetAppService.AssignTag(assignTagDto); IList <TagTarget> tagTargets = tagTargetRepository.GetAllList(); tagTargets.Count.ShouldBe(2); tagTargets[0].TagId.ShouldBe(3); tagTargets[0].TargetId.ShouldBe(14); tagTargets[1].TagId.ShouldBe(3); tagTargets[1].TargetId.ShouldBe(15); }
public void AssignTag(AssignTagDto input) { IDictionary <string, object> paramDict = GenerateParamDict(input); IList <MetaEntity> metaEntities = metaEntityManager.ExtractEntity(input.Type, input.Sql, paramDict); MetaEntitySyncResult targetResult = metaEntityManager.SyncEntityToTarget(metaEntities); Tag tagResult = tagRepository.FirstOrDefault(t => t.Id == input.TagId); tagTargetManager.AssignTag(targetResult.Targets, tagResult); }
public async Task GetTargetsOfTagAsync_Tests() { string Sql1 = @"SELECT Id, Name FROM Product WHERE VisibleIndividually = @vi AND ApprovedRatingSum = @ars"; IList <MetaEntity> metaEntities1 = metaEntityManager.ExtractEntity(MetaEntityType.Product, Sql1, new { vi = 1, ars = 4 }); MetaEntitySyncResult result1 = metaEntityManager.SyncEntityToTarget(metaEntities1); // Root 1 CreateTagDto createRoot1TagDto = new CreateTagDto { Name = "Root1" }; var root1TagDto = await tagAppService.Create(createRoot1TagDto); // Sub 11 CreateTagDto createSub11TagDto = new CreateTagDto { Name = "Sub11", ParentId = root1TagDto.Id }; var sub11TagDto = await tagAppService.Create(createSub11TagDto); // Leaf 111 CreateTagDto createLeaf111TagDto = new CreateTagDto { Name = "Leaf111", ParentId = sub11TagDto.Id }; var leaf111TagDto = await tagAppService.Create(createLeaf111TagDto); Tag tag = tagRepository.FirstOrDefault(leaf111TagDto.Id); tagTargetManager.AssignTag(result1.Targets, tag); IList <TagTarget> tagTargets = tagTargetRepository.GetAllList(); tagTargets.Count.ShouldBe(18); using (var context = Resolve <StarryNightDbContext>()) { Tag tagResult = context.Tags .Include(t => t.TagTargets) .ThenInclude(tt => tt.Target) .FirstOrDefault(t => t.Id == leaf111TagDto.Id); tagResult.TagTargets.Count.ShouldBe(18); ICollection <Target> taggedTargets1 = tagManager.GetTargetsOfTag(tagResult, 10, 0); taggedTargets1.Count.ShouldBe(10); ICollection <Target> taggedTargets2 = tagManager.GetTargetsOfTag(tagResult, 10, 10); taggedTargets2.Count.ShouldBe(8); ICollection <Target> taggedTargets3 = tagManager.GetTargetsOfTag(tagResult, 100, 0); taggedTargets3.Count.ShouldBe(18); } }
public MetaEntityResultDto ExtractAndSyncEntity(MetaEntityQueryDto input) { IDictionary <string, object> paramDict = GenerateParamDict(input); IList <MetaEntity> metaEntities = metaEntityManager.ExtractEntity(input.Type, input.Sql, paramDict); MetaEntitySyncResult result = metaEntityManager.SyncEntityToTarget(metaEntities); return(new MetaEntityResultDto() { InsertedCount = result.InsertedCount, UpdatedCount = result.UpdatedCount, UnchangedCount = result.UnchangedCount }); }