| 36,6 → 36,7 |
|---|
| $this->genererChpFamille(); |
| $this->genererDonneesTestMultiVersion(); |
| $this->genererChpHierarchie(); |
| $this->genererBDTFXReduit(); |
| break; |
| case 'chargerStructureSql' : |
| $this->chargerStructureSql(); |
| 55,6 → 56,9 |
|---|
| case 'genererDonneesTestMultiVersion' : |
| $this->genererDonneesTestMultiVersion(); |
| break; |
| case 'genererBDTFXR' : |
| $this->genererBDTFXReduit(); |
| break; |
| case 'supprimerDonneesTestMultiVersion' : |
| $this->supprimerDonneesTestMultiVersion(); |
| break; |
| 326,6 → 330,24 |
|---|
| $requete = "DROP TABLE IF EXISTS $tableTest"; |
| $this->getBdd()->requeter($requete); |
| } |
| |
| private function genererBDTFXReduit() { |
| $table = Config::get('tables.bdtfx'); |
| $version = Config::get('version'); |
| |
| $requete = "create table bdtfxr_v".$version." as (SELECT * |
| FROM ".$table." |
| WHERE |
| (`presence` = 'P' AND num_nom = num_nom_retenu) |
| OR |
| (`flore_bonnier_num` != '' OR `flore_cnrs_num` != '' OR `flore_coste_num` != '' |
| OR `flore_fournier_num` != '' OR `flore_fg_num` != ''))"; |
| $table = $this->getBdd()->requeter($requete); |
| |
| $requete_meta = "INSERT INTO `bdtfxr_meta`(`guid`, `langue_meta`, `code`, `version`, `titre`, `description`, `mots_cles`, `citation`, `url_tech`, `url_projet`, `source`, `createurs`, `editeur`, `contributeurs`, `droits`, `url_droits`, `langue`, `date_creation`, `date_validite`, `couverture_spatiale`, `couverture_temporelle`, `web_services`) ". |
| " SELECT * FROM `bdtfx_meta` WHERE `version` = '".str_replace('_', '.', $version)."'"; |
| $meta = $this->getBdd()->requeter($requete_meta); |
| } |
| |
| private function supprimerTous() { |
| $requete = "DROP TABLE IF EXISTS bdtfx_meta, bdtfx_v1_01, bdtfx_v1_02"; |