WebSVN – eFlore/Projets.eflore-projets – Diff – /trunk/scripts/modules/coste/Coste.php


<?php
//declare(encoding='UTF-8');
/**
 * Exemple de lancement du script : :
 * /opt/lampp/bin/php cli.php coste -a chargerTous
 *
 * @category	php 5.2
 * @package		eFlore/Scripts
 * @author		Jean-Pascal MILCENT <jpm@tela-botanica.org>
 * @copyright	Copyright (c) 2012, Tela Botanica (accueil@tela-botanica.org)
 * @license		http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
 * @license		http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
 * @version		$Id$
 */
class Coste extends EfloreScript {
 
	public function executer() {
		try {
			$this->initialiserProjet('coste');
 
			// Lancement de l'action demandée
			$cmd = $this->getParametre('a');
			switch ($cmd) {
				case 'chargerTous' :
					$this->chargerStructureSql();
					$this->chargerVersions();
					break;
				case 'chargerStructureSql' :
					$this->chargerStructureSql();
					break;
				case 'chargerVersions' :
					$this->chargerVersions();
					break;
				case 'supprimerTous' :
					$this->supprimerTous();
					break;
				case 'creerV1' :
					$this->creerVersion1();
					break;
				case 'nettoyerV1' :
					$this->nettoyerVersion1();
					break;
				case 'creerDscTxt' :
					$this->creerDescriptionTxt();
					break;
				case 'statDscTxt' :
					$this->verifierDescriptionTxt();
					break;
				case 'correspondanceDsc' :
					$this->genererCorrespondanceDescription();
					break;
				case 'fusionIndex' :
					$this->fusionnerIndex();
					break;
				default :
					throw new Exception("Erreur : la commande '$cmd' n'existe pas!");
			}
		} catch (Exception $e) {
			$this->traiterErreur($e->getMessage());
		}
	}
 
	private function chargerVersions() {
		$versions = explode(',', Config::get('versions'));
		$versionsDonnees = explode(',', Config::get('versionsDonnees'));
		foreach ($versions as $id => $version) {
			$versionDonnees = $versionsDonnees[$id];
			$this->chargerStructureSqlVersion($versionDonnees, $version);
			$this->chargerIndexVersion($versionDonnees, $version);
			$this->chargerDumpWikiniVersion($versionDonnees, $version);
		}
	}
 
	private function chargerStructureSqlVersion($versionDonnees, $version) {
		$fichierSqlTpl = Config::get('chemins.structureSqlVersionTpl');
		$fichierSql = sprintf($fichierSqlTpl, $versionDonnees, $version);
		$contenuSql = $this->recupererContenu($fichierSql);
		$this->executerScripSql($contenuSql);
	}
 
	private function chargerIndexVersion($versionDonnees, $version) {
		$fichierTsvTpl = Config::get('chemins.costeTpl');
		$fichierTsv = sprintf($fichierTsvTpl, $versionDonnees, $version);
		$tableTpl = Config::get('tables.costeTpl');
		$table = sprintf($tableTpl, $version);
		$requete = "LOAD DATA INFILE '$fichierTsv' ".
			"REPLACE INTO TABLE $table ".
			'CHARACTER SET utf8 '.
			'FIELDS '.
			"	TERMINATED BY '\t' ".
			"	ENCLOSED BY '' ".
			"	ESCAPED BY '\\\' ".
			'IGNORE 1 LINES ';
		$this->getBdd()->requeter($requete);
	}
 
