From a4673571570816a06d4188169fc00dada79ec0a3 Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Sun, 15 May 2022 00:46:39 +1000 Subject: Converted nodes+r_nodes tables into nodes+edges+r_nodes+r_edges Conversion avoids encoding node children as JSON strings, and allows for easier querying of edge data. Adjusted server to use new format. Also added some table indexes for common operations. --- backend/data/genEolNameData.py | 3 +++ 1 file changed, 3 insertions(+) (limited to 'backend/data/genEolNameData.py') diff --git a/backend/data/genEolNameData.py b/backend/data/genEolNameData.py index 7f7e499..277f3a7 100755 --- a/backend/data/genEolNameData.py +++ b/backend/data/genEolNameData.py @@ -64,7 +64,10 @@ dbCon = sqlite3.connect(dbFile) dbCur = dbCon.cursor() # Create tables dbCur.execute("CREATE TABLE names(name TEXT, alt_name TEXT, pref_alt INT, PRIMARY KEY(name, alt_name))") +dbCur.execute("CREATE INDEX names_alt_idx ON names(alt_name)") +dbCur.execute("CREATE INDEX names_alt_idx_nc ON names(alt_name COLLATE NOCASE)") dbCur.execute("CREATE TABLE eol_ids(id INT PRIMARY KEY, name TEXT)") +dbCur.execute("CREATE INDEX eol_name_idx ON eol_ids(name)") # Iterate through 'nodes' table, resolving to canonical-names usedPids = set() unresolvedNodeNames = set() -- cgit v1.2.3