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;
				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() {
		$conteneur = new Conteneur();
		$conteneur->setParametre('-v', $this->getParametre('-v'));
		require_once dirname(__FILE__)."/Description.php";
		$description = new Description($conteneur);
		$description->genererDescriptionTxt();
	}
}
?>

Rev 351	Rev 424
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' :`
-		44	`$this->creerDescriptionTxt();`
-		45	`break;`
43	`default :`	46	`default :`
44	`throw new Exception("Erreur : la commande '$cmd' n'existe pas!");`	47	`throw new Exception("Erreur : la commande '$cmd' n'existe pas!");`
45	`}`	48	`}`
46	`} catch (Exception $e) {`	49	`} catch (Exception $e) {`
47	`$this->traiterErreur($e->getMessage());`	50	`$this->traiterErreur($e->getMessage());`
48	`}`	51	`}`
49	`}`	52	`}`
50		53
51	`private function chargerVersions() {`	54	`private function chargerVersions() {`
52	`$versions = explode(',', Config::get('versions'));`	55	`$versions = explode(',', Config::get('versions'));`
53	`$versionsDonnees = explode(',', Config::get('versionsDonnees'));`	56	`$versionsDonnees = explode(',', Config::get('versionsDonnees'));`
54	`foreach ($versions as $id => $version) {`	57	`foreach ($versions as $id => $version) {`
55	`$versionDonnees = $versionsDonnees[$id];`	58	`$versionDonnees = $versionsDonnees[$id];`
56	`$this->chargerStructureSqlVersion($versionDonnees, $version);`	59	`$this->chargerStructureSqlVersion($versionDonnees, $version);`
57	`$this->chargerIndexVersion($versionDonnees, $version);`	60	`$this->chargerIndexVersion($versionDonnees, $version);`
58	`$this->chargerDumpWikiniVersion($versionDonnees, $version);`	61	`$this->chargerDumpWikiniVersion($versionDonnees, $version);`
59	`}`	62	`}`
60	`}`	63	`}`
61		64
62	`private function chargerStructureSqlVersion($versionDonnees, $version) {`	65	`private function chargerStructureSqlVersion($versionDonnees, $version) {`
63	`$fichierSqlTpl = Config::get('chemins.structureSqlVersionTpl');`	66	`$fichierSqlTpl = Config::get('chemins.structureSqlVersionTpl');`
64	`$fichierSql = sprintf($fichierSqlTpl, $versionDonnees, $version);`	67	`$fichierSql = sprintf($fichierSqlTpl, $versionDonnees, $version);`
65	`$contenuSql = $this->recupererContenu($fichierSql);`	68	`$contenuSql = $this->recupererContenu($fichierSql);`
66	`$this->executerScripSql($contenuSql);`	69	`$this->executerScripSql($contenuSql);`
67	`}`	70	`}`
68		71
69	`private function chargerIndexVersion($versionDonnees, $version) {`	72	`private function chargerIndexVersion($versionDonnees, $version) {`
70	`$fichierTsvTpl = Config::get('chemins.costeTpl');`	73	`$fichierTsvTpl = Config::get('chemins.costeTpl');`
71	`$fichierTsv = sprintf($fichierTsvTpl, $versionDonnees, $version);`	74	`$fichierTsv = sprintf($fichierTsvTpl, $versionDonnees, $version);`
72	`$tableTpl = Config::get('tables.costeTpl');`	75	`$tableTpl = Config::get('tables.costeTpl');`
73	`$table = sprintf($tableTpl, $version);`	76	`$table = sprintf($tableTpl, $version);`
74	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`	77	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`
75	`"REPLACE INTO TABLE $table ".`	78	`"REPLACE INTO TABLE $table ".`
76	`'CHARACTER SET utf8 '.`	79	`'CHARACTER SET utf8 '.`
77	`'FIELDS '.`	80	`'FIELDS '.`
78	`" TERMINATED BY '\t' ".`	81	`" TERMINATED BY '\t' ".`
79	`" ENCLOSED BY '' ".`	82	`" ENCLOSED BY '' ".`
80	`" ESCAPED BY '\\\' ".`	83	`" ESCAPED BY '\\\' ".`
81	`'IGNORE 1 LINES ';`	84	`'IGNORE 1 LINES ';`
82	`$this->getBdd()->requeter($requete);`	85	`$this->getBdd()->requeter($requete);`
83	`}`	86	`}`
84		87
85	`private function chargerDumpWikiniVersion($versionDonnees, $version) {`	88	`private function chargerDumpWikiniVersion($versionDonnees, $version) {`
86	`$fichierWikiTpl = Config::get('chemins.costeWikiniTpl');`	89	`$fichierWikiTpl = Config::get('chemins.costeWikiniTpl');`
87	`$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version);`	90	`$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version);`
88	`$contenuSql = $this->recupererContenu($fichierDump);`	91	`$contenuSql = $this->recupererContenu($fichierDump);`
89	`$this->executerScripSql($contenuSql);`	92	`$this->executerScripSql($contenuSql);`
90	`}`	93	`}`
91		94
92	`private function supprimerTous() {`	95	`private function supprimerTous() {`
93	`$requete = "DROP TABLE IF EXISTS coste_meta, ".`	96	`$requete = "DROP TABLE IF EXISTS coste_meta, ".`
94	`" coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".`	97	`" coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".`
95	`" coste_v1_00 ";`	98	`" coste_v1_00 ";`
96	`$this->getBdd()->requeter($requete);`	99	`$this->getBdd()->requeter($requete);`
97	`}`	100	`}`
98		101
99	`private function nettoyerVersion1() {`	102	`private function nettoyerVersion1() {`
100	`$requete = "DROP TABLE IF EXISTS coste_correspondance_bdnff, coste_images_auteur_correspondance_bdnff, ".`	103	`$requete = "DROP TABLE IF EXISTS coste_correspondance_bdnff, coste_images_auteur_correspondance_bdnff, ".`
101	`" coste_images_correspondance_bdnff, coste_index, coste_index_general";`	104	`" coste_images_correspondance_bdnff, coste_index, coste_index_general";`
102	`$this->getBdd()->requeter($requete);`	105	`$this->getBdd()->requeter($requete);`
103	`}`	106	`}`
104		107
105	`private function creerVersion1() {`	108	`private function creerVersion1() {`
106	`$this->chargerStructureSqlVersion('0.00', '0_00');`	109	`$this->chargerStructureSqlVersion('0.00', '0_00');`
107	`$this->chargerCosteImagesAuteurCorrespondanceBdnff();`	110	`$this->chargerCosteImagesAuteurCorrespondanceBdnff();`
108	`$this->chargerCosteCorrespondanceBdnff();`	111	`$this->chargerCosteCorrespondanceBdnff();`
109	`}`	112	`}`
110		113
111	`private function chargerCosteImagesAuteurCorrespondanceBdnff() {`	114	`private function chargerCosteImagesAuteurCorrespondanceBdnff() {`
112	`$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_auteur_correspondance_bdnff.tsv';`	115	`$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_auteur_correspondance_bdnff.tsv';`
113	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`	116	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`
114	`"REPLACE INTO TABLE coste_images_auteur_correspondance_bdnff ".`	117	`"REPLACE INTO TABLE coste_images_auteur_correspondance_bdnff ".`
115	`'CHARACTER SET utf8 '.`	118	`'CHARACTER SET utf8 '.`
116	`'FIELDS '.`	119	`'FIELDS '.`
117	`" TERMINATED BY '\t' ".`	120	`" TERMINATED BY '\t' ".`
118	`" ENCLOSED BY '\"' ".`	121	`" ENCLOSED BY '\"' ".`
119	`" ESCAPED BY '\\\' ".`	122	`" ESCAPED BY '\\\' ".`
120	`'IGNORE 1 LINES ';`	123	`'IGNORE 1 LINES ';`
121	`$this->getBdd()->requeter($requete);`	124	`$this->getBdd()->requeter($requete);`
122	`}`	125	`}`
123		126
124	`private function chargerCosteCorrespondanceBdnff() {`	127	`private function chargerCosteCorrespondanceBdnff() {`
125	`$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_correspondance_bdnff.tsv';`	128	`$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_correspondance_bdnff.tsv';`
126	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`	129	`$requete = "LOAD DATA INFILE '$fichierTsv' ".`
127	`"REPLACE INTO TABLE coste_images_correspondance_bdnff ".`	130	`"REPLACE INTO TABLE coste_images_correspondance_bdnff ".`
128	`'CHARACTER SET utf8 '.`	131	`'CHARACTER SET utf8 '.`
129	`'FIELDS '.`	132	`'FIELDS '.`
130	`" TERMINATED BY '\t' ".`	133	`" TERMINATED BY '\t' ".`
131	`" ENCLOSED BY '' ".`	134	`" ENCLOSED BY '' ".`
132	`" ESCAPED BY '\\\' ".`	135	`" ESCAPED BY '\\\' ".`
133	`'IGNORE 1 LINES ';`	136	`'IGNORE 1 LINES ';`
134	`$this->getBdd()->requeter($requete);`	137	`$this->getBdd()->requeter($requete);`
135	`}`	138	`}`
-		139
-		140	`private function creerDescriptionTxt() {`
-		141	`$conteneur = new Conteneur();`
-		142	`$conteneur->setParametre('-v', $this->getParametre('-v'));`
-		143	`require_once dirname(__FILE__)."/Description.php";`
-		144	`$description = new Description($conteneur);`
-		145	`$description->genererDescriptionTxt();`
-		146	`}`
136	`}`	147	`}`
137	`?>`	148	`?>`

Subversion Repositories eFlore/Projets.eflore-projets

(root)/trunk/scripts/modules/coste/Coste.php @ 351 – Rev 351 → 424