public void TestSTAsEWKT()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
Assert.AreEqual(
"SRID=4326;POLYGON((0 0,0 1,1 1,1 0,0 0))",
db.Select(() => GeometryOutput.STAsEWKT("0103000020E61000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000")));
Assert.AreEqual(
"CIRCULARSTRING(220268 150415 1,220227 150505 2,220227 150406 3)",
db.Select(() => GeometryOutput.STAsEWKT("0108000080030000000000000060E30A4100000000785C0241000000000000F03F0000000018E20A4100000000485F024100000000000000400000000018E20A4100000000305C02410000000000000840")));
Assert.IsNull(db.Select(() => GeometryOutput.STAsEWKT((NTSG)null)));
// geography
db.TestGeographies
.Value(g => g.Id, 1)
.Value(g => g.Geography, () => GeometryInput.STGeographyFromText("POINT(30 60)"))
.Insert();
Assert.AreEqual(
"SRID=4326;POINT(30 60)",
db.TestGeographies
.Where(g => g.Id == 1)
.Select(g => g.Geography.STAsEWKT())
.Single());
}
}
public void TestSTTranslatedXYZ()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string geomText = "POINT(0 0 0)";
db.TestGeometries.Value(g => g.Id, 1).Value(p => p.Geometry, () => GeometryInput.STGeomFromText(geomText)).Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STTranslate(5, 12, 3))
.Select(g => GeometryOutput.STAsEWKT(g))
.Single();
Assert.AreEqual("POINT(5 12 3)", result);
}
}
