public void AndGroup_SqlFilter_Success()
{
var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5);
Assert.Equal("pe.Id = 5 AND (pe.Id = 5)", filter.AndGroup(filter).RawSql);
}
public void AndGroup_EmptyFilterWithSqlFilter_Success()
{
var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5);
Assert.Equal("(pe.Id = 5)", SqlFilter <Person> .Empty.AndGroup(filter).RawSql);
}
public void Or_EmptyFilterWithSqlFilterBase_Success()
{
var filter = SqlFilter <Passport> .From(m => m.Id).EqualTo(6);
Assert.Equal("pa.Id = 6", SqlFilter <Person> .Empty.Or(filter).RawSql);
}
public void From_GenericSqlField_Success()
{
var filter = SqlFilter <Person> .From(SqlField <Person> .From(m => m.Id)).EqualTo(5);
Assert.Equal("pe.Id = 5", filter.RawSql);
}
public void Or_SqlFilter_Success()
{
var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5);
Assert.Equal("pe.Id = 5 OR pe.Id = 5", filter.Or(filter).RawSql);
}
public void Or_EmptyFilterWithSqlFilter_Success()
{
var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5);
Assert.Equal("pe.Id = 5", SqlFilter <Person> .Empty.Or(filter).RawSql);
}
public void From_LambdaExpressionWithAlias_Success()
{
var filter = SqlFilter <Person> .From(m => m.Id, new SqlAlias <Person>("al")).EqualTo(5);
Assert.Equal("al.Id = 5", filter.RawSql);
}
public void From_LambdaExpression_Success()
{
var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5);
Assert.Equal("pe.Id = 5", filter.RawSql);
}
public void And_EmptyFilterWithSqlFilter_Success()
{
var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5);
Assert.Equal("pe.Id = 5", SqlFilter <Passport> .Empty.And(SqlFilter <Person> .Empty).And(filter).RawSql);
}
public void OrGroup_EmptyFilterWithSqlFilterBase_Success()
{
var filter = SqlFilter <Passport> .From(m => m.Id).EqualTo(6);
Assert.Equal("(pa.Id = 6)", SqlFilter <Passport> .Empty.And(SqlFilter <Person> .Empty).OrGroup(filter).RawSql);
}
public void OrGroup_SqlFilter_Success()
{
var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5);
Assert.Equal("pe.Id = 5 OR (pe.Id = 5)", SqlFilter <Passport> .Empty.And(filter).OrGroup(filter).RawSql);
}