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); |
} |
|