public IEnumerable <FoodTruck> GetFoodTrucks(Coordinate coordinate)
{
var _sodaClient = new SodaClient(_appSettingsManager.AppSettings.Value.SanFranciscoFoodTruckApiUrl, _appSettingsManager.AppSettings.Value.AppToken);
var resource = _sodaClient.GetResource <Dictionary <string, object> >(_appSettingsManager.AppSettings.Value.ResourceId);
IQueryBuilder queryBuilder = _queryBuilders.Where(q => q.IsQueryType(QueryType.Within)).Single();
string query = queryBuilder.Build(coordinate.ConvertToFieldFilters());
var soql = _soqlQuery.Where(query).Limit(_appSettingsManager.AppSettings.Value.SoqlQueryLimit);
var results = resource.Query <FoodTruck>(soql);
return(results);
}
public void Query_Ctor_Takes_Precidence()
{
var query = "SELECT something WHERE this > that ORDER BY another";
var expected = String.Format("{0}={1}", SoqlQuery.QueryKey, query);
var soql = new SoqlQuery(query);
var select = soql.Select("column1", "column2").ToString();
var where = soql.Where("that > this").ToString();
var order = soql.Order("yetanother").ToString();
Assert.AreEqual(expected, select);
Assert.AreEqual(expected, where);
Assert.AreEqual(expected, order);
}
public void All_Query_Methods_Return_The_Original_Instance()
{
var original = new SoqlQuery();
var select = original.Select("something");
var where = original.Where("something");
var order = original.Order(SoqlOrderDirection.DESC, "something");
var group = original.Group("something");
var limit = original.Limit(10);
var offset = original.Offset(10);
var search = original.FullTextSearch("something");
Assert.AreSame(original, select);
Assert.AreSame(original, where);
Assert.AreSame(original, order);
Assert.AreSame(original, group);
Assert.AreSame(original, limit);
Assert.AreSame(original, offset);
Assert.AreSame(original, search);
}
public void All_Query_Methods_Return_The_Original_Instance()
{
var original = new SoqlQuery();
var select = original.Select("something");
var where = original.Where("something");
var order = original.Order(SoqlOrderDirection.DESC, "something");
var group = original.Group("something");
var limit = original.Limit(10);
var offset = original.Offset(10);
var search = original.FullTextSearch("something");
Assert.AreSame(original, select);
Assert.AreSame(original, where);
Assert.AreSame(original, order);
Assert.AreSame(original, group);
Assert.AreSame(original, limit);
Assert.AreSame(original, offset);
Assert.AreSame(original, search);
}
