aboutsummaryrefslogtreecommitdiff
path: root/backend/data/genSpellfixNameData.py
diff options
context:
space:
mode:
Diffstat (limited to 'backend/data/genSpellfixNameData.py')
-rwxr-xr-xbackend/data/genSpellfixNameData.py32
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()