public void When_Create_Is_Called_With_Valid_Data_SavesData(string name, string address)
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Address = address, Name = name
};
var id = userDbOperation.Create(user);
user.Id = id;
Assert.That(id > 0);
using (var conn = new SqlConnection(UserDbOperations.ConnectionString))
{
var createdUser = conn.Query <User>($"SELECT * FROM Users WHERE Id={id}").FirstOrDefault();
Assert.IsNotNull(createdUser);
Assert.AreEqual(user.Name, createdUser.Name);
Assert.AreEqual(user.Address, createdUser.Address);
Assert.That(createdUser.Id > 0);
conn.Execute($"DELETE FROM Users WHERE Id={id}");
}
}
public void When_Create_Is_Called_With_Address_As_Null_It_Throws_SqlException()
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = "SomeName", Address = null
};
Assert.Throws <SqlException>(() => userDbOperation.Create(user));
}
public void When_Create_Is_Called_With_Invalid_Data_Throws_SqlException(string name, string address)
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = name, Address = address
};
Assert.Throws <SqlException>(() => userDbOperation.Create(user));
}
public void When_Create_Is_Called_With_Parameters_Having_Exceeded_Length_Should_Throw_SqlException(string name,
string address)
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = name, Address = address
};
Assert.Throws <SqlException>(() => userDbOperation.Create(user));
}
public void When_GetById_Is_Called_It_Should_Return_A_User_With_The_Id_And_Pass()
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = "Joe", Address = "Pune"
};
var id = userDbOperation.Create(user);
user.Id = id;
var person = userDbOperation.GetById(user);
Assert.Pass();
}
public void When_Delete_Is_Called_For_Valid_Data_In_Database_It_Should_Delete()
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = "Shreya", Address = "Pune"
};
var id = userDbOperation.Create(user);
user.Id = id;
userDbOperation.Delete(user);
Assert.Pass();
}
public void When_Update_Is_Called_After_Inserting_InValid_Data_It_Should_Throw_Exception(string newName,
string newAddress, string updatedName, string updatedAddress)
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = newName, Address = newAddress
};
var id = userDbOperation.Create(user);
user.Name = updatedName;
user.Address = updatedAddress;
user.Id = id;
Assert.Throws <SqlException>(() => userDbOperation.Update(user));
}
public void When_Create_Is_Called_With_Valid_Data()
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Address = "Mumbai", Name = "Harish"
};
userDbOperation.Create(user);
using (var conn = new SqlConnection(UserDbOperations.ConnectionString))
{
var createdUser = conn.Query <User>("SELECT * FROM USers WHERE Name='Harish'").FirstOrDefault();
Assert.IsNotNull(createdUser);
Assert.AreEqual(user.Name, createdUser.Name);
Assert.AreEqual(user.Address, createdUser.Address);
Assert.That(createdUser.Id > 0);
}
}
public void When_Update_Is_Called_After_Setting_Data_Having_Exceeded_Length_It_Should_Throw_A_SqlException(string newName,
string newAddress, string updatedName, string updatedAddress)
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = newName, Address = newAddress
};
var id = userDbOperation.Create(user);
user.Name = updatedName;
user.Address = updatedAddress;
user.Id = id;
Assert.Throws <SqlException>(() => userDbOperation.Update(user));
using (var conn = new SqlConnection(UserDbOperations.ConnectionString))
{
conn.Execute($"DELETE FROM Users WHERE Id={id}");
}
}
public void When_Update_Is_Called_After_Inserting_Valid_Data_It_Should_Update()
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = "Rakesh", Address = "Bangalore"
};
var id = userDbOperation.Create(user);
user.Name = "Vijaya";
user.Address = "Mumbai";
user.Id = id;
userDbOperation.Update(user);
using (var conn = new SqlConnection(UserDbOperations.ConnectionString))
{
var createdUser = conn.Query <User>($"SELECT * FROM Users WHERE Id={id}").FirstOrDefault();
Assert.AreEqual(createdUser.Name, user.Name);
Assert.AreEqual(createdUser.Address, user.Address);
}
}