def test_publish_add_column(self):
"""Publish should add a geometry column to tables that don't have one"""
# Create a table
self.test_table.create(self.engine, checkfirst=True)
# Spatialize it
ds = Datastored("test_already", "lat", "lng")
ds.publish()
# Check that the geometry column exists
sql = "select count(column_name) from information_schema.columns where table_name='test_already' and column_name='geometry'"
conn = self.engine.connect()
res = conn.execute(sql)
self.assertEqual(res.rowcount, 1)
for row in res:
self.assertEqual(row["count"], 1)
conn.close()
def test_publish_add_column(self):
"""Publish should add a geometry column to tables that don't have one"""
# Create a table
self.test_table.create(self.engine, checkfirst=True)
# Spatialize it
ds = Datastored("test_already", "lat", "lng")
ds.publish()
# Check that the geometry column exists
sql = "select count(column_name) from information_schema.columns where table_name='test_already' and column_name='geometry'"
conn = self.engine.connect()
res = conn.execute(sql)
self.assertEqual(res.rowcount, 1)
for row in res:
self.assertEqual(row["count"], 1)
conn.close()
def test_publish_already_published(self):
"""If a resource has already been spatialized, should not fail"""
# Create a table
self.test_table.create(self.engine, checkfirst=True)
# Give it a geometry column
sql = "select AddGeometryColumn('public', 'test_already', 'geometry', 4326, 'GEOMETRY', 2)"
conn = self.engine.connect()
try:
t = conn.begin()
conn.execute(sql)
t.commit()
except Exception as ex:
t.rollback()
conn.close()
# Now try and "spatialize" it
ds = Datastored("test_already", "lat", "lng")
self.assertTrue(ds.publish())
def test_publish_already_published(self):
"""If a resource has already been spatialized, should not fail"""
# Create a table
self.test_table.create(self.engine, checkfirst=True)
# Give it a geometry column
sql = "select AddGeometryColumn('public', 'test_already', 'geometry', 4326, 'GEOMETRY', 2)"
conn = self.engine.connect()
try:
t = conn.begin()
conn.execute(sql)
t.commit()
except Exception as ex:
t.rollback()
conn.close()
# Now try and "spatialize" it
ds = Datastored("test_already", "lat", "lng")
self.assertTrue(ds.publish())