X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=ut%2Fcheckdb.php;h=90b05de53287a9994e5f5ef5a4bfe5886cbe91f0;hb=c76545c351fae4e2298624ff9ee5bf854dc5a5b6;hp=fb2c25fd84cd0a6ffd260047a0c90cf5c495ea7e;hpb=93b53499adec78fef5d823110e954c4fcc6c5a7c;p=platal.git

diff --git a/ut/checkdb.php b/ut/checkdb.php
index fb2c25f..90b05de 100644
--- a/ut/checkdb.php
+++ b/ut/checkdb.php
@@ -69,6 +69,16 @@ class CheckDB extends PlTestCase
                     LEFT JOIN  geoloc_countries  AS gc ON (pa.countryId = gc.iso_3166_1_a2)
                         WHERE  gc.countryFR IS NULL OR gc.countryFR = \'\''),
 
+            'missing nationalities' =>
+                array('SELECT  p.pid, p.nationality1, p.nationality2, p.nationality3
+                         FROM  profiles         AS p
+                    LEFT JOIN  geoloc_countries AS g1 ON (p.nationality1 = g1.iso_3166_1_a2)
+                    LEFT JOIN  geoloc_countries AS g2 ON (p.nationality2 = g2.iso_3166_1_a2)
+                    LEFT JOIN  geoloc_countries AS g3 ON (p.nationality3 = g3.iso_3166_1_a2)
+                        WHERE  (p.nationality1 IS NOT NULL AND (g1.nationalityFR IS NULL OR g1.nationalityFR = \'\'))
+                               OR (p.nationality2 IS NOT NULL AND (g2.nationalityFR IS NULL OR g2.nationalityFR = \'\'))
+                               OR (p.nationality3 IS NOT NULL AND (g3.nationalityFR IS NULL OR g3.nationalityFR = \'\'))'),
+
             'ax_id' =>
                 array('SELECT  pid, hrpid, ax_id, COUNT(ax_id) AS c
                          FROM  profiles