public void Expression_Method_Invalid_Call()
{
Person person = new Person();
Exception ex = Assert.Throws <InvalidOperationException>(() => SqlExp.NotIn(person.Id, new int[] { 1, 2, 3 }));
Assert.Equal("Only for expressions.", ex.Message);
}
public void Expression_Method_Null()
{
Person person = null;
IOperator op = sql.Op(() => SqlExp.NotIn(person.Name, null));
QueryResult result = engine.Compile(op);
Assert.Equal("\"person\".\"Name\" NOT IN NULL", result.Sql);
Assert.Equal(new Dictionary <string, object>(), result.Parameters);
}
public void Expression_Method_Column()
{
Person person = null;
Department dept = null;
IOperator op = sql.Op(() => SqlExp.NotIn(person.Department.Id, dept.Id));
QueryResult result = engine.Compile(op);
Assert.Equal("\"person\".\"DepartmentId\" NOT IN \"dept\".\"Id\"", result.Sql);
Assert.Equal(new Dictionary <string, object>(), result.Parameters);
}
public void Expression_Method()
{
Person person = null;
IOperator op = sql.Op(() => SqlExp.NotIn(person.Id, new int[] { 1, 2, 3 }));
QueryResult result = engine.Compile(op);
Assert.Equal("\"person\".\"Id\" NOT IN (@p0, @p1, @p2)", result.Sql);
Assert.Equal(new Dictionary <string, object>()
{
["@p0"] = 1, ["@p1"] = 2, ["@p2"] = 3
}, result.Parameters);
}
public void Expression_Method_Nested_Deep(object value)
{
Person2 person = null;
IOperator op = sql.Op(() => SqlExp.NotIn(person.Address.City.Country.Name, value));
QueryResult result = engine.Compile(op);
Assert.Equal("\"person\".\"AddressCityCountryName\" NOT IN @p0", result.Sql);
Assert.Equal(new Dictionary <string, object>
{
["@p0"] = value
}, result.Parameters);
}
public void Expression_Method_ForeignKey(object value)
{
Person person = null;
IOperator op = sql.Op(() => SqlExp.NotIn(person.Department.Id, value));
QueryResult result = engine.Compile(op);
Assert.Equal("\"person\".\"DepartmentId\" NOT IN @p0", result.Sql);
Assert.Equal(new Dictionary <string, object>
{
["@p0"] = value
}, result.Parameters);
}
public void Expression_Method_Inline_Value()
{
Person person = null;
IOperator op = sql.Op(() => SqlExp.NotIn(person.Id, 1));
QueryResult result = engine.Compile(op);
Assert.Equal("\"person\".\"Id\" NOT IN @p0", result.Sql);
Assert.Equal(new Dictionary <string, object>
{
["@p0"] = 1
}, result.Parameters);
}
public void Expression_Method_List <T>(List <T> value)
{
Department dept = null;
IOperator op = sql.Op(() => SqlExp.NotIn(dept.Name, value));
QueryResult result = engine.Compile(op);
Assert.Equal("\"dept\".\"Name\" NOT IN (@p0, @p1, @p2)", result.Sql);
Assert.Equal(new Dictionary <string, object>
{
["@p0"] = value[0],
["@p1"] = value[1],
["@p2"] = value[2]
}, result.Parameters);
}
public void Expression_Method_Array <T>(T[] value)
{
Person person = null;
IOperator op = sql.Op(() => SqlExp.NotIn(person.Id, value));
QueryResult result = engine.Compile(op);
Assert.Equal("\"person\".\"Id\" NOT IN (@p0, @p1, @p2)", result.Sql);
Assert.Equal(new Dictionary <string, object>
{
["@p0"] = value[0],
["@p1"] = value[1],
["@p2"] = value[2]
}, result.Parameters);
}