public void TransformSQLOrderByError()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search1 = new AdvancedSearch();
search1.ToSQL("Document/whereas/id/eq/10/Orderby/count", "1", wrapper);
Assert.AreEqual(1, wrapper.Count);
ModelStateDictionary wrapper2 = new ModelStateDictionary();
AdvancedSearch search2 = new AdvancedSearch();
search2.ToSQL("Document/whereas/id/eq/10/Orderby/id/aaa", "1", wrapper2);
Assert.AreEqual(1, wrapper2.Count);
ModelStateDictionary wrapper3 = new ModelStateDictionary();
AdvancedSearch search3 = new AdvancedSearch();
search3.ToSQL("Document/whereas/id/eq/10/Orderby/id", "1", wrapper3);
Assert.AreEqual(1, wrapper3.Count);
ModelStateDictionary wrapper4 = new ModelStateDictionary();
AdvancedSearch search4 = new AdvancedSearch();
search4.ToSQL("Document/whereas/id/eq/10/Orderby/OrderBy/id/asc", "1", wrapper4);
Assert.AreEqual(1, wrapper4.Count);
ModelStateDictionary wrapper5 = new ModelStateDictionary();
AdvancedSearch search5 = new AdvancedSearch();
search5.ToSQL("Document/OrderBy/id/asc/whereas/id/eq/10///", "1", wrapper5);
Assert.AreEqual(1, wrapper5.Count);
ModelStateDictionary wrapper6 = new ModelStateDictionary();
AdvancedSearch search6 = new AdvancedSearch();
search6.ToSQL("Document/OrderBy/id/asc/whereas/id/eq/10", "1", wrapper6);
Assert.AreEqual(1, wrapper6.Count);
}
public void TransformSQLSlashes()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search1 = new AdvancedSearch();
search1.ToSQL("///////", "1", wrapper);
Assert.AreEqual(1, wrapper.Count);
ModelStateDictionary wrapper2 = new ModelStateDictionary();
AdvancedSearch search2 = new AdvancedSearch();
search2.ToSQL("/", "1", wrapper2);
Assert.AreEqual(1, wrapper2.Count);
ModelStateDictionary wrapper3 = new ModelStateDictionary();
AdvancedSearch search3 = new AdvancedSearch();
search3.ToSQL("//", "1", wrapper3);
Assert.AreEqual(1, wrapper3.Count);
ModelStateDictionary wrapper4 = new ModelStateDictionary();
AdvancedSearch search4 = new AdvancedSearch();
search4.ToSQL("/Document/", "1", wrapper4);
Assert.AreEqual(1, wrapper4.Count);
ModelStateDictionary wrapper5 = new ModelStateDictionary();
AdvancedSearch search5 = new AdvancedSearch();
search5.ToSQL("/where/id/eq/10", "1", wrapper5);
Assert.AreEqual(1, wrapper5.Count);
ModelStateDictionary wrapper6 = new ModelStateDictionary();
AdvancedSearch search6 = new AdvancedSearch();
search6.ToSQL("/and/and/and/and", "1", wrapper6);
Assert.AreEqual(1, wrapper6.Count);
}
public void TransformSQLCountError()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search = new AdvancedSearch();
search.ToSQL("Document/whereas/id/eq/10/count/count", "1", wrapper);
Assert.AreEqual(1, wrapper.Count);
ModelStateDictionary wrapper2 = new ModelStateDictionary();
AdvancedSearch search2 = new AdvancedSearch();
search2.ToSQL("Document/whereas/id/eq/10/limit/5/count", "1", wrapper2);
Assert.AreEqual(1, wrapper2.Count);
ModelStateDictionary wrapper3 = new ModelStateDictionary();
AdvancedSearch search3 = new AdvancedSearch();
search3.ToSQL("Document/whereas/id/eq/10/Orderby/title/count", "1", wrapper3);
Assert.AreEqual(1, wrapper3.Count);
}
public void TransformSQLUnknownResource()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search = new AdvancedSearch();
search.ToSQL("unknownresource/where/id/eq/10", "1", wrapper);
Assert.AreEqual(1, wrapper.Count);
}
public void TransformSQLUnknownKeyWord()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search = new AdvancedSearch();
search.ToSQL("Document/whereas/id/eq/10", "1", wrapper);
Assert.AreEqual(1, wrapper.Count);
ModelStateDictionary wrapper2 = new ModelStateDictionary();
AdvancedSearch search2 = new AdvancedSearch();
search2.ToSQL("Document/where/id/eq/10/ora/id/eq/15", "1", wrapper2);
Assert.AreEqual(1, wrapper2.Count);
}
public void TransformSQLRandom()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search = new AdvancedSearch();
search.ToSQL("fpefpoeà)orfàfioefsdfvkpoejkfge", "1", wrapper);
Assert.AreEqual(1, wrapper.Count);
}
public void TransformSQLEmpty()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search1 = new AdvancedSearch();
search1.ToSQL("", "1", wrapper);
Assert.AreEqual(1, wrapper.Count);
ModelStateDictionary wrapper2 = new ModelStateDictionary();
AdvancedSearch search2 = new AdvancedSearch();
search2.ToSQL(null, "1", wrapper2);
Assert.AreEqual(1, wrapper2.Count);
}
public void TransformSQLLimitNegativeNumber()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search1 = new AdvancedSearch();
search1.ToSQL("Document/limit/-1/10", "1", wrapper);
Assert.AreEqual(1, wrapper.Count);
ModelStateDictionary wrapper2 = new ModelStateDictionary();
AdvancedSearch search2 = new AdvancedSearch();
search2.ToSQL("Document/limit/-1/-1", "1", wrapper2);
Assert.AreEqual(1, wrapper2.Count);
ModelStateDictionary wrapper3 = new ModelStateDictionary();
AdvancedSearch search3 = new AdvancedSearch();
search3.ToSQL("Document/limit/1/-1", "1", wrapper3);
Assert.AreEqual(1, wrapper3.Count);
ModelStateDictionary wrapper4 = new ModelStateDictionary();
AdvancedSearch search4 = new AdvancedSearch();
search4.ToSQL("Document/limit/1/0", "1", wrapper4);
Assert.AreEqual(1, wrapper4.Count);
ModelStateDictionary wrapper5 = new ModelStateDictionary();
AdvancedSearch search5 = new AdvancedSearch();
search5.ToSQL("Document/limit/0", "1", wrapper5);
Assert.AreEqual(1, wrapper5.Count);
ModelStateDictionary wrapper6 = new ModelStateDictionary();
AdvancedSearch search6 = new AdvancedSearch();
search6.ToSQL("Document/limit/0/-1", "1", wrapper6);
Assert.AreEqual(1, wrapper6.Count);
}
public void TransformSQLLimitWithOffset()
{
ModelStateDictionary wrapper = new ModelStateDictionary();
AdvancedSearch search = new AdvancedSearch();
search.ToSQL("Document/limit/5/10", "1", wrapper);
TestInfo(search.Infos, new SearchInfos()
{
count = false,
orderByClause = "id ascending",
resource = "Document",
skip = 5,
take = 10,
whereClause = new System.Text.StringBuilder("Home.ClientId == 1"),
whereParameters = new List<object>() { }
});
}
public void Init()
{
wrapper = new ModelStateDictionary();
search = new AdvancedSearch();
}
