From cd611fc89535357b227dbc21727534c6275a27f0 Mon Sep 17 00:00:00 2001
From: Terry Truong <terry06890@gmail.com>
Date: Sun, 19 Jun 2022 17:04:40 +1000
Subject: Add code/file for adding manually-picked alt-names

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

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

diff --git a/backend/data/addPickedNames.py b/backend/data/addPickedNames.py
new file mode 100755
index 0000000..b231ab7
--- /dev/null
+++ b/backend/data/addPickedNames.py
@@ -0,0 +1,48 @@
+#!/usr/bin/python3
+
+import sys
+import sqlite3
+
+usageInfo =  f"usage: {sys.argv[0]}\n"
+usageInfo += "Reads alt-name data from a file, and adds it to the 'names' table.\n"
+usageInfo += "The file is expected to have lines of the form: nodeName|altName|prefAlt\n"
+usageInfo += "    These correspond to entries in the 'names' table. 'prefAlt' should\n"
+usageInfo += "    be 1 or 0. A line may specify name1|name1|1, which causes the node\n"
+usageInfo += "    to have no preferred alt-name.\n"
+if len(sys.argv) > 1:
+	print(usageInfo, file=sys.stderr)
+	sys.exit(1)
+
+dbFile = "data.db"
+pickedNamesFile = "pickedNames.txt"
+
+# Open db
+dbCon = sqlite3.connect(dbFile)
+dbCur = dbCon.cursor()
+# Iterate through picked-names file
+with open(pickedNamesFile) as file:
+	for line in file:
+		# Get record data
+		(nodeName, altName, prefAlt) = line.lower().rstrip().split("|")
+		prefAlt = int(prefAlt)
+		# Remove any existing preferred-alt status
+		if prefAlt == 1:
+			query = "SELECT name, alt_name FROM names WHERE name = ? AND pref_alt = 1"
+			row = dbCur.execute(query, (nodeName,)).fetchone()
+			if row != None:
+				dbCur.execute("UPDATE names SET pref_alt = 0 WHERE name = ? AND alt_name = ?", row)
+		# Check for an existing record
+		if nodeName == altName:
+			continue
+		query = "SELECT name, alt_name, pref_alt FROM names WHERE name = ? AND alt_name = ?"
+		row = dbCur.execute(query, (nodeName, altName)).fetchone()
+		if row == None:
+			dbCur.execute("INSERT INTO names VALUES (?, ?, ?, 'picked')", (nodeName, altName, prefAlt))
+		else:
+			# Update existing record
+			if row[2] != prefAlt:
+				dbCur.execute("UPDATE names SET pref_alt = ?, src = 'picked' WHERE name = ? AND alt_name = ?",
+					(prefAlt, nodeName, altName))
+# Close db
+dbCon.commit()
+dbCon.close()
-- 
cgit v1.2.3