Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 1200 → Rev 1199

/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);
}
}
}
/trunk/jrest/scripts/MigrationObs.php
136,9 → 136,8
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";
148,8 → 147,7
echo " ETAPE 4. Migration des observations ... \n\n";
echo "-------------------------------------------------------------------\n\n";
$this->migrerObs();
$this->mettreANullPrenomNomVide();
$this->ordonnerObs();
$this->ordonnerObs();
echo "\n"."\n"."\n";
}
 
633,18 → 631,5
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,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);
}
}