Subversion Repositories eFlore/Projets.eflore-projets

Compare Revisions

Ignore whitespace Rev 1324 → Rev 1325

/trunk/scripts/modules/vascan/Vascan.php
2,7 → 2,7
//declare(encoding='UTF-8');
/**
* Exemple de lancement du script : :
* /opt/lampp/bin/php cli.php taxref -a chargerTous
* /opt/lampp/bin/php cli.php vascan -a chargerTous
*
* @category php 5.2
* @package eFlore/Scripts
12,7 → 12,7
* @license http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
* @version $Id$
*/
class Taxref extends EfloreScript {
class Vascan extends EfloreScript {
 
private $table = null;
private $pasInsertion = 1000;
30,7 → 30,7
switch ($cmd) {
case 'chargerTous' :
$this->chargerStructureSql();
$this->chargertaxref();
$this->chargerVascan();
$this->genererChpNumTax();
$this->genererChpNomSciHtml();
$this->genererChpFamille();
40,8 → 40,8
case 'chargerStructureSql' :
$this->chargerStructureSql();
break;
case 'chargerTaxref' :
$this->chargerTaxref();
case 'chargerVascan' :
$this->chargerVascan();
break;
case 'genererChpNumTax' :
$this->genererChpNumTax();
70,9 → 70,9
}
}
 
private function chargerTaxref() {
private function chargerVascan() {
$chemin = Config::get('chemins.bdt');
$table = Config::get('tables.taxref');
$table = Config::get('tables.vascan');
$requete = "LOAD DATA INFILE '$chemin' ".
"REPLACE INTO TABLE $table ".
'CHARACTER SET utf8 '.
147,7 → 147,7
}
 
private function initialiserGenerationChamps() {
$this->table = Config::get('tables.taxref');
$this->table = Config::get('tables.vascan');
}
 
private function preparerTablePrChpNomSciHtml() {
307,7 → 307,7
private function genererChpHierarchie() {
$this->initialiserGenerationChamps();
$this->preparerTablePrChpHierarchie();
$table = Config::get('tables.taxref');
$table = Config::get('tables.vascan');
$requete = "UPDATE $table SET hierarchie = NULL ";
$mise_a_jour = $this->getBdd()->requeter($requete);
356,23 → 356,23
$contenuSql = $this->recupererContenu(Config::get('chemins.structureSqlTest'));
$this->executerScripSql($contenuSql);
 
$table = Config::get('tables.taxref');
$tableTest = Config::get('tables.taxrefTest');
$table = Config::get('tables.vascan');
$tableTest = Config::get('tables.vascanTest');
$requete = "INSERT INTO $tableTest SELECT * FROM $table";
$this->getBdd()->requeter($requete);
}
 
private function supprimerDonneesTestMultiVersion() {
$tableMeta = Config::get('tables.taxrefMeta');
$requete = "DELETE FROM $tableMeta WHERE guid = 'urn:lsid:tela-botanica.org:taxref:1.00'";
$tableMeta = Config::get('tables.vascanMeta');
$requete = "DELETE FROM $tableMeta WHERE guid = 'urn:lsid:tela-botanica.org:vascan:1.00'";
$this->getBdd()->requeter($requete);
 
$tableTest = Config::get('tables.taxrefTest');
$tableTest = Config::get('tables.vascanTest');
$requete = "DROP TABLE IF EXISTS $tableTest";
$this->getBdd()->requeter($requete);
}
private function supprimerTous() {
$requete = "DROP TABLE IF EXISTS taxref_meta, taxref_v0_01, taxref_v1_00";
$requete = "DROP TABLE IF EXISTS vascan_meta, vascan_v0_01, vascan_v1_00";
$this->getBdd()->requeter($requete);
}