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); |