# The following query shows that you can manipulate geometries within the code
# I can get back a union of two geometries
# and convert from a string to Geometry type if it is in WKT
# Code that is being run:
# Geom = self._session.query(Samplingfeature).first()
# GeomText = self._session.query(func.ST_Union(Geom.FeatureGeometry,func.ST_GeomFromText(TestGeom)).ST_AsText()).first()
print "\n\n------------GeometryTest--------- \n",
TestGeom = "POINT (30 10)"
print "Static Test Geometry:", TestGeom
print core_read.getGeometryTest(TestGeom)
geomsf = core_read.getSamplingFeatureByGeometry("POINT(111.781944 41.743333)")
print "Get Sampling Feature by Geometry: ", geomsf
# you can drill down into the code and get object linked by foreign keys
print "\n\n------------Foreign Key sample--------- \n",
#
result = core_read.getAllResult()[0]
print "FeatureAction: ", result.FeatureActionObj
print "Action: ", result.FeatureActionObj.ActionObj
print "Action Attribute: ", result.FeatureActionObj.ActionObj.ActionTypeCV
TSResult = result_read.getTimeSeriesResultsByResultId(result.ResultID)
print "TSResult: ", TSResult
TSValues = result_read.getTimeSeriesValuesByResultId(result.ResultID)
print "Values: ", TSValues
print "Get SamplingFeatures by code: ", sf
#The following query shows that you can manipulate geometries within the code
#I can get back a union of two geometries
#and convert from a string to Geometry type if it is in WKT
#Code that is being run:
#Geom = self._session.query(Samplingfeature).first()
#GeomText = self._session.query(func.ST_Union(Geom.FeatureGeometry,func.ST_GeomFromText(TestGeom)).ST_AsText()).first()
print "\n\n------------GeometryTest--------- \n",
TestGeom = "POINT (30 10)"
print "Static Test Geometry:", TestGeom
print core_read.getGeometryTest(TestGeom)
geomsf = core_read.getSamplingFeatureByGeometry('POINT(111.781944 41.743333)')
print "Get Sampling Feature by Geometry: ", geomsf
# you can drill down into the code and get object linked by foreign keys
print "\n\n------------Foreign Key sample--------- \n",
#
result = core_read.getAllResult()[0]
print "FeatureAction: ", result.FeatureActionObj
print "Action: ", result.FeatureActionObj.ActionObj
print "Action Attribute: ", result.FeatureActionObj.ActionObj.ActionTypeCV
TSResult = result_read.getTimeSeriesResultsByResultId(result.ResultID)
print "TSResult: ", TSResult
TSValues = result_read.getTimeSeriesValuesByResultId(result.ResultID)
print "Values: ", TSValues
#print dir(result)