	private function chargerDumpWikiniVersion($versionDonnees, $version) {
		$fichierWikiTpl = Config::get('chemins.costeWikiniTpl');
		$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version);
		$contenuSql = $this->recupererContenu($fichierDump);
		$this->executerScripSql($contenuSql);
	}
 
	private function supprimerTous() {
		$requete = "DROP TABLE IF EXISTS coste_meta, ".
			"	coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".
			"	coste_v1_00 ";
		$this->getBdd()->requeter($requete);
	}
 
	private function nettoyerVersion1() {
		$requete = "DROP TABLE IF EXISTS coste_correspondance_bdnff, coste_images_auteur_correspondance_bdnff, ".
			"	coste_images_correspondance_bdnff, coste_index, coste_index_general";
		$this->getBdd()->requeter($requete);
	}
 
	private function creerVersion1() {
		$this->chargerStructureSqlVersion('0.00', '0_00');
		$this->chargerCosteImagesAuteurCorrespondanceBdnff();
		$this->chargerCosteCorrespondanceBdnff();
	}
 
	private function chargerCosteImagesAuteurCorrespondanceBdnff() {
		$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_auteur_correspondance_bdnff.tsv';
		$requete = "LOAD DATA INFILE '$fichierTsv' ".
				"REPLACE INTO TABLE coste_images_auteur_correspondance_bdnff ".
				'CHARACTER SET utf8 '.
				'FIELDS '.
				"	TERMINATED BY '\t' ".
				"	ENCLOSED BY '\"' ".
				"	ESCAPED BY '\\\' ".
				'IGNORE 1 LINES ';
		$this->getBdd()->requeter($requete);
	}
 
	private function chargerCosteCorrespondanceBdnff() {
		$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_correspondance_bdnff.tsv';
		$requete = "LOAD DATA INFILE '$fichierTsv' ".
					"REPLACE INTO TABLE coste_images_correspondance_bdnff ".
					'CHARACTER SET utf8 '.
					'FIELDS '.
					"	TERMINATED BY '\t' ".
					"	ENCLOSED BY '' ".
					"	ESCAPED BY '\\\' ".
					'IGNORE 1 LINES ';
		$this->getBdd()->requeter($requete);
	}
 
	private function creerDescriptionTxt() {
		$description = $this->getClasseDescription();
		$description->genererDescriptionTxt();
	}
 
	private function verifierDescriptionTxt() {
		$description = $this->getClasseDescription();
		$description->verifierDescriptionTxt();
	}
 
	private function genererCorrespondanceDescription() {
		$description = $this->getClasseDescription();
		$description->genererCorrespondance();
	}
 
	private function getClasseDescription() {
		$description = $this->getClasse('Description');
		return $description;
	}
 
	private function fusionnerIndex() {
		$description = $this->getClasseIndex();
		$description->fusionnerIndex();
	}
 
	private function getClasseIndex() {
		$index = $this->getClasse('Index');
		return $index;
	}
 
	private function getClasse($classeNom) {
		$conteneur = new Conteneur();
		$conteneur->setParametre('-v', $this->getParametre('-v'));
		require_once dirname(__FILE__).'/'.$classeNom.'.php';
		$objet = new $classeNom($conteneur);
		return $objet;
	}
}
?>

