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