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