public void GenerateDeleteQuery_CustomColumnNames_Valid()
{
// Arrange
var generator = new MySqlQueryGenerator <CustomColumnNamesEntity>("Orders");
// Act
var deleteQuery = generator.GenerateDeleteQuery();
// Assert
Assert.Equal($@"SELECT Orders.OrderId AS Id, Orders.DateCreated AS Date FROM Orders WHERE Orders.OrderId = @Id;
DELETE FROM Orders WHERE Orders.OrderId = @Id;", deleteQuery);
}
public void GenerateDeleteQuery_NoPrimaryKey_Valid()
{
// Arrange
var generator = new MySqlQueryGenerator <HeapEntity>("Users");
// Act
var deleteQuery = generator.GenerateDeleteQuery();
// Assert
Assert.Equal($@"SELECT Users.Username, Users.Password FROM Users WHERE Users.Username = @Username AND Users.Password = @Password;
DELETE FROM Users WHERE Users.Username = @Username AND Users.Password = @Password;", deleteQuery);
}
public void GenerateDeleteQuery_OnePrimaryKey_Valid()
{
// Arrange
var generator = new MySqlQueryGenerator <SinglePrimaryKeyEntity>("Users");
// Act
var deleteQuery = generator.GenerateDeleteQuery();
// Assert
Assert.Equal($@"SELECT Users.Id, Users.Username, Users.Password FROM Users WHERE Users.Id = @Id;
DELETE FROM Users WHERE Users.Id = @Id;", deleteQuery);
}
