| New file |
|---|
| 0,0 → 1,111 |
|---|
| <?php |
| /** Exemple lancement: |
| * /opt/lampp/bin/php -d memory_limit=3500M ~/web/eflore-projets/scripts/cli.php baseveg -a chargerTous |
| */ |
| |
| class Baseveg extends EfloreScript { |
| |
| |
| |
| |
| |
| public function executer() { |
| try { |
| $this->initialiserProjet('baseveg'); |
| $cmd = $this->getParametre('a'); |
| switch ($cmd) { |
| case 'supprimerTous' : |
| $this->supprimerTous(); |
| break; |
| case 'chargerStructureSql' : |
| $this->chargerStructureSql(); |
| break; |
| case 'chargerMetadonnees' : |
| $this->chargerMetadonnees(); |
| break; |
| case 'chargerDonnees' : |
| $this->chargerDonnees(); |
| break; |
| case 'verifierFichier' : |
| //cette étape met en avant les valeurs qui vont poser des problèmes (ontologies..) |
| $this->verifierFichier(); |
| break; |
| case 'supprimerOntologies' : |
| $this->supprimerOntologies(); |
| break; |
| case 'chargerOntologies' : |
| $this->chargerOntologies(); |
| break; |
| case 'chargerTous' : |
| //$this->supprimerTous(); |
| $this->chargerStructureSql(); |
| $this->chargerMetadonnees(); |
| $this->chargerDonnees(); |
| $this->chargerOntologies(); |
| break; |
| default : |
| throw new Exception("Erreur : la commande '$cmd' n'existe pas!"); |
| } |
| } catch (Exception $e) { |
| $this->traiterErreur($e->getMessage()); |
| } |
| } |
| |
| |
| private function getClasseBasevegVerif() { |
| $conteneur = new Conteneur(); |
| require_once dirname(__FILE__)."/BasevegVerif.php"; |
| $verif = new BasevegVerif($conteneur,'baseveg'); |
| return $verif; |
| } |
| |
| private function verifierFichier() { |
| $verif = $this->getClasseBasevegVerif(); |
| $verif->verifierFichier(Config::get('chemins.donnees')); |
| } |
| |
| private function supprimerOntologies() { |
| $chemin = Config::get('chemins.ontologies'); |
| $table = Config::get('tables.ontologies'); |
| $requete = "TRUNCATE TABLE $table ;"; |
| $this->getBdd()->requeter($requete); |
| } |
| |
| private function chargerOntologies() { |
| $chemin = Config::get('chemins.ontologies'); |
| $table = Config::get('tables.ontologies'); |
| $requete = "LOAD DATA INFILE '$chemin' ". |
| "REPLACE INTO TABLE $table ". |
| 'CHARACTER SET utf8 '. |
| 'FIELDS '. |
| " TERMINATED BY '\t' ". |
| " ENCLOSED BY '' ". |
| " ESCAPED BY '\\\' " |
| ; |
| $this->getBdd()->requeter($requete); |
| } |
| |
| private function chargerDonnees() { |
| $table = Config::get('tables.donnees'); |
| $requete = "LOAD DATA INFILE '".Config::get('chemins.donnees')."' ". |
| "REPLACE INTO TABLE $table ". |
| 'CHARACTER SET utf8 '. |
| 'FIELDS '. |
| " TERMINATED BY '\t' ". |
| " ENCLOSED BY '' ". |
| " ESCAPED BY '\\\'"; |
| $this->getBdd()->requeter($requete); |
| } |
| |
| protected function chargerMetadonnees() { |
| $contenuSql = $this->recupererContenu(Config::get('chemins.metadonnees')); |
| $this->executerScripSql($contenuSql); |
| } |
| |
| private function supprimerTous() { |
| $requete = "DROP TABLE IF EXISTS baseveg_meta, baseveg_ontologies, baseveg_v".Config::get('version'); |
| $this->getBdd()->requeter($requete); |
| } |
| |
| } |
| ?> |