Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 2935 → Rev 2936

/trunk/scripts/modules/nettoyage/Nettoyage.php
22,6 → 22,7
class Nettoyage extends Script {
 
protected $bdd;
protected $colonnes;
 
 
public function __construct($script_nom, $parametres_cli) {
31,10 → 32,14
 
public function executer() {
$cmd = $this->getParametre('a');
$requete_colonnes = "SELECT column_name FROM information_schema.columns WHERE table_name = 'cel_obs' AND table_schema='tb_cel';";
$this->colonnes = $this->bdd->recupererTous($requete_colonnes);
try {
switch ($cmd) {
case 'tout' :
$this->supprimerRetourLigne();
$this->supprimerAntislash();
$this->supprimerGuillement();
$this->unifierNomReferentiel();
$this->unifierCertitude();
$this->verifierGeodatum();
73,18 → 78,33
}
 
private function supprimerRetourLigne() {
foreach ($this->colonnes as $id=>$colonne) {
echo "Suppression des retour ligne dans la colonne ".$colonne['column_name']." ...";
$requete = "UPDATE cel_obs SET ".$colonne['column_name']." = REPLACE(".$colonne['column_name'].', "\n", "")';
$this->bdd->requeter($requete);
echo "effectuée \n";
}
}
private function supprimerAntislash() {
$requete_colonnes = "SELECT column_name FROM information_schema.columns WHERE table_name = 'cel_obs' AND table_schema='tb_cel';";
$colonnes = $this->bdd->recupererTous($requete_colonnes);
foreach ($colonnes as $id=>$colonne) {
foreach ($this->colonnes as $id=>$colonne) {
echo "Suppression des antislash dans la colonne ".$colonne['column_name']." ...";
$requete = "UPDATE cel_obs SET ".$colonne['column_name']." = REPLACE(".$colonne['column_name'].', "\\\", "")';
$requete = "UPDATE cel_obs SET ".$colonne['column_name']." = REPLACE(".$colonne['column_name'].', "\", "")';
$this->bdd->requeter($requete);
echo "effectuée \n";
}
}
private function supprimerGuillemet() {
foreach ($this->colonnes as $id=>$colonne) {
echo "Suppression des guillements dans la colonne ".$colonne['column_name']." ...";
$requete = "UPDATE cel_obs SET ".$colonne['column_name']." = REPLACE(".$colonne['column_name'].',"\"", "")';
$this->bdd->requeter($requete);
echo "effectuée \n";
}
}
private function unifierNull() {
$requete_colonnes = "SELECT column_name FROM information_schema.columns WHERE table_name = 'cel_obs' AND table_schema='tb_cel';";
$colonnes = $this->bdd->recupererTous($requete_colonnes);