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);
}
