diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-06-19 19:30:53 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-06-19 19:31:31 +1000 |
| commit | fb8a1874b549aa8df755880ba8d013684ab7d1c1 (patch) | |
| tree | 95586173ba0b2641911ac4f9a02f8916bb3d812c /backend | |
| parent | 71246f7ee116fac94396b2fd1e3c48623851a5f3 (diff) | |
Make addPickedNames.py avoid redundant updates
Diffstat (limited to 'backend')
| -rwxr-xr-x | backend/data/addPickedNames.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/backend/data/addPickedNames.py b/backend/data/addPickedNames.py index b231ab7..3ef099a 100755 --- a/backend/data/addPickedNames.py +++ b/backend/data/addPickedNames.py @@ -29,7 +29,8 @@ with open(pickedNamesFile) as file: if prefAlt == 1: query = "SELECT name, alt_name FROM names WHERE name = ? AND pref_alt = 1" row = dbCur.execute(query, (nodeName,)).fetchone() - if row != None: + if row != None and row[1] != altName: + print(f"Removing pref-alt status from alt-name {row[1]} for {nodeName}") dbCur.execute("UPDATE names SET pref_alt = 0 WHERE name = ? AND alt_name = ?", row) # Check for an existing record if nodeName == altName: @@ -37,10 +38,12 @@ with open(pickedNamesFile) as file: query = "SELECT name, alt_name, pref_alt FROM names WHERE name = ? AND alt_name = ?" row = dbCur.execute(query, (nodeName, altName)).fetchone() if row == None: + print(f"Adding record for alt-name {altName} for {nodeName}") dbCur.execute("INSERT INTO names VALUES (?, ?, ?, 'picked')", (nodeName, altName, prefAlt)) else: # Update existing record if row[2] != prefAlt: + print(f"Updating record for alt-name {altName} for {nodeName}") dbCur.execute("UPDATE names SET pref_alt = ?, src = 'picked' WHERE name = ? AND alt_name = ?", (prefAlt, nodeName, altName)) # Close db |