Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 478 | Rev 484 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 478 Rev 479
Line 1... Line 1...
1 
<?php
 1 
<?php
2 
class Version1 {
 2 
class Versions {
Line 3... Line 3...
3 
 
 3 
 
4 
	private $conteneur = null;
 4 
	private $conteneur = null;
5 
	private $eflore = null;
 5 
	private $eflore = null;
Line 62... Line 62...
62 
	}
 62 
	}
Line 63... Line 63...
63 
 
 63 
 
64 
	public function supprimerTous() {
 64 
	public function supprimerTous() {
65 
		$requete = "DROP TABLE IF EXISTS coste_meta, ".
 65 
		$requete = "DROP TABLE IF EXISTS coste_meta, ".
66 
				"	coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".
 66 
				"	coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".
67 
				"	coste_v1_00 ";
 67 
				"	coste_v1_00, coste_v2_00 ";
68 
		$this->bdd->requeter($requete);
 68 
		$this->bdd->requeter($requete);
69 
	}
 - 
 
70 
 
 - 
 
71 
	public function nettoyerVersion1() {
 - 
 
72 
		$requete = "DROP TABLE IF EXISTS coste_correspondance_bdnff, coste_images_auteur_correspondance_bdnff, ".
 - 
 
73 
				"	coste_images_correspondance_bdnff, coste_index, coste_index_general";
 - 
 
74 
		$this->bdd->requeter($requete);
 - 
 
75 
	}
 - 
 
76 
 
 - 
 
77 
	public function creerVersion1() {
 - 
 
78 
		$this->chargerStructureSqlVersion('0.00', '0_00');
 - 
 
79 
		$this->chargerCosteImagesAuteurCorrespondanceBdnff();
 - 
 
80 
		$this->chargerCosteCorrespondanceBdnff();
 - 
 
81 
	}
 - 
 
82 
 
 - 
 
83 
	private function chargerCosteImagesAuteurCorrespondanceBdnff() {
 - 
 
84 
		$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_auteur_correspondance_bdnff.tsv';
 - 
 
85 
		$requete = "LOAD DATA INFILE '$fichierTsv' ".
 - 
 
86 
				"REPLACE INTO TABLE coste_images_auteur_correspondance_bdnff ".
 - 
 
87 
				'CHARACTER SET utf8 '.
 - 
 
88 
				'FIELDS '.
 - 
 
89 
				"	TERMINATED BY '\t' ".
 - 
 
90 
				"	ENCLOSED BY '\"' ".
 - 
 
91 
				"	ESCAPED BY '\\\' ".
 - 
 
92 
				'IGNORE 1 LINES ';
 - 
 
93 
		$this->bdd->requeter($requete);
 - 
 
94 
	}
 - 
 
95 
 
 - 
 
96 
	private function chargerCosteCorrespondanceBdnff() {
 - 
 
97 
		$fichierTsv = sprintf(Config::get('dossierTsvTpl'), '0.00').'coste_images_correspondance_bdnff.tsv';
 - 
 
98 
		$requete = "LOAD DATA INFILE '$fichierTsv' ".
 - 
 
99 
				"REPLACE INTO TABLE coste_images_correspondance_bdnff ".
 - 
 
100 
				'CHARACTER SET utf8 '.
 - 
 
101 
				'FIELDS '.
 - 
 
102 
				"	TERMINATED BY '\t' ".
 - 
 
103 
				"	ENCLOSED BY '' ".
 - 
 
104 
				"	ESCAPED BY '\\\' ".
 - 
 
105 
				'IGNORE 1 LINES ';
 - 
 
106 
		$this->bdd->requeter($requete);
 - 
 
107 
	}
 69 
	}
108 
}
 70 
}
109 
?>
 71 
?>