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