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"; |