public void Can_set_statement()
{
// set statement using constructor
var request = new AnalyticsRequest(Statement);
var formValues = request.GetFormValues();
Assert.Equal(Statement, formValues["statement"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal(Statement, json.statement.Value);
// set statement using method
const string statement = "SELECT 1 FROM `datset`;";
request.WithStatement(statement);
formValues = request.GetFormValues();
Assert.Equal(statement, formValues["statement"]);
json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal(statement, json.statement.Value);
}
public void Can_add_credentials(string username, bool isAdmin, string expectedUser)
{
const string password = "******";
var request = new AnalyticsRequest(Statement);
var formValues = request.GetFormValues();
Assert.False(formValues.ContainsKey("creds"));
request.AddCredentials(username, password, isAdmin);
formValues = request.GetFormValues();
var creds = (List <dynamic>)formValues["creds"];
Assert.Equal(1, creds.Count);
var expected = $"{{ user = {expectedUser}, pass = {password} }}";
foreach (var cred in creds)
{
Assert.Equal(expected, cred.ToString());
}
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal(1, json.creds.Count);
Assert.Equal($"{{\"user\":\"{expectedUser}\",\"pass\":\"password\"}}", json.creds[0].ToString(Formatting.None));
}
public void Pretty_default_is_false()
{
var request = new AnalyticsRequest(Statement);
var formValues = request.GetFormValues();
Assert.Equal(false, formValues["pretty"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal(false, json.pretty.Value);
}
public void Statement_is_cleaned(string statement)
{
const string expected = "SELECT 1;";
var request = new AnalyticsRequest(statement);
var formValues = request.GetFormValues();
Assert.Equal(expected, formValues["statement"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal(expected, json.statement.Value);
}
public void Can_set_pretty_parameter()
{
var request = new AnalyticsRequest(Statement);
request.Pretty(true);
var formValues = request.GetFormValues();
Assert.Equal(true, formValues["pretty"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal(true, json.pretty.Value);
}
public void Default_timeout_is_75_seconds()
{
var request = new AnalyticsRequest(Statement);
request.ConfigureLifespan(75); // sets default timeout to 75 seconds
var formValues = request.GetFormValues();
Assert.Equal("75000ms", formValues["timeout"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal("75000ms", json.timeout.Value);
}
public void Can_set_metrics_parameter()
{
var request = new AnalyticsRequest(Statement);
request.IncludeMetrics(true);
var formValues = request.GetFormValues();
Assert.Equal(true, formValues["metrics"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal(true, json.metrics.Value);
}
public void Can_set_timeout()
{
var request = new AnalyticsRequest(Statement)
{
Timeout = TimeSpan.FromSeconds(15)
};
var formValues = request.GetFormValues();
Assert.Equal("15000ms", formValues["timeout"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.Equal("15000ms", json.timeout.Value);
}
public void Can_set_timeout()
{
var request = new AnalyticsRequest(_defaultstatement);
request.Timeout(TimeSpan.FromSeconds(15));
request.ConfigureLifespan(75);
var formValues = request.GetFormValues();
Assert.AreEqual("15000ms", formValues["timeout"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
Assert.AreEqual("15000ms", json.timeout.Value);
}
public void Can_add_named_parameter()
{
var request = new AnalyticsRequest(Statement);
request.AddNamedParameter("my_string", "value");
request.AddNamedParameter("my_int", 10);
request.AddNamedParameter("my_bool", true);
var formValues = request.GetFormValues();
Assert.Equal("value", formValues["my_string"]);
Assert.Equal(10, formValues["my_int"]);
Assert.Equal(true, formValues["my_bool"]);
var json = JsonConvert.DeserializeObject <dynamic>(
request.GetFormValuesAsJson()
);
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 request = new AnalyticsRequest(Statement);
request.AddPositionalParameter("value");
request.AddPositionalParameter(10);
request.AddPositionalParameter(true);
var formValues = request.GetFormValues();
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>(
request.GetFormValuesAsJson()
);
Assert.Equal("value", json.args[0].Value);
Assert.Equal(10, json.args[1].Value);
Assert.Equal(true, json.args[2].Value);
}
