diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-05-17 12:11:53 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-05-17 12:11:53 +1000 |
| commit | a92a3574b3e4a92850b8542502dcf3836b1501cd (patch) | |
| tree | 5081368695298a26a626b837c9a2f0c14d5a334e /backend/data/genOtolData.py | |
| parent | 8637a64a059188935e95f57df9fc4132a6ae57a9 (diff) | |
Make search suggestions include non-alt-names
Diffstat (limited to 'backend/data/genOtolData.py')
| -rwxr-xr-x | backend/data/genOtolData.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/data/genOtolData.py b/backend/data/genOtolData.py index 2ae154d..d1567d3 100755 --- a/backend/data/genOtolData.py +++ b/backend/data/genOtolData.py @@ -210,6 +210,7 @@ print("Creating nodes and edges tables") dbCon = sqlite3.connect(dbFile) dbCur = dbCon.cursor() dbCur.execute("CREATE TABLE nodes (name TEXT PRIMARY KEY, tips INT)") +dbCur.execute("CREATE INDEX nodes_idx_nc ON nodes(name COLLATE NOCASE)") dbCur.execute("CREATE TABLE edges (node TEXT, child TEXT, p_support INT, PRIMARY KEY (node, child))") dbCur.execute("CREATE INDEX edges_child_idx ON edges(child)") for node in nodeMap.values(): |