/// <summary> /// Writes the cross data. /// </summary> /// <param name="outputFileName"> /// Name of the output file. /// </param> /// <param name="crossSectionalDataStructureObject"> /// The cross sectional data structure object. /// </param> private static void WriteCrossDataNoTimeMeasure(string outputFileName, ICrossSectionalDataStructureObject crossSectionalDataStructureObject) { using (XmlWriter writer = XmlWriter.Create(outputFileName, new XmlWriterSettings { Indent = true })) using (ICrossSectionalWriterEngine crossSectionalWriter = new CrossSectionalWriterEngine(writer, SdmxSchema.GetFromEnum(SdmxSchemaEnumType.VersionTwo))) { crossSectionalWriter.WriteHeader(new HeaderImpl("TEST_ID", "TEST_SENDER")); crossSectionalWriter.StartDataset(null, crossSectionalDataStructureObject, null); crossSectionalWriter.StartXSGroup(); crossSectionalWriter.WriteXSGroupKeyValue("FREQ", "Q"); crossSectionalWriter.StartSection(); crossSectionalWriter.WriteSectionKeyValue("ADJUSTMENT", "N"); crossSectionalWriter.StartXSObservation("A", "1"); crossSectionalWriter.WriteAttributeValue("DECIMALS", "3"); crossSectionalWriter.StartXSObservation("B", "2"); crossSectionalWriter.WriteAttributeValue("DECIMALS", "3"); } }
public void TestCrossSectionalDataWriter(string dsd) { ISdmxObjects objects; var file = new FileInfo(dsd); IStructureParsingManager manager = new StructureParsingManager(SdmxSchemaEnumType.Null); using (var readable = new FileReadableDataLocation(file)) { IStructureWorkspace structureWorkspace = manager.ParseStructures(readable); objects = structureWorkspace.GetStructureObjects(false); } foreach (var dataStructureObject in objects.DataStructures) { var crossDsd = dataStructureObject as ICrossSectionalDataStructureObject; Assert.IsNotNull(crossDsd); using (var writer = XmlWriter.Create("cross-" + file.Name)) { var crossWriter = new CrossSectionalWriterEngine(writer, SdmxSchema.GetFromEnum(SdmxSchemaEnumType.VersionTwo)); crossWriter.WriteHeader(new HeaderImpl("TEST", "TEST")); crossWriter.StartDataset(null, crossDsd, null); foreach (var component in crossDsd.GetCrossSectionalAttachDataSet(true)) { switch (component.StructureType.EnumType) { case SdmxStructureEnumType.Dimension: crossWriter.WriteDataSetKeyValue(component.ConceptRef.ChildReference.Id, "DS"); break; case SdmxStructureEnumType.DataAttribute: crossWriter.WriteAttributeValue(component.ConceptRef.ChildReference.Id, "DS"); break; } } crossWriter.StartXSGroup(); var timeDimension = crossDsd.GetDimensions(SdmxStructureEnumType.TimeDimension).FirstOrDefault(); IDimension freq = crossDsd.GetDimensions().FirstOrDefault(dimension => dimension.FrequencyDimension); IAttributeObject timeFormat = crossDsd.Attributes.FirstOrDefault(o => o.TimeFormat); if (timeDimension != null) { crossWriter.WriteXSGroupKeyValue(timeDimension.ConceptRef.ChildReference.Id, "2000"); if (freq != null) { crossWriter.WriteXSGroupKeyValue(freq.ConceptRef.ChildReference.Id, "A"); } if (timeFormat != null) { crossWriter.WriteAttributeValue(timeFormat.ConceptRef.ChildReference.Id, "DS"); } } foreach (var component in crossDsd.GetCrossSectionalAttachGroup(true)) { switch (component.StructureType.EnumType) { case SdmxStructureEnumType.Dimension: { if (!component.Equals(freq)) { crossWriter.WriteXSGroupKeyValue(component.ConceptRef.ChildReference.Id, "DS"); } } break; case SdmxStructureEnumType.DataAttribute: if (!component.Equals(timeFormat)) { crossWriter.WriteAttributeValue(component.ConceptRef.ChildReference.Id, "DS"); } break; } } crossWriter.StartSection(); foreach (var component in crossDsd.GetCrossSectionalAttachSection(true)) { switch (component.StructureType.EnumType) { case SdmxStructureEnumType.Dimension: crossWriter.WriteXSGroupKeyValue(component.ConceptRef.ChildReference.Id, "DS"); break; case SdmxStructureEnumType.DataAttribute: crossWriter.WriteAttributeValue(component.ConceptRef.ChildReference.Id, "DS"); break; } } if (crossDsd.CrossSectionalMeasures.Count > 0) { for (int index = 0; index < crossDsd.CrossSectionalMeasures.Count; index++) { var crossSectionalMeasure = crossDsd.CrossSectionalMeasures[index]; crossWriter.StartXSObservation(crossSectionalMeasure.Code, "1.002"); foreach (var component in crossDsd.GetCrossSectionalAttachObservation()) { switch (component.StructureType.EnumType) { case SdmxStructureEnumType.Dimension: crossWriter.WriteXSGroupKeyValue(component.ConceptRef.ChildReference.Id, "XS" + index); break; case SdmxStructureEnumType.DataAttribute: crossWriter.WriteAttributeValue(component.ConceptRef.ChildReference.Id, "XSOBS"); break; } } } } else { crossWriter.StartXSObservation(crossDsd.PrimaryMeasure.ConceptRef.ChildReference.Id, "1.002"); foreach (var component in crossDsd.GetCrossSectionalAttachObservation()) { switch (component.StructureType.EnumType) { case SdmxStructureEnumType.Dimension: crossWriter.WriteXSGroupKeyValue(component.ConceptRef.ChildReference.Id, "PM"); break; case SdmxStructureEnumType.DataAttribute: crossWriter.WriteAttributeValue(component.ConceptRef.ChildReference.Id, "PM"); break; } } } crossWriter.Close(); } } }
/// <summary> /// The main. /// </summary> /// <param name="args"> /// The args. /// </param> public static void Main(string[] args) { // 1. We need a IDataStructureObject. In this example we read it from a file. Alternative we could build it from a mutable object. IDataStructureObject dataStructure; using (IReadableDataLocation readable = new FileReadableDataLocation("ESTAT+DEMOGRAPHY+2.1.xml")) { IStructureWorkspace structureWorkspace = _parsingManager.ParseStructures(readable); ISdmxObjects structureBeans = structureWorkspace.GetStructureObjects(false); dataStructure = structureBeans.DataStructures.FirstOrDefault(); } if (dataStructure == null) { throw new InvalidOperationException("Could not build dataStructure object"); } using (XmlWriter writer = XmlWriter.Create("re-using-cross-writer.xml", new XmlWriterSettings { Indent = true })) { // initialize the data writing engine. It can be for SDMX versions 2.0 only. var dataWriterEngine = new CrossSectionalWriterEngine(writer, SdmxSchema.GetFromEnum(SdmxSchemaEnumType.VersionTwo)); // write header dataWriterEngine.WriteHeader(new HeaderImpl("ZZ9", "ZZ9")); // start dataset dataWriterEngine.StartDataset(null, dataStructure, null); // write dataset attributes dataWriterEngine.WriteAttributeValue("REV_NUM", "1"); dataWriterEngine.WriteAttributeValue("TAB_NUM", "RQEL11V1"); // write 1 group entry dataWriterEngine.StartXSGroup(); dataWriterEngine.WriteXSGroupKeyValue("FREQ", "A"); dataWriterEngine.WriteXSGroupKeyValue("COUNTRY", "LU"); dataWriterEngine.WriteXSGroupKeyValue("TIME", "1920"); dataWriterEngine.WriteAttributeValue("TIME_FORMAT", "P1Y"); // write a series entry dataWriterEngine.StartSection(); dataWriterEngine.WriteAttributeValue("UNIT_MULT", "0"); dataWriterEngine.WriteAttributeValue("DECI", "1"); dataWriterEngine.WriteAttributeValue("UNIT", "UNITS"); // write observations for the abose section dataWriterEngine.StartXSObservation("PJAN1T", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("LBIRTHST", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("DEATHST", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("ADJT", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("LBIRTHOUT", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("DEATHUN1", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("MAR", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("DIV", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("IMMIT", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("EMIGT", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("NETMT", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("TFRNSI", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); dataWriterEngine.StartXSObservation("LEXPNSIT", "2030.1"); dataWriterEngine.WriteXSObservationKeyValue("SEX", "F"); dataWriterEngine.WriteAttributeValue("OBS_STATUS", "P"); // close cross Writer dataWriterEngine.Close(); } }