From 6bb1d2e369512bec91ecc0c63238f4ad4c54c528 Mon Sep 17 00:00:00 2001
From: Terry Truong <terry06890@gmail.com>
Date: Thu, 5 May 2022 13:17:13 +1000
Subject: Display common names

Also add capitalizeWords() in util.ts, for more capitalization control
---
 backend/server.py | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'backend')

diff --git a/backend/server.py b/backend/server.py
index c1e5538..c8567ab 100755
--- a/backend/server.py
+++ b/backend/server.py
@@ -30,6 +30,7 @@ dbCon.load_extension('./data/spellfix')
 def lookupNodes(names):
 	nodeObjs = {}
 	cur = dbCon.cursor()
+	# Get node info
 	query = "SELECT name, children, parent, tips, p_support FROM nodes WHERE" \
 		" name IN ({})".format(",".join(["?"] * len(names)))
 	for row in cur.execute(query, names):
@@ -39,6 +40,7 @@ def lookupNodes(names):
 			"parent": None if row[2] == "" else row[2],
 			"tips": row[3],
 			"pSupport": True if row[4] == 1 else False,
+			"commonName": None,
 		}
 		# Check for image file
 		match = re.fullmatch(r"\[(.+) \+ (.+)]", name)
@@ -50,6 +52,13 @@ def lookupNodes(names):
 				nodeObj["imgName"] = getNodeImg(match.group(2))
 		# Add node object
 		nodeObjs[name] = nodeObj
+	# Get preferred-name info
+	query = "SELECT name, alt_name FROM names WHERE pref_alt = 1 AND" \
+		" name IN ({})".format(",".join(["?"] * len(names)))
+	for row in cur.execute(query, names):
+		[name, altName] = row
+		nodeObjs[name]["commonName"] = altName
+	#
 	return nodeObjs
 def getNodeImg(name):
 	cur = dbCon.cursor()
-- 
cgit v1.2.3