1,6 → 1,6 |
<?php |
/** Exemple lancement: |
* /opt/lampp/bin/php -d memory_limit=3500M ~/web/eflore-projets/scripts/cli.php bdnt -a chargerTous |
* /opt/lampp/bin/php -d memory_limit=3500M cli.php vigie_flore -a chargerTous |
*/ |
class Photoflora extends EfloreScript { |
|
10,15 → 10,22 |
$this->initialiserProjet('photoflora'); |
|
$cmd = $this->getParametre('a'); |
switch ($cmd) { |
case 'chargerTous' : |
$this->chargerStructureSql(); |
break; |
case 'chargerStructureSql' : |
$this->chargerStructureSql(); |
break; |
case 'chargerOntologies' : |
switch ($cmd) { |
case 'chargerTous' : |
$this->chargerStructureSql(); |
$this->chargerDonnees(); |
$this->ajouterOntologie(); |
break; |
case 'chargerStructureSql' : |
$this->chargerStructureSql(); |
break; |
case 'chargerDonnees' : |
$this->chargerDonnees(); |
$this->ajouterOntologie(); |
break; |
case 'ajouterOntologie' : |
$this->ajouterOntologie(); |
break; |
case 'supprimerTous' : |
$this->supprimerTous(); |
break; |
28,11 → 35,33 |
} catch (Exception $e) { |
$this->traiterErreur($e->getMessage()); |
} |
} |
} |
|
protected function chargerDonnees() { |
$chemin = Config::get('chemins.donnees'); |
$table = Config::get('tables.donnees'); |
$requete = "LOAD DATA INFILE '$chemin' ". |
"REPLACE INTO TABLE $table ". |
'CHARACTER SET utf8 '. |
'FIELDS '. |
" TERMINATED BY '\t' ". |
" ENCLOSED BY '' ". |
" ESCAPED BY '\\\' ". |
'IGNORE 1 LINES'; |
$this->getBdd()->requeter($requete); |
} |
|
|
private function ajouterOntologie() { |
$requete = "INSERT INTO `eflore_ontologies` (`id`, `classe_id`, `nom`, `description`, `code`, `complements`) VALUES |
(26, 10, 'PhotoFlora', 'données issues de la <a href=\"http://www.photoflora.fr\" title=\"PhotoFlora\" onclick=\"window.open(this.href); return false;\">Base de données de photos de plantes essentiellement de la flore européenne</a> par Benoit BOCK avec les données de Jean-Luc TASSET, Christophe BODIN, Bernard TILLY...', 'PF', 'legende=#FFBD00');"; |
$this->getBdd()->requeter($requete); |
} |
|
private function supprimerTous() { |
$requete = "DROP TABLE IF EXISTS photoflora_meta"; |
$requete = "DROP TABLE IF EXISTS photoflora_meta;"; |
$this->getBdd()->requeter($requete); |
Debug::printr('suppression'); |
} |
} |
?> |