public void Test_sqlite_select_string_builder_join_clause()
{
// Arrange
var ssb = new SqLiteSelectStringBuilder();
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 OUTER JOIN Table3 ON Table3.Column3 = Table2.Column2";
Assert.Equal(expectedResult, result);
}
public void Test_sqlite_select_string_builder()
{
// Arrange
var ssb = new SqLiteSelectStringBuilder();
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);
}