Use prefix-search with ranking-by-length

1 files changed, 0 insertions, 32 deletions

diff --git a/backend/data/genSpellfixNameData.py b/backend/data/genSpellfixNameData.py
deleted file mode 100755
index 9a3a7a1..0000000
--- a/backend/data/genSpellfixNameData.py
+++ /dev/null
@@ -1,32 +0,0 @@
-#!/usr/bin/python3
-
-import sys
-import sqlite3
-
-usageInfo =  f"usage: {sys.argv[0]}\n"
-usageInfo += "Reads alt-names from a 'names' table in a database, and adds a spellfix \n"
-usageInfo += "table 'spellfix_alt_names' usable for fuzzy-searching those names.\n"
-if len(sys.argv) > 1:
-	print(usageInfo, file=sys.stderr)
-	sys.exit(1)
-
-dbFile = "data.db"
-
-# Connect to db, and load spellfix extension
-dbCon = sqlite3.connect(dbFile)
-dbCon.enable_load_extension(True)
-dbCon.load_extension('./spellfix')
-# Create spellfix table, and insert alt-names
-spellfixCur = dbCon.cursor()
-spellfixCur.execute("CREATE VIRTUAL TABLE spellfix_alt_names USING spellfix1")
-namesCur = dbCon.cursor()
-iterationNum = 0
-for row in namesCur.execute("SELECT DISTINCT alt_name FROM names"):
-	iterationNum += 1
-	if iterationNum % 10000 == 0:
-		print("Loop {}: {}".format(iterationNum, row[0]))
-	# Insert alt-name
-	spellfixCur.execute("INSERT INTO spellfix_alt_names(word) VALUES (?)", (row[0],))
-# Close db
-dbCon.commit()
-dbCon.close()