From 16ab1e34ebd7327b454e16c7212e0c7891ecf35f Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Fri, 15 Oct 2010 15:47:50 +0200 Subject: [PATCH] Adds crons to checked if there are remaining issues due to the merge. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- bin/cron/checkdb.php | 6 ++++++ bin/cron/clean.php | 4 ++++ 2 files changed, 10 insertions(+) diff --git a/bin/cron/checkdb.php b/bin/cron/checkdb.php index a82dfbc..721e5ea 100755 --- a/bin/cron/checkdb.php +++ b/bin/cron/checkdb.php @@ -112,5 +112,11 @@ check("SELECT a.alias AS username, b.alias AS loginbis, b.expire WHERE a.type = 'a_vie'", "Donne la liste des homonymes qui ont un alias égal à leur loginbis depuis plus d'un mois, il est temps de supprimer leur alias."); +// XXX: counts the number of remaining issues due to the merge (to be removed once all merge related issues have been fixed) +check('SELECT COUNT(*) + FROM profile_merge_issues + WHERE issues IS NULL OR issues = \'\'', + 'Dénombre les erreurs dues à la fusion restantes.'); + // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?> diff --git a/bin/cron/clean.php b/bin/cron/clean.php index 153da31..84fade9 100755 --- a/bin/cron/clean.php +++ b/bin/cron/clean.php @@ -62,5 +62,9 @@ query('ALTER TABLE profile_skill_enum query('DELETE FROM search_autocomplete WHERE generated < DATE_SUB(NOW(), INTERVAL 1 DAY)'); +// XXX: cleans profile_merge_issues (to be removed once all merge related issues have been fixed) +query('DELETE FROM profile_merge_issues + WHERE issues IS NULL OR issues = \'\''); + // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?> -- 2.1.4