public void When_given_expr_refers_value_array_return_multiple_rows_with_single_column()
{
var searchResult = JSONQuery.GetValue(jsonTestData, "Messages.Sends.Content");
Converter converter = new Converter();
var data = converter.ConvertToRecord(searchResult);
Assert.AreEqual(data.Length, 3, "Wrong number of results");
Assert.AreEqual(data[0].FieldCount, 1, "Wrong field count of result");
// Validate row values
Assert.AreEqual(data[0].GetString(0), "Whats up?", "Invalid data on 1. row");
Assert.AreEqual(data[1].GetString(0), "Me too. Nice to hear!", "Invalid data on 2. row");
Assert.AreEqual(data[2].GetString(0), "How is life going on?", "Invalid data on 3. row");
}
public static void ToTable(string jsonData, string expression)
{
var searchResult = JSONQuery.GetValue(jsonData, expression);
Converter converter = new Converter();
var data = converter.ConvertToRecord(searchResult);
if (data.Length > 0)
{
SqlContext.Pipe.SendResultsStart(data[0]);
for (int i = 0; i < data.Length; i++)
{
SqlContext.Pipe.SendResultsRow(data[i]);
}
SqlContext.Pipe.SendResultsEnd();
}
}
public void When_given_expr_refers_dictionary_return_keys_as_columns()
{
var searchResult = JSONQuery.GetValue(jsonTestData, "Messages[0]");
Converter converter = new Converter();
var data = converter.ConvertToRecord(searchResult);
Assert.AreEqual(data.Length, 1, "Wrong number of results");
Assert.AreEqual(data[0].FieldCount, 4, "Wrong field count of result");
// Validate column names
Assert.AreEqual(data[0].GetName(0), "Title", "1. field has invalid name");
Assert.AreEqual(data[0].GetName(1), "To", "2. field has invalid name");
Assert.AreEqual(data[0].GetName(2), "Sends", "3. field has invalid name");
Assert.AreEqual(data[0].GetName(3), "Receives", "4. field has invalid name");
// Validate row values
Assert.AreEqual(data[0].GetString(0), "Heyy", "Invalid data on 1. field");
Assert.AreEqual(data[0].GetString(1), "Thelove", "Invalid data on 2. field");
Assert.IsNotNullOrEmpty(data[0].GetString(2), "Empty data on 3. field");
Assert.IsNotNullOrEmpty(data[0].GetString(3), "Empty data on 4. field");
}
public override int GetHashCode()
{
return(JSONQuery.GetHashCode());
}
public void When_element_not_able_to_aggregated_return_null(string expression)
{
var found = JSONQuery.GetAvg(JsonTestData, expression);
Assert.IsNull(found);
}
public void When_element_in_chain_of_arrays_requested_return_average_of_all_values(string expression, double expected)
{
var found = JSONQuery.GetAvg(JsonTestData, expression);
Assert.AreEqual(expected, found.Value);
}
public void When_given_property_is_not_applicable_return_null(string expression)
{
var found = JSONQuery.GetValue(JsonTestData, expression);
Assert.IsNull(found);
}
public void When_given_property_supplied_with_attribute_filter_values(object expected, string expression)
{
var found = JSONQuery.GetValue(JsonTestData, expression);
Assert.AreEqual(expected, found);
}
public void When_given_index_not_found_return_null(string expression)
{
var found = JSONQuery.GetValue(JsonTestData, expression);
Assert.IsNull(found);
}
public void When_child_property_supplied_return_correct_value(object expected, string expression)
{
var found = JSONQuery.GetValue(JsonTestData, expression);
Assert.AreEqual(expected, found);
}
public void When_element_in_chain_of_arrays_requested_return_max_of_all_values(string expression, object expected)
{
var found = JSONQuery.GetMax(JsonTestData, expression);
Assert.AreEqual(expected, found);
}
public void When_root_node_begins_with_arrays_return_count_of_all_values(string expression, double expected)
{
var found = JSONQuery.GetCount(JsonTestData, expression);
Assert.AreEqual(expected, found);
}
public static string Min(string jsonData, string expression)
{
var min = JSONQuery.GetMax(jsonData, expression);
return(ToReturnString(min));
}
public static int Count(string jsonData, string expression)
{
var count = JSONQuery.GetCount(jsonData, expression);
return(count);
}
public static string Value(string jsonData, string expression)
{
var searchResult = JSONQuery.GetValue(jsonData, expression);
return(ToReturnString(searchResult));
}
public void When_given_property_not_found_return_null()
{
var found = JSONQuery.GetValue(JsonTestData, "Messages[0].Receives[1].TestProperty");
Assert.IsNull(found);
}
