public void From_TypedSqlField_Success()
{
var sqlField = new TypedSqlField(typeof(Person), typeof(int))
{
Name = nameof(Person.Id),
Alias = new SqlAlias("pe")
};
var filter = SqlFilter <Person> .From(sqlField).EqualTo(5);
Assert.Equal("pe.Id = 5", filter.RawSql);
}
public void And_TypedSqlField_Success()
{
var sqlField = new TypedSqlField(typeof(Person), typeof(string))
{
Name = nameof(Person.Name),
Alias = new SqlAlias("pe")
};
var filter = SqlFilter <Person> .From(m => m.Id).EqualTo(5)
.And(sqlField).EqualTo("Sergey");
Assert.Equal("pe.Id = 5 AND pe.Name = 'Sergey'", filter.RawSql);
}
public void Or_EmptyFilterWithTypedSqlField_Success()
{
var sqlField = new TypedSqlField(typeof(Person), typeof(string))
{
Name = nameof(Person.Name),
Alias = new SqlAlias("pe")
};
var filter = SqlFilter <Person> .Empty
.Or(sqlField).EqualTo("Sergey");
Assert.Equal("pe.Name = 'Sergey'", filter.RawSql);
}
public void Or_TypedSqlField_Success()
{
var sqlField = new TypedSqlField(typeof(Person), typeof(string))
{
Name = nameof(Person.Name),
Alias = new SqlAlias("pe")
};
var filter = SqlFilter <Person> .Empty.And(SqlFilter <Passport> .From(m => m.Id).EqualTo(5))
.Or(sqlField).EqualTo("Sergey");
Assert.Equal("pa.Id = 5 OR pe.Name = 'Sergey'", filter.RawSql);
}
