public void Can_set_statement()
{
// set statement using constructor
var options = new AnalyticsOptions();
var formValues = options.GetFormValues(Statement);
Assert.Equal(Statement, formValues["statement"]);
var json = JsonConvert.DeserializeObject <dynamic>(
options.GetFormValuesAsJson(Statement)
);
Assert.Equal(Statement, json.statement.Value);
// set statement using method
const string statement = "SELECT 1 FROM `datset`;";
formValues = options.GetFormValues(statement);
Assert.Equal(statement, formValues["statement"]);
json = JsonConvert.DeserializeObject <dynamic>(
options.GetFormValuesAsJson(statement)
);
Assert.Equal(statement, json.statement.Value);
}
public void Test_GetFormValuesAsJson()
{
var options = new AnalyticsOptions()
{
BucketName = "default",
ScopeName = "scope1",
QueryContext = "queryctx",
}
.Parameter("par1")
.Parameter("par2")
.Parameter("namedpar1", "namedpar1val")
.Parameter("namedpar2", "namedpar2val")
.Raw("raw1", "val1")
.Raw("raw2", "val2")
.Readonly(true)
.ClientContextId("cctxid")
.Timeout(TimeSpan.FromSeconds(10))
.ScanConsistency(AnalyticsScanConsistency.RequestPlus)
.Priority(true);
var json = options.GetFormValuesAsJson("SELECT * FROM default");
var expected = "{\"statement\":\"SELECT * FROM default;\",\"timeout\":\"10000ms\",\"client_context_id\":\"cctxid\",\"query_context\":\"queryctx\",\"namedpar1\":\"namedpar1val\",\"namedpar2\":\"namedpar2val\",\"raw1\":\"val1\",\"raw2\":\"val2\",\"args\":[\"par1\",\"par2\"]}";
Assert.Contains(expected, json);
}
public void Can_set_timeout()
{
var options = new AnalyticsOptions().Timeout(TimeSpan.FromSeconds(15));
var formValues = options.GetFormValues(Statement);
Assert.Equal("15000ms", formValues["timeout"]);
var jsonDocument = JsonDocument.Parse(options.GetFormValuesAsJson(Statement));
Assert.Equal("15000ms", jsonDocument.RootElement.GetProperty("timeout").GetString());
}
public void Statement_is_cleaned(string statement)
{
const string expected = "SELECT 1;";
var options = new AnalyticsOptions();
var formValues = options.GetFormValues(statement);
Assert.Equal(expected, formValues["statement"]);
var jsonDocument1 = JsonDocument.Parse(options.GetFormValuesAsJson(statement));
Assert.Equal(expected, jsonDocument1.RootElement.GetProperty("statement").GetString());
}
public void Default_timeout_is_75_seconds()
{
// sets default timeout to 75 seconds
var options = new AnalyticsOptions().Timeout(TimeSpan.FromSeconds(75));
var formValues = options.GetFormValues(Statement);
Assert.Equal("75000ms", formValues["timeout"]);
var jsonDocument = JsonDocument.Parse(options.GetFormValuesAsJson(Statement));
Assert.Equal("75000ms", jsonDocument.RootElement.GetProperty("timeout").GetString());
}
public void Can_set_timeout()
{
var options = new AnalyticsOptions().Timeout(TimeSpan.FromSeconds(15));
var formValues = options.GetFormValues(Statement);
Assert.Equal("15000ms", formValues["timeout"]);
var json = JsonConvert.DeserializeObject <dynamic>(
options.GetFormValuesAsJson(Statement)
);
Assert.Equal("15000ms", json.timeout.Value);
}
public void Can_set_statement()
{
// set statement using constructor
var options = new AnalyticsOptions();
var formValues = options.GetFormValues(Statement);
Assert.Equal(Statement, formValues["statement"]);
var jsonDocument = JsonDocument.Parse(options.GetFormValuesAsJson(Statement));
Assert.Equal(Statement, jsonDocument.RootElement.GetProperty("statement").GetString());
// set statement using method
const string statement = "SELECT 1 FROM `datset`;";
formValues = options.GetFormValues(statement);
Assert.Equal(statement, formValues["statement"]);
var jsonDocument1 = JsonDocument.Parse(options.GetFormValuesAsJson(statement));
Assert.Equal(statement, jsonDocument1.RootElement.GetProperty("statement").GetString());
}
public void Statement_is_cleaned(string statement)
{
const string expected = "SELECT 1;";
var options = new AnalyticsOptions();
var formValues = options.GetFormValues(statement);
Assert.Equal(expected, formValues["statement"]);
var json = JsonConvert.DeserializeObject <dynamic>(
options.GetFormValuesAsJson(statement)
);
Assert.Equal(expected, json.statement.Value);
}
public void Default_timeout_is_75_seconds()
{
// sets default timeout to 75 seconds
var options = new AnalyticsOptions().Timeout(TimeSpan.FromSeconds(75));
var formValues = options.GetFormValues(Statement);
Assert.Equal("75000ms", formValues["timeout"]);
var json = JsonConvert.DeserializeObject <dynamic>(
options.GetFormValuesAsJson(Statement)
);
Assert.Equal("75000ms", json.timeout.Value);
}
public void Can_add_named_parameter()
{
var options = new AnalyticsOptions();
options.Parameter("my_string", "value");
options.Parameter("my_int", 10);
options.Parameter("my_bool", true);
var formValues = options.GetFormValues(Statement);
Assert.Equal("value", formValues["my_string"]);
Assert.Equal(10, formValues["my_int"]);
Assert.Equal(true, formValues["my_bool"]);
var jsonDocument = JsonDocument.Parse(options.GetFormValuesAsJson(Statement));
Assert.Equal("value", jsonDocument.RootElement.GetProperty("my_string").ToString());
Assert.Equal(10, jsonDocument.RootElement.GetProperty("my_int").GetInt32());
Assert.True(jsonDocument.RootElement.GetProperty("my_bool").GetBoolean());
}
public void Can_add_named_parameter()
{
var options = new AnalyticsOptions();
options.Parameter("my_string", "value");
options.Parameter("my_int", 10);
options.Parameter("my_bool", true);
var formValues = options.GetFormValues(Statement);
Assert.Equal("value", formValues["my_string"]);
Assert.Equal(10, formValues["my_int"]);
Assert.Equal(true, formValues["my_bool"]);
var json = JsonConvert.DeserializeObject <dynamic>(
options.GetFormValuesAsJson(Statement)
);
Assert.Equal("value", json.my_string.Value);
Assert.Equal(10, json.my_int.Value);
Assert.Equal(true, json.my_bool.Value);
}
public void Can_add_positional_parameter()
{
var options = new AnalyticsOptions();
options.Parameter("value");
options.Parameter(10);
options.Parameter(true);
var formValues = options.GetFormValues(Statement);
var args = formValues["args"] as object[];
Assert.NotNull(args);
Assert.Equal("value", args[0]);
Assert.Equal(10, args[1]);
Assert.Equal(true, args[2]);
var jsonDocument = JsonDocument.Parse(options.GetFormValuesAsJson(Statement));
var array = jsonDocument.RootElement.GetProperty("args");
Assert.Equal("value", array[0].GetString());
Assert.Equal(10, array[1].GetInt32());
Assert.True(array[2].GetBoolean());
}
public void Can_add_positional_parameter()
{
var options = new AnalyticsOptions();
options.Parameter("value");
options.Parameter(10);
options.Parameter(true);
var formValues = options.GetFormValues(Statement);
var args = formValues["args"] as object[];
Assert.NotNull(args);
Assert.Equal("value", args[0]);
Assert.Equal(10, args[1]);
Assert.Equal(true, args[2]);
var json = JsonConvert.DeserializeObject <dynamic>(
options.GetFormValuesAsJson(Statement)
);
Assert.Equal("value", json.args[0].Value);
Assert.Equal(10, json.args[1].Value);
Assert.Equal(true, json.args[2].Value);
}