Rev 428	Rev 469
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 coste -a chargerTous`	5	`* /opt/lampp/bin/php cli.php coste -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) 2012, Tela Botanica (accueil@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`	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 Coste extends EfloreScript {`	15	`class Coste extends EfloreScript {`
16		16
17	`public function executer() {`	17	`public function executer() {`
18	`try {`	18	`try {`
19	`$this->initialiserProjet('coste');`	19	`$this->initialiserProjet('coste');`
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->chargerVersions();`	26	`$this->chargerVersions();`
27	`break;`	27	`break;`
28	`case 'chargerStructureSql' :`	28	`case 'chargerStructureSql' :`
29	`$this->chargerStructureSql();`	29	`$this->chargerStructureSql();`
30	`break;`	30	`break;`
31	`case 'chargerVersions' :`	31	`case 'chargerVersions' :`
32	`$this->chargerVersions();`	32	`$this->chargerVersions();`
33	`break;`	33	`break;`
34	`case 'supprimerTous' :`	34	`case 'supprimerTous' :`
35	`$this->supprimerTous();`	35	`$this->supprimerTous();`
36	`break;`	36	`break;`
37	`case 'creerV1' :`	37	`case 'creerV1' :`
38	`$this->creerVersion1();`	38	`$this->creerVersion1();`
39	`break;`	39	`break;`
40	`case 'nettoyerV1' :`	40	`case 'nettoyerV1' :`
41	`$this->nettoyerVersion1();`	41	`$this->nettoyerVersion1();`
42	`break;`	42	`break;`
43	`case 'creerDscTxt' :`	43	`case 'creerDscTxt' :`
44	`$this->creerDescriptionTxt();`	44	`$this->creerDescriptionTxt();`
45	`break;`	45	`break;`
46	`case 'statDscTxt' :`	46	`case 'statDscTxt' :`
47	`$this->verifierDescriptionTxt();`	47	`$this->verifierDescriptionTxt();`
48	`break;`	48	`break;`
49	`case 'correspondanceDsc' :`	49	`case 'correspondanceDsc' :`
50	`$this->genererCorrespondanceDescription();`	50	`$this->genererCorrespondanceDescription();`
51	`break;`	51	`break;`
-		52	`case 'fusionIndex' :`
-		53	`$this->fusionnerIndex();`
-		54	`break;`
52	`default :`	55	`default :`
53	`throw new Exception("Erreur : la commande '$cmd' n'existe pas!");`	56	`throw new Exception("Erreur : la commande '$cmd' n'existe pas!");`
54	`}`	57	`}`
55	`} catch (Exception $e) {`	58	`} catch (Exception $e) {`
56	`$this->traiterErreur($e->getMessage());`	59	`$this->traiterErreur($e->getMessage());`
57	`}`	60	`}`
58	`}`	61	`}`
59		62
60	`private function chargerVersions() {`	63	`private function chargerVersions() {`
61	`$versions = explode(',', Config::get('versions'));`	64	`$versions = explode(',', Config::get('versions'));`
62	`$versionsDonnees = explode(',', Config::get('versionsDonnees'));`	65	`$versionsDonnees = explode(',', Config::get('versionsDonnees'));`
63	`foreach ($versions as $id => $version) {`	66	`foreach ($versions as $id => $version) {`
64	`$versionDonnees = $versionsDonnees[$id];`	67	`$versionDonnees = $versionsDonnees[$id];`
65	`$this->chargerStructureSqlVersion($versionDonnees, $version);`	68	`$this->chargerStructureSqlVersion($versionDonnees, $version);`
66	`$this->chargerIndexVersion($versionDonnees, $version);`	69	`$this->chargerIndexVersion($versionDonnees, $version);`
67	`$this->chargerDumpWikiniVersion($versionDonnees, $version);`	70	`$this->chargerDumpWikiniVersion($versionDonnees, $version);`
68	`}`	71	`}`
69	`}`	72	`}`
70		73
71	`private function chargerStructureSqlVersion($versionDonnees, $version) {`	74	`private function chargerStructureSqlVersion($versionDonnees, $version) {`
72	`$fichierSqlTpl = Config::get('chemins.structureSqlVersionTpl');`	75	`$fichierSqlTpl = Config::get('chemins.structureSqlVersionTpl');`
73	`$fichierSql = sprintf($fichierSqlTpl, $versionDonnees, $version);`	76	`$fichierSql = sprintf($fichierSqlTpl, $versionDonnees, $version);`
74	`$contenuSql = $this->recupererContenu($fichierSql);`	77	`$contenuSql = $this->recupererContenu($fichierSql);`
75	`$this->executerScripSql($contenuSql);`	78	`$this->executerScripSql($contenuSql);`
76	`}`	79	`}`
77		80
78	`private function chargerIndexVersion($versionDonnees, $version) {`	81	`private function chargerIndexVersion($versionDonnees, $version) {`
79	`$fichierTsvTpl = Config::get('chemins.costeTpl');`	82	`$fichierTsvTpl = Config::get('chemins.costeTpl');`
80	`$fichierTsv = sprintf($fichierTsvTpl, $versionDonnees, $version);`	83	`$fichierTsv = sprintf($fichierTsvTpl, $versionDonnees, $version);`
81	`$tableTpl = Config::get('tables.costeTpl');`	84	`$tableTpl = Config::get('tables.costeTpl');`
82	`$table = sprintf($tableTpl, $version);`	85	`$table = sprintf($tableTpl, $version);`
83	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`	86	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`
84	`"REPLACE INTO TABLE $table ".`	87	`"REPLACE INTO TABLE $table ".`
85	`'CHARACTER SET utf8 '.`	88	`'CHARACTER SET utf8 '.`
86	`'FIELDS '.`	89	`'FIELDS '.`
87	`" TERMINATED BY '\t' ".`	90	`" TERMINATED BY '\t' ".`
88	`" ENCLOSED BY '' ".`	91	`" ENCLOSED BY '' ".`
89	`" ESCAPED BY '\\\' ".`	92	`" ESCAPED BY '\\\' ".`
90	`'IGNORE 1 LINES ';`	93	`'IGNORE 1 LINES ';`
91	`$this->getBdd()->requeter($requete);`	94	`$this->getBdd()->requeter($requete);`
92	`}`	95	`}`
93		96
94	`private function chargerDumpWikiniVersion($versionDonnees, $version) {`	97	`private function chargerDumpWikiniVersion($versionDonnees, $version) {`
95	`$fichierWikiTpl = Config::get('chemins.costeWikiniTpl');`	98	`$fichierWikiTpl = Config::get('chemins.costeWikiniTpl');`
96	`$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version);`	99	`$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version);`
97	`$contenuSql = $this->recupererContenu($fichierDump);`	100	`$contenuSql = $this->recupererContenu($fichierDump);`
98	`$this->executerScripSql($contenuSql);`	101	`$this->executerScripSql($contenuSql);`
99	`}`	102	`}`
100		103
101	`private function supprimerTous() {`	104	`private function supprimerTous() {`
102	`$requete = "DROP TABLE IF EXISTS coste_meta, ".`	105	`$requete = "DROP TABLE IF EXISTS coste_meta, ".`
103	`" coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".`	106	`" coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".`
104	`" coste_v1_00 ";`	107	`" coste_v1_00 ";`
105	`$this->getBdd()->requeter($requete);`	108	`$this->getBdd()->requeter($requete);`
106	`}`	109	`}`
107		110
108	`private function nettoyerVersion1() {`	111	`private function nettoyerVersion1() {`
109	`$requete = "DROP TABLE IF EXISTS coste_correspondance_bdnff, coste_images_auteur_correspondance_bdnff, ".`	112	`$requete = "DROP TABLE IF EXISTS coste_correspondance_bdnff, coste_images_auteur_correspondance_bdnff, ".`
110	`" coste_images_correspondance_bdnff, coste_index, coste_index_general";`	113	`" coste_images_correspondance_bdnff, coste_index, coste_index_general";`
111	`$this->getBdd()->requeter($requete);`	114	`$this->getBdd()->requeter($requete);`
112	`}`	115	`}`
113		116
114	`private function creerVersion1() {`	117	`private function creerVersion1() {`
115	`$this->chargerStructureSqlVersion('0.00', '0_00');`	118	`$this->chargerStructureSqlVersion('0.00', '0_00');`
116	`$this->chargerCosteImagesAuteurCorrespondanceBdnff();`	119	`$this->chargerCosteImagesAuteurCorrespondanceBdnff();`
117	`$this->chargerCosteCorrespondanceBdnff();`	120	`$this->chargerCosteCorrespondanceBdnff();`
118	`}`	121	`}`
119		122
120	`private function chargerCosteImagesAuteurCorrespondanceBdnff() {`	123	`private function chargerCosteImagesAuteurCorrespondanceBdnff() {`
121	`$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_auteur_correspondance_bdnff.tsv';`	124	`$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_auteur_correspondance_bdnff.tsv';`
122	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`	125	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`
123	`"REPLACE INTO TABLE coste_images_auteur_correspondance_bdnff ".`	126	`"REPLACE INTO TABLE coste_images_auteur_correspondance_bdnff ".`
124	`'CHARACTER SET utf8 '.`	127	`'CHARACTER SET utf8 '.`
125	`'FIELDS '.`	128	`'FIELDS '.`
126	`" TERMINATED BY '\t' ".`	129	`" TERMINATED BY '\t' ".`
127	`" ENCLOSED BY '\"' ".`	130	`" ENCLOSED BY '\"' ".`
128	`" ESCAPED BY '\\\' ".`	131	`" ESCAPED BY '\\\' ".`
129	`'IGNORE 1 LINES ';`	132	`'IGNORE 1 LINES ';`
130	`$this->getBdd()->requeter($requete);`	133	`$this->getBdd()->requeter($requete);`
131	`}`	134	`}`
132		135
133	`private function chargerCosteCorrespondanceBdnff() {`	136	`private function chargerCosteCorrespondanceBdnff() {`
134	`$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_correspondance_bdnff.tsv';`	137	`$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_correspondance_bdnff.tsv';`
135	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`	138	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`
136	`"REPLACE INTO TABLE coste_images_correspondance_bdnff ".`	139	`"REPLACE INTO TABLE coste_images_correspondance_bdnff ".`
137	`'CHARACTER SET utf8 '.`	140	`'CHARACTER SET utf8 '.`
138	`'FIELDS '.`	141	`'FIELDS '.`
139	`" TERMINATED BY '\t' ".`	142	`" TERMINATED BY '\t' ".`
140	`" ENCLOSED BY '' ".`	143	`" ENCLOSED BY '' ".`
141	`" ESCAPED BY '\\\' ".`	144	`" ESCAPED BY '\\\' ".`
142	`'IGNORE 1 LINES ';`	145	`'IGNORE 1 LINES ';`
143	`$this->getBdd()->requeter($requete);`	146	`$this->getBdd()->requeter($requete);`
144	`}`	147	`}`
145		148
146	`private function creerDescriptionTxt() {`	149	`private function creerDescriptionTxt() {`
147	`$description = $this->getClasseDescription();`	150	`$description = $this->getClasseDescription();`
148	`$description->genererDescriptionTxt();`	151	`$description->genererDescriptionTxt();`
149	`}`	152	`}`
150		153
151	`private function verifierDescriptionTxt() {`	154	`private function verifierDescriptionTxt() {`
152	`$description = $this->getClasseDescription();`	155	`$description = $this->getClasseDescription();`
153	`$description->verifierDescriptionTxt();`	156	`$description->verifierDescriptionTxt();`
154	`}`	157	`}`
155		158
156	`private function genererCorrespondanceDescription() {`	159	`private function genererCorrespondanceDescription() {`
157	`$description = $this->getClasseDescription();`	160	`$description = $this->getClasseDescription();`
158	`$description->genererCorrespondance();`	161	`$description->genererCorrespondance();`
159	`}`	162	`}`
160		163
-		164	`private function getClasseDescription() {`
-		165	`$description = $this->getClasse('Description');`
-		166	`return $description;`
-		167	`}`
-		168
-		169	`private function fusionnerIndex() {`
-		170	`$description = $this->getClasseIndex();`
-		171	`$description->fusionnerIndex();`
-		172	`}`
-		173
-		174	`private function getClasseIndex() {`
-		175	`$index = $this->getClasse('Index');`
-		176	`return $index;`
-		177	`}`
-		178
161	`private function getClasseDescription() {`	179	`private function getClasse($classeNom) {`
162	`$conteneur = new Conteneur();`	180	`$conteneur = new Conteneur();`
163	`$conteneur->setParametre('-v', $this->getParametre('-v'));`	181	`$conteneur->setParametre('-v', $this->getParametre('-v'));`
164	`require_once dirname(__FILE__)."/Description.php";`	182	`require_once dirname(__FILE__).'/'.$classeNom.'.php';`
165	`$description = new Description($conteneur);`	183	`$objet = new $classeNom($conteneur);`
166	`return $description;`	184	`return $objet;`
167	`}`	185	`}`
168	`}`	186	`}`
169	`?>`	187	`?>`

Subversion Repositories eFlore/Projets.eflore-projets

(root)/trunk/scripts/modules/coste/Coste.php – Rev 428 → 469