Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev Author Line No. Line
292 jpm 1 
<?php
2 
//declare(encoding='UTF-8');
3 
/**
4 
 * Exemple de lancement du script : :
5 
 * /opt/lampp/bin/php cli.php coste -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) 2012, 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 Coste extends EfloreScript {
16 
 
17 
	public function executer() {
18 
		try {
19 
			$this->initialiserProjet('coste');
20 
 
21 
			// Lancement de l'action demandée
22 
			$cmd = $this->getParametre('a');
23 
			switch ($cmd) {
24 
				case 'chargerTous' :
25 
					$this->chargerStructureSql();
26 
					$this->chargerVersions();
27 
					break;
28 
				case 'chargerStructureSql' :
29 
					$this->chargerStructureSql();
30 
					break;
31 
				case 'chargerVersions' :
32 
					$this->chargerVersions();
33 
					break;
34 
				case 'supprimerTous' :
35 
					$this->supprimerTous();
36 
					break;
37 
				case 'creerV1' :
38 
					$this->creerVersion1();
39 
					break;
40 
				case 'nettoyerV1' :
41 
					$this->nettoyerVersion1();
42 
					break;
43 
				default :
44 
					throw new Exception("Erreur : la commande '$cmd' n'existe pas!");
45 
			}
46 
		} catch (Exception $e) {
47 
			$this->traiterErreur($e->getMessage());
48 
		}
49 
	}
50 
 
51 
	private function chargerVersions() {
52 
		$versions = explode(',', Config::get('versions'));
53 
		$versionsDonnees = explode(',', Config::get('versionsDonnees'));
54 
		foreach ($versions as $id => $version) {
55 
			$versionDonnees = $versionsDonnees[$id];
56 
			$this->chargerStructureSqlVersion($versionDonnees, $version);
57 
			$this->chargerIndexVersion($versionDonnees, $version);
58 
			$this->chargerDumpWikiniVersion($versionDonnees, $version);
59 
		}
60 
	}
61 
 
62 
	private function chargerStructureSqlVersion($versionDonnees, $version) {
63 
		$fichierSqlTpl = Config::get('chemins.structureSqlVersionTpl');
64 
		$fichierSql = sprintf($fichierSqlTpl, $versionDonnees, $version);
65 
		$contenuSql = $this->recupererContenu($fichierSql);
66 
		$this->executerScripSql($contenuSql);
67 
	}
68 
 
69 
	private function chargerIndexVersion($versionDonnees, $version) {
70 
		$fichierTsvTpl = Config::get('chemins.costeTpl');
71 
		$fichierTsv = sprintf($fichierTsvTpl, $versionDonnees, $version);
72 
		$tableTpl = Config::get('tables.costeTpl');
73 
		$table = sprintf($tableTpl, $version);
74 
		$requete = "LOAD DATA INFILE '$fichierTsv' ".
75 
			"REPLACE INTO TABLE $table ".
76 
			'CHARACTER SET utf8 '.
77 
			'FIELDS '.
78 
			"	TERMINATED BY '\t' ".
79 
			"	ENCLOSED BY '' ".
80 
			"	ESCAPED BY '\\\' ".
81 
			'IGNORE 1 LINES ';
82 
		$this->getBdd()->requeter($requete);
83 
	}
84 
 
85 
	private function chargerDumpWikiniVersion($versionDonnees, $version) {
86 
		$fichierWikiTpl = Config::get('chemins.costeWikiniTpl');
87 
		$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version);
88 
		$contenuSql = $this->recupererContenu($fichierDump);
89 
		$this->executerScripSql($contenuSql);
90 
	}
91 
 
92 
	private function supprimerTous() {
351 jpm 93 
		$requete = "DROP TABLE IF EXISTS coste_meta, ".
292 jpm 94 
			"	coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".
95 
			"	coste_v1_00 ";
96 
		$this->getBdd()->requeter($requete);
97 
	}
98 
 
99 
	private function nettoyerVersion1() {
351 jpm 100 
		$requete = "DROP TABLE IF EXISTS coste_correspondance_bdnff, coste_images_auteur_correspondance_bdnff, ".
292 jpm 101 
			"	coste_images_correspondance_bdnff, coste_index, coste_index_general";
102 
		$this->getBdd()->requeter($requete);
103 
	}
104 
 
105 
	private function creerVersion1() {
106 
		$this->chargerStructureSqlVersion('0.00', '0_00');
107 
		$this->chargerCosteImagesAuteurCorrespondanceBdnff();
108 
		$this->chargerCosteCorrespondanceBdnff();
109 
	}
110 
 
111 
	private function chargerCosteImagesAuteurCorrespondanceBdnff() {
112 
		$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_auteur_correspondance_bdnff.tsv';
113 
		$requete = "LOAD DATA INFILE '$fichierTsv' ".
114 
				"REPLACE INTO TABLE coste_images_auteur_correspondance_bdnff ".
115 
				'CHARACTER SET utf8 '.
116 
				'FIELDS '.
117 
				"	TERMINATED BY '\t' ".
118 
				"	ENCLOSED BY '\"' ".
119 
				"	ESCAPED BY '\\\' ".
120 
				'IGNORE 1 LINES ';
121 
		$this->getBdd()->requeter($requete);
122 
	}
123 
 
124 
	private function chargerCosteCorrespondanceBdnff() {
125 
		$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_correspondance_bdnff.tsv';
126 
		$requete = "LOAD DATA INFILE '$fichierTsv' ".
127 
					"REPLACE INTO TABLE coste_images_correspondance_bdnff ".
128 
					'CHARACTER SET utf8 '.
129 
					'FIELDS '.
130 
					"	TERMINATED BY '\t' ".
131 
					"	ENCLOSED BY '' ".
132 
					"	ESCAPED BY '\\\' ".
133 
					'IGNORE 1 LINES ';
134 
		$this->getBdd()->requeter($requete);
135 
	}
136 
}
137 
?>