/// <summary> /// Gets the datatable representing the SPARQL values /// </summary> internal DataTable GetDataTable() { DataTable result = new DataTable(); result.ExtendedProperties.Add("IsOptional", false); result.ExtendedProperties.Add("JoinAsUnion", false); //Create the columns of the SPARQL values this.Bindings.ToList() .ForEach(b => RDFQueryEngine.AddColumn(result, b.Key)); result.AcceptChanges(); //Create the rows of the SPARQL values result.BeginLoadData(); for (int i = 0; i < this.MaxBindingsLength; i++) { Dictionary <String, String> bindings = new Dictionary <String, String>(); this.Bindings.ToList() .ForEach(b => { RDFPatternMember bindingValue = b.Value.ElementAtOrDefault(i); bindings.Add(b.Key, bindingValue?.ToString()); if (bindingValue == null) { result.ExtendedProperties["IsOptional"] = true; } }); RDFQueryEngine.AddRow(result, bindings); } result.EndLoadData(); return(result); }
/// <summary> /// Helps in finalization step by updating the projection's result table (NUMERIC) /// </summary> private void UpdateProjectionTableNumeric(String partitionKey, DataTable projFuncTable) { //Get bindings from context Dictionary <String, String> bindings = new Dictionary <String, String>(); foreach (String pkValue in partitionKey.Split(new String[] { "§PK§" }, StringSplitOptions.RemoveEmptyEntries)) { String[] pValues = pkValue.Split(new String[] { "§PV§" }, StringSplitOptions.None); bindings.Add(pValues[0], pValues[1]); } //Add aggregator value to bindings Double aggregatorValue = this.AggregatorContext.GetPartitionKeyExecutionResult <Double>(partitionKey, Double.PositiveInfinity); if (aggregatorValue.Equals(Double.NaN)) { bindings.Add(this.ProjectionVariable.VariableName, String.Empty); } else { bindings.Add(this.ProjectionVariable.VariableName, new RDFTypedLiteral(Convert.ToString(aggregatorValue, CultureInfo.InvariantCulture), RDFModelEnums.RDFDatatypes.XSD_DOUBLE).ToString()); } //Add bindings to result's table RDFQueryEngine.AddRow(projFuncTable, bindings); }
/// <summary> /// Helps in finalization step by updating the projection's result table /// </summary> internal override void UpdateProjectionTable(String partitionKey, DataTable projFuncTable) { //Get bindings from context Dictionary <String, String> bindings = new Dictionary <String, String>(); foreach (String pkValue in partitionKey.Split(new String[] { "§PK§" }, StringSplitOptions.RemoveEmptyEntries)) { String[] pValues = pkValue.Split(new String[] { "§PV§" }, StringSplitOptions.None); bindings.Add(pValues[0], pValues[1]); } //Add aggregator value to bindings Double aggregatorValue = this.AggregatorContext.GetPartitionKeyExecutionResult <Double>(partitionKey, 0d); if (aggregatorValue.Equals(Double.NaN)) { bindings.Add(this.ProjectionVariable.VariableName, String.Empty); } else { bindings.Add(this.ProjectionVariable.VariableName, aggregatorValue.ToString()); } //Add bindings to result's table RDFQueryEngine.AddRow(projFuncTable, bindings); }
/// <summary> /// Helps in finalization step by updating the projection's result table /// </summary> internal override void UpdateProjectionTable(string partitionKey, DataTable projFuncTable) { //Get bindings from context Dictionary <string, string> bindings = new Dictionary <string, string>(); foreach (string pkValue in partitionKey.Split(new string[] { "§PK§" }, StringSplitOptions.RemoveEmptyEntries)) { string[] pValues = pkValue.Split(new string[] { "§PV§" }, StringSplitOptions.None); bindings.Add(pValues[0], pValues[1]); } //Add aggregator value to bindings string aggregatorValue = this.AggregatorContext.GetPartitionKeyExecutionResult <string>(partitionKey, string.Empty); bindings.Add(this.ProjectionVariable.VariableName, aggregatorValue.TrimEnd(this.Separator)); //Add bindings to result's table RDFQueryEngine.AddRow(projFuncTable, bindings); }
/// <summary> /// Helps in finalization step by updating the projection's result table /// </summary> internal override void UpdateProjectionTable(string partitionKey, DataTable projFuncTable) { //Get bindings from context Dictionary <string, string> bindings = new Dictionary <string, string>(); foreach (string pkValue in partitionKey.Split(new string[] { "§PK§" }, StringSplitOptions.RemoveEmptyEntries)) { string[] pValues = pkValue.Split(new string[] { "§PV§" }, StringSplitOptions.None); bindings.Add(pValues[0], pValues[1]); } //Add aggregator value to bindings double aggregatorValue = this.AggregatorContext.GetPartitionKeyExecutionResult <double>(partitionKey, 0d); bindings.Add(this.ProjectionVariable.VariableName, new RDFTypedLiteral(Convert.ToString(aggregatorValue, CultureInfo.InvariantCulture), RDFModelEnums.RDFDatatypes.XSD_DECIMAL).ToString()); //Add bindings to result's table RDFQueryEngine.AddRow(projFuncTable, bindings); }
/// <summary> /// Gets the datatable representing the SPARQL values /// </summary> internal DataTable GetDataTable() { DataTable result = new DataTable(); //Create the columns of the SPARQL values this.Bindings.ToList() .ForEach(b => RDFQueryEngine.AddColumn(result, b.Key)); result.AcceptChanges(); //Create the rows of the SPARQL values result.BeginLoadData(); for (int i = 0; i < this.MaxBindingsLength; i++) { Dictionary <String, String> bindings = new Dictionary <String, String>(); this.Bindings.ToList() .ForEach(b => bindings.Add(b.Key, b.Value.ElementAtOrDefault(i)?.ToString())); RDFQueryEngine.AddRow(result, bindings); } result.EndLoadData(); return(result); }
/// <summary> /// Reads the given "SPARQL Query Results XML Format" stream into a SELECT query result /// </summary> public static RDFSelectQueryResult FromSparqlXmlResult(Stream inputStream) { try { #region deserialize RDFSelectQueryResult result = new RDFSelectQueryResult(); using (StreamReader streamReader = new StreamReader(inputStream, Encoding.UTF8)) { using (XmlTextReader xmlReader = new XmlTextReader(streamReader)) { xmlReader.DtdProcessing = DtdProcessing.Parse; xmlReader.Normalization = false; #region document XmlDocument srxDoc = new XmlDocument(); srxDoc.Load(xmlReader); #endregion #region results Boolean foundHead = false; Boolean foundResults = false; var nodesEnum = srxDoc.DocumentElement.ChildNodes.GetEnumerator(); while (nodesEnum != null && nodesEnum.MoveNext()) { XmlNode node = (XmlNode)nodesEnum.Current; #region HEAD if (node.Name.ToUpperInvariant().Equals("HEAD", StringComparison.Ordinal)) { foundHead = true; if (node.HasChildNodes) { var variablesEnum = node.ChildNodes.GetEnumerator(); while (variablesEnum != null && variablesEnum.MoveNext()) { #region VARIABLE XmlNode varNode = (XmlNode)variablesEnum.Current; if (varNode.Name.ToUpperInvariant().Equals("VARIABLE", StringComparison.Ordinal)) { if (varNode.Attributes.Count > 0) { XmlAttribute varAttr = varNode.Attributes["name"]; if (varAttr != null && varAttr.Value != String.Empty) { RDFQueryEngine.AddColumn(result.SelectResults, varAttr.Value); } else { throw new RDFModelException("one \"variable\" node was found without, or with empty, \"name\" attribute."); } } else { throw new RDFModelException("one \"variable\" node was found without attributes."); } } #endregion } } else { throw new RDFModelException("\"head\" node was found without children."); } } #endregion #region RESULTS else if (node.Name.ToUpperInvariant().Equals("RESULTS", StringComparison.Ordinal)) { foundResults = true; if (foundHead) { var resultsEnum = node.ChildNodes.GetEnumerator(); while (resultsEnum != null && resultsEnum.MoveNext()) { XmlNode resNode = (XmlNode)resultsEnum.Current; #region RESULT if (resNode.Name.ToUpperInvariant().Equals("RESULT", StringComparison.Ordinal)) { if (resNode.HasChildNodes) { var results = new Dictionary <String, String>(); var bdgEnum = resNode.ChildNodes.GetEnumerator(); while (bdgEnum != null && bdgEnum.MoveNext()) { XmlNode bdgNode = (XmlNode)bdgEnum.Current; Boolean foundUri = false; Boolean foundLit = false; #region BINDING if (bdgNode.Name.ToUpperInvariant().Equals("BINDING", StringComparison.Ordinal)) { if (bdgNode.Attributes != null && bdgNode.Attributes.Count > 0) { XmlAttribute varAttr = bdgNode.Attributes["name"]; if (varAttr != null && varAttr.Value != String.Empty) { if (bdgNode.HasChildNodes) { #region URI / BNODE if (bdgNode.FirstChild.Name.ToUpperInvariant().Equals("URI", StringComparison.Ordinal) || bdgNode.FirstChild.Name.ToUpperInvariant().Equals("BNODE", StringComparison.Ordinal)) { foundUri = true; if (RDFModelUtilities.GetUriFromString(bdgNode.InnerText) != null) { results.Add(varAttr.Value, bdgNode.InnerText); } else { throw new RDFModelException("one \"uri\" node contained data not corresponding to a valid Uri."); } } #endregion #region LITERAL else if (bdgNode.FirstChild.Name.ToUpperInvariant().Equals("LITERAL", StringComparison.Ordinal)) { foundLit = true; if (bdgNode.FirstChild.Attributes != null && bdgNode.FirstChild.Attributes.Count > 0) { XmlAttribute litAttr = bdgNode.FirstChild.Attributes["datatype"]; if (litAttr != null && litAttr.Value != String.Empty) { results.Add(varAttr.Value, bdgNode.FirstChild.InnerText + "^^" + litAttr.Value); } else { litAttr = bdgNode.FirstChild.Attributes[RDFVocabulary.XML.PREFIX + ":lang"]; if (litAttr != null && litAttr.Value != String.Empty) { results.Add(varAttr.Value, bdgNode.FirstChild.InnerText + "@" + litAttr.Value); } else { throw new RDFModelException("one \"literal\" node was found with attribute different from \"datatype\" or \"xml:lang\"."); } } } else { results.Add(varAttr.Value, bdgNode.InnerText); } } #endregion } else { throw new RDFQueryException("one \"binding\" node was found without children."); } } else { throw new RDFQueryException("one \"binding\" node was found without, or with empty, \"name\" attribute."); } } else { throw new RDFQueryException("one \"binding\" node was found without attributes."); } } #endregion if (!foundUri && !foundLit) { throw new RDFQueryException("one \"binding\" node was found without mandatory child \"uri\" or \"literal\"."); } } RDFQueryEngine.AddRow(result.SelectResults, results); } } #endregion } } else { throw new RDFModelException("\"head\" node was not found, or was after \"results\" node."); } } #endregion } if (!foundHead) { throw new RDFStoreException("mandatory \"head\" node was not found"); } if (!foundResults) { throw new RDFStoreException("mandatory \"results\" node was not found"); } #endregion } } return(result); #endregion } catch (Exception ex) { throw new RDFQueryException("Cannot read given \"SPARQL Query Results XML Format\" source because: " + ex.Message, ex); } }