public void SparqlResultSetToDataTable9() { SparqlResultSet results = new SparqlResultSet(); try { DataTable table = results.ToDataTable(); Assert.True(false, "Should have thrown an InvalidCastException"); } catch (InvalidCastException ex) { Assert.Equal(SparqlResultsType.Unknown, results.ResultsType); Console.WriteLine("Errored as expected"); Console.WriteLine(); TestTools.ReportError("Invalid Cast", ex); } }
public void SparqlResultSetToDataTable8() { SparqlResultSet rset = new SparqlResultSet(false); DataTable table = rset.ToDataTable(); Assert.True(rset.ResultsType == SparqlResultsType.Boolean); Assert.Equal(table.Columns.Count, 1); Assert.Equal(table.Rows.Count, 1); Assert.False((bool)table.Rows[0]["ASK"], "Should be false"); foreach (DataRow row in table.Rows) { foreach (DataColumn col in table.Columns) { Object temp = row[col]; Console.Write(col.ColumnName + " = " + ((temp != null) ? temp.ToString() : String.Empty) + " , "); } Console.WriteLine(); } }
public void SparqlResultSetToDataTable6() { String query = "ASK WHERE {?s <http://example.org/noSuchPredicate> ?o}"; SparqlQueryParser parser = new SparqlQueryParser(); SparqlQuery q = parser.ParseFromString(query); Graph g = new Graph(); FileLoader.Load(g, "resources\\InferenceTest.ttl"); Object results = g.ExecuteQuery(q); if (results is SparqlResultSet) { SparqlResultSet rset = (SparqlResultSet)results; DataTable table = rset.ToDataTable(); Assert.True(rset.ResultsType == SparqlResultsType.Boolean); Assert.Equal(table.Columns.Count, 1); Assert.Equal(table.Rows.Count, 1); Assert.False((bool)table.Rows[0]["ASK"], "Should be false"); foreach (DataRow row in table.Rows) { foreach (DataColumn col in table.Columns) { Object temp = row[col]; Console.Write(col.ColumnName + " = " + ((temp != null) ? temp.ToString() : String.Empty) + " , "); } Console.WriteLine(); } } else { Assert.True(false, "Query should have returned a Result Set"); } }
public void SparqlResultSetToDataTable4() { String query = "PREFIX ex: <http://example.org/vehicles/> SELECT * WHERE {?s a ex:Car . OPTIONAL { ?s ex:Speed ?speed }}"; SparqlQueryParser parser = new SparqlQueryParser(); SparqlQuery q = parser.ParseFromString(query); Graph g = new Graph(); FileLoader.Load(g, "resources\\InferenceTest.ttl"); Object results = g.ExecuteQuery(q); if (results is SparqlResultSet) { SparqlResultSet rset = (SparqlResultSet)results; DataTable table = rset.ToDataTable(); Assert.Equal(rset.Variables.Count(), table.Columns.Count); Assert.Equal(rset.Count, table.Rows.Count); foreach (DataRow row in table.Rows) { foreach (DataColumn col in table.Columns) { Object temp = row[col]; Console.Write(col.ColumnName + " = " + ((temp != null) ? temp.ToString() : String.Empty) + " , "); } Console.WriteLine(); } } else { Assert.True(false, "Query should have returned a Result Set"); } }