public void CheckIfUACExists_ShouldReturn1()
{
var data = new List<product>{
new product{ article_id = 1, webshop_url = "www.borderloop.nl", affiliate_unique_id = "UAC"}
}.AsQueryable();
var mockSet = new Mock<DbSet<product>>();
mockSet.As<IQueryable<product>>().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As<IQueryable<product>>().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As<IQueryable<product>>().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As<IQueryable<product>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.product).Returns(mockSet.Object);
var service = new BetsyService(mockContext.Object);
var correctArticleId = service.GetAIDFromUAC(new Product { Webshop = "www.borderloop.nl", AffiliateProdID = "UAC" });
var incorrectArticleId = service.GetAIDFromUAC(new Product { Webshop = "www.borderloop.nl", AffiliateProdID = "NotUAC" });
Assert.AreEqual(1, correctArticleId);
Assert.AreEqual(-1, incorrectArticleId);
}
public void CheckIfBrandExists_ShouldReturnTrue()
{
var data = new List<article>{
new article{ brand = "DefinitelyNotApple", id = 1, description = "This thing is anything but Applish", image_loc = "somewhere.jpg" }
}.AsQueryable();
var mockSet = new Mock<DbSet<article>>();
mockSet.As<IQueryable<article>>().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As<IQueryable<article>>().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As<IQueryable<article>>().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As<IQueryable<article>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.article).Returns(mockSet.Object);
var service = new BetsyService(mockContext.Object);
var checkTrue = service.CheckIfBrandExists("DefinitelyNotApple");
var checkFalse = service.CheckIfBrandExists("Apple");
Assert.AreEqual(true, checkTrue);
Assert.AreEqual(false, checkFalse);
}
public void GetArticleNumberFromEan_ShouldReturn1()
{
var data = new List<ean>{
new ean { article_id = 1, ean1 = "0000000000"},
}.AsQueryable();
var mockSet = new Mock<DbSet<ean>>();
mockSet.As<IQueryable<ean>>().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As<IQueryable<ean>>().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As<IQueryable<ean>>().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As<IQueryable<ean>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.ean).Returns(mockSet.Object);
var service = new BetsyService(mockContext.Object);
var aid = service.GetArticleNumber("ean", "ean", "0000000000");
var wrongEan = service.GetArticleNumber("ean", "ean", "1111111111");
var wrongTable = service.GetArticleNumber("NonExistingTable", "NonExistingColumn", "SomeValue");
Assert.AreEqual(1, aid);
Assert.AreEqual(-1, wrongEan);
Assert.AreEqual(-1, wrongTable);
}
public void GetArticleNumberFromSku_ShouldReturn1()
{
var data = new List<sku>{
new sku { article_id = 1, sku1 = "0000000000"},
}.AsQueryable();
var mockSet = new Mock<DbSet<sku>>();
mockSet.As<IQueryable<sku>>().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As<IQueryable<sku>>().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As<IQueryable<sku>>().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As<IQueryable<sku>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.sku).Returns(mockSet.Object);
var service = new BetsyService(mockContext.Object);
var aid = service.GetArticleNumber("sku", "sku", "0000000000");
var wrongSku = service.GetArticleNumber("sku", "sku", "1111111111");
Assert.AreEqual(1, aid);
Assert.AreEqual(-1, wrongSku);
}
public void SaveMatchTest()
{
var articleData = new List<article>{
new article{
id = 1,
title = new List<title>{
new title{
title1 = "Samsung Galaxy S5",
id = 1,
title_synonym = new List<title_synonym>{
new title_synonym{
title = "Galaxy S5",
title_id = 1,
occurrences = 5
}
},
country = new country{
id = 1,
name = "Nederland",
extension = "nl"
},
article_id = 1,
country_id = 1
}
},
brand = "Samsung",
ean = new List<ean> {
new ean {
ean1 = "0000000000"
},
new ean {
ean1 = "0000000001"
}
},
sku = new List<sku> {
new sku {
sku1 = "1111111111"
},
new sku {
sku1 = "1111111110"
}
}
}
}.AsQueryable();
var titleData = new List<title>
{
new title
{
title1 = "Samsung Galaxy S5",
id = 1,
title_synonym = new List<title_synonym>{
new title_synonym{
title = "Galaxy S5",
title_id = 1,
occurrences = 1,
}
},
country = new country{
id = 1,
name = "Nederland",
extension = "nl"
},
article_id = 1
}
}.AsQueryable();
var titleSynonymData = new List<title_synonym>
{
new title_synonym
{
title = "Galaxy S5",
title_id = 1,
occurrences = 1
}
}.AsQueryable();
var skuData = new List<sku>{}.AsQueryable();
var articleMockSet = new Mock<DbSet<article>>();
articleMockSet.As<IQueryable<article>>().Setup(m => m.Provider).Returns(articleData.Provider);
articleMockSet.As<IQueryable<article>>().Setup(m => m.Expression).Returns(articleData.Expression);
articleMockSet.As<IQueryable<article>>().Setup(m => m.ElementType).Returns(articleData.ElementType);
articleMockSet.As<IQueryable<article>>().Setup(m => m.GetEnumerator()).Returns(articleData.GetEnumerator());
var titleMockSet = new Mock<DbSet<title>>();
titleMockSet.As<IQueryable<title>>().Setup(m => m.Provider).Returns(titleData.Provider);
titleMockSet.As<IQueryable<title>>().Setup(m => m.Expression).Returns(titleData.Expression);
titleMockSet.As<IQueryable<title>>().Setup(m => m.ElementType).Returns(titleData.ElementType);
titleMockSet.As<IQueryable<title>>().Setup(m => m.GetEnumerator()).Returns(titleData.GetEnumerator());
var titleSynMockSet = new Mock<DbSet<title_synonym>>();
titleSynMockSet.As<IQueryable<title_synonym>>().Setup(m => m.Provider).Returns(titleSynonymData.Provider);
titleSynMockSet.As<IQueryable<title_synonym>>().Setup(m => m.Expression).Returns(titleSynonymData.Expression);
titleSynMockSet.As<IQueryable<title_synonym>>().Setup(m => m.ElementType).Returns(titleSynonymData.ElementType);
titleSynMockSet.As<IQueryable<title_synonym>>().Setup(m => m.GetEnumerator()).Returns(titleSynonymData.GetEnumerator());
var skuMockSet = new Mock<DbSet<sku>>();
skuMockSet.As<IQueryable<sku>>().Setup(m => m.Provider).Returns(skuData.Provider);
skuMockSet.As<IQueryable<sku>>().Setup(m => m.Expression).Returns(skuData.Expression);
skuMockSet.As<IQueryable<sku>>().Setup(m => m.ElementType).Returns(skuData.ElementType);
skuMockSet.As<IQueryable<sku>>().Setup(m => m.GetEnumerator()).Returns(skuData.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.article).Returns(articleMockSet.Object);
mockContext.Setup(c => c.title).Returns(titleMockSet.Object);
mockContext.Setup(c => c.title_synonym).Returns(titleSynMockSet.Object);
mockContext.Setup(c => c.sku).Returns(skuMockSet.Object);
var service = new BetsyService(mockContext.Object);
service.SaveMatch(new Product { Title = "Galaxy S5", EAN = "0000000000", SKU = "1010101010" }, 1, 1);
mockContext.Verify(m => m.SaveChanges(), Times.AtMost(2));
}
public void GetArticleNumberFromTitle_ShouldReturn1()
{
var data = new List<title>{
new title { article_id = 1, title1 = "Hello"},
}.AsQueryable();
var mockSet = new Mock<DbSet<title>>();
mockSet.As<IQueryable<title>>().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As<IQueryable<title>>().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As<IQueryable<title>>().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As<IQueryable<title>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.title).Returns(mockSet.Object);
var service = new BetsyService(mockContext.Object);
var aid = service.GetArticleNumber("title", "title", "Hello");
var wrongTitle = service.GetArticleNumber("title", "title", "Bye");
Assert.AreEqual(1, aid);
Assert.AreEqual(-1, wrongTitle);
}