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