<?php
class Versions {

	private $conteneur = null;
	private $eflore = null;
	private $bdd = null;

	public function __construct(Conteneur $conteneur) {
		$this->conteneur = $conteneur;
		$this->eflore = $conteneur->getEfloreCommun();
		$this->bdd = $conteneur->getBdd();
	}

	public function chargerTous() {
		$this->chargerVersions();
	}

	public 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->eflore->recupererContenu($fichierSql);
		$this->eflore->executerScriptSql($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->bdd->requeter($requete);
	}

	private function chargerDumpWikiniVersion($versionDonnees, $version) {
		$versionMajeure = (int) substr($version, 0, 1);
		if ($versionMajeure < 2) {
			$fichierWikiTpl = Config::get('chemins.costeWikiniTpl');
			$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version);
			$contenuSql = $this->eflore->recupererContenu($fichierDump);
			$this->eflore->executerScriptSql($contenuSql);
		}
	}

	public function supprimerTous() {
		$requete = "DROP TABLE IF EXISTS coste_meta, ".
				"	coste_correspondance_bdnff, coste_images_auteur_correspondance_bdnff, ".
				"	coste_images_correspondance_bdnff, coste_index, coste_index_general, ".
				"	coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ".
				"	coste_v1_00, coste_v2_00 ";
		$this->bdd->requeter($requete);
	}
}
?>