public void Get_byIdUserExists_shouldReturnUser() { // Arrange var repository = new DapperUserRepository(Connection, UsersTableName); var userId = Guid.NewGuid(); var appId = Guid.NewGuid(); var serviceId = Guid.NewGuid(); var createdAt = DateTime.Now; var userModel = new UserModel { UserId = userId, AppId = appId, ServiceId = serviceId, CreatedAt = createdAt, Enabled = true }; // Act var id = repository.Insert(userModel); // Act var actual = repository.Get(id); // Assert Assert.AreEqual(userId, actual.UserId); Assert.AreEqual(appId, actual.AppId); Assert.AreEqual(serviceId, actual.ServiceId); Assert.AreEqual(createdAt.Date, actual.CreatedAt.Date); Assert.IsTrue(actual.Enabled); Assert.IsTrue(actual.Id > 0); }
public void Update_userDoesNotExist_shouldThrowException() { var repository = new DapperUserRepository(Connection, UsersTableName); var user = CreateUser(); var id = repository.Insert(user); repository.Update(id + 1, user); }
public void Update_invalidData_shouldThrowException() { var repository = new DapperUserRepository(Connection, UsersTableName); var user = CreateUser(); var id = repository.Insert(user); repository.Update(id, null); }
public void Update_userExistsValidData_shouldUpdateUser() { var repository = new DapperUserRepository(Connection, UsersTableName); var user = CreateUser(); user.Enabled = true; var id = repository.Insert(user); user = CreateUser(); user.Enabled = false; repository.Update(id, user); var actual = repository.Get(id); user.Id = id; Assert.AreEqual(user, actual); }
public void Insert_invalidUser_shouldThrowException() { // Arrange var repository = new DapperUserRepository(Connection, UsersTableName); // Act repository.Insert(null); // Assert // see expected exception }
public void Insert_validUser_shouldInsertUser() { // Arrange var repository = new DapperUserRepository(Connection, UsersTableName); var userModel = CreateUser(); // Act var id = repository.Insert(userModel); // Assert Assert.IsTrue(id > 0); var users = QueryFromFile<UserModel>(SelectUserScriptFilename, new Dictionary<string, string> { {"UserId", userModel.UserId.ToString()} }).ToList(); Assert.AreNotEqual(0, users.Count()); var actual = users.First(); Assert.AreEqual(userModel.UserId, actual.UserId); Assert.AreEqual(userModel.AppId, actual.AppId); Assert.AreEqual(userModel.ServiceId, actual.ServiceId); Assert.AreEqual(userModel.CreatedAt.Date, actual.CreatedAt.Date); Assert.IsTrue(actual.Enabled); Assert.IsTrue(actual.Id > 0); }