private void DoDocumentReset()
{
_fs.SetConfigurationContent(null);
_fs.ConfigurationDocument = null;
_service.SyncSessionCopy();
_doc = null;
BuildDefaultDocument();
if (null != _doc)
{
_fs.ConfigurationDocument = "config.xml";
_fs.SetConfigurationContent(_doc.ToXml());
MessageBox.Show(Strings.ConfigurationDocumentReset);
}
}
public void TestOdbcSaveLoad()
{
var schema = new FeatureSchema("Default", "Test schema");
var cls = new ClassDefinition("Cities", "Cities class");
cls.AddProperty(new DataPropertyDefinition("ID", "Primary Key")
{
DataType = DataPropertyType.Int64,
IsNullable = false,
IsAutoGenerated = true
}, true);
cls.AddProperty(new DataPropertyDefinition("Name", "City Name")
{
DataType = DataPropertyType.String,
IsNullable = true,
IsAutoGenerated = false,
Length = 255
});
cls.AddProperty(new GeometricPropertyDefinition("Geometry", "Geometry property")
{
GeometricTypes = FeatureGeometricType.Point,
SpecificGeometryTypes = new SpecificGeometryType[] { SpecificGeometryType.Point },
HasElevation = false,
HasMeasure = false,
SpatialContextAssociation = "Default"
});
cls.AddProperty(new DataPropertyDefinition("Population", "Population")
{
DataType = DataPropertyType.Int32,
IsNullable = true,
IsAutoGenerated = false
});
cls.DefaultGeometryPropertyName = "Geometry";
schema.AddClass(cls);
var sc = new FdoSpatialContextListSpatialContext();
sc.CoordinateSystemName = "LL84";
sc.CoordinateSystemWkt = "";
sc.Description = "Default Spatial Context";
sc.Extent = new FdoSpatialContextListSpatialContextExtent()
{
LowerLeftCoordinate = new FdoSpatialContextListSpatialContextExtentLowerLeftCoordinate()
{
X = "-180.0",
Y = "-180.0"
},
UpperRightCoordinate = new FdoSpatialContextListSpatialContextExtentUpperRightCoordinate()
{
X = "180.0",
Y = "180.0"
}
};
sc.ExtentType = FdoSpatialContextListSpatialContextExtentType.Static;
sc.Name = "Default";
sc.XYTolerance = 0.0001;
sc.ZTolerance = 0.0001;
var conf = new OdbcConfigurationDocument();
conf.AddSchema(schema);
conf.AddSpatialContext(sc);
var ov = new OdbcTableItem();
ov.SchemaName = schema.Name;
ov.ClassName = cls.Name;
ov.SpatialContextName = sc.Name;
ov.XColumn = "Lon";
ov.YColumn = "Lat";
conf.AddOverride(ov);
string path = "OdbcConfigTest.xml";
File.WriteAllText(path, conf.ToXml());
conf = null;
string xml = File.ReadAllText(path);
conf = ConfigurationDocument.LoadXml(xml) as OdbcConfigurationDocument;
Assert.NotNull(conf);
ov = conf.GetOverride("Default", "Cities");
Assert.NotNull(ov);
Assert.AreEqual("Default", ov.SchemaName);
Assert.AreEqual("Cities", ov.ClassName);
Assert.AreEqual(sc.Name, ov.SpatialContextName);
Assert.AreEqual("Lon", ov.XColumn);
Assert.AreEqual("Lat", ov.YColumn);
}
