public void GenerateUpdateQuery_AllColumnsHasNoSetter_Throws()
{
// Arrange
var generator = new MySqlQueryGenerator <AllColumnsHasMissingSetterEntity>("Users");
// Act && Assert
Assert.Throws <InvalidOperationException>(() => generator.GenerateUpdateQuery());
}
public void GenerateUpdateQuery_NoPrimaryKey_Throws()
{
// Arrange
var generator = new MySqlQueryGenerator <HeapEntity>("Users");
// Act && Assert
Assert.Throws <InvalidOperationException>(() => generator.GenerateUpdateQuery());
}
public void GenerateUpdateQuery_ColumnHasNoSetter_ColumnIsExcluded()
{
// Arrange
var generator = new MySqlQueryGenerator <ColumnHasMissingSetterEntity>("Users");
// Act
var query = generator.GenerateUpdateQuery();
// Assert
Assert.Equal(@"UPDATE Users SET Age = @Age WHERE Users.Id = @Id;
SELECT Users.Id, Users.Age, Users.DateCreated FROM Users WHERE Users.Id = @Id;", query);
}
public void GenerateUpdateQuery_CustomColumnNames_Valid()
{
// Arrange
var generator = new MySqlQueryGenerator <CustomColumnNamesEntity>("Orders");
// Act
var updateQuery = generator.GenerateUpdateQuery();
// Assert
Assert.Equal($@"UPDATE Orders SET DateCreated = @Date WHERE Orders.OrderId = @Id;
SELECT Orders.OrderId AS Id, Orders.DateCreated AS Date FROM Orders WHERE Orders.OrderId = @Id;", updateQuery);
}
public void GenerateUpdateQuery_CompositePrimaryKey_Valid()
{
// Arrange
var generator = new MySqlQueryGenerator <CompositePrimaryKeyEntity>("Users");
// Act
var updateQuery = generator.GenerateUpdateQuery();
// Assert
Assert.Equal($@"UPDATE Users SET DateCreated = @DateCreated WHERE Users.Username = @Username AND Users.Password = @Password;
SELECT Users.Username, Users.Password, Users.DateCreated FROM Users WHERE Users.Username = @Username AND Users.Password = @Password;", updateQuery);
}
public void GenerateUpdateQuery_SinglePrimaryKey_Valid()
{
// Arrange
var generator = new MySqlQueryGenerator <SinglePrimaryKeyEntity>("Users");
// Act
var updateQuery = generator.GenerateUpdateQuery();
// Assert
Assert.Equal($@"UPDATE Users SET Username = @Username, Password = @Password WHERE Users.Id = @Id;
SELECT Users.Id, Users.Username, Users.Password FROM Users WHERE Users.Id = @Id;", updateQuery);
}