public void QueryNoParameterTest()
{
QueryBuilder builder = new QueryBuilder(@"yahoo.finance.sectors");
string query = builder.GetQuery((QueryParameter) null, false);
var expected = @"select * from yahoo.finance.sectors";
Assert.AreEqual(expected, query);
string queryEscaped = builder.GetQuery((QueryParameter) null, true);
expected = Uri.EscapeDataString(expected);
Assert.AreEqual(expected, queryEscaped);
}
public void QueryOneParameterTest()
{
var parameter = new QueryParameter("symbol", "yhoo");
QueryBuilder builder = new QueryBuilder(@"yahoo.finance.quotes");
string query = builder.GetQuery(parameter, false);
var expected = @"select * from yahoo.finance.quotes where symbol='yhoo'";
Assert.AreEqual(expected, query);
string queryEscaped = builder.GetQuery(parameter, true);
expected = Uri.EscapeDataString(expected);
Assert.AreEqual(expected, queryEscaped);
}
public void QueryTwoParameterTest()
{
var parameter1 = new QueryParameter("symbol", "yhoo");
var parameter2 = new QueryParameter("expiration", "2010-06");
QueryBuilder builder = new QueryBuilder(@"yahoo.finance.quotes");
string query = builder.GetQuery(new[] { parameter1, parameter2 }, false);
var expected = @"select * from yahoo.finance.quotes where symbol='yhoo' and expiration='2010-06'";
Assert.AreEqual(expected, query);
string queryEscaped = builder.GetQuery(new[] { parameter1, parameter2 }, true);
expected = Uri.EscapeDataString(expected);
Assert.AreEqual(expected, queryEscaped);
}
public void UrlTest()
{
var parameter = new QueryParameter("symbol", "yhoo");
string url = new QueryBuilder(@"yahoo.finance.quotes").GetUrl(parameter);
Assert.AreEqual(@"http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%3D'yhoo' &format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=", url);
}
