+# SPDX-License-Identifier: GPL-3.0-or-later
+#
+# This file is part of Nominatim. (https://nominatim.org)
+#
+# Copyright (C) 2024 by the Nominatim developer community.
+# For a full list of authors see the git log.
"""
Legacy word table for testing with functions to prefil and test contents
of the table.
conn.commit()
+ def add_full_word(self, word_id, word, word_token=None):
+ with self.conn.cursor() as cur:
+ cur.execute("""INSERT INTO word (word_id, word_token, type, word, info)
+ VALUES(%s, %s, 'W', %s, '{}'::jsonb)""",
+ (word_id, word or word_token, word))
+ self.conn.commit()
+
+
def add_special(self, word_token, word, cls, typ, oper):
with self.conn.cursor() as cur:
cur.execute("""INSERT INTO word (word_token, type, word, info)
self.conn.commit()
+ def add_housenumber(self, word_id, word_tokens, word=None):
+ with self.conn.cursor() as cur:
+ if isinstance(word_tokens, str):
+ # old style without analyser
+ cur.execute("""INSERT INTO word (word_id, word_token, type)
+ VALUES (%s, %s, 'H')
+ """, (word_id, word_tokens))
+ else:
+ if word is None:
+ word = word_tokens[0]
+ for token in word_tokens:
+ cur.execute("""INSERT INTO word (word_id, word_token, type, word, info)
+ VALUES (%s, %s, 'H', %s, jsonb_build_object('lookup', %s))
+ """, (word_id, token, word, word_tokens[0]))
+
+ self.conn.commit()
+
+
def count(self):
with self.conn.cursor() as cur:
return cur.scalar("SELECT count(*) FROM word")
return cur.scalar("SELECT count(*) FROM word WHERE type = 'S'")
+ def count_housenumbers(self):
+ with self.conn.cursor() as cur:
+ return cur.scalar("SELECT count(*) FROM word WHERE type = 'H'")
+
+
def get_special(self):
with self.conn.cursor() as cur:
cur.execute("SELECT word_token, info, word FROM word WHERE type = 'S'")