public virtual void Evaluate_Returns_Query_Results() { // arrange var query = new AdHocQuery { ConnectionString = "Data Source=lonbscadsqlbl01;Initial Catalog=CADIS_E2E01;Integrated Security=True", Sql = "select top 10 sec_id, sec_name from t_master_aam_sec" }; // act //AvDataContext = // assert }
public HttpResponseMessage Search([FromBody] JToken jsonbody) { AdHocQuery adhoc = new AdHocQuery() { Fields = jsonbody["fields"].ToObject <string[]>().ToList <string>(), Query = jsonbody["query"].ToString() }; string myJson = BsonToJson.RinseBsonOutput (new Data.Base().Find(adhoc, CollectionName)); var response = this.Request.CreateResponse(HttpStatusCode.OK); response.Content = new StringContent(myJson, Encoding.UTF8, "application/json"); return(response); }
public bool LoadAdHocQueryInfo(string filename) { ci.adHocFilename = filename; AdHocQueryInfo = new List <AdHocQuery>(); string jsonText = LoadJson(filename); adHocQueryAll aqa = JsonConvert.DeserializeObject <adHocQueryAll>(jsonText); foreach (DBSP2ClassGen.adHocQuery aq in aqa.AdHocQueries) { AdHocQuery ahq = new AdHocQuery(); ahq.QueryId = aq.QueryId; ahq.QueryString = aq.QueryString; ahq.ParamInfo = new Dictionary <string, string>(); foreach (DBSP2ClassGen.ParamInfo pi in aq.ParamInfos) { ahq.ParamInfo.Add(pi.name, pi.type); } AdHocQueryInfo.Add(ahq); } return(true); }
public string Find(AdHocQuery adhoc, string collectionName) { return(AdHoc(adhoc.Query, adhoc.Fields, 0, 0, collectionName)); //throw new NotImplementedException(); }
public bool LoadAdHocQueryInfo(string filename) { ci.adHocFilename = filename; AdHocQueryInfo = new List<AdHocQuery>(); string jsonText = LoadJson(filename); adHocQueryAll aqa = JsonConvert.DeserializeObject<adHocQueryAll>(jsonText); foreach (DBSP2ClassGen.adHocQuery aq in aqa.AdHocQueries) { AdHocQuery ahq = new AdHocQuery(); ahq.QueryId = aq.QueryId; ahq.QueryString = aq.QueryString; ahq.ParamInfo = new Dictionary<string, string>(); foreach( DBSP2ClassGen.ParamInfo pi in aq.ParamInfos) { ahq.ParamInfo.Add(pi.name, pi.type); } AdHocQueryInfo.Add(ahq); } return true; }