/trunk/scripts/modules/coste/Versions.php |
---|
File deleted |
\ No newline at end of file |
/trunk/scripts/modules/coste/A_LIRE.txt |
---|
New file |
0,0 → 1,15 |
Les scripts DescriptionSp.php et Cles.php, lancés dans cet ordre permettent respectivement : |
- La récupération des descriptions des espèces. |
- Insertions des textes dans la table coste_pages, |
- Insertions des titres des espèces dans la table coste_triples |
- Création de la table correspondance BDNFF |
- La génération des num_nom du projet coste |
- L'insertion des num_nom dans coste_triples |
- La création de la table coste_v0_1 |
- La recupération des clés et des descriptions des groupes, familles et genre. |
- Insertion dans la table coste_pages des textes |
- Insertion dans la table coste_triples des num_nom et des titres |
Un script permettant de lancer ces deux derniers a été créé : CreationProjetCoste.php. |
Le dernier script est celui d'ajout du nom_sci_html (creationCol.php) à la table coste. |
Property changes: |
Added: svn:eol-style |
+native |
\ No newline at end of property |
Added: svn:executable |
+* |
\ No newline at end of property |
/trunk/scripts/modules/coste/Version1.php |
---|
New file |
0,0 → 1,109 |
<?php |
class Version1 { |
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->chargerStructureSql(); |
$this->chargerVersions(); |
} |
public function chargerStructureSql() { |
$this->eflore->chargerStructureSql(); |
} |
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->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->bdd->requeter($requete); |
} |
private function chargerDumpWikiniVersion($versionDonnees, $version) { |
$fichierWikiTpl = Config::get('chemins.costeWikiniTpl'); |
$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version); |
$contenuSql = $this->eflore->recupererContenu($fichierDump); |
$this->eflore->executerScripSql($contenuSql); |
} |
public 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->bdd->requeter($requete); |
} |
public 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->bdd->requeter($requete); |
} |
public 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->bdd->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->bdd->requeter($requete); |
} |
} |
?> |
/trunk/scripts/modules/coste/Version2.php |
---|
New file |
0,0 → 1,70 |
<?php |
class Version2 { |
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->chargerStructureSql(); |
} |
public function chargerStructureSql() { |
$this->eflore->chargerStructureSql(); |
} |
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->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->bdd->requeter($requete); |
} |
private function chargerDumpWikiniVersion($versionDonnees, $version) { |
$fichierWikiTpl = Config::get('chemins.costeWikiniTpl'); |
$fichierDump = sprintf($fichierWikiTpl, $versionDonnees, $version); |
$contenuSql = $this->eflore->recupererContenu($fichierDump); |
$this->eflore->executerScripSql($contenuSql); |
} |
public function supprimerTous() { |
$requete = "DROP TABLE IF EXISTS coste_meta, ". |
" coste_acls, coste_links, coste_pages, coste_referrers, coste_triples, coste_users, ". |
" coste_v2_00 "; |
$this->bdd->requeter($requete); |
} |
} |
?> |
/trunk/scripts/modules/coste/Coste.php |
---|
37,6 → 37,14 |
$version = $this->getClasseVersion(); |
$version->supprimerTous(); |
break; |
case 'creerV1' : |
$version = $this->getClasseVersion(); |
$version->creerVersion1(); |
break; |
case 'nettoyerV1' : |
$version = $this->getClasseVersion(); |
$version->nettoyerVersion1(); |
break; |
case 'creerDscTxt' : |
$description = $this->getClasseDescription(); |
$description->genererDescriptionTxt(); |
73,9 → 81,9 |
} |
} |
private function getClasseVersion() { |
$version = $this->getClasse('Versions'); |
return $version; |
private function getClasseVersion($version = '1') { |
$version1 = $this->getClasse('Version'); |
return $version1; |
} |
private function getClasseDescription() { |