15,7 → 15,6 |
$this->chargerStructureSql(); |
$this->chargerDonnees('especes'); |
$this->chargerDonnees('lois'); |
$this->genererChampNumNomRetenu(); |
break; |
case 'chargerStructureSql' : |
$this->chargerStructureSql(); |
23,11 → 22,7 |
case 'chargerDonnees' : |
$this->chargerDonnees('especes'); |
$this->chargerDonnees('lois'); |
$this->genererChampNumNomRetenu(); |
break; |
case 'genererChampNumNomRetenu' : |
$this->genererChampNumNomRetenu(); |
break; |
case 'supprimerTous' : |
$this->supprimerTous(); |
break; |
52,34 → 47,6 |
'IGNORE 1 LINES'; |
$this->getBdd()->requeter($requete); |
} |
|
private function genererChampNumNomRetenu() { |
$this->preparerTablePrChpNumNomRetenu(); |
$this->genererNumNomRetenu(); |
} |
|
private function preparerTablePrChpNumNomRetenu() { |
$table = Config::get('tables.especes'); |
$requete = "SHOW COLUMNS FROM $table LIKE 'num_nom_retenu' "; |
$resultat = $this->getBdd()->recuperer($requete); |
if ($resultat === false) { |
$requete = "ALTER TABLE $table ". |
'ADD num_nom_retenu INT(10) '. |
'NULL DEFAULT NULL AFTER num_nom'; |
$this->getBdd()->requeter($requete); |
} |
} |
|
private function genererNumNomRetenu() { |
$table = Config::get('tables.especes'); |
$table_referentiel = Config::get('tables.referentielTaxo'); |
|
$requete = 'UPDATE '.$table.' s, '.$table_referentiel.' r '. |
'SET s.num_nom_retenu = r.num_nom_retenu '. |
' WHERE s.num_nom = r.num_nom '; |
|
$this->getBdd()->requeter($requete); |
} |
|
private function supprimerTous() { |
$requete = "DROP TABLE IF EXISTS sptb_meta, sptb_especes_v2012, sptb_lois_v2012"; |