public void TestSTAsText()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
var g1 = db.Select(() => GeometryConstructors.STMakePoint(-71.064544, 42.28787));
Assert.AreEqual("POINT(-71.064544 42.28787)", db.Select(() => GeometryOutput.STAsText(g1)));
Assert.AreEqual("POINT(-71.065 42.288)", db.Select(() => GeometryOutput.STAsText(g1, 3)));
Assert.AreEqual("POINT(-71 42)", db.Select(() => GeometryOutput.STAsText(g1, 0)));
Assert.IsNull(db.Select(() => GeometryOutput.STAsText(null)));
}
}
public void TestSTTranslatedXY()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string geomText = "POINT(-71.01 42.37)";
db.TestGeometries.Value(g => g.Id, 1).Value(p => p.Geometry, () => GeometryInput.STGeomFromText(geomText, 4326)).Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STTranslate(1, 0))
.Select(g => GeometryOutput.STAsText(g))
.Single();
Assert.AreEqual("POINT(-70.01 42.37)", result);
}
}
public void TestSTAsText()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
var g1 = db.Select(() => GeometryConstructors.STMakePoint(-71.064544, 42.28787));
Assert.AreEqual("POINT(-71.064544 42.28787)", db.Select(() => GeometryOutput.STAsText(g1)));
Assert.AreEqual("POINT(-71.065 42.288)", db.Select(() => GeometryOutput.STAsText(g1, 3)));
Assert.AreEqual("POINT(-71 42)", db.Select(() => GeometryOutput.STAsText(g1, 0)));
Assert.AreEqual(
"POLYGON((0 0,0 1,1 1,1 0,0 0))",
db.Select(() => GeometryOutput.STAsText("01030000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000")));
Assert.AreEqual(
"POINT(111.11 1.11)",
db.Select(() => GeometryOutput.STAsText(GeometryInput.STGeomFromEWKT("SRID=4326;POINT(111.1111111 1.1111111)"), 2)));
Assert.IsNull(db.Select(() => GeometryOutput.STAsText((NTSG)null)));
const string Wkt2 = "LINESTRING(0 30,120 30)";
db.TestGeographies
.Value(g => g.Id, 1)
.Value(g => g.Geography, () => GeometryInput.STGeogFromText(Wkt2))
.Insert();
var geographyText = db.TestGeographies
.Where(g => g.Id == 1)
.Select(g => g.Geography.STAsText())
.Single();
Assert.AreEqual(Wkt2, geographyText);
}
}
