- with self.db_connection.cursor() as db_cursor:
- db_cursor.execute(SQL("""CREATE TABLE IF NOT EXISTS {} {} AS
- SELECT place_id AS place_id,
- st_centroid(geometry) AS centroid
- FROM placex
- WHERE class = %s AND type = %s""")
- .format(Identifier(table_name), SQL(sql_tablespace)),
- (phrase_class, phrase_type))
-
-
- def _create_place_classtype_indexes(self, sql_tablespace, phrase_class, phrase_type):
+ with self.db_connection.cursor() as cur:
+ cur.execute(SQL("""CREATE TABLE IF NOT EXISTS {} {} AS
+ SELECT place_id AS place_id,
+ st_centroid(geometry) AS centroid
+ FROM placex
+ WHERE class = %s AND type = %s
+ """).format(Identifier(table_name), SQL(sql_tablespace)),
+ (phrase_class, phrase_type))
+
+
+ def _create_place_classtype_indexes(self, sql_tablespace: str,
+ phrase_class: str, phrase_type: str) -> None: