Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xbin/build-master-status11
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`' \