public void ShouldBuildQueryWithLike()
{
var givenString = "Title,samsung,samsung,true";
var desiredString = "select * from Product where ( Title like '%samsung%' ) ";
var myQueryBuilder = new MyQueryBuilder();
var result = myQueryBuilder.BuildQuery(givenString).Result;
Assert.AreEqual(result, desiredString);
}
public void ShouldBuildSimpleQuery()
{
var givenString = "CityId,2";
var desiredString = "select * from Product where ( CityId ='2' ) ";
var myQueryBuilder = new MyQueryBuilder();
var result = myQueryBuilder.BuildQuery(givenString).Result;
Assert.AreEqual(result, desiredString);
}
public void ShouldBuildComplexQuery()
{
var givenString = "Username,spiri0c7fa;CityId,2;Price,1400,2000;TradesAccepted,1;CategoryId,4";
var desiredString =
"select * from Product where ( Username ='******' ) and ( CityId ='2' ) and ( Price >='1400' and Price <='2000' ) and ( TradesAccepted ='1' ) and ( CategoryId ='4' ) ";
var myQueryBuilder = new MyQueryBuilder();
var result = myQueryBuilder.BuildQuery(givenString).Result;
Assert.AreEqual(result, desiredString);
}
public void OnPageEntering()
{
myRichTextBox1.RichTextBox.Text = MyQueryBuilder.GetQuery();
}
