public void Test_Statement()
{
var query = new QueryRequest().
BaseUri(new Uri(string.Format("http://{0}:8093/query", _server))).
Statement("SELECT * FROM default");
var json = query.GetFormValuesAsJson();
var expected = "{\"statement\":\"SELECT * FROM default\",\"timeout\":\"75000ms\"}";
Console.WriteLine(json);
Assert.AreEqual(expected, json);
}
public void Test_Positional_Parameters()
{
var query = new QueryRequest().
BaseUri(new Uri(string.Format("http://{0}:8093/query", _server))).
Statement("SELECT * FROM default WHERE type=$1").
AddPositionalParameter("dog");
var json = query.GetFormValuesAsJson();
var expected = "{\"statement\":\"SELECT * FROM default WHERE type=$1\",\"timeout\":\"75000ms\",\"args\":[\"dog\"]}";
Console.WriteLine(json);
Assert.AreEqual(expected, json);
}
public void Test_Statement_ClientContextId()
{
var query = new QueryRequest().
BaseUri(new Uri(string.Format("http://{0}:8093/query", _server))).
Statement("SELECT * FROM default").
ClientContextId("somecontextlessthanorequalto64chars");
var json = query.GetFormValuesAsJson();
var expected = "{\"statement\":\"SELECT * FROM default\",\"client_context_id\":\"somecontextlessthanorequalto64chars\"}";
Console.WriteLine(json);
Assert.AreEqual(expected, json);
}
public void Test_Named_Parameters_Two_Arguments()
{
var query = new QueryRequest().
BaseUri(new Uri(string.Format("http://{0}:8093/query", _server))).
Statement("SELECT * FROM default WHERE type=$canine OR type=$feline").
AddNamedParameter("canine", "dog").
AddNamedParameter("feline", "cat");
var json = query.GetFormValuesAsJson();
var expected = "{\"statement\":\"SELECT * FROM default WHERE type=$canine OR type=$feline\"," +
"\"timeout\":\"75000ms\",\"$canine\":\"dog\",\"$feline\":\"cat\"}";
Console.WriteLine(json);
Assert.AreEqual(expected, json);
}
public void When_Timeout_Set_Query_Contains_Milliseconds_With_Unit()
{
var query = new QueryRequest()
.BaseUri(new Uri(string.Format("http://{0}:8093/query", _server)))
.Statement("SELECT * FROM `beer-sample`")
.Timeout(new TimeSpan(0, 0, 0, 0, 5));
var json = query.GetFormValuesAsJson();
var expected = "{\"statement\":\"SELECT * FROM `beer-sample`\",\"timeout\":\"5ms\"}";
Console.WriteLine(json);
Assert.AreEqual(expected, json);
}
public void When_isAdmin_Is_False_Credentials_Contains_local()
{
var query = new QueryRequest().
BaseUri(new Uri(string.Format("http://{0}:8093/query", _server))).
Statement("SELECT * FROM authenticated").
AddCredentials("authenticated", "secret", false);
var json = query.GetFormValuesAsJson();
var expected = "{\"statement\":\"SELECT * FROM authenticated\",\"timeout\":\"75000ms\"," +
"\"creds\":[{\"user\":\"local:authenticated\",\"pass\":\"secret\"}]}";
Console.WriteLine(json);
Assert.AreEqual(expected, json);
}
