public void TestBitwiseAnd()
{
var storeName = "TestBitwiseAnd_" + DateTime.Now.Ticks;
_client.CreateStore(storeName);
var job = _client.ExecuteTransaction(storeName, new UpdateTransactionData {
InsertData = _testData
});
TestHelper.AssertJobCompletesSuccessfully(_client, storeName, job);
var results = _client.ExecuteQuery(storeName,
@"PREFIX bsfunc: <http://brightstardb.com/.well-known/sparql/functions/>
SELECT ?s WHERE {
?s <http://example.org/p1> ?p1 ;
<http://example.org/p2> ?p2 .
FILTER (bsfunc:bit_and(?p1, ?p2) = 1)
}");
var resultsDoc = XDocument.Load(results);
Assert.AreEqual(1, resultsDoc.SparqlResultRows().Count());
var row = resultsDoc.SparqlResultRows().First();
Assert.AreEqual("http://example.org/y", row.GetColumnValue("s").ToString());
}
public Stream GetResultsStream(SparqlResultsFormat format, RdfFormat graphFormat, DateTime?ifNotModifiedSince, out ISerializationFormat streamFormat)
{
if (_commitId > 0)
{
var commitPointInfo = _service.GetCommitPoint(_storeName, _commitId);
if (commitPointInfo == null)
{
throw new InvalidCommitPointException();
}
return(_service.ExecuteQuery(commitPointInfo, _sparqlRequest.Query, _sparqlRequest.DefaultGraphUri, format, graphFormat, out streamFormat));
}
return(_service.ExecuteQuery(_storeName, _sparqlRequest.Query, _sparqlRequest.DefaultGraphUri, ifNotModifiedSince, format, graphFormat, out streamFormat));
}
public static void AssertTriplePatternNotInDefaultGraph(IBrightstarService client, string storeName,
string triplePattern)
{
var sparql = "ASK {{" + triplePattern + "}}";
var resultsDoc = XDocument.Load(client.ExecuteQuery(storeName, sparql));
Assert.IsFalse(resultsDoc.SparqlBooleanResult());
}
public static void AssertTriplePatternInGraph(IBrightstarService client, string storeName, string triplePattern,
string graphUri)
{
var sparql = "ASK { GRAPH <" + graphUri + "> {" + triplePattern + "}}";
var resultsDoc = XDocument.Load(client.ExecuteQuery(storeName, sparql));
Assert.IsTrue(resultsDoc.SparqlBooleanResult());
}
public SparqlResult ExecuteQuery(SparqlQueryContext queryContext, IList <string> datasetGraphUris)
{
ISerializationFormat resultFormat;
var resultStream = _client.ExecuteQuery(_storeName, queryContext.SparqlQuery, datasetGraphUris, null, queryContext.SparqlResultsFormat,
queryContext.GraphResultsFormat, out resultFormat);
return(new SparqlResult(resultStream, resultFormat, queryContext));
}
public static void AssertTriplePatternNotInDefaultGraph(IBrightstarService client, string storeName,
string triplePattern)
{
var sparql = "ASK {{" + triplePattern + "}}";
var resultsDoc = XDocument.Load(client.ExecuteQuery(storeName, sparql));
Assert.IsFalse(resultsDoc.SparqlBooleanResult());
}
public static void AssertTriplePatternInGraph(IBrightstarService client, string storeName, string triplePattern,
string graphUri)
{
var sparql = "ASK { GRAPH <" + graphUri + "> {" + triplePattern + "}}";
var resultsDoc = XDocument.Load(client.ExecuteQuery(storeName, sparql));
Assert.IsTrue(resultsDoc.SparqlBooleanResult());
}
public void TestQuery()
{
XDocument responseDoc = XDocument.Load(_client.ExecuteQuery(_storeName, "SELECT ?s ?p ?o WHERE { ?s ?p ?o }"));
Assert.IsNotNull(responseDoc);
Assert.IsNotNull(responseDoc.Root);
Assert.AreEqual("http://www.w3.org/2005/sparql-results#", responseDoc.Root.Name.Namespace);
Assert.AreEqual("sparql", responseDoc.Root.Name.LocalName);
}
protected string ExecuteQuery(string queryPath, SparqlResultsFormat resultsFormat)
{
var queryExp = File.ReadAllText(queryPath);
var resultsStream = _service.ExecuteQuery(_storeName, queryExp, resultsFormat: resultsFormat);
using (var streamReader = new StreamReader(resultsStream))
{
return(streamReader.ReadToEnd());
}
}
public void TestQuery()
{
var storeName = Guid.NewGuid().ToString();
_client.CreateStore(storeName);
XDocument responseDoc = XDocument.Load(_client.ExecuteQuery(storeName, "SELECT ?s ?p ?o WHERE { ?s ?p ?o }"));
Assert.IsNotNull(responseDoc);
Assert.IsNotNull(responseDoc.Root);
Assert.AreEqual("http://www.w3.org/2005/sparql-results#", responseDoc.Root.Name.Namespace);
Assert.AreEqual("sparql", responseDoc.Root.Name.LocalName);
}
private static void QueryCommitPoint(IBrightstarService client, ICommitPointInfo commitPointInfo)
{
const string sparqlQuery =
"SELECT ?l WHERE { ?s <http://www.w3.org/2000/01/rdf-schema#label> ?l } ORDER BY ?l";
var resultsStream = client.ExecuteQuery(commitPointInfo, sparqlQuery);
var resultsDoc = XDocument.Load(resultsStream);
var labels = new List <string>();
foreach (var row in resultsDoc.SparqlResultRows())
{
labels.Add(row.GetColumnValue("l").ToString());
}
Console.WriteLine("Query returns: {0}", string.Join(", ", labels));
}
private void QueryData()
{
try
{
const string queryTemplate =
"SELECT ?friend WHERE {{ {{<{0}> <http://purl.org/foaf/0.1/knows> ?friend }} UNION {{ ?friend <http://purl.org/foaf/0.1/knows> <{0}> }} }}";
var rng = new Random();
var timer = new Stopwatch();
do
{
try
{
var randomPerson = String.Format("http://example.org/person/{0}", rng.Next(25000));
timer.Restart();
var query = String.Format(queryTemplate, randomPerson);
int rowCount;
using (var stream = _client.ExecuteQuery(_storeName, query))
{
var resultDoc = XDocument.Load(stream);
rowCount = resultDoc.SparqlResultRows().Count();
}
timer.Stop();
_queryTimes.Enqueue(new Tuple <long, int>(timer.ElapsedMilliseconds, rowCount));
} catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Query failed: " + ex.Message);
Console.ResetColor();
_queryTimes.Enqueue(new Tuple <long, int>(-1, 0));
}
} while (!_endQueries);
}
catch (Exception ex)
{
Console.Error.WriteLine(ex);
}
}
public void TestInsert()
{
var storeName = CreateStore("TestInsert");
ExecuteUpdate(storeName, @"PREFIX dc: <http://purl.org/dc/elements/1.1/>
INSERT DATA
{
<http://example/book1> dc:title ""A new book"" ;
dc:creator ""A.N.Other"" .
}");
var results = _client.ExecuteQuery(storeName,
"PREFIX dc: <http://purl.org/dc/elements/1.1/> SELECT ?o WHERE { <http://example/book1> dc:title ?o }");
var resultsDoc = XDocument.Load(results);
var resultRow = resultsDoc.SparqlResultRows().FirstOrDefault();
Assert.IsNotNull(resultRow);
Assert.AreEqual("A new book", resultRow.GetColumnValue("o").ToString());
ExecuteUpdate(storeName,
@"PREFIX dc: <http://purl.org/dc/elements/1.1/>
INSERT { ?a a <http://example.org/book> }
WHERE { ?a dc:title ""A new book"" }");
results = _client.ExecuteQuery(storeName, "SELECT ?b WHERE {?b a <http://example.org/book>}");
resultsDoc = XDocument.Load(results);
resultRow = resultsDoc.SparqlResultRows().FirstOrDefault();
Assert.IsNotNull(resultRow);
Assert.AreEqual(new Uri("http://example/book1"), resultRow.GetColumnValue("b"));
}
public Stream ExecuteQuery(string queryExpression, IList <string> datasetGraphUris)
{
return(_client.ExecuteQuery(_storeName, queryExpression, datasetGraphUris));
}
public void ExecuteQueryForHtml(DateTime?ifNotModifiedSince)
{
Stream resultsStream;
// No query => no results rather than triggering an error
if (String.IsNullOrEmpty(_sparqlRequest.Query))
{
HasFormattedResults = false;
RawResults = String.Empty;
return;
}
try
{
if (_commitId > 0)
{
var commitPointInfo = _service.GetCommitPoint(_storeName, _commitId);
if (commitPointInfo == null)
{
throw new InvalidCommitPointException();
}
resultsStream = _service.ExecuteQuery(commitPointInfo, _sparqlRequest.Query,
_sparqlRequest.DefaultGraphUri, ResultsFormat);
}
else
{
resultsStream = _service.ExecuteQuery(_storeName, _sparqlRequest.Query,
_sparqlRequest.DefaultGraphUri,
ifNotModifiedSince, ResultsFormat);
}
}
catch (Exception ex)
{
ErrorMessage = FormatExceptionMessages(ex);
return;
}
if (ResultsFormat == SparqlResultsFormat.Xml)
{
XDocument resultsDoc = XDocument.Load(resultsStream);
HasFormattedResults = true;
Variables = resultsDoc.GetVariableNames().ToList();
Rows = new List <object[]>();
var varCount = Variables.Count;
foreach (var resultRow in resultsDoc.SparqlResultRows())
{
var row = new object[varCount];
for (int i = 0; i < varCount; i++)
{
row[i] = resultRow.GetColumnValue(Variables[i]);
}
Rows.Add(row);
}
}
else
{
HasFormattedResults = false;
using (var rdr = new StreamReader(resultsStream))
{
RawResults = rdr.ReadToEnd();
}
}
}
private static void QueryCommitPoint(IBrightstarService client, ICommitPointInfo commitPointInfo)
{
const string sparqlQuery =
"SELECT ?l WHERE { ?s <http://www.w3.org/2000/01/rdf-schema#label> ?l } ORDER BY ?l";
var resultsStream = client.ExecuteQuery(commitPointInfo, sparqlQuery);
var resultsDoc = XDocument.Load(resultsStream);
var labels = new List<string>();
foreach(var row in resultsDoc.SparqlResultRows())
{
labels.Add(row.GetColumnValue("l").ToString());
}
Console.WriteLine("Query returns: {0}", string.Join(", ",labels));
}
