From 27106d9e0c70524a42cad4b2d662177c8490c174 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 4 Feb 2018 12:07:03 +0100 Subject: bin/build-master-status: only add not-yet-existent todos newly to database --- bin/build-master-status | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'bin/build-master-status') 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`' \ -- cgit v1.2.3