145,9 → 145,7 |
} |
|
private function unifierNull() { |
$requete_colonnes = "SELECT column_name FROM information_schema.columns WHERE table_name = '".$this->bd_cel.".cel_obs' AND table_schema='tb_cel';"; |
$colonnes = $this->bdd->recupererTous($requete_colonnes); |
foreach ($colonnes as $colonne) { |
foreach ($this->colonnes as $id=>$colonne) { |
echo "Suppression des vides dans la colonne ".$colonne['column_name']." ..."; |
$dsl = array( 'transmission', 'altitude'); |
if (isset($dsl[$colonne['column_name']])) { |
401,13 → 399,13 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'autre' WHERE `mots_cles_texte` like '%MobileSauvages%'"; |
$this->bdd->requeter($requete); |
|
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%Projets coopƩratifs%' and input_source = ''"; |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%Projets coopƩratifs%' and (input_source = '' OR input_source IS NULL)"; |
$this->bdd->requeter($requete); |
|
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%widget%' and input_source = ''"; |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%widget%' and (input_source = '' OR input_source IS NULL)"; |
$this->bdd->requeter($requete); |
|
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'cel' WHERE input_source = ''"; |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'cel' WHERE input_source = '' OR input_source IS NULL"; |
$this->bdd->requeter($requete); |
|
echo "Suppression motcle du chemin \n"; |