public void CanListEntitiesByNameOrSurname() { // Arrange var conn = GetConnectionString(); var repo = new SqliteUserRepository(conn); var entity1 = new User(0, "email1", new byte[] { 0x1, 0x1 }, "NameB", "Surname1", false, false); var entity2 = new User(0, "email2", new byte[] { 0x2, 0x2 }, "Name2", "SurnameA", true, true); var entity3 = new User(0, "email2", new byte[] { 0x2, 0x2 }, "Name3", "SurnameB", true, true); var savedEntity1 = repo.AddOrUpdate(entity1); repo.AddOrUpdate(entity2); var savedEntity3 = repo.AddOrUpdate(entity3); var filters = ImmutableList.Create(new[]
public void CanListEntitiesByIdAndNameNotFound() { // Arrange var conn = GetConnectionString(); var repo = new SqliteUserRepository(conn); var entity1 = new User(0, "email1", new byte[] { 0x1, 0x1 }, "Name1", "Surname1", false, false); var entity2 = new User(0, "email2", new byte[] { 0x2, 0x2 }, "Name2", "Surname2", true, true); repo.AddOrUpdate(entity1); repo.AddOrUpdate(entity2); var filters = ImmutableList.Create(new[] { new Filter <User>("Id", (uint)1), new Filter <User>("Name", "Name2") }); // Act var listEntities = repo.ListEntities(filters); // Assert Assert.IsTrue(listEntities.IsValid); Assert.IsFalse(listEntities.Value.Any()); }
public void CanListEntitiesActive() { // Arrange var conn = GetConnectionString(); var repo = new SqliteUserRepository(conn); var entity1 = new User(0, "email1", new byte[] { 0x1, 0x2 }, "Name1", isActive: true); var savedEntity1 = repo.AddOrUpdate(entity1); var entity2 = new User(0, "email2", new byte[] { 0x2, 0x1 }, "Name2", isActive: false); _ = repo.AddOrUpdate(entity2); // Act var listEntities = repo.ListEntities(status: Status.Active); // Assert Assert.IsTrue(listEntities.IsValid); Assert.IsTrue(listEntities.Value.Count == 1); Assert.IsTrue(savedEntity1.Value.Equals(listEntities.Value.First())); }
public void CanListEntitiesByEmail() { // Arrange var conn = GetConnectionString(); var repo = new SqliteUserRepository(conn); var entity1 = new User(0, "email1", new byte[] { 0x1, 0x1 }, "Name1", "Surname1", false, false); var entity2 = new User(0, "email2", new byte[] { 0x2, 0x2 }, "Name2", "Surname2", true, true); repo.AddOrUpdate(entity1); var savedEntity2 = repo.AddOrUpdate(entity2); var filters = ImmutableList.Create(new Filter <User>("Email", "email2")); // Act var listEntities = repo.ListEntities(filters); // Assert Assert.IsTrue(listEntities.IsValid); Assert.IsTrue(listEntities.Value.Any()); Assert.IsTrue(savedEntity2.Value.Equals(listEntities.Value.First())); }
public void AddOrUpdateEntityIsRequired() { // Arrange var conn = GetConnectionString(); var repo = new SqliteUserRepository(conn); // Act var result = repo.AddOrUpdate(null); // Assert Assert.IsFalse(result.IsValid); Assert.IsTrue(result.Exception is ArgumentNullException); }
public void AddOrUpdateIsSafe() { // Arrange var conn = GetConnectionString(); var entity = new User(0, "email", new byte[] { 0x1, 0x2 }, "Name", "Surname"); var repo = new SqliteUserRepository(conn); // Act _conn.Dispose(); var newEntity = repo.AddOrUpdate(entity); // Assert Assert.IsFalse(newEntity.IsValid); }
public void CanGetEntityById() { // Arrange var conn = GetConnectionString(); var repo = new SqliteUserRepository(conn); var entity = new User(0, "email", new byte[] { 0x1, 0x2 }, "Name"); var savedEntity = repo.AddOrUpdate(entity); // Act var result = repo.GetById(savedEntity.Value.Id); // Assert Assert.IsTrue(result.IsValid); Assert.IsTrue(result.Value.Equals(savedEntity.Value)); }
public void CanCreateEntity() { // Arrange var conn = GetConnectionString(); var repo = new SqliteUserRepository(conn); var entity = new User(0, "email", new byte[] { 0x1, 0x2 }, "Name"); // Act var newEntity = repo.AddOrUpdate(entity); // Assert Assert.IsTrue(newEntity.IsValid); Assert.IsTrue(newEntity.Value.Id == 1); }
public void CanListEntities() { // Arrange var conn = GetConnectionString(); var repo = new SqliteUserRepository(conn); var entity = new User(0, "email", new byte[] { 0x1, 0x2 }, "Name"); var savedEntity = repo.AddOrUpdate(entity); // Act var listEntities = repo.ListEntities(); // Assert Assert.IsTrue(listEntities.IsValid); Assert.IsTrue(listEntities.Value.Any()); Assert.IsTrue(savedEntity.Value.Equals(listEntities.Value.First())); }