bin/build-master-status: only add not-yet-existent todos newly to database

1 files changed, 10 insertions, 1 deletions

diff --git a/bin/build-master-status b/bin/build-master-status
index ce49332..0e80bd6 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -584,7 +584,16 @@ if ${web}; then
       printf ';\n'
       printf 'INSERT IGNORE INTO `todos` (`file`,`line`,`description`) '
       printf 'SELECT `td`.`file`,`td`.`line`,`td`.`description` '
-      printf 'FROM `td`;\n'
+      printf 'FROM `td` '
+      printf 'WHERE NOT EXISTS ('
+      printf 'SELECT * FROM `todos`'
+      printf ' AND `td`.`%s`=`todos`.`%s`' \
+        'file' 'file' \
+        'line' 'line' \
+        'description' 'description' | \
+        sed 's/^ AND / WHERE /'
+      printf ');\n'
+
       printf 'DELETE FROM `todos` WHERE NOT EXISTS ('
       printf 'SELECT * FROM `td`'
       printf ' AND `td`.`%s`=`todos`.`%s`' \