| 33,6 → 33,7 |
|---|
| $this->chargerBdtxa(); |
| $this->genererChpNomSciHtml(); |
| $this->genererChpFamille(); |
| $this->genererChpNomComplet(); |
| break; |
| case 'chargerStructureSql' : |
| $this->chargerStructureSql(); |
| 128,6 → 129,31 |
|---|
| 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() { |