diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-05-15 00:46:39 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-05-15 16:43:22 +1000 |
| commit | a4673571570816a06d4188169fc00dada79ec0a3 (patch) | |
| tree | 468c5bcf4fe8ecbb64ba2e472d6f908c35f3ee5b /backend/data/genEolNameData.py | |
| parent | 9a647b3fe26b9928c254003446b96e9ea0ea70e1 (diff) | |
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.
Diffstat (limited to 'backend/data/genEolNameData.py')
| -rwxr-xr-x | backend/data/genEolNameData.py | 3 |
1 files changed, 3 insertions, 0 deletions
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() |