public void SingleStatementPlusUnmatchableOptionalStatementWithVariable() { MemoryTripleStore statements = new MemoryTripleStore(); statements.Add(new Statement(new UriRef("ex:s"), new UriRef("ex:p"), new UriRef("ex:o"))); SimpleQueryBuilder builder = new SimpleQueryBuilder(); builder.AddPattern(new Pattern(new Variable("v"), new UriRef("ex:p"), new UriRef("ex:o"))); builder.AddOptional(new Pattern(new Variable("v"), new UriRef("ex:p2"), new Variable("o"))); Query query = builder.GetQuery(); QuerySqlMapper mapper = new QuerySqlMapper(query, statements); string expected = "SELECT rn_v.resourceHash rh_v, rn_v.nodeHash nh_v, rn_v.nodeType nt_v, u_v.uri val_v, NULL sub_v, NULL rh_o, NULL nh_o, NULL nt_o, NULL val_o, NULL sub_o " + "FROM Statements s1 JOIN ResourceNodes rn_v ON rn_v.resourceHash=s1.subjectHash AND rn_v.graphId=s1.graphId " + "LEFT OUTER JOIN UriRefs u_v ON rn_v.nodeHash=u_v.hash AND rn_v.nodeType='u' " + "WHERE s1.predicateHash=" + statements.GetResourceDenotedBy(new UriRef("ex:p")).GetHashCode() + " AND s1.objectHash=" + statements.GetResourceDenotedBy(new UriRef("ex:o")).GetHashCode() + " AND s1.graphId=" + statements.GetHashCode(); Assert.AreEqual(expected, mapper.Sql); }
public void SingleStatementPlusMultipleOptionalStatementsInOneGroup() { MemoryTripleStore statements = new MemoryTripleStore(); statements.Add(new Statement(new UriRef("ex:s"), new UriRef("ex:p"), new UriRef("ex:o"))); statements.Add(new Statement(new UriRef("ex:s"), new UriRef("ex:p2"), new UriRef("ex:o2"))); SimpleQueryBuilder builder = new SimpleQueryBuilder(); builder.AddPattern(new Pattern(new Variable("v"), new UriRef("ex:p"), new UriRef("ex:o"))); builder.AddOptional(new Pattern(new Variable("v"), new Variable("p"), new UriRef("ex:o2"))); builder.AddOptional(new Pattern(new Variable("v"), new Variable("p"), new UriRef("ex:o"))); Query query = builder.GetQuery(); QuerySqlMapper mapper = new QuerySqlMapper(query, statements); string expected = "SELECT rn_v.resourceHash rh_v, rn_v.nodeHash nh_v, rn_v.nodeType nt_v, u_v.uri val_v, NULL sub_v, rn_p.resourceHash rh_p, rn_p.nodeHash nh_p, rn_p.nodeType nt_p, u_p.uri val_p, NULL sub_p " + "FROM Statements s1 " + "LEFT OUTER JOIN Statements s2" + " ON s2.subjectHash=s1.subjectHash" + " AND s2.objectHash=" + statements.GetResourceDenotedBy(new UriRef("ex:o2")).GetHashCode() + " AND s2.graphId=" + statements.GetHashCode() + " JOIN Statements s3" + " ON s3.subjectHash=s2.subjectHash" + " AND s3.predicateHash=s2.predicateHash" + " AND s3.objectHash=" + statements.GetResourceDenotedBy(new UriRef("ex:o")).GetHashCode() + " AND s3.graphId=" + statements.GetHashCode() + " JOIN ResourceNodes rn_v ON rn_v.resourceHash=s1.subjectHash AND rn_v.graphId=s1.graphId " + "LEFT OUTER JOIN UriRefs u_v ON rn_v.nodeHash=u_v.hash AND rn_v.nodeType='u' " + "JOIN ResourceNodes rn_p ON rn_p.resourceHash=s2.predicateHash AND rn_p.graphId=s2.graphId " + "LEFT OUTER JOIN UriRefs u_p ON rn_p.nodeHash=u_p.hash AND rn_p.nodeType='u' " + "WHERE s1.predicateHash=" + statements.GetResourceDenotedBy(new UriRef("ex:p")).GetHashCode() + " AND s1.objectHash=" + statements.GetResourceDenotedBy(new UriRef("ex:o")).GetHashCode() + " AND s1.graphId=" + statements.GetHashCode(); Assert.AreEqual(expected, mapper.Sql); }