def test_ST_Dump(self):
lake_id = self._create_one_lake()
lake = session.query(Lake).get(lake_id)
assert isinstance(lake.geom, WKBElement)
s = select([func.ST_Dump(Lake.__table__.c.geom)])
r1 = session.execute(s).scalar()
assert isinstance(r1, str)
s = select([func.ST_Dump(Lake.__table__.c.geom).path])
r2 = session.execute(s).scalar()
assert isinstance(r2, list)
assert r2 == []
s = select([func.ST_Dump(Lake.__table__.c.geom).geom])
r2 = session.execute(s).scalar()
assert isinstance(r2, WKBElement)
assert r2.data == lake.geom.data
r3 = session.execute(func.ST_Dump(lake.geom).geom).scalar()
assert isinstance(r3, WKBElement)
assert r3.data == lake.geom.data
r4 = session.query(func.ST_Dump(Lake.geom).geom).scalar()
assert isinstance(r4, WKBElement)
assert r4.data == lake.geom.data
r5 = session.query(Lake.geom.ST_Dump().geom).scalar()
assert isinstance(r5, WKBElement)
assert r5.data == lake.geom.data
assert r2.data == r3.data == r4.data == r5.data
def test_ST_Dump(self, geography_table):
s = select([func.ST_Dump(geography_table.c.geom).geom])
eq_sql(
s, 'SELECT ST_AsEWKB((ST_Dump("table".geom)).geom) AS geom '
'FROM "table"')
