public void TestCastWithClass()
{
var dict = new Dictionary<string, object> {{"Name", "Bob"}};
dynamic test = new SimpleResultSet(new[] {new SimpleRecord(dict)});
IEnumerable<Foo> foos = test.Cast<Foo>();
Assert.AreEqual(1, foos.Count());
}
public void TestOfType()
{
dynamic test = new SimpleResultSet(new dynamic[] { "Hello", 1 });
IEnumerable<int> ints = test.OfType<int>();
Assert.AreEqual(1, ints.Count());
Assert.AreEqual(1, ints.Single());
}
private SimpleResultSet ToMultipleDynamicEnumerables(IEnumerable <IEnumerable <IDictionary <string, object> > > resultSets)
{
var result = new SimpleResultSet(resultSets.Select(resultSet => resultSet.Select(dict => new SimpleRecord(dict))));
result.SetOutputValues(_arguments);
return(result);
}
public override bool TryGetMember(GetMemberBinder binder, out object result)
{
if (_data.ContainsKey(binder.Name))
{
result = _data[binder.Name];
var converted = ConvertResult(result);
if (!ReferenceEquals(result, converted))
_data[binder.Name] = result = converted;
return true;
}
if (_tableName == null)
{
result = null;
return false;
}
var relatedAdapter = _database.Adapter as IAdapterWithRelation;
if (relatedAdapter != null && relatedAdapter.IsValidRelation(_tableName, binder.Name))
{
var relatedRows = relatedAdapter.FindRelated(_tableName, _data, binder.Name);
if (relatedRows.Count() == 1 && !binder.Name.IsPlural())
{
result = new SimpleRecord(relatedRows.Single(), binder.Name, _database);
}
else
{
result = new SimpleResultSet(relatedRows.Select(dict => new SimpleRecord(dict, binder.Name, _database)));
}
return true;
}
return base.TryGetMember(binder, out result);
}
public async Task <SimpleResultSet> ExecuteDispatchFromNodeGroup(NodeGroup ng, JsonObject sparqlConnectionJson, JsonObject edcConstraintsJson, JsonObject runtimeConstraintsJson)
{
SimpleResultSet retval = null;
conf.SetServiceEndpoint(mappingPrefix + dispatchFromNodegroupEndpoint);
this.parameterJson.Add("jsonRenderedNodeGroup", JsonValue.CreateStringValue(ng.ToJson().ToString()));
this.parameterJson.Add("sparqlConnection", JsonValue.CreateStringValue(sparqlConnectionJson.ToString()));
if (edcConstraintsJson != null)
{
this.parameterJson.Add("externalDataConnectionConstraints", JsonValue.CreateStringValue(edcConstraintsJson.ToString()));
}
if (runtimeConstraintsJson != null)
{
this.parameterJson.Add("runtimeConstraints", JsonValue.CreateStringValue(runtimeConstraintsJson.ToString()));
}
try
{
JsonObject kObj = (JsonObject)(await this.Execute());
retval = SimpleResultSet.FromJson(kObj);
retval.ThrowExceptionIfUnsuccessful();
}
finally{
conf.SetServiceEndpoint(null);
this.parameterJson.Remove("jsonRenderedNodeGroup");
this.parameterJson.Remove("sparqlConnection");
this.parameterJson.Remove("externalDataConnectionConstraints");
this.parameterJson.Remove("runtimeConstraints");
}
return(retval);
}
public async Task <SimpleResultSet> ExecuteDispatchFilterById(String nodegroupID, String targetObjectSparqlId, JsonObject sparqlConnectionJson, JsonObject edcConstraintsJson, JsonArray runtimeConstraintsJson)
{
SimpleResultSet retval = null;
conf.SetServiceEndpoint(mappingPrefix + dispatchFilterByIdEndpoint);
this.parameterJson.Add("nodeGroupId", JsonValue.CreateStringValue(nodegroupID));
this.parameterJson.Add("sparqlConnection", JsonValue.CreateStringValue(sparqlConnectionJson.ToString()));
this.parameterJson.Add("targetObjectSparqlId", JsonValue.CreateStringValue(targetObjectSparqlId));
if (edcConstraintsJson != null)
{
this.parameterJson.Add("externalDataConnectionConstraints", JsonValue.CreateStringValue(edcConstraintsJson.ToString()));
}
if (runtimeConstraintsJson != null)
{
this.parameterJson.Add("runtimeConstraints", JsonValue.CreateStringValue(runtimeConstraintsJson.ToString()));
}
try
{
JsonObject kObj = (JsonObject)(await this.Execute());
retval = SimpleResultSet.FromJson(kObj);
retval.ThrowExceptionIfUnsuccessful();
}
finally{
conf.SetServiceEndpoint(null);
this.parameterJson.Remove("nodeGroupId");
this.parameterJson.Remove("sparqlConnection");
this.parameterJson.Remove("externalDataConnectionConstraints");
this.parameterJson.Remove("runtimeConstraints");
this.parameterJson.Remove("targetObjectSparqlId");
}
return(retval);
}
public async Task <OntologyInfo> ExecuteGetOntologyInfo(SparqlConnection connection)
{ // get the ontology info information related to this connection.
SimpleResultSet interrimResult = null;
OntologyInfo retval = null;
conf.SetServiceEndpoint(mappingPrefix + ontologyInfoDetailsEndpoint);
String connectionJsonString = connection.ToJson().ToString();
this.parameterJson.Add("jsonRenderedSparqlConnection", JsonValue.CreateStringValue(connectionJsonString));
try
{ // talk to the service to get the ontology info details.
//JsonObject obj = (JsonObject)this.Execute().Result;
JsonObject objExec = (JsonObject)(await this.Execute());
interrimResult = SimpleResultSet.FromJson(objExec);
interrimResult.ThrowExceptionIfUnsuccessful();
// get the actual value from the results
JsonObject obj = interrimResult.GetResultJsonObject("ontologyInfo");
// build an oInfo from it.
retval = new OntologyInfo();
retval.AddJson(obj);
}
finally
{
conf.SetServiceEndpoint(null);
this.parameterJson.Remove("jsonRenderedSparqlConnection");
}
// return the OntologyInfo
return(retval);
}
public void TestCast()
{
dynamic test = new SimpleResultSet(new[] { "Hello", "World" });
IEnumerable <string> strings = test.Cast <string>();
Assert.AreEqual(2, strings.Count());
}
public async Task <long> ExecuteDispatchCountByNodegroupToLong(NodeGroup nodegroup, JsonObject sparqlConnectionJson, JsonObject edcConstraintsJson, JsonArray runtimeConstraintsJson)
{
SimpleResultSet ret = await this.ExecuteDispatchCountFromNodeGroup(nodegroup, sparqlConnectionJson, edcConstraintsJson, runtimeConstraintsJson);
Table tab = await this.WaitForJobAndGetTable(ret.GetResult("JobId"));
return(tab.GetCellAsInt(0, 0));
}
public void TestOfType()
{
dynamic test = new SimpleResultSet(new dynamic[] { "Hello", 1 });
IEnumerable <int> ints = test.OfType <int>();
Assert.AreEqual(1, ints.Count());
Assert.AreEqual(1, ints.Single());
}
public void ConvertsToHashSet()
{
dynamic list = new SimpleResultSet(Records(1));
HashSet <dynamic> generic = list;
Assert.IsNotNull(generic);
Assert.AreEqual("0", generic.Single().Data);
}
public void ConvertsToNonGenericList()
{
dynamic list = new SimpleResultSet(Records(1));
ArrayList generic = list;
Assert.IsNotNull(generic);
Assert.AreEqual("0", ((dynamic)generic[0]).Data);
}
public void ConvertsToGenericList()
{
dynamic list = new SimpleResultSet(Records(1));
List <dynamic> generic = list;
Assert.IsNotNull(generic);
Assert.AreEqual("0", generic[0].Data);
}
public void TestCastWithForeach()
{
var dict = new Dictionary<string, object>(HomogenizedEqualityComparer.DefaultInstance) { { "Name", "Bob" } };
dynamic test = new SimpleResultSet(new[] { new SimpleRecord(dict) });
foreach (Foo foo in test)
{
Assert.AreEqual("Bob", foo.Name);
}
}
public static SimpleResultSet ResultSetFromModifiedRowCount(this int count)
{
var simpleResultSet = new SimpleResultSet(Enumerable.Empty <SimpleRecord>());
simpleResultSet.SetOutputValues(new Dictionary <string, object> {
{ "__ReturnValue", count }
});
return(simpleResultSet);
}
public void TestCastWithForeach()
{
var dict = new Dictionary<string, object> { { "Name", "Bob" } };
dynamic test = new SimpleResultSet(new[] { new SimpleRecord(dict) });
foreach (Foo foo in test)
{
Assert.AreEqual("Bob", foo.Name);
}
}
public void CastToGenericCreatesTypedList()
{
dynamic list = new SimpleResultSet(Records(1));
IEnumerable <TestType> converted = list.Cast <TestType>();
Assert.IsNotNull(converted);
Assert.AreEqual(1, converted.Count());
Assert.AreEqual("0", converted.First().Data);
}
public void ToGenericListCreatesTypedList()
{
dynamic list = new SimpleResultSet(Records(1));
List <TestType> converted = list.ToList <TestType>();
Assert.IsNotNull(converted);
Assert.AreEqual(1, converted.Count);
Assert.AreEqual("0", converted[0].Data);
}
public void ToListCreatesList()
{
dynamic list = new SimpleResultSet(Records(1));
List <dynamic> array = list.ToList();
Assert.IsNotNull(array);
Assert.AreEqual(1, array.Count);
Assert.AreEqual("0", array[0].Data);
}
/* execute and get a simple result set */
public async Task <SimpleResultSet> ExecuteWithSimpleResultReturn()
{
if (conf.GetServiceEndpoint() == null || conf.GetServiceEndpoint().Length == 0)
{
throw new Exception("Attempting to execute client with no endpoint specified.");
}
JsonObject kObj = (JsonObject)(await this.Execute());
return(SimpleResultSet.FromJson(kObj));
}
public void ToGenericArrayCreatesTypedArray()
{
dynamic list = new SimpleResultSet(Records(1));
TestType[] array = list.ToArray <TestType>();
Assert.IsNotNull(array);
Assert.AreEqual(1, array.Length);
Assert.AreEqual("0", array[0].Data);
}
public void ToArrayCreatesArray()
{
dynamic list = new SimpleResultSet(Records(1));
dynamic[] array = list.ToArray();
Assert.IsNotNull(array);
Assert.AreEqual(1, array.Length);
Assert.AreEqual("0", array[0].Data);
}
/* get the last run result as a simple result set */
protected SimpleResultSet GetRunResultAsSimpleResultSet()
{
SimpleResultSet retval = new SimpleResultSet();
if (this.runResult == null)
{
throw new Exception("last service communication resulted in null and cannot be converted");
}
retval = SimpleResultSet.FromJson((JsonObject)this.runResult);
return(retval);
}
/// <summary>
/// Executes the versioned save.
/// </summary>
public SimpleResultSet ExecuteNonTransactedVersionedSave(Func <dynamic, SimpleResultSet> dbAction, string outOfDateError)
{
SimpleResultSet result = ExecuteNonTransacted(dbAction);
if (result.SingleOrDefault() == null)
{
throw new ConcurrencyException(outOfDateError);
}
return(result);
}
public void TestCastWithClass()
{
var dict = new Dictionary <string, object>(HomogenizedEqualityComparer.DefaultInstance)
{
{ "Name", "Bob" }
};
dynamic test = new SimpleResultSet(new[] { new SimpleRecord(dict) });
IEnumerable <Foo> foos = test.Cast <Foo>();
Assert.AreEqual(1, foos.Count());
}
public void TestCastWithForeach()
{
var dict = new Dictionary <string, object>(HomogenizedEqualityComparer.DefaultInstance)
{
{ "Name", "Bob" }
};
dynamic test = new SimpleResultSet(new[] { new SimpleRecord(dict) });
foreach (Foo foo in test)
{
Assert.AreEqual("Bob", foo.Name);
}
}
public async Task <Boolean> ExecuteGetJobCompletionCheckWithSimpleReturn(String jobId)
{
SimpleResultSet retval = await this.ExecuteGetJobCompletionCheck(jobId);
String val = retval.GetResult("completed");
if (val.ToLower().Equals("true"))
{
return(true);
}
else
{
return(false);
}
}
public void CastToGenericCreatesTypedListWithSubTypes()
{
var firstRecord = new SimpleRecord(new Dictionary <string, object>
{
{ "Data", "First" },
{ "List", new List <string> {
"First-One", "First-Two"
} }
});
var list = new SimpleResultSet(new List <dynamic> {
firstRecord
});
var result = list.Cast <TestType2>().First();
Assert.AreEqual(2, result.List.Count);
}
public async Task <SimpleResultSet> ExecuteGetJobStatus(String jobId)
{
SimpleResultSet retval = null;
conf.SetServiceEndpoint(mappingPrefix + jobStatusEndpoint);
this.parameterJson.Add("jobID", JsonValue.CreateStringValue(jobId));
try
{
JsonObject kObj = (JsonObject)(await this.Execute());
retval = SimpleResultSet.FromJson(kObj);
retval.ThrowExceptionIfUnsuccessful();
}
finally
{
conf.SetServiceEndpoint(null);
this.parameterJson.Remove("jobID");
}
return(retval);
}
public void FirstOrDefaultWithFailingCriteriaReturnsNull()
{
var list = new SimpleResultSet(Records(20));
Assert.IsNull(list.FirstOrDefault<TestType>(t => t.Data.EndsWith("A")));
}
public void LastReturnsLastElement()
{
var list = new SimpleResultSet(Records(10));
Assert.AreEqual("9", list.Last().Data);
}
public void ToGenericListCreatesTypedList()
{
dynamic list = new SimpleResultSet(Records(1));
List<TestType> converted = list.ToList<TestType>();
Assert.IsNotNull(converted);
Assert.AreEqual(1, converted.Count);
Assert.AreEqual("0", converted[0].Data);
}
public void FirstWithFailingCriteriaThrows()
{
var list = new SimpleResultSet(Records(20));
Assert.Throws<InvalidOperationException>(() => list.First<TestType>(t => t.Data.EndsWith("A")));
}
public void ConvertsToHashSet()
{
dynamic list = new SimpleResultSet(Records(1));
HashSet<dynamic> generic = list;
Assert.IsNotNull(generic);
Assert.AreEqual("0", generic.Single().Data);
}
public void ToGenericArrayCreatesTypedArray()
{
dynamic list = new SimpleResultSet(Records(1));
TestType[] array = list.ToArray<TestType>();
Assert.IsNotNull(array);
Assert.AreEqual(1, array.Length);
Assert.AreEqual("0", array[0].Data);
}
public void SingleThrowsOnListWithMoreThanOneElement()
{
var list = new SimpleResultSet(Records(2));
Assert.Throws<InvalidOperationException>(() => list.Single());
}
public void ConvertsToGenericList()
{
dynamic list = new SimpleResultSet(Records(1));
List<dynamic> generic = list;
Assert.IsNotNull(generic);
Assert.AreEqual("0", generic[0].Data);
}
public void LastOrDefaultReturnsLastElement()
{
var list = new SimpleResultSet(Records(10));
Assert.AreEqual("9", list.LastOrDefault().Data);
}
public void FirstOrDefaultReturnsNullOnEmptyList()
{
var list = new SimpleResultSet(Records(0));
Assert.IsNull(list.FirstOrDefault());
}
public void FirstWithFailingCriteriaThrows()
{
var list = new SimpleResultSet(Records(20));
Assert.Throws <InvalidOperationException>(() => list.First <TestType>(t => t.Data.EndsWith("A")));
}
public void FirstOrDefaultWithCriteriaReturnsMatch()
{
var list = new SimpleResultSet(Records(20));
Assert.AreEqual("8", list.FirstOrDefault <TestType>(t => t.Data.EndsWith("8")).Data);
}
public void FirstOrDefaultWithFailingCriteriaReturnsNull()
{
var list = new SimpleResultSet(Records(20));
Assert.IsNull(list.FirstOrDefault <TestType>(t => t.Data.EndsWith("A")));
}
public void GenericSingleOrDefaultReturnsNullOnEmptyList()
{
var list = new SimpleResultSet(Records(0));
Assert.IsNull(list.SingleOrDefault<TestType>());
}
public void SingleWithCriteriaMatchingOneRecordReturnsMatch()
{
var list = new SimpleResultSet(Records(10));
Assert.AreEqual("8", list.Single<TestType>(t => t.Data.EndsWith("8")).Data);
}
public void GenericSingleOrDefaultThrowsOnListWithMoreThanOneElement()
{
var list = new SimpleResultSet(Records(2));
Assert.Throws<InvalidOperationException>(() => list.SingleOrDefault<TestType>());
}
public void FirstReturnsFirstElement()
{
var list = new SimpleResultSet(Records(10));
Assert.AreEqual("0", list.First().Data);
}
public void ConvertsToNonGenericList()
{
dynamic list = new SimpleResultSet(Records(1));
ArrayList generic = list;
Assert.IsNotNull(generic);
Assert.AreEqual("0", ((dynamic)generic[0]).Data);
}
public void SingleOrDefaultWithCriteriaMatchingMultipleRecordsThrows()
{
var list = new SimpleResultSet(Records(20));
Assert.Throws<InvalidOperationException>(() => list.SingleOrDefault<TestType>(t => t.Data.EndsWith("8")));
}
public void ToArrayCreatesArray()
{
dynamic list = new SimpleResultSet(Records(1));
dynamic[] array = list.ToArray();
Assert.IsNotNull(array);
Assert.AreEqual(1, array.Length);
Assert.AreEqual("0", array[0].Data);
}
public void GenericFirstOrDefaultReturnsFirstElement()
{
var list = new SimpleResultSet(Records(10));
Assert.AreEqual("0", list.FirstOrDefault<TestType>().Data);
}
public void ToListCreatesList()
{
dynamic list = new SimpleResultSet(Records(1));
List<dynamic> array = list.ToList();
Assert.IsNotNull(array);
Assert.AreEqual(1, array.Count);
Assert.AreEqual("0", array[0].Data);
}
public void GenericLastReturnsLastElement()
{
var list = new SimpleResultSet(Records(10));
Assert.AreEqual("9", list.Last<TestType>().Data);
}
public void CastToGenericCreatesTypedList()
{
dynamic list = new SimpleResultSet(Records(1));
IEnumerable<TestType> converted = list.Cast<TestType>();
Assert.IsNotNull(converted);
Assert.AreEqual(1, converted.Count());
Assert.AreEqual("0", converted.First().Data);
}
public void GenericSingleThrowsOnEmptyList()
{
var list = new SimpleResultSet(Records(0));
Assert.Throws<InvalidOperationException>(() => list.Single<TestType>());
}
public void FirstOrDefaultWithCriteriaReturnsMatch()
{
var list = new SimpleResultSet(Records(20));
Assert.AreEqual("8", list.FirstOrDefault<TestType>(t => t.Data.EndsWith("8")).Data);
}
public void GenericSingleOrDefaultReturnsSingleElement()
{
var list = new SimpleResultSet(Records(1));
Assert.AreEqual("0", list.SingleOrDefault<TestType>().Data);
}
public void LastThrowsOnEmptyList()
{
var list = new SimpleResultSet(Records(0));
Assert.Throws<InvalidOperationException>(() => list.Last());
}
public void LastThrowsOnEmptyList()
{
var list = new SimpleResultSet(Records(0));
Assert.Throws <InvalidOperationException>(() => list.Last());
}
public void LastOrDefaultReturnsNullOnEmptyList()
{
var list = new SimpleResultSet(Records(0));
Assert.IsNull(list.LastOrDefault());
}
public void SingleReturnsSingleElement()
{
var list = new SimpleResultSet(Records(1));
Assert.AreEqual("0", list.Single().Data);
}
