diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-06-15 00:23:23 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-06-15 00:23:23 +1000 |
| commit | 025f5b6cb96dba346b2c4d4ca159a5a6a7eb04c4 (patch) | |
| tree | eaac30a67b9a47fcedbf10ec8f55404aa51a9cb6 /backend/data/genEolNameData.py | |
| parent | 88376b3bb7f9072d5fcc83d63eaf425e9b21b77e (diff) | |
Add 'src' field to 'names' table
Diffstat (limited to 'backend/data/genEolNameData.py')
| -rwxr-xr-x | backend/data/genEolNameData.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/data/genEolNameData.py b/backend/data/genEolNameData.py index 1b80dd8..74b0e3d 100755 --- a/backend/data/genEolNameData.py +++ b/backend/data/genEolNameData.py @@ -76,7 +76,7 @@ print(f"Found {len(nameToPickedPid)}") 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 TABLE names(name TEXT, alt_name TEXT, pref_alt INT, src TEXT, 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)") @@ -94,7 +94,7 @@ def addToDb(nodeName, pidToUse): altNames.add(n) for n in altNames: isPreferred = 1 if (n == preferredName) else 0 - dbCur.execute("INSERT INTO names VALUES (?, ?, ?)", (nodeName, n, isPreferred)) + dbCur.execute("INSERT INTO names VALUES (?, ?, ?, 'eol')", (nodeName, n, isPreferred)) for name in nameToPickedPid: # Add manually-picked pids pickedPid = nameToPickedPid[name] usedPids.add(pickedPid) |