public void testSQLQueryFormatter100()
{
Query q = new Query(StudentDTD.STUDENTPERSONAL);
q.AddCondition("Name/FirstName", ComparisonOperators.LE, "Sally");
// Convert the query to XML and back
Query reparsed = QueryTests.SaveToXMLAndReparse(q, SifVersion.LATEST);
IDictionary fields = new Hashtable();
fields["Name/FirstName"] =
new SQLField("Users.FName", DbType.String);
SQLQueryFormatter formatter = new SQLQueryFormatter();
String sql = formatter.Format(reparsed, fields);
Assert.AreEqual("( Users.FName <= 'Sally' )", sql, "Query format");
}
public void testSQLQueryFormatter050()
{
Query q = new Query(StudentDTD.STUDENTPERSONAL);
q.AddCondition("Demographics/RaceList/Race/Code", ComparisonOperators.EQ, "1002");
// Convert the query to XML and back
Query reparsed = QueryTests.SaveToXMLAndReparse(q, SifVersion.LATEST);
IDictionary fields = new Hashtable();
fields["Demographics/RaceList/Race/Code"] =
new SQLField("Users.vchFirstName{0998=I;0999=A;1000=B;1001=H;1002=W}",
DbType.String);
SQLQueryFormatter formatter = new SQLQueryFormatter();
String sql = formatter.Format(reparsed, fields);
Assert.AreEqual("( Users.vchFirstName = 'W' )", sql, "Query format");
}
