Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 123 | Rev 348 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 123 Rev 130
1 
<?php
 1 
<?php
2 
//declare(encoding='UTF-8');
 2 
//declare(encoding='UTF-8');
3 
/**
 3 
/**
4 
 * Exemple de lancement du script : :
 4 
 * Exemple de lancement du script : :
5 
 * /opt/lampp/bin/php cli.php cel -a chargerTous
 5 
 * /opt/lampp/bin/php cli.php cel -a chargerTous
6 
 *
 6 
 *
7 
 * @category	php 5.2
 7 
 * @category	php 5.2
8 
 * @package		eFlore/Scripts
 8 
 * @package		eFlore/Scripts
9 
 * @author		Jean-Pascal MILCENT <jpm@tela-botanica.org>
 9 
 * @author		Jean-Pascal MILCENT <jpm@tela-botanica.org>
10 
 * @copyright	Copyright (c) 2011, Tela Botanica (accueil@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
 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
 12 
 * @license		http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
13 
 * @version		$Id$
 13 
 * @version		$Id$
14 
 */
 14 
 */
15 
class Cel extends EfloreScript {
 15 
class Cel extends EfloreScript {
16 
 
 16 
 
17 
	public function executer() {
 17 
	public function executer() {
18 
		try {
 18 
		try {
19 
			$this->initialiserProjet('cel');
 19 
			$this->initialiserProjet('cel');
20 
 
 20 
 
21 
			// Lancement de l'action demandée
 21 
			// Lancement de l'action demandée
22 
			$cmd = $this->getParametre('a');
 22 
			$cmd = $this->getParametre('a');
23 
			switch ($cmd) {
 23 
			switch ($cmd) {
24 
				case 'chargerTous' :
 24 
				case 'chargerTous' :
25 
					$this->chargerStructureSql();
 25 
					$this->chargerStructureSql();
26 
					$this->chargerCel();
 26 
					$this->chargerCel();
27 
					break;
 27 
					break;
- 
 
 28 
				case 'supprimerTous' :
- 
 
 29 
					$this->supprimerTous();
- 
 
 30 
					break;
28 
				default :
 31 
				default :
29 
					throw new Exception("Erreur : la commande '$cmd' n'existe pas!");
 32 
					throw new Exception("Erreur : la commande '$cmd' n'existe pas!");
30 
			}
 33 
			}
31 
		} catch (Exception $e) {
 34 
		} catch (Exception $e) {
32 
			$this->traiterErreur($e->getMessage());
 35 
			$this->traiterErreur($e->getMessage());
33 
		}
 36 
		}
34 
	}
 37 
	}
35 
 
 38 
 
36 
	public function chargerCel() {
 39 
	public function chargerCel() {
37 
		$tablesCodes = array_keys(Config::get('tables'));
 40 
		$tablesCodes = array_keys(Config::get('tables'));
38 
		foreach ($tablesCodes as $code) {
 41 
		foreach ($tablesCodes as $code) {
39 
			echo "Chargement de la table : $code\n";
 42 
			echo "Chargement de la table : $code\n";
40 
			$this->chargerFichierTsvDansTable($code);
 43 
			$this->chargerFichierTsvDansTable($code);
41 
		}
 44 
		}
42 
	}
 45 
	}
43 
 
 46 
 
44 
	private function chargerFichierTsvDansTable($code) {
 47 
	private function chargerFichierTsvDansTable($code) {
45 
		$chemin = Config::get('chemins.'.$code);
 48 
		$chemin = Config::get('chemins.'.$code);
46 
		$table = Config::get('tables.'.$code);
 49 
		$table = Config::get('tables.'.$code);
47 
		$requete = "LOAD DATA INFILE '$chemin' ".
 50 
		$requete = "LOAD DATA INFILE '$chemin' ".
48 
			"REPLACE INTO TABLE $table ".
 51 
			"REPLACE INTO TABLE $table ".
49 
			'CHARACTER SET utf8 '.
 52 
			'CHARACTER SET utf8 '.
50 
			'FIELDS '.
 53 
			'FIELDS '.
51 
			"	TERMINATED BY '\t' ".
 54 
			"	TERMINATED BY '\t' ".
52 
			"	ENCLOSED BY '' ".
 55 
			"	ENCLOSED BY '' ".
53 
			"	ESCAPED BY '\\\' ".
 56 
			"	ESCAPED BY '\\\' ".
54 
			'IGNORE 1 LINES';
 57 
			'IGNORE 1 LINES';
55 
		$this->getBdd()->requeter($requete);
 58 
		$this->getBdd()->requeter($requete);
- 
 
 59 
	}
- 
 
 60 
 
- 
 
 61 
	private function supprimerTous() {
- 
 
 62 
		$requete = "DROP TABLE cel_images, cel_inventory, cel_mots_cles_images, cel_mots_cles_obs, cel_obs_images, locations";
- 
 
 63 
		$this->getBdd()->requeter($requete);
56 
	}
 64 
	}
57 
}
 65 
}
58 
?>
 66 
?>