public void TestSelectRegexFilter()
{
// Arrange
graph = new RDFGraph();
RDFSelectQuery query;
BuildGraph(graph);
// Act
query = new RDFSelectQuery();
var x = new RDFVariable("x");
var y = new RDFVariable("y");
var z = new RDFVariable("z");
var patternGroup = new RDFPatternGroup("PatternGroup1").AddPattern(new RDFPattern(x, y, z));
var filter = new RDFRegexFilter(x, new Regex(@".1$", RegexOptions.IgnoreCase)); // Filter subjects ending with 1
patternGroup.AddFilter(filter);
query.AddPatternGroup(patternGroup)
.AddProjectionVariable(x)
.AddProjectionVariable(y)
.AddProjectionVariable(z);
var result = query.ApplyToGraph(graph);
// Assert
Assert.AreEqual(3, result.SelectResultsCount);
}
public void CreateRegexFilter()
{
//Arrange
var n = new RDFVariable("n");
var filter = new RDFRegexFilter(n, new Regex(@"Mouse", RegexOptions.IgnoreCase));
var pg1 = new RDFPatternGroup("PG1");
//Act
pg1.AddFilter(filter);
//Assert
Assert.Contains(filter.ToString(), pg1.ToString());
}
public void CreateIsNumericFilter()
{
//Arrange
var x = new RDFVariable("x");
var filter = new RDFIsUriFilter(x);
var pg1 = new RDFPatternGroup("PG1");
//Act
pg1.AddFilter(filter);
//Assert
Assert.Contains(filter.ToString(), pg1.ToString());
}
public void CreateComparisonFilter()
{
//Arrange
var y = new RDFVariable("y");
var filter = new RDFComparisonFilter(RDFQueryEnums.RDFComparisonFlavors.LessThan, y, new RDFPlainLiteral("25"));
var pg1 = new RDFPatternGroup("PG1");
//Act
pg1.AddFilter(filter);
//Assert
Assert.Contains(filter.ToString(), pg1.ToString());
}
public void CreateLangMatchesFilter()
{
//Arrange
var n = new RDFVariable("n");
var filter = new RDFLangMatchesFilter(n, "it-IT");
var pg1 = new RDFPatternGroup("PG1");
//Act
pg1.AddFilter(filter);
//Assert
Assert.Contains(filter.ToString(), pg1.ToString());
}
public void CreateSameTermFilter()
{
//Arrange
var x = new RDFVariable("x");
var filter = new RDFSameTermFilter(x, donaldduck);
var pg1 = new RDFPatternGroup("PG1");
//Act
pg1.AddFilter(filter);
//Assert
Assert.Contains(filter.ToString(), pg1.ToString());
}
private RDFSelectQuery BuildSelectAllQuery(RDFFilter filter = null)
{
var query = new RDFSelectQuery();
var x = new RDFVariable("x");
var y = new RDFVariable("y");
var z = new RDFVariable("z");
var patternGroup = new RDFPatternGroup("PatternGroup1").AddPattern(new RDFPattern(x, y, z));
if (filter != null)
{
patternGroup.AddFilter(filter);
}
query.AddPatternGroup(patternGroup)
.AddProjectionVariable(x)
.AddProjectionVariable(y)
.AddProjectionVariable(z);
return(query);
}
/// <summary>
/// WORKING WITH SPARQL QUERIES
/// </summary>
private void WorkingWithQueries(RDFGraph graph, RDFResource donaldduck)
{
RDFSelectQuery selectQuery = new RDFSelectQuery();
// CREATE VARIABLE
var x = new RDFVariable("x"); // ?X
var y = new RDFVariable("y"); // ?Y
var n = new RDFVariable("n"); // ?N
var c = new RDFVariable("c"); // ?C
// CREATE PATTERNS
var dogOf = new RDFResource(RDFVocabulary.DC.BASE_URI + "dogOf");
var y_dogOf_x = new RDFPattern(y, dogOf, x); // TRIPLE PATTERN
var c_y_dogOf_x = new RDFPattern(c, y, dogOf, x); // QUADRUPLE PATTERN
// CREATE EMPTY PATTERN GROUP
var pg1 = new RDFPatternGroup("PG1");
// CREATE PATTERN GROUP FROM A LIST OF PATTERNS
var patterns = new List <RDFPattern>()
{
y_dogOf_x
};
var pg2 = new RDFPatternGroup("PG2", patterns);
// ADD PATTERNS TO PATTERN GROUP
pg1.AddPattern(y_dogOf_x);
pg1.AddPattern(c_y_dogOf_x);
// ADD PATTERN GROUPS TO QUERY
selectQuery.AddPatternGroup(pg1);
selectQuery.AddPatternGroup(pg2);
// ADD FILTERS TO PATTERN GROUP
pg1.AddFilter(new RDFSameTermFilter(new RDFVariable("character"), donaldduck));
pg1.AddFilter(new RDFLangMatchesFilter(n, "it-IT"));
// ADD MODIFIERS TO QUERY
selectQuery.AddModifier(new RDFOrderByModifier(n, RDFQueryEnums.RDFOrderByFlavors.ASC));
selectQuery.AddModifier(new RDFDistinctModifier());
selectQuery.AddModifier(new RDFGroupByModifier(new List <RDFVariable> {
x
}));
selectQuery.AddModifier(new RDFLimitModifier(100));
selectQuery.AddModifier(new RDFOffsetModifier(25));
// INITIALIZE PROPERTY PATH (VARIABLE TERMS)
var variablePropPath = new RDFPropertyPath(new RDFVariable("START"), new RDFVariable("END"));
// INITIALIZE PROPERTY PATH (MIXED TERMS)
var mixedPropPath = new RDFPropertyPath(new RDFResource("http://res.org/"), new RDFVariable("END"));
//ADD SEQUENCE STEPS TO PROPERTY PATH
variablePropPath.AddSequenceStep(new
RDFPropertyPathStep(new RDFResource("rdf:P1")));
variablePropPath.AddSequenceStep(new
RDFPropertyPathStep(new RDFResource("rdf:P2")));
//ADD ALTERNATIVE STEPS TO PROPERTY PATH
var altSteps = new List <RDFPropertyPathStep>();
altSteps.Add(new RDFPropertyPathStep(new
RDFResource("rdf:P3")));
altSteps.Add(new RDFPropertyPathStep(new
RDFResource("rdf:P7")));
variablePropPath.AddAlternativeSteps(altSteps);
// ADD INVERSE SEQUENCE STEP TO PROPERTY PATH: ?START ^rdf:INVP ?END
variablePropPath.AddSequenceStep(new RDFPropertyPathStep(new RDFResource("rdf:INVP")).Inverse());
//ADD ALTERNATIVE STEPS (ONE INVERSE) TO PROPERTY PATH: ?START (rdf:P3|^rdf:INVP3) ?END
var altSteps2 = new List <RDFPropertyPathStep>();
altSteps2.Add(new RDFPropertyPathStep(new RDFResource("rdf:P3")));
altSteps2.Add(new RDFPropertyPathStep(new RDFResource("rdf:INVP3")).Inverse());
variablePropPath.AddAlternativeSteps(altSteps2);
// ADD SUBQUERY TO QUERY
RDFSelectQuery mySubQuery = new RDFSelectQuery();
selectQuery.AddSubQuery(mySubQuery);
// ADD AGGREGATORS TO GROUPBY MODIFIER
RDFGroupByModifier gm = new RDFGroupByModifier(new List <RDFVariable> {
x
});
gm.AddAggregator(new RDFAvgAggregator(new RDFVariable("age"), new RDFVariable("avg_age")));
gm.AddAggregator(new RDFCountAggregator(new RDFVariable("dept"), new RDFVariable("count_dept")));
gm.AddAggregator(new RDFGroupConcatAggregator(new RDFVariable("name"), new RDFVariable("gc_name"), "-"));
gm.AddAggregator(new RDFSampleAggregator(new RDFVariable("name"), new RDFVariable("sample_name")));
gm.AddAggregator(new RDFSumAggregator(new RDFVariable("salary"), new RDFVariable("sum_salary")));
gm.AddAggregator(new RDFMinAggregator(new RDFVariable("age"), new RDFVariable("min_age"),
RDFQueryEnums.RDFMinMaxAggregatorFlavors.Numeric)); //?age is expected to have numeric typedliterals
gm.AddAggregator(new RDFMinAggregator(new RDFVariable("city"), new RDFVariable("min_city"),
RDFQueryEnums.RDFMinMaxAggregatorFlavors.String));
gm.AddAggregator(new RDFMaxAggregator(new RDFVariable("salary"), new RDFVariable("max_salary"),
RDFQueryEnums.RDFMinMaxAggregatorFlavors.Numeric)); //?salary is expected to have numeric typedliterals
gm.AddAggregator(new RDFMaxAggregator(new RDFVariable("city"), new RDFVariable("min_city"),
RDFQueryEnums.RDFMinMaxAggregatorFlavors.String));
// It is possible to filter a group - by partitioned set of SPARQL results by applying the SetHavingClause operator on desired aggregators:
// ADD AGGREGATORS TO GROUPBY MODIFIER
RDFModelEnums.RDFDatatypes xsdDbl = RDFModelEnums.RDFDatatypes.XSD_DOUBLE;
RDFModelEnums.RDFDatatypes xsdInt = RDFModelEnums.RDFDatatypes.XSD_INT;
gm.AddAggregator(new RDFAvgAggregator(new RDFVariable("age"), new RDFVariable("avg_age"))
.SetHavingClause(RDFQueryEnums.RDFComparisonFlavors.GreaterThan, new RDFTypedLiteral("25.5", xsdDbl))
);
gm.AddAggregator(new RDFCountAggregator(new RDFVariable("dept"), new RDFVariable("count_dept"))
.SetHavingClause(RDFQueryEnums.RDFComparisonFlavors.EqualTo, new RDFTypedLiteral("4", xsdInt))
);
//Declare the following SPARQL values:
/*
* VALUES (?a ?b ?c) {
* ("1" "2" "3")
* ("2" "4" "6")
* ("3" "6" UNDEF)
* }
*/
RDFValues myValues = new RDFValues()
.AddColumn(new RDFVariable("a"),
new List <RDFPatternMember>()
{
new RDFPlainLiteral("1"),
new RDFPlainLiteral("2"),
new RDFPlainLiteral("3")
})
.AddColumn(new RDFVariable("b"),
new List <RDFPatternMember>()
{
new RDFPlainLiteral("2"),
new RDFPlainLiteral("4"),
new RDFPlainLiteral("6")
})
.AddColumn(new RDFVariable("c"),
new List <RDFPatternMember>()
{
new RDFPlainLiteral("3"),
new RDFPlainLiteral("6"),
null //UNDEF
});
// ADD PROPERTY PATH TO PATTERN GROUP
pg1.AddValues(myValues);
// CREATING AND EXECUTING SELECT QUERIES
// APPLY SELECT QUERY TO GRAPH
RDFSelectQueryResult selectQueryResult = selectQuery.ApplyToGraph(graph);
// APPLY SELECT QUERY TO STORE
//RDFSelectQueryResult selectQueryResult = selectQuery.ApplyToStore(store);
// APPLY SELECT QUERY TO FEDERATION
//RDFSelectQueryResult selectQueryResult = selectQuery.ApplyToFederation(federation);
// EXPORT SELECT QUERY RESULTS TO SPARQL XML FORMAT (FILE)
selectQueryResult.ToSparqlXmlResult(@"C:\TMP\select_results.srq");
// EXPORT SELECT QUERY RESULTS TO SPARQL XML FORMAT (STREAM)
//selectQueryResult.ToSparqlXmlResult(myStream);
// IMPORT SELECT QUERY RESULTS FROM SPARQL XML FORMAT (FILE)
selectQueryResult = RDFSelectQueryResult.FromSparqlXmlResult(@"C:\TMP\select_results.srq");
// IMPORT SELECT QUERY RESULTS FROM SPARQL XML FORMAT (STREAM)
//selectQueryResult = RDFSelectQueryResult.FromSparqlXmlResult(myStream);
}
