/trunk/jrest/scripts/MigrationObs.php |
---|
136,8 → 136,9 |
echo "-------------------------------------------------------------------\n\n"; |
echo " ETAPE 2. Migration des utilisateurs ... \n\n"; |
echo "-------------------------------------------------------------------\n\n"; |
$this->migrerUtilisateurs(); |
$this->migrerUtilisateurs(); |
echo "-------------------------------------------------------------------\n\n"; |
echo " ETAPE 3. Migration des zone géographiques ... \n\n"; |
echo "-------------------------------------------------------------------\n\n"; |
147,7 → 148,8 |
echo " ETAPE 4. Migration des observations ... \n\n"; |
echo "-------------------------------------------------------------------\n\n"; |
$this->migrerObs(); |
$this->ordonnerObs(); |
$this->mettreANullPrenomNomVide(); |
$this->ordonnerObs(); |
echo "\n"."\n"."\n"; |
} |
631,5 → 633,18 |
public function mailValide($mail) { |
// 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,6 → 685,7 |
echo " ETAPE 2. Migration des images ... \n\n"; |
echo "-------------------------------------------------------------------\n\n"; |
$this->migrerImages(); |
$this->mettreANullPrenomNomVide(); |
$this->ordonnerImages(); |
echo "\n"."\n"."\n"; |
1054,4 → 1055,17 |
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,6 → 79,7 |
echo "-------------------------------------------------------------------\n"; |
$this->genererIndexTexteMotsClesObs(); |
$this->genererIndexTexteMotsClesImages(); |
$this->mettreANullMotsClesTxtVide(); |
echo "\n"."\n"."\n"; |
} |
402,4 → 403,16 |
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); |
} |
} |
} |