From 07397961bfb113bd9c03883f2b24e6d287f989ca Mon Sep 17 00:00:00 2001
From: Terry Truong <terry06890@gmail.com>
Date: Thu, 26 May 2022 13:22:36 +1000
Subject: Add some enwiki redirect data as alt-names

---
 backend/data/genEnwikiDescData.py | 71 +++++++++++++++++++++++++++++++++++++++
 1 file changed, 71 insertions(+)
 create mode 100755 backend/data/genEnwikiDescData.py

(limited to 'backend/data/genEnwikiDescData.py')

diff --git a/backend/data/genEnwikiDescData.py b/backend/data/genEnwikiDescData.py
new file mode 100755
index 0000000..40a6c92
--- /dev/null
+++ b/backend/data/genEnwikiDescData.py
@@ -0,0 +1,71 @@
+#!/usr/bin/python3
+
+import sys, re
+import sqlite3
+
+usageInfo =  f"usage: {sys.argv[0]}\n"
+usageInfo += "Reads Wikimedia enwiki data from enwiki/, and node and name data"
+usageInfo += "from a sqlite database, and adds description data for names that\n"
+usageInfo += "don't have them.\n"
+if len(sys.argv) > 1:
+	print(usageInfo, file=sys.stderr)
+	sys.exit(1)
+
+enwikiDb = "enwiki/enwikiData.db"
+dbFile = "data.db"
+
+# Open dbs
+enwikiCon = sqlite3.connect(enwikiDb)
+enwikiCur = enwikiCon.cursor()
+dbCon = sqlite3.connect(dbFile)
+dbCur = dbCon.cursor()
+# Get node names without descriptions
+print("Getting node names")
+nodeNames = set()
+query = "SELECT nodes.name FROM nodes LEFT JOIN descs ON nodes.name = descs.name WHERE desc IS NULL"
+for row in dbCur.execute(query):
+	nodeNames.add(row[0])
+print("Found {} names".format(len(nodeNames)))
+# Find page id for each node name
+print("Getting node page-ids")
+nodeToPageId = {}
+iterNum = 0
+for name in nodeNames:
+	iterNum += 1
+	if iterNum % 1e4 == 0:
+		print("At iteration {}".format(iterNum))
+	#
+	row = enwikiCur.execute("SELECT id FROM pages WHERE pages.title = ? COLLATE NOCASE", (name,)).fetchone()
+	if row != None:
+		nodeToPageId[name] = row[0]
+# Resolve redirects
+print("Resolving redirects")
+redirectingNames = set()
+iterNum = 0
+for (name, pageId) in nodeToPageId.items():
+	iterNum += 1
+	if iterNum % 1000 == 0:
+		print("At iteration {}".format(iterNum))
+	#
+	row = enwikiCur.execute(
+		"SELECT pages.id FROM redirects INNER JOIN pages ON redirects.target = pages.title WHERE redirects.id = ?",
+		(pageId,)).fetchone()
+	if row != None:
+		nodeToPageId[name] = row[0]
+		redirectingNames.add(name)
+# Add descriptions for each node
+print("Adding description data")
+iterNum = 0
+for (name, pageId) in nodeToPageId.items():
+	iterNum += 1
+	if iterNum % 1000 == 0:
+		print("At iteration {}".format(iterNum))
+	#
+	row = enwikiCur.execute("SELECT desc FROM descs where descs.id = ?", (pageId,)).fetchone()
+	if row != None:
+		dbCur.execute("INSERT INTO descs VALUES (?, ?, ?, ?, ?)",
+			(name, row[0], 1 if name in redirectingNames else 0, pageId, 0))
+# Close dbs
+dbCon.commit()
+dbCon.close()
+enwikiCon.close()
-- 
cgit v1.2.3