public void Test_Statement()
{
var query = new QueryRequest().
BaseUri(new Uri("http://192.168.30.101:8093/query")).
Statement("SELECT * FROM default");
var uri = query.GetRequestUri();
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM default"));
Console.WriteLine(uri);
}
public void Test_Positional_Parameters()
{
var query = new QueryRequest().
BaseUri(new Uri("http://192.168.30.101:8093/query")).
Statement("SELECT * FROM default WHERE type=$1").
AddPositionalParameter("dog");
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM default WHERE type=$1&args=[\"dog\"]"));
}
public void Test_Statement_ClientContextId()
{
var query = new QueryRequest().
BaseUri(new Uri("http://192.168.30.101:8093/query")).
Statement("SELECT * FROM default").
ClientContextId("somecontextlessthanorequalto64chars");
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM default&client_context_id=somecontextlessthanorequalto64chars"));
}
public void When_isAdmin_Is_False_Credentials_Contains_local()
{
var query = new QueryRequest().
BaseUri(new Uri("http://192.168.30.101:8093/query")).
Statement("SELECT * FROM authenticated").
AddCredentials("authenticated", "secret", false);
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM authenticated&creds=[{\"user\":\"local:authenticated\"%2C\"pass\":\"secret\"}]"));
}
public void When_isAdmin_Is_True_Credentials_Contains_admin()
{
var query = new QueryRequest().
BaseUri(new Uri(string.Format("http://{0}:8093/query", _server))).
Statement("SELECT * FROM authenticated").
AddCredentials("authenticated", "secret", true);
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM authenticated&creds=[{\"user\":\"admin:authenticated\"%2C\"pass\":\"secret\"}]"));
}
public void Test_Named_Parameters_Two_Arguments()
{
var query = new QueryRequest().
BaseUri(new Uri("http://192.168.30.101:8093/query")).
Statement("SELECT * FROM default WHERE type=$canine OR type=$feline").
AddNamedParameter("canine", "dog").
AddNamedParameter("feline", "cat");
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM default WHERE type=$canine OR type=$feline&$canine=\"dog\"&$feline=\"cat\""));
}
public void When_Prepared_True_And_No_Cached_Prepared_Statement_Exists_Return_Append_Prepare()
{
var query = new QueryRequest()
.BaseUri(new Uri("http://192.168.30.101:8093/query"))
.Statement("SELECT * FROM `beer-sample`")
.Prepared(true);
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=PREPARE SELECT * FROM `beer-sample`"));
}
public void When_Timeout_Set_Query_Contains_Milliseconds_With_Unit()
{
var query = new QueryRequest()
.BaseUri(new Uri("http://192.168.30.101:8093/query"))
.Statement("SELECT * FROM `beer-sample`")
.Timeout(new TimeSpan(0, 0, 0, 0, 5));
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM `beer-sample`&timeout=5ms"));
}
public void Test_Positional_Parameters_Two_Arguments()
{
var query = new QueryRequest().
BaseUri(new Uri(string.Format("http://{0}:8093/query", _server))).
Statement("SELECT * FROM default WHERE type=$1 OR type=$2").
AddPositionalParameter("dog").
AddPositionalParameter("cat");
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM default WHERE type=$1 OR type=$2&args=[\"dog\"%2C\"cat\"]"));
}
public void Test_Statement_ClientContextId_Pretty()
{
var query = new QueryRequest().
BaseUri(new Uri(string.Format("http://{0}:8093/query", _server))).
Statement("SELECT * FROM default").
ClientContextId("somecontextlessthanorequalto64chars").
Pretty(true);
var uri = query.GetRequestUri();
Console.WriteLine(uri);
Assert.IsTrue(uri.ToString().Contains(":8093/query?statement=SELECT * FROM default&pretty=true&client_context_id=somecontextlessthanorequalto64chars"));
}
public void When_Prepared_True_And_No_Cached_Prepared_Statement_Exists_IPreparable_HasPrepared_Is_False()
{
var query = new QueryRequest()
.BaseUri(new Uri("http://192.168.30.101:8093/query"))
.Statement("SELECT * FROM `beer-sample`")
.Prepared(true);
//need to run this once
var uri = query.GetRequestUri();
var preparable = query as IPreparable;
Assert.IsNotNull(preparable);
Assert.IsFalse(preparable.HasPrepared);
}
public void When_Prepared_True_And_Cached_Prepared_Statement_Exists_IPreparable_HasPrepared_Is_True()
{
var query = new QueryRequest()
.BaseUri(new Uri("http://192.168.30.101:8093/query"))
.Statement("SELECT * FROM `beer-sample`")
.Prepared(true);
//need to run this once
var uri = query.GetRequestUri();
var response = JsonConvert.DeserializeObject <dynamic>(File.ReadAllText(@"Data\\N1QL\\prepared-statement.json"));
var preparedStatement = response.results[0].ToString().Replace("\r\n", "");
var preparable = query as IPreparable;
Assert.IsNotNull(preparable);
preparable.CachePreparedStatement(preparedStatement);
Assert.IsTrue(preparable.HasPrepared);
}
