private void Equals_2()
{
Expression <Func <Student, bool> > exp = it => SqlFunc.Equals(it.Name, it.Name);
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, " (\"NAME\" = \"NAME\") ", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", "a")
}, "Equals_2 error");
Expression <Func <Student, bool> > exp2 = it => SqlFunc.Equals("a", "a2");
OracleExpressionContext expContext2 = new OracleExpressionContext();
expContext2.Resolve(exp2, ResolveExpressType.WhereSingle);
var value2 = expContext2.Result.GetString();
var pars2 = expContext2.Parameters;
base.Check(value2, pars2, " (:MethodConst0 = :MethodConst1) ", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", "a"), new SugarParameter(":MethodConst1", "a2")
}, "Equals2 error");
}
private void single()
{
int p = 1;
Expression <Func <Student, object> > exp = it => new Student()
{
Name = "a", Id = it.Id, SchoolId = p, TestId = it.Id + 11
};
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.SelectSingle);
var selectorValue = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(
selectorValue,
pars,
@" :CONSTANT0 AS ""NAME"" , ""ID"" AS ""ID"" , :CONSTANT1 AS ""SCHOOLID"" , ( ""ID"" + :ID2 ) AS ""TESTID"" ",
new List <SugarParameter>()
{
new SugarParameter(":constant0", "a"),
new SugarParameter(":constant1", 1),
new SugarParameter(":Id2", 11)
},
"Select.single Error");
}
private void ContainsArray()
{
string[] array = new string[] { "1", "2" };
Expression <Func <Student, bool> > exp = it => SqlFunc.ContainsArray(array, it.Name);
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, null, " (\"NAME\" IN ('1','2')) ", null, "Contains2 error");
}
private void HasNumber()
{
Expression <Func <Student, bool> > exp = it => SqlFunc.HasNumber(it.Id);
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( \"ID\">0 AND \"ID\" IS NOT NULL )", new List <SugarParameter>()
{
}, "HasNumber error");
}
private void whereSingle11()
{
Expression <Func <Student, bool> > exp = it => !true;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( 1 = 2 )", new List <SugarParameter>()
{
}, "whereSingle11");
}
private void whereSingle14()
{
Expression <Func <Student, bool> > exp = it => true && it.Name != null;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "(( 1 = 1 ) AND( \"NAME\" IS NOT NULL ))", new List <SugarParameter>()
{
}, "whereSingle14");
}
private void whereSingle22()
{
Expression <Func <DataTestInfo2, bool> > exp = it => !it.Bool2.Value;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "NOT ( \"BOOL2\"=1 ) ", new List <SugarParameter>()
{
}, "whereSingle22");
}
private void whereSingle8(Student st)
{
Expression <Func <Student, bool> > exp = it => it.Name == null;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( \"Name\" IS NULL )", new List <SugarParameter>()
{
}, "whereSingle8");
}
private void MappingColumn()
{
Expression <Func <Student, bool> > exp = it => SqlFunc.MappingColumn(it.Id, "Name") == 1;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "(Name = :Const1 )", new List <SugarParameter>()
{
new SugarParameter(":Const1", 1)
}, "MappingColumn error");
}
private void StringIsNullOrEmpty()
{
Expression <Func <Student, bool> > exp = it => it.Id > 2 || SqlFunc.IsNullOrEmpty(it.Id);;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "(( \"ID\" > :Id0 ) OR ( \"ID\"='' OR \"ID\" IS NULL ))", new List <SugarParameter>()
{
new SugarParameter(":Id0", 2)
}, "StringIsNullOrEmpty error");
}
private void ToLower()
{
Expression <Func <Student, bool> > exp = it => "a" == SqlFunc.ToLower(it.Id);
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( :Const0 = (LOWER(\"ID\")) )", new List <SugarParameter>()
{
new SugarParameter(":Const0", "a")
}, "ToLower error");
}
private void Trim()
{
Expression <Func <Student, bool> > exp = it => SqlFunc.Trim(" a") == it.Name;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "(trim(:MethodConst0) = \"NAME\" )", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", " a")
}, "Trim error");
}
private void Contains2(string name = "a")
{
Expression <Func <Student, bool> > exp = it => SqlFunc.Contains(it.Name, name);
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, " (\"NAME\" like '%'||:MethodConst0||'%') ", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", "a")
}, "Contains2 error");
}
private void Between()
{
Expression <Func <Student, bool> > exp = it => SqlFunc.Between(it.Name, 1, 2);
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, " (\"NAME\" BETWEEN :MethodConst0 AND :MethodConst1) ", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", 1), new SugarParameter(":MethodConst1", 2),
}, "Between error");
}
private void ConvetToString()
{
Expression <Func <Student, bool> > exp = it => Convert.ToString(it.Id) == "a";
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "(CAST(\"ID\" AS VARCHAR2(4000)) = :Const0 )", new List <SugarParameter>()
{
new SugarParameter(":Const0", "a")
}, "ConvetToString error");
}
private void single4(int p = 1)
{
Expression <Func <Student, object> > exp = it => it.CreateTime.HasValue;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.IsSingle = false;
expContext.Resolve(exp, ResolveExpressType.WhereMultiple);
var selectorValue = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(
@"( ""IT"".""CREATETIME""<>'' AND ""IT"".""CREATETIME"" IS NOT NULL )", null, selectorValue, null,
"Select.single4 Error");
}
private void Length3()
{
Expression <Func <Student, bool> > exp = it => it.Name.Length > "a".Length;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "(LENGTH(\"NAME\") > :Length1 )", new List <SugarParameter>()
{
new SugarParameter(":Length1", 1)
}, "Length3 error");
}
private void whereSingle1()
{
Expression <Func <Student, bool> > exp = it => it.Id > 1;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( \"Id\" > :Id0 )", new List <SugarParameter>()
{
new SugarParameter(":Id0", 1)
}, "whereSingle1");
}
private void whereSingle17()
{
Expression <Func <DataTestInfo, bool> > exp = it => true && it.String.Contains("a");
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "(( 1 = 1 ) AND (\"STRING\" like '%'+:MethodConst1+'%') )", new List <SugarParameter>()
{
new SugarParameter(":MethodConst1", "a")
}, "whereSingle17");
}
private void whereSingle19()
{
Expression <Func <DataTestInfo2, bool> > exp = it => it.Bool2.Value == false;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( \"BOOL2\" = :Value0 )", new List <SugarParameter>()
{
new SugarParameter(":Value0", false)
}, "whereSingle19");
}
private void whereSingle9(Student st)
{
Expression <Func <Student, bool> > exp = it => it.Name == st.Name;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( \"NAME\" = :Name0 )", new List <SugarParameter>()
{
new SugarParameter(":Name0", null)
}, "whereSingle9");
}
private void whereSingle15()
{
Expression <Func <DataTestInfo, bool> > exp = it => it.Money2 == 1;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( \"MONEY2\" = :Const0 )", new List <SugarParameter>()
{
new SugarParameter(":Const0", 1)
}, "whereSingle15");
}
private void whereSingle12()
{
Expression <Func <DataTestInfo2, bool> > exp = it => it.Bool1 == true;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( \"Bool1\" = @Bool10 )", new List <SugarParameter>()
{
new SugarParameter("@Bool10", true)
}, "whereSingle12");
}
private void DateAddDay()
{
var x2 = DateTime.Now;
Expression <Func <Student, bool> > exp = it => SqlFunc.DateAdd(x2, 1) == x2;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "((:MethodConst0+(1*:MethodConst1)) = :Const2 )", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", x2), new SugarParameter(":MethodConst1", 1), new SugarParameter(":Const2", x2)
}, "DateAddDay error");
}
private void whereSingle23()
{
decimal?val = 1;
Expression <Func <DataTestInfo, bool> > exp = it => it.Decimal2 == val.Value;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "( \"DECIMAL2\" = :Const0 )", new List <SugarParameter>()
{
new SugarParameter(":Const0", val)
}, "whereSingle23");
}
private void DateIsSameByDay()
{
var x2 = DateTime.Now;
Expression <Func <Student, bool> > exp = it => SqlFunc.DateIsSame(x2, x2);
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, " (ROUND(TO_NUMBER(:MethodConst0 - :MethodConst1))=0) ", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", x2), new SugarParameter(":MethodConst1", x2)
}, "DateIsSameDay error");
}
private void StringIsNullOrEmpty2()
{
Expression <Func <Student, bool> > exp = it => 2 == it.Id || SqlFunc.IsNullOrEmpty(true);;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "(( :Id0 = \"ID\" ) OR ( :MethodConst1='' OR :MethodConst1 IS NULL ))", new List <SugarParameter>()
{
new SugarParameter(":MethodConst1", true),
new SugarParameter(":Id0", 2)
}, "StringIsNullOrEmpty2 error");
}
private void StringIsNullOrEmpty5()
{
WhereConst.name = "xx";
Expression <Func <Student, bool> > exp = it => !SqlFunc.IsNullOrEmpty(WhereConst.name);;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, "NOT( :MethodConst0='' OR :MethodConst0 IS NULL )", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", "xx")
}, "StringIsNullOrEmpty5 error");
}
private void DateValue()
{
var x2 = DateTime.Now;
Expression <Func <Student, bool> > exp = it => SqlFunc.DateValue(x2, DateType.Year) == 1;
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, " ((CAST(TO_CHAR(:MethodConst0,'yyyy') AS NUMBER) = :Const2 )", new List <SugarParameter>()
{
new SugarParameter(":MethodConst0", x2), new SugarParameter(":Const2", 1)
}, "DateValue error");
}
private void whereSingle3()
{
Expression <Func <Student, bool> > exp = it => it.Id > 1 || it.Name == "a";
OracleExpressionContext expContext = new OracleExpressionContext();
expContext.Resolve(exp, ResolveExpressType.WhereSingle);
var value = expContext.Result.GetString();
var pars = expContext.Parameters;
base.Check(value, pars, " (( \"Id\" > @Id0 ) OR ( \"Name\" = @Name1 ))", new List <SugarParameter>()
{
new SugarParameter("@Id0", 1),
new SugarParameter("@Name1", "a")
}, "whereSingle3");
}
