| 48,6 → 48,7 |
|---|
| $this->verifierCodeInsee(); |
| $this->verifierGeodatum(); |
| $this->analyserMotsCles(); |
| $this->changerSensible(); |
| $this->supprimerInfosLiesObsInexistante(); |
| $this->unifierNull(); |
| break; |
| 78,6 → 79,9 |
|---|
| case 'verifierCodeInsee' : |
| $this->verifierCodeInsee(); |
| break; |
| case 'sensible' : |
| $this->changerSensible(); |
| break; |
| case 'unifierNull' : // lancer en dernier pour bien réussir |
| $this->unifierNull(); |
| break; |
| 415,4 → 419,13 |
|---|
| WHERE `mots_cles_texte` LIKE '%adeterminer%'"; |
| $this->bdd->requeter($requete); |
| } |
| |
| private function changerSensible(){ |
| echo "Sensible \n"; |
| $requete = "ALTER TABLE tb_nettoye_cel`cel_obs` ADD `published_location` int(1)"; |
| $this->bdd->requeter($requete); |
| |
| $requete = "UPDATE tb_nettoye_cel.cel_obs SET published_location = '1' WHERE `mots_cles_texte` like '%sensible%'"; |
| $this->bdd->requeter($requete); |
| } |
| } |