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