/trunk/scripts/modules/tapirlink/A_LIRE.txt |
---|
1,0 → 0,0 |
créer une base de données tb_hit_indexation avant de lancer les scripts |
Créer une base de données tb_hit_indexation avant de lancer les scripts |
/trunk/scripts/modules/tapirlink/Tapirlink.php |
---|
36,7 → 36,34 |
} |
} |
public function chargerTapirlink() { |
protected function initialiserProjet($projet) { |
$bases = $this->getListeBases(); |
parent::initialiserProjet($projet); |
$this->verifierPresenceBdd($bases); |
} |
private function getListeBases() { |
$requete = "SHOW DATABASES"; |
$bases = $this->getBdd()->recupererTous($requete); |
return $bases; |
} |
private function verifierPresenceBdd($bases) { |
$bddNom = Config::get('bdd_nom'); |
$existe = false; |
foreach ($bases as $base) { |
if ($base['Database'] == $bddNom) { |
$existe = true; |
break; |
} |
} |
if ($existe === false) { |
$message = "Veuillez créer la base de données '$bddNom'."; |
throw new Exception($message); |
} |
} |
private function chargerTapirlink() { |
$tablesCodes = array_keys(Config::get('tables')); |
foreach ($tablesCodes as $code) { |
echo "Chargement de la table : $code\n"; |
59,7 → 86,7 |
} |
private function supprimerTous() { |
$requete = "DROP TABLE cel_images, cel_inventory, cel_mots_cles_images, cel_mots_cles_obs, cel_obs_images, locations"; |
$requete = "DROP TABLE IF EXISTS raw_occurrence_record "; |
$this->getBdd()->requeter($requete); |
} |
} |
/trunk/scripts/modules/cel/A_LIRE.txt |
---|
New file |
0,0 → 1,0 |
Créer une base de données tb_cel avant de lancer les scripts |
Property changes: |
Added: svn:eol-style |
+native |
\ No newline at end of property |
/trunk/scripts/modules/cel/Cel.php |
---|
36,6 → 36,33 |
} |
} |
protected function initialiserProjet($projet) { |
$bases = $this->getListeBases(); |
parent::initialiserProjet($projet); |
$this->verifierPresenceBdd($bases); |
} |
private function getListeBases() { |
$requete = "SHOW DATABASES"; |
$bases = $this->getBdd()->recupererTous($requete); |
return $bases; |
} |
private function verifierPresenceBdd($bases) { |
$bddNom = Config::get('bdd_nom'); |
$existe = false; |
foreach ($bases as $base) { |
if ($base['Database'] == $bddNom) { |
$existe = true; |
break; |
} |
} |
if ($existe === false) { |
$message = "Veuillez créer la base de données '$bddNom'."; |
throw new Exception($message); |
} |
} |
public function chargerCel() { |
$tablesCodes = array_keys(Config::get('tables')); |
foreach ($tablesCodes as $code) { |
59,7 → 86,8 |
} |
private function supprimerTous() { |
$requete = "DROP TABLE cel_images, cel_inventory, cel_mots_cles_images, cel_mots_cles_obs, cel_obs_images, locations"; |
$requete = "DROP TABLE IF EXISTS cel_images, cel_inventory, cel_mots_cles_images, cel_mots_cles_obs, ". |
"cel_obs_images, locations "; |
$this->getBdd()->requeter($requete); |
} |
} |