コード例 #1
0
ファイル: test_datastored.py プロジェクト: okfn/ckanext-ngds
    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()
コード例 #2
0
    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()
コード例 #3
0
ファイル: test_datastored.py プロジェクト: okfn/ckanext-ngds
    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())
コード例 #4
0
    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())