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