WebSVN – eFlore/Projets.eflore-projets – Diff – /branches/v5.12-baouque/scripts/modules/sptb/Sptb.php


<?php
/** Exemple lancement:
 * /opt/lampp/bin/php -d memory_limit=3500M cli.php sptb -a chargerTous
*/
class Sptb extends EfloreScript {
 
	public function executer() {
		// Lancement de l'action demandée
		try {
			$this->initialiserProjet('sptb');
 
			$cmd = $this->getParametre('a');
		    switch ($cmd) {
		    	case 'chargerTous' :
		    		$this->chargerStructureSql();
		    		$this->chargerDonnees('especes');
		    		$this->chargerDonnees('lois');
		    		$this-> ajouterChamps();
		    		$this->genererChampNumNomRetenu();
		    		break;
	    		case 'chargerStructureSql' :
	    			$this->chargerStructureSql();
	    			break;
				case 'chargerDonnees' :
		    		$this->chargerDonnees('especes');
		    		$this->chargerDonnees('lois');
		    		$this-> ajouterChamps();
		    		$this->genererChampNumNomRetenu();
					break;
				case 'genererChampNumNomRetenu' :
		    		$this-> ajouterChamps();
					$this->genererChampNumNomRetenu();
					break;
				case 'supprimerTous' :
					$this->supprimerTous();
					break;
				default :
					throw new Exception("Erreur : la commande '$cmd' n'existe pas!");
			}
		} catch (Exception $e) {
			$this->traiterErreur($e->getMessage());
		}
    }
 
	protected function chargerDonnees($type) {
		$chemin = Config::get('chemins.'.$type);
		$table = Config::get('tables.'.$type);
		$requete = "LOAD DATA INFILE '$chemin' ".
			"REPLACE INTO TABLE $table ".
			'CHARACTER SET utf8 '.
			'FIELDS '.
			"	TERMINATED BY '\t' ".
			"	ENCLOSED BY '' ".
			"	ESCAPED BY '\\\' ".
			'IGNORE 1 LINES';
		$this->getBdd()->requeter($requete);
	}
	
	private function genererChampNumNomRetenu() {
		$this->preparerTablePrChpNumNomRetenu();
		$this->genererNumNomRetenu();
	}
	
	private function preparerTablePrChpNumNomRetenu() {
		$table = Config::get('tables.especes');
		$requete = "SHOW COLUMNS FROM $table LIKE 'num_nom_retenu' ";
		$resultat = $this->getBdd()->recuperer($requete);
		if ($resultat === false) {
			$requete = 	"ALTER TABLE $table ".
					'ADD num_nom_retenu INT(10) '.
					'NULL DEFAULT NULL AFTER num_nom';
			$this->getBdd()->requeter($requete);
		}
	}
	private function ajouterChamps() {
		$table = Config::get('tables.especes');
		
		$requete = 'ALTER TABLE '.$table.' ADD `num_nom` INT( 10 ) NOT NULL ,
					ADD `num_nom_retenu` INT( 10 ) NOT NULL ,
					ADD `nom_sci` VARCHAR( 70 ) NOT NULL ';
		$this->getBdd()->requeter($requete);
	}
	
	private function genererNumNomRetenu() {
		$table = Config::get('tables.especes');
		$table_referentiel = Config::get('tables.referentielTaxo');
		
		$requete = 'UPDATE '.$table.' s, '.$table_referentiel.' r '.
		           'SET s.num_nom_retenu = r.num_nom_retenu, s.num_nom = r.num_nom, s.nom_sci = r.nom_sci '.
		           '	WHERE s.cd_nom = r.cd_nom ';
		
		$this->getBdd()->requeter($requete);
	}
 
	private function supprimerTous() {
		$requete = "DROP TABLE IF EXISTS sptb_meta, sptb_especes_v2012, sptb_lois_v2012";
		$this->getBdd()->requeter($requete);
		Debug::printr('suppression');
	}
}
?>

Rev 1175	Rev 1191
1	`<?php`	1	`<?php`
2	`/** Exemple lancement:`	2	`/** Exemple lancement:`
3	`* /opt/lampp/bin/php -d memory_limit=3500M cli.php sptb -a chargerTous`	3	`* /opt/lampp/bin/php -d memory_limit=3500M cli.php sptb -a chargerTous`
4	`*/`	4	`*/`
5	`class Sptb extends EfloreScript {`	5	`class Sptb extends EfloreScript {`
6		6
7	`public function executer() {`	7	`public function executer() {`
8	`// Lancement de l'action demandée`	8	`// Lancement de l'action demandée`
9	`try {`	9	`try {`
10	`$this->initialiserProjet('sptb');`	10	`$this->initialiserProjet('sptb');`
11		11
12	`$cmd = $this->getParametre('a');`	12	`$cmd = $this->getParametre('a');`
13	`switch ($cmd) {`	13	`switch ($cmd) {`
14	`case 'chargerTous' :`	14	`case 'chargerTous' :`
15	`$this->chargerStructureSql();`	15	`$this->chargerStructureSql();`
16	`$this->chargerDonnees('especes');`	16	`$this->chargerDonnees('especes');`
17	`$this->chargerDonnees('lois');`	17	`$this->chargerDonnees('lois');`
-		18	`$this-> ajouterChamps();`
18	`$this->genererChampNumNomRetenu();`	19	`$this->genererChampNumNomRetenu();`
19	`break;`	20	`break;`
20	`case 'chargerStructureSql' :`	21	`case 'chargerStructureSql' :`
21	`$this->chargerStructureSql();`	22	`$this->chargerStructureSql();`
22	`break;`	23	`break;`
23	`case 'chargerDonnees' :`	24	`case 'chargerDonnees' :`
24	`$this->chargerDonnees('especes');`	25	`$this->chargerDonnees('especes');`
25	`$this->chargerDonnees('lois');`	26	`$this->chargerDonnees('lois');`
-		27	`$this-> ajouterChamps();`
26	`$this->genererChampNumNomRetenu();`	28	`$this->genererChampNumNomRetenu();`
27	`break;`	29	`break;`
28	`case 'genererChampNumNomRetenu' :`	30	`case 'genererChampNumNomRetenu' :`
-		31	`$this-> ajouterChamps();`
29	`$this->genererChampNumNomRetenu();`	32	`$this->genererChampNumNomRetenu();`
30	`break;`	33	`break;`
31	`case 'supprimerTous' :`	34	`case 'supprimerTous' :`
32	`$this->supprimerTous();`	35	`$this->supprimerTous();`
33	`break;`	36	`break;`
34	`default :`	37	`default :`
35	`throw new Exception("Erreur : la commande '$cmd' n'existe pas!");`	38	`throw new Exception("Erreur : la commande '$cmd' n'existe pas!");`
36	`}`	39	`}`
37	`} catch (Exception $e) {`	40	`} catch (Exception $e) {`
38	`$this->traiterErreur($e->getMessage());`	41	`$this->traiterErreur($e->getMessage());`
39	`}`	42	`}`
40	`}`	43	`}`
41		44
42	`private function chargerDonnees($type) {`	45	`protected function chargerDonnees($type) {`
43	`$chemin = Config::get('chemins.'.$type);`	46	`$chemin = Config::get('chemins.'.$type);`
44	`$table = Config::get('tables.'.$type);`	47	`$table = Config::get('tables.'.$type);`
45	`$requete = "LOAD DATA INFILE '$chemin' ".`	48	`$requete = "LOAD DATA INFILE '$chemin' ".`
46	`"REPLACE INTO TABLE $table ".`	49	`"REPLACE INTO TABLE $table ".`
47	`'CHARACTER SET utf8 '.`	50	`'CHARACTER SET utf8 '.`
48	`'FIELDS '.`	51	`'FIELDS '.`
49	`" TERMINATED BY '\t' ".`	52	`" TERMINATED BY '\t' ".`
50	`" ENCLOSED BY '' ".`	53	`" ENCLOSED BY '' ".`
51	`" ESCAPED BY '\\\' ".`	54	`" ESCAPED BY '\\\' ".`
52	`'IGNORE 1 LINES';`	55	`'IGNORE 1 LINES';`
53	`$this->getBdd()->requeter($requete);`	56	`$this->getBdd()->requeter($requete);`
54	`}`	57	`}`
55		58
56	`private function genererChampNumNomRetenu() {`	59	`private function genererChampNumNomRetenu() {`
57	`$this->preparerTablePrChpNumNomRetenu();`	60	`$this->preparerTablePrChpNumNomRetenu();`
58	`$this->genererNumNomRetenu();`	61	`$this->genererNumNomRetenu();`
59	`}`	62	`}`
60		63
61	`private function preparerTablePrChpNumNomRetenu() {`	64	`private function preparerTablePrChpNumNomRetenu() {`
62	`$table = Config::get('tables.especes');`	65	`$table = Config::get('tables.especes');`
63	`$requete = "SHOW COLUMNS FROM $table LIKE 'num_nom_retenu' ";`	66	`$requete = "SHOW COLUMNS FROM $table LIKE 'num_nom_retenu' ";`
64	`$resultat = $this->getBdd()->recuperer($requete);`	67	`$resultat = $this->getBdd()->recuperer($requete);`
65	`if ($resultat === false) {`	68	`if ($resultat === false) {`
66	`$requete = "ALTER TABLE $table ".`	69	`$requete = "ALTER TABLE $table ".`
67	`'ADD num_nom_retenu INT(10) '.`	70	`'ADD num_nom_retenu INT(10) '.`
68	`'NULL DEFAULT NULL AFTER num_nom';`	71	`'NULL DEFAULT NULL AFTER num_nom';`
69	`$this->getBdd()->requeter($requete);`	72	`$this->getBdd()->requeter($requete);`
70	`}`	73	`}`
71	`}`	74	`}`
-		75	`private function ajouterChamps() {`
-		76	`$table = Config::get('tables.especes');`
-		77
-		78	$requete = 'ALTER TABLE '.$table.' ADD `num_nom` INT( 10 ) NOT NULL ,
-		79	ADD `num_nom_retenu` INT( 10 ) NOT NULL ,
-		80	ADD `nom_sci` VARCHAR( 70 ) NOT NULL ';
-		81	`$this->getBdd()->requeter($requete);`
-		82	`}`
72		83
73	`private function genererNumNomRetenu() {`	84	`private function genererNumNomRetenu() {`
74	`$table = Config::get('tables.especes');`	85	`$table = Config::get('tables.especes');`
75	`$table_referentiel = Config::get('tables.referentielTaxo');`	86	`$table_referentiel = Config::get('tables.referentielTaxo');`
76		87
77	`$requete = 'UPDATE '.$table.' s, '.$table_referentiel.' r '.`	88	`$requete = 'UPDATE '.$table.' s, '.$table_referentiel.' r '.`
78	`'SET s.num_nom_retenu = r.num_nom_retenu '.`	89	`'SET s.num_nom_retenu = r.num_nom_retenu, s.num_nom = r.num_nom, s.nom_sci = r.nom_sci '.`
79	`' WHERE s.num_nom = r.num_nom ';`	90	`' WHERE s.cd_nom = r.cd_nom ';`
80		91
81	`$this->getBdd()->requeter($requete);`	92	`$this->getBdd()->requeter($requete);`
82	`}`	93	`}`
83		94
84	`private function supprimerTous() {`	95	`private function supprimerTous() {`
85	`$requete = "DROP TABLE IF EXISTS sptb_meta, sptb_especes_v2012, sptb_lois_v2012";`	96	`$requete = "DROP TABLE IF EXISTS sptb_meta, sptb_especes_v2012, sptb_lois_v2012";`
86	`$this->getBdd()->requeter($requete);`	97	`$this->getBdd()->requeter($requete);`
87	`Debug::printr('suppression');`	98	`Debug::printr('suppression');`
88	`}`	99	`}`
89	`}`	100	`}`
90	`?>`	101	`?>`

Subversion Repositories eFlore/Projets.eflore-projets

(root)/branches/v5.12-baouque/scripts/modules/sptb/Sptb.php – Rev 1175 → 1191