33,7 → 33,6 |
$this->chargerBdtxa(); |
$this->genererChpNomSciHtml(); |
$this->genererChpFamille(); |
$this->genererChpNomComplet(); |
break; |
case 'chargerStructureSql' : |
$this->chargerStructureSql(); |
129,31 → 128,6 |
throw new Exception("Erreur d'insertion pour le tuple $id"); |
} |
} |
} |
|
private function genererChpNomComplet() { |
$this->preparerTablePrChpNomComplet(); |
$this->remplirChpNomComplet(); |
} |
|
private function preparerTablePrChpNomComplet() { |
$requete = "SHOW COLUMNS FROM {$this->table} LIKE 'nom_complet' "; |
$resultat = $this->getBdd()->recuperer($requete); |
if ($resultat === false) { |
$requete = "ALTER TABLE {$this->table} ". |
'ADD nom_complet VARCHAR( 500 ) '. |
'CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL '; |
$this->getBdd()->requeter($requete); |
} |
} |
|
private function remplirChpNomComplet() { |
$this->afficherAvancement("Attribution du champ nom complet au taxons"); |
$requete = "UPDATE {$this->table} SET nom_complet = CONCAT(nom_sci,' ',auteur)"; |
$resultat = $this->getBdd()->requeter($requete); |
if ($resultat === false) { |
throw new Exception("Erreur de génération du champ nom complet"); |
} |
} |
|
private function genererChpFamille() { |