public void FromFunctionTest() { ISqlFunction function = new SqlFunction("SUM"); function.AddArgument(new SqlStringExpression("1")); function.AddArgument(new SqlStringExpression("2")); ISqlObject obj = SqlObject.FromFunction(function); Assert.AreEqual <string>(function.SqlString, obj.Fullname); Assert.AreEqual <string>(function.SqlString, obj.SqlString); }
public void OracleFieldConstructorTest_Function() { ISqlFunction function = new SqlFunction("SUM"); function.AddArgument(new SqlStringExpression("1")); function.AddArgument(new SqlStringExpression("2")); ISqlObject field = new OracleField(function, "Total"); Assert.AreEqual <string>(string.Format("\"{0}\"", field.Name.ToUpper()), field.Fullname); Assert.AreEqual <string>(string.Format("{0} \"{1}\"", function.SqlString, field.Name.ToUpper()), field.SqlString); }
public void MySqlFieldConstructorTest_Function() { ISqlFunction function = new SqlFunction("SUM"); function.AddArgument(new SqlStringExpression("1")); function.AddArgument(new SqlStringExpression("2")); ISqlObject field = new MySqlField(function, "Total"); Assert.AreEqual <string>(string.Format("`{0}`", field.Name), field.Fullname); Assert.AreEqual <string>(string.Format("{0} AS `{1}`", function.SqlString, field.Name), field.SqlString); }
public void AddArgumentTest_One() { SqlFunction target = new SqlFunction("ADD"); ISqlExpression argument = new SqlStringExpression("13"); target.AddArgument(argument); Assert.AreEqual <string>(string.Format("{0}({1})", target.Name, argument.SqlString), target.SqlString); }
public void AddArgumentTest_Field_Distinct() { SqlFunction target = new SqlFunction("COUNT"); ISqlObject field = new SqlServerField(new SqlServerSource("Table"), "ID", null); target.AddArgument(field, true); Assert.AreEqual <string>(string.Format("{0}(DISTINCT {1})", target.Name, field.Fullname), target.SqlString); }
public void AddArgumentTest_More() { SqlFunction target = new SqlFunction("SUM"); ISqlExpression argument0 = new SqlStringExpression("13"); ISqlExpression argument1 = new SqlStringExpression("14"); target.AddArgument(argument0, argument1); Assert.AreEqual <string>(string.Format("{0}({1}, {2})", target.Name, argument0.SqlString, argument1.SqlString), target.SqlString); }
public void RemoveArgumentTest() { SqlFunction target = new SqlFunction("ADD"); ISqlExpression argument0 = new SqlStringExpression("13"); ISqlExpression argument1 = new SqlStringExpression("14"); ISqlExpression argument2 = new SqlStringExpression("15"); target.AddArgument(argument0, argument1, argument2); Assert.AreEqual <string>(string.Format("{0}({1}, {2}, {3})", target.Name, argument0.SqlString, argument1.SqlString, argument2.SqlString), target.SqlString); target.RemoveArgument(argument2); Assert.AreEqual <string>(string.Format("{0}({1}, {2})", target.Name, argument0.SqlString, argument1.SqlString), target.SqlString); }
public void AddArgumentTest_Parametric() { SqlFunction target = new SqlFunction("SUM"); ISqlExpression argument0 = SqlStringExpression.FromParameter(new SqlParameter("@p0", 13)); ISqlExpression argument1 = SqlStringExpression.FromParameter(new SqlParameter("@p1", 14)); target.AddArgument(argument0, argument1); Assert.AreEqual <string>(string.Format("{0}({1}, {2})", target.Name, argument0.SqlString, argument1.SqlString), target.SqlString); Assert.IsTrue(target.Parameters.Count == 2); Assert.IsTrue(target.Parameters.Contains(argument0.Parameters[0])); Assert.IsTrue(target.Parameters.Contains(argument1.Parameters[0])); }