/trunk/jrest/scripts/MigrationObs.php |
---|
138,7 → 138,6 |
echo "-------------------------------------------------------------------\n\n"; |
$this->migrerUtilisateurs(); |
echo "-------------------------------------------------------------------\n\n"; |
echo " ETAPE 3. Migration des zone géographiques ... \n\n"; |
echo "-------------------------------------------------------------------\n\n"; |
148,7 → 147,6 |
echo " ETAPE 4. Migration des observations ... \n\n"; |
echo "-------------------------------------------------------------------\n\n"; |
$this->migrerObs(); |
$this->mettreANullPrenomNomVide(); |
$this->ordonnerObs(); |
echo "\n"."\n"."\n"; |
} |
634,17 → 632,4 |
// vérification bidon mais ça suffit pour ici |
return !(strpos('@', $mail) === false); |
} |
private function mettreANullPrenomNomVide() { |
$bdd = self::$bdd_cel_migration; |
$requete = "UPDATE $bdd.cel_obs ". |
'SET prenom_utilisateur = NULL '. |
"WHERE prenom_utilisateur = '' "; |
$this->executer($requete); |
$requete = "UPDATE $bdd.cel_obs ". |
'SET nom_utilisateur = NULL '. |
"WHERE nom_utilisateur = '' "; |
$this->executer($requete); |
} |
} |
/trunk/jrest/scripts/MigrationImages.php |
---|
685,7 → 685,6 |
echo " ETAPE 2. Migration des images ... \n\n"; |
echo "-------------------------------------------------------------------\n\n"; |
$this->migrerImages(); |
$this->mettreANullPrenomNomVide(); |
$this->ordonnerImages(); |
echo "\n"."\n"."\n"; |
1055,17 → 1054,4 |
echo "\n"; |
echo "\n---------------------------------------------------------------- OK\n\n"; |
} |
private function mettreANullPrenomNomVide() { |
$bdd = self::$bdd_cel_migration; |
$requete = "UPDATE $bdd.cel_images ". |
'SET prenom_utilisateur = NULL '. |
"WHERE prenom_utilisateur = '' "; |
$this->executer($requete); |
$requete = "UPDATE $bdd.cel_images ". |
'SET nom_utilisateur = NULL '. |
"WHERE nom_utilisateur = '' "; |
$this->executer($requete); |
} |
} |
/trunk/jrest/scripts/MigrationMotsCles.php |
---|
79,7 → 79,6 |
echo "-------------------------------------------------------------------\n"; |
$this->genererIndexTexteMotsClesObs(); |
$this->genererIndexTexteMotsClesImages(); |
$this->mettreANullMotsClesTxtVide(); |
echo "\n"."\n"."\n"; |
} |
403,16 → 402,4 |
return $this->executer($requete); |
} |
private function mettreANullMotsClesTxtVide() { |
$bdd = self::$bdd_cel_migration; |
$tables = array('cel_obs', 'cel_images'); |
foreach ($tables as $table) { |
$requete = "UPDATE $bdd.$table ". |
'SET mots_cles_texte = NULL '. |
"WHERE mots_cles_texte = '' "; |
$this->executer($requete); |
} |
} |
} |