X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=ut%2Fcheckdb.php;h=47b30f2dead043feaf24aecdb4930b6b51ee7613;hb=f3d6e2cc6f0c3889adc9129adb3b66e5875bc462;hp=fb2c25fd84cd0a6ffd260047a0c90cf5c495ea7e;hpb=93b53499adec78fef5d823110e954c4fcc6c5a7c;p=platal.git diff --git a/ut/checkdb.php b/ut/checkdb.php index fb2c25f..47b30f2 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 @@ -92,9 +102,6 @@ class CheckDB extends PlTestCase 'profile_education_enum' => 'name', 'profile_education_field_enum' => 'field', 'profile_job_enum' => 'name', - 'profile_job_sector_enum' => 'name', - 'profile_job_subsector_enum' => 'name', - 'profile_job_subsubsector_enum' => 'name', 'profile_langskill_enum' => 'langue_fr', 'profile_medal_enum' => 'text', 'profile_name_enum' => 'name',