public void Test_mysql_select_string_builder_join_clause()
{
// Arrange
var ssb = new MySqlSelectStringBuilder();
ssb.Select("Column1", "Column2").From("Table1")
.Join("Table2").On("Column2").EqualsTo("Table1", "Column1")
.LeftJoin("Table3").On("Column3").EqualsTo("Table2", "Column2");
// Act
var result = ssb.Build();
// Assert
var expectedResult =
@"SELECT `Column1`, `Column2` FROM `Table1`
INNER JOIN `Table2` ON `Table2`.`Column2` = `Table1`.`Column1`
LEFT JOIN `Table3` ON `Table3`.`Column3` = `Table2`.`Column2`";
Assert.Equal(expectedResult, result);
}
public void Test_mysql_select_string_builder()
{
// Arrange
var ssb = new MySqlSelectStringBuilder();
ssb.From("Table").Select("Column").Distinct()
.Where("Column1").EqualsTo(1)
.Where("Column2").Like("value")
.GroupBy("Column3", "Column4");
// Act
var result = ssb.Build();
// Assert
var expectedResult =
@"SELECT DISTINCT `Column` FROM `Table`
WHERE (`Column1` = 1) AND (`Column2` LIKE 'value')
GROUP BY `Column3`, `Column4`";
Assert.Equal(expectedResult, result);
}
