public void TestParameterSqlInfo()
{
IParameterSqlInfo paramSql1 =
new MockParameterSqlInfo("testfieldname", "paramName", Habanero.Base.ParameterType.String, "tbl");
IExpression exp = Expression.CreateExpression("paramName = 'test'");
exp.SetParameterSqlInfo(paramSql1);
SqlStatement st = CreateSqlStatement();
exp.SqlExpressionString(st, "", "");
Assert.AreEqual("tbl.testfieldname = " + GetParamName(0) + "", st.Statement.ToString());
Assert.AreEqual("test", st.Parameters[0].Value);
}
public void TestParameterSqlInfoWithMoreThanOne()
{
IParameterSqlInfo paramSql1 =
new MockParameterSqlInfo("testfieldname", "paramName", ParameterType.String, "tbl");
IParameterSqlInfo paramSql2 =
new MockParameterSqlInfo("testfieldname2", "paramName2", ParameterType.Date, "tbl2");
IExpression exp = Expression.CreateExpression("paramName = 'test' and paramName2 = '10 Feb 2003'");
exp.SetParameterSqlInfo(paramSql2);
exp.SetParameterSqlInfo(paramSql1);
SqlStatement st = CreateSqlStatement();
exp.SqlExpressionString(st, "", "");
Assert.AreEqual("(tbl.testfieldname = " + GetParamName(0) + " AND tbl2.testfieldname2 = " + GetParamName(1) + ")", st.Statement.ToString());
Assert.AreEqual("test", st.Parameters[0].Value);
Assert.AreEqual(new DateTime(2003, 02, 10), st.Parameters[1].Value);
}
public void TestParameterSqlInfoWithMoreThanOne()
{
IParameterSqlInfo paramSql1 =
new MockParameterSqlInfo("testfieldname", "paramName", ParameterType.String, "tbl");
IParameterSqlInfo paramSql2 =
new MockParameterSqlInfo("testfieldname2", "paramName2", ParameterType.Date, "tbl2");
IExpression exp = Expression.CreateExpression("paramName = 'test' and paramName2 = '10 Feb 2003'");
exp.SetParameterSqlInfo(paramSql2);
exp.SetParameterSqlInfo(paramSql1);
SqlStatement st = new SqlStatement(DatabaseConnection.CurrentConnection);
exp.SqlExpressionString(st, "", "");
Assert.AreEqual("(tbl.testfieldname = ?Param0 AND tbl2.testfieldname2 = ?Param1)", st.Statement.ToString());
Assert.AreEqual("test", st.Parameters[0].Value);
Assert.AreEqual(new DateTime(2003, 02, 10), st.Parameters[1].Value);
}
public void TestParameterSqlInfo()
{
IParameterSqlInfo paramSql1 =
new MockParameterSqlInfo("testfieldname", "paramName", Habanero.Base.ParameterType.String, "tbl");
IExpression exp = Expression.CreateExpression("paramName = 'test'");
exp.SetParameterSqlInfo(paramSql1);
SqlStatement st = new SqlStatement(DatabaseConnection.CurrentConnection);
exp.SqlExpressionString(st, "", "");
Assert.AreEqual("tbl.testfieldname = ?Param0", st.Statement.ToString());
Assert.AreEqual("test", st.Parameters[0].Value);
}