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;
using MongoDB.Driver;
namespace Grand.Data.Tests.MongoDb;
[TestClass]
public class MongoRepositoryTests
{
private IRepository<SampleCollection> _myRepository;
[TestInitialize]
public void Init()
{
_myRepository = new MongoDBRepositoryTest<SampleCollection>();
}
[TestMethod]
public void Insert_MongoRepository_Success()
{
//Arrange
var product = new SampleCollection();
//Act
_myRepository.Insert(product);
//Assert
Assert.AreEqual(1, _myRepository.Table.Count());
Assert.AreEqual("user", _myRepository.Table.FirstOrDefault()!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, _myRepository.Table.FirstOrDefault()!.CreatedOnUtc.Year);
Assert.AreEqual(DateTime.UtcNow.Month, _myRepository.Table.FirstOrDefault()!.CreatedOnUtc.Month);
Assert.AreEqual(DateTime.UtcNow.Day, _myRepository.Table.FirstOrDefault()!.CreatedOnUtc.Day);
}
[TestMethod]
public async Task InsertAsync_UniqueIndexViolated_ThrowsDuplicateKeyGrandException()
{
//Arrange
var collection = ((MongoDBRepositoryTest<SampleCollection>)_myRepository).Collection;
await collection.Indexes.CreateOneAsync(new CreateIndexModel<SampleCollection>(
Builders<SampleCollection>.IndexKeys.Descending(x => x.Count),
new CreateIndexOptions { Name = "Count", Unique = true }));
await _myRepository.InsertAsync(new SampleCollection { Id = "1", Count = 7 });
//Act / Assert
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_MongoRepository_Success()
{
//Arrange
var product = new SampleCollection { Id = "1" };
await _myRepository.InsertAsync(product);
//Act
var p = _myRepository.GetById("1");
//Assert
Assert.IsNotNull(p);
}
[TestMethod]
public async Task GetByIdAsync_MongoRepository_Success()
{
//Arrange
var product = new SampleCollection { Id = "1" };
await _myRepository.InsertAsync(product);
//Act
var p = await _myRepository.GetByIdAsync("1");
//Assert
Assert.IsNotNull(p);
Assert.AreEqual("user", p!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, p!.CreatedOnUtc.Year);
}
[TestMethod]
public async Task GetOneAsync_MongoRepository_Success()
{
//Arrange
var product = new SampleCollection { Id = "1" };
await _myRepository.InsertAsync(product);
//Act
var p = await _myRepository.GetOneAsync(x => x.Id == "1");
//Assert
Assert.IsNotNull(p);
Assert.AreEqual("user", p!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, p!.CreatedOnUtc.Year);
}
[TestMethod]
public async Task ClearAsync_MongoRepository_Success()
{
var product = new SampleCollection { Id = "1" };
await _myRepository.InsertAsync(product);
await _myRepository.ClearAsync();
Assert.IsEmpty(_myRepository.Table);
}
[TestMethod]
public async Task AddToSet_MongoRepository_Success()
{
//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.AreEqual("user", p!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, p!.CreatedOnUtc.Year);
Assert.AreEqual("user", p!.UpdatedBy);
Assert.IsTrue(p!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task Delete_MongoRepository_Success()
{
//Arrange
var product = new SampleCollection { Id = "1" };
await _myRepository.InsertAsync(product);
//Act
_myRepository.Delete(product);
var p = _myRepository.GetById("1");
//Assert
Assert.IsNull(p);
}
[TestMethod]
public async Task DeleteAsync_MongoRepository_Success()
{
//Arrange
var product = new SampleCollection { Id = "1" };
await _myRepository.InsertAsync(product);
//Act
await _myRepository.DeleteAsync(product);
var p = _myRepository.GetById("1");
//Assert
Assert.IsNull(p);
}
[TestMethod]
public async Task DeleteManyAsync_MongoRepository_Success()
{
//Arrange
var products = new List<SampleCollection> {
new() { Id = "1", Name = "Test" },
new() { Id = "2", Name = "Test" },
new() { Id = "3", Name = "Test2" }
};
products.ForEach(x => _myRepository.Insert(x));
//Act
await _myRepository.DeleteManyAsync(x => x.Name == "Test");
//Assert
Assert.AreEqual(1, _myRepository.Table.Count());
}
[TestMethod]
public async Task Pull_MongoRepository_Success()
{
//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.AreEqual("user", p!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, p!.CreatedOnUtc.Year);
Assert.AreEqual("user", p!.UpdatedBy);
Assert.IsTrue(p!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task Pull_ById_NothingToPull_LeavesTheDocumentUnwritten()
{
//Arrange
_myRepository.Insert(new SampleCollection { Id = "1", Name = "Test", Phones = ["Phone1", "Phone3"] });
//Act
await _myRepository.RemoveCollectionFieldItem("1", x => x.Phones, y => y == "Phone2");
//Assert
var p = _myRepository.GetById("1");
Assert.HasCount(2, p.Phones);
Assert.IsNull(p.UpdatedOnUtc);
Assert.IsNull(p.UpdatedBy);
}
[TestMethod]
public async Task Pull_Many_MongoRepository_Success()
{
//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);
//nothing to pull from p3, so it must not be written (nor re-stamped) at all
Assert.IsNull(p3.UpdatedOnUtc);
Assert.IsNull(p3.UpdatedBy);
Assert.AreEqual("user", p1!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, p1!.CreatedOnUtc.Year);
Assert.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task PullFilter_1_MongoRepository_Success()
{
//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.AreEqual("user", p1!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, p1!.CreatedOnUtc.Year);
Assert.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task PullFilter_2_MongoRepository_Success()
{
//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.AreEqual("user", p1!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, p1!.CreatedOnUtc.Year);
Assert.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task PullFilter_2_Many_MongoRepository_Success()
{
//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");
var p3 = _myRepository.GetById("3");
//Assert
//p3 has no user field to pull, so it must not be written (nor re-stamped) at all
Assert.IsNull(p3.UpdatedOnUtc);
Assert.HasCount(1, p1.UserFields);
Assert.HasCount(2, p2.UserFields);
Assert.AreEqual("user", p1!.CreatedBy);
Assert.AreEqual(DateTime.UtcNow.Year, p1!.CreatedOnUtc.Year);
Assert.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public void Update_MongoRepository_Success()
{
//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.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task UpdateAsync_MongoRepository_Success()
{
//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.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task UpdateField_MongoRepository_Success()
{
//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.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task IncField_MongoRepository_Success()
{
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_MongoRepository_Success()
{
//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");
var p1 = pUpdated.FirstOrDefault();
//Assert
Assert.AreEqual(2, pUpdated.Count());
Assert.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task UpdateOneAsync_MongoRepository_Success()
{
//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");
var p1 = pUpdated.FirstOrDefault();
//Assert
Assert.AreEqual(1, pUpdated.Count());
Assert.AreEqual("user", p1!.UpdatedBy);
Assert.IsTrue(p1!.UpdatedOnUtc.HasValue);
}
[TestMethod]
public async Task UpdateToSet_MongoRepository_Success()
{
//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.AreEqual("user", p!.UpdatedBy);
Assert.IsTrue(p!.UpdatedOnUtc.HasValue);
}
}