public void TestGetSqlStringWithNoParameters() { Parameter param = new Parameter("prop", "table", "field", "=", "value", ParameterType.String); Assert.AreEqual("", param.GetSqlStringWithNoParameters()); }
public void Test_GetParameterValueAsObject_WhenDateType_TomorrowString_ShouldReturnYesterday() { //---------------Set up test pack------------------- Parameter param = new Parameter("prop", "table", "field", "=", "tomorrow", ParameterType.Date); //---------------Assert Precondition---------------- //---------------Execute Test ---------------------- DateTime parameterValueAsObject = (DateTime)param.GetParameterValueAsObject(); //---------------Test Result ----------------------- Assert.IsNotNull(parameterValueAsObject); Assert.AreEqual(DateTimeToday.Value.AddDays(1), parameterValueAsObject); }
public void TestParameterConstructors() { Parameter param = new Parameter("prop", "field", "=", "value"); Assert.AreEqual("prop = 'value'", param.ExpressionString()); Assert.AreEqual("[field]", param.FieldFullName("[", "]")); param = new Parameter("prop", "table", "field", "=", "value", ParameterType.String); Assert.AreEqual("prop = 'value'", param.ExpressionString()); Assert.AreEqual("[table].[field]", param.FieldFullName("[", "]")); }
public void TestParameterTypes() { Parameter param = new Parameter("prop", "table", "field", "=", "value", ParameterType.String); Assert.AreEqual("value", param.GetParameterValueAsObject()); param = new Parameter("prop", "table", "field", "=", "true", ParameterType.Bool); Assert.AreEqual(true, param.GetParameterValueAsObject()); param = new Parameter("prop", "table", "field", "=", "2007/2/1", ParameterType.Date); Assert.AreEqual(new DateTime(2007, 2, 1), param.GetParameterValueAsObject()); param = new Parameter("prop", "table", "field", "=", "2.1", ParameterType.Number); Assert.AreEqual(2.1, param.GetParameterValueAsObject()); }
public void TestParameterParsing() { IExpression exp = new Parameter("Field1 = 'test'"); Assert.AreEqual("Field1 = 'test'", exp.ExpressionString()); }