Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 299 | Rev 349 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
297 gduche 1
<?php
2
//declare(encoding='UTF-8');
3
/**
4
 * Exemple de lancement du script : :
5
 * /opt/lampp/bin/php cli.php cel -a chargerTous
6
 *
7
 * @category	php 5.2
8
 * @package		eFlore/Scripts
9
 * @author		Jean-Pascal MILCENT <jpm@tela-botanica.org>
10
 * @copyright	Copyright (c) 2011, Tela Botanica (accueil@tela-botanica.org)
11
 * @license		http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
12
 * @license		http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
13
 * @version		$Id$
14
 */
15
class BiblioBota extends EfloreScript {
16
 
17
	public function executer() {
18
		try {
19
			$this->initialiserProjet('biblio_bota');
20
 
21
			// Lancement de l'action demandée
22
			$cmd = $this->getParametre('a');
23
			switch ($cmd) {
24
				case 'chargerTous' :
25
					$this->chargerStructureSql();
26
					$this->chargerBiblioBota();
27
					break;
28
				case 'supprimerTous' :
29
					$this->supprimerTous();
30
					break;
31
				default :
32
					throw new Exception("Erreur : la commande '$cmd' n'existe pas!");
33
			}
34
		} catch (Exception $e) {
35
			$this->traiterErreur($e->getMessage());
36
		}
37
	}
38
 
39
	public function chargerBiblioBota() {
40
		$tablesCodes = array_keys(Config::get('tables'));
41
		foreach ($tablesCodes as $code) {
42
			echo "Chargement de la table : $code\n";
43
			$this->chargerFichierTsvDansTable($code);
44
		}
45
	}
46
 
47
	private function chargerFichierTsvDansTable($code) {
48
		$chemin = Config::get('chemins.'.$code);
49
		$table = Config::get('tables.'.$code);
50
		$requete = "LOAD DATA INFILE '$chemin' ".
51
			"REPLACE INTO TABLE $table ".
52
			'CHARACTER SET utf8 '.
53
			'FIELDS '.
54
			"	TERMINATED BY '\t' ".
299 gduche 55
			"	ENCLOSED BY '\"' ".
300 gduche 56
			"	ESCAPED BY '\\\' ";
297 gduche 57
		$this->getBdd()->requeter($requete);
58
	}
59
 
60
	private function supprimerTous() {
61
		$requete = "DROP TABLE `biblio_article`, `biblio_article_sauv`, `biblio_aut_saisie`, `biblio_collection`, `biblio_domaine`, `biblio_domaine_lier`, `biblio_domaine_lier_sauv`, `biblio_fasc`, `biblio_fasc_sauv`, `biblio_item`, `biblio_item_sauv`, `biblio_item_typlog`, `biblio_item_typphy`, `biblio_link`, `biblio_link_categ`, `biblio_link_categoriser`, `biblio_link_sauv`, `biblio_media`, `biblio_modif`, `biblio_serie`, `biblio_spy`, `biblio_str`, `biblio_str_sauve`, `biblio_str_type`";
62
		$this->getBdd()->requeter($requete);
63
	}
64
}
65
?>