Open-source eCommerce platform for C# and ASP.NET Core 10 with MongoDB. Build multi-store shops and multi-vendor marketplaces with B2B/B2C, REST API, plugins, Vue 3 and Docker.
C# aspnet-corecsharpdockerdotnetecommerceecommerce-platformmongodbmulti-storemulti-vendornosqlonline-shopshoppingcart
using Grand.Domain.Common;
using Grand.SharedKernel;
using Microsoft.VisualStudio.TestTools.UnitTesting;
namespace Grand.Data.Tests.LiteDb;
[TestClass]
public class LiteDbRepositoryTests
{
[TestInitialize]
public void Init()
{
}
[TestMethod]
public void Insert_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var product = new SampleCollection { Id = "1" };
//Act
myRepository.Insert(product);
//Assert
Assert.AreEqual(1, myRepository.Table.Count());
Assert.AreEqual("user", myRepository.Table.FirstOrDefault(x => x.Id == "1")!.CreatedBy);
}
[TestMethod]
public async Task InsertAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var product = new SampleCollection { Id = "11" };
//Act
await myRepository.InsertAsync(product);
var p = myRepository.GetById("11");
//Assert
Assert.IsNotNull(p);
Assert.AreEqual(1, myRepository.Table.Count());
Assert.AreEqual("user", p.CreatedBy);
}
[TestMethod]
public async Task InsertAsync_UniqueIndexViolated_ThrowsDuplicateKeyGrandException()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
myRepository.EnsureUniqueIndex(x => x.Count);
await myRepository.InsertAsync(new SampleCollection { Id = "1", Count = 7 });
await Assert.ThrowsExactlyAsync<DuplicateKeyGrandException>(async () =>
await myRepository.InsertAsync(new SampleCollection { Id = "2", Count = 7 }));
Assert.AreEqual(1, myRepository.Table.Count());
}
[TestMethod]
public async Task GetById_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
var product = new SampleCollection { Id = "1" };
await myRepository.InsertAsync(product);
var p = myRepository.GetById("1");
Assert.IsNotNull(p);
}
[TestMethod]
public async Task GetByIdAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
var product = new SampleCollection { Id = "1" };
await myRepository.InsertAsync(product);
var p = await myRepository.GetByIdAsync("1");
Assert.IsNotNull(p);
}
[TestMethod]
public async Task GetOneAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
var product = new SampleCollection { Id = "1" };
await myRepository.InsertAsync(product);
var p = await myRepository.GetOneAsync(x => x.Id == "1");
Assert.IsNotNull(p);
}
[TestMethod]
public async Task GetOneAsync_ToLowerInvariant_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
var product = new SampleCollection { Id = "1" };
await myRepository.InsertAsync(product);
var p = await myRepository.GetOneAsync(x => x.Id == "1".ToLowerInvariant());
Assert.IsNotNull(p);
}
[TestMethod]
public async Task ClearAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
var product = new SampleCollection { Id = "1" };
await myRepository.InsertAsync(product);
await myRepository.ClearAsync();
Assert.IsEmpty(myRepository.Table);
}
[TestMethod]
public async Task AddToSet_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var product = new SampleCollection { Id = "1" };
await myRepository.InsertAsync(product);
await myRepository.AddToCollectionField("1", x => x.UserFields,
new UserField { Key = "key", Value = "value", StoreId = "" });
//Act
await myRepository.AddToCollectionField("1", x => x.UserFields,
new UserField { Key = "key2", Value = "value2", StoreId = "" });
var p = myRepository.GetById("1");
//Assert
Assert.HasCount(2, p.UserFields);
Assert.IsTrue(p.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p.UpdatedBy);
}
[TestMethod]
public async Task Delete_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
var product = new SampleCollection { Id = "1" };
await myRepository.InsertAsync(product);
myRepository.Delete(product);
var p = myRepository.GetById("1");
Assert.IsNull(p);
}
[TestMethod]
public async Task DeleteAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
var product = new SampleCollection { Id = "1" };
await myRepository.InsertAsync(product);
await myRepository.DeleteAsync(product);
var p = myRepository.GetById("1");
Assert.IsNull(p);
}
[TestMethod]
public async Task DeleteManyAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
await myRepository.InsertAsync(new SampleCollection { Id = "1", Name = "Test" });
await myRepository.InsertAsync(new SampleCollection { Id = "2", Name = "Test" });
await myRepository.InsertAsync(new SampleCollection { Id = "3", Name = "Test2" });
await myRepository.DeleteManyAsync(x => x.Name == "Test");
Assert.AreEqual(1, myRepository.Table.Count());
}
[TestMethod]
public async Task Pull_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
Phones = ["Phone1", "Phone2", "Phone3"]
},
new() {
Id = "2", Name = "Test2",
Phones = ["Phone1", "Phone2", "Phone3"]
},
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.RemoveCollectionFieldItem("1", x => x.Phones, y => y == "Phone2");
var p = myRepository.GetById("1");
//Assert
Assert.HasCount(2, p.Phones);
Assert.IsTrue(p.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p.UpdatedBy);
}
[TestMethod]
public async Task Pull_Many_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
Phones = ["Phone1", "Phone2", "Phone3"]
},
new() {
Id = "2", Name = "Test2",
Phones = ["Phone1", "Phone2", "Phone3"]
},
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.RemoveCollectionFieldItem(string.Empty, x => x.Phones, y => y == "Phone2");
var p1 = myRepository.GetById("1");
var p2 = myRepository.GetById("2");
var p3 = myRepository.GetById("3");
//Assert
Assert.HasCount(2, p1.Phones);
Assert.HasCount(2, p2.Phones);
Assert.IsEmpty(p3.Phones);
Assert.IsTrue(p1.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p1.UpdatedBy);
}
[TestMethod]
public async Task PullFilter_1_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value1", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test2" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.RemoveCollectionFieldItem("1", x => x.UserFields, x => x.Value == "value");
var p1 = myRepository.GetById("1");
//Assert
Assert.HasCount(2, p1.UserFields);
Assert.IsTrue(p1.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p1.UpdatedBy);
}
[TestMethod]
public async Task PullFilter_2_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test2" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.RemoveCollectionFieldItem("1", x => x.UserFields, x => x.Value == "value");
var p1 = myRepository.GetById("1");
//Assert
Assert.HasCount(1, p1.UserFields);
Assert.IsTrue(p1.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p1.UpdatedBy);
}
[TestMethod]
public async Task PullFilter_2_Many_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() {
Id = "2", Name = "Test2",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value1", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.RemoveCollectionFieldItem(string.Empty, x => x.UserFields, x => x.Value == "value");
var p1 = myRepository.GetById("1");
var p2 = myRepository.GetById("2");
//Assert
Assert.HasCount(1, p1.UserFields);
Assert.HasCount(2, p2.UserFields);
Assert.IsTrue(p1.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p1.UpdatedBy);
}
[TestMethod]
public void Update_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test2" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
var p1_update = products.FirstOrDefault();
p1_update.Name = "update";
//Act
myRepository.Update(p1_update);
var p1 = myRepository.GetById("1");
//Assert
Assert.AreEqual("update", p1.Name);
Assert.IsTrue(p1.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p1.UpdatedBy);
}
[TestMethod]
public async Task UpdateAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test2" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
var p1_update = products.FirstOrDefault();
p1_update.Name = "update";
//Act
await myRepository.UpdateAsync(p1_update);
var p1 = myRepository.GetById("1");
//Assert
Assert.AreEqual("update", p1.Name);
Assert.IsTrue(p1.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p1.UpdatedBy);
}
[TestMethod]
public async Task UpdateField_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test2" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.UpdateField("1", x => x.Name, "update");
var p1 = myRepository.GetById("1");
//Assert
Assert.AreEqual("update", p1.Name);
Assert.IsTrue(p1.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p1.UpdatedBy);
}
[TestMethod]
public async Task IncField_MongoRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
var sample = new SampleCollection { Id = "1", Name = "Test" };
await myRepository.InsertAsync(sample);
await myRepository.IncField("1", x => x.Count, 1);
await myRepository.IncField("1", x => x.Count, 1);
await myRepository.IncField("1", x => x.Count, 1);
var p1 = myRepository.GetById("1");
Assert.AreEqual(3, p1.Count);
}
[TestMethod]
public async Task UpdateManyAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.UpdateManyAsync(x => x.Name == "Test",
UpdateBuilder<SampleCollection>.Create().Set(x => x.Name, "UpdateTest"));
var pUpdated = myRepository.Table.Where(x => x.Name == "UpdateTest");
//Asser
Assert.AreEqual(2, pUpdated.Count());
Assert.IsTrue(pUpdated.FirstOrDefault()!.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", pUpdated.FirstOrDefault()!.UpdatedBy);
}
[TestMethod]
public async Task UpdateOneAsync_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.UpdateOneAsync(x => x.Name == "Test",
UpdateBuilder<SampleCollection>.Create().Set(x => x.Name, "UpdateTest"));
var pUpdated = myRepository.Table.Where(x => x.Name == "UpdateTest");
//Assert
Assert.AreEqual(1, pUpdated.Count());
Assert.IsTrue(pUpdated.FirstOrDefault()!.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", pUpdated.FirstOrDefault()!.UpdatedBy);
}
[TestMethod]
public async Task UpdateToSet_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.UpdateCollectionFieldItem("1", x => x.UserFields, z => z.Key == "key", new UserField { Key = "key", Value = "update", StoreId = "1" });
var p = myRepository.GetById("1");
//Assert
Assert.AreEqual("update", p.UserFields!.FirstOrDefault(x => x.Key == "key")!.Value);
Assert.IsTrue(p.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p.UpdatedBy);
}
[TestMethod]
public async Task UpdateToSet_2_LiteRepository_Success()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
//Arrange
var products = new List<SampleCollection> {
new() {
Id = "1", Name = "Test",
UserFields = new List<UserField> {
new() { Key = "key", Value = "value", StoreId = "" },
new() { Key = "key1", Value = "value", StoreId = "" },
new() { Key = "key2", Value = "value2", StoreId = "" }
}
},
new() { Id = "2", Name = "Test" },
new() { Id = "3", Name = "Test3" }
};
products.ForEach(x => myRepository.Insert(x));
//Act
await myRepository.UpdateCollectionFieldItem("1", x => x.UserFields, z => z.Key == "key",
new UserField { Key = "key", Value = "update", StoreId = "1" });
var p = myRepository.GetById("1");
//Assert
Assert.AreEqual("update", p.UserFields!.FirstOrDefault(x => x.Key == "key")!.Value);
Assert.IsTrue(p.UpdatedOnUtc.HasValue);
Assert.AreEqual("user", p.UpdatedBy);
}
[TestMethod]
public void TableCollection_ReadsTheEntityCollection()
{
var myRepository = new LiteDBRepositoryMock<SampleCollection>();
myRepository.Insert(new SampleCollection { Id = "1", Name = "Test" });
myRepository.Insert(new SampleCollection { Id = "2", Name = "Test2" });
//reads the collection named after the entity, not one named "T"
var result = myRepository.TableCollection<SampleCollection>().ToList();
Assert.AreEqual(2, result.Count);
Assert.IsNotNull(result.FirstOrDefault(x => x.Id == "1"));
}
}