| New file |
|---|
| 0,0 → 1,195 |
|---|
| <?php |
| |
| class MigrationWiki extends ProjetService { |
| |
| const dry_run = false; |
| |
| private function executerRequeteManip($requete, $mode_fetch = false) { |
| // Fonction de commodité pour afficher les requetes au lieu de les executer |
| if (self::dry_run) { |
| echo str_replace('),','),'.NL, $requete); |
| return true; |
| } else { |
| if($mode_fetch) { |
| return $this->bdd->query($requete)->fetchAll($mode_fetch); |
| } else { |
| return $this->bdd->query($requete); |
| } |
| } |
| } |
| |
| private function executerRequete($requete, $mode_fetch = false) { |
| if (self::dry_run) { |
| echo '<pre>'.str_replace('),','),'.NL, $requete).'</pre>'; |
| } |
| |
| $retour = $this->bdd->query($requete)->fetchAll($mode_fetch); |
| return $retour; |
| } |
| |
| public function __construct($config, $demarrer_session= true) { |
| parent::__construct($config, $demarrer_session); |
| define('NL',"\n"); |
| } |
| |
| public function getElement($uid){ |
| exit; |
| $requete_projets_wikinis = 'SELECT * FROM gen_wikini'; |
| $wikinis_projets = $this->executerRequete($requete_projets_wikinis, PDO::FETCH_ASSOC); |
| |
| foreach($wikinis_projets as $wikini) { |
| |
| // test sur un wiki |
| if($wikini['gewi_code_alpha_wikini'] != 'relais') { |
| continue; |
| } |
| |
| $base = $wikini['gewi_bdd_nom']; |
| $prefixe = $wikini['gewi_table_prefix']; |
| |
| $chemin_wiki_sur_site = $this->config['appli']['chemin_wikis_integres']; |
| $chemin_wiki = $wikini['gewi_chemin']; |
| |
| echo NL.'Traitement du wiki '.$chemin_wiki.NL; |
| echo NL.$chemin_wiki.NL; |
| |
| if(!file_exists($chemin_wiki)) { |
| echo 'Impossible de migrer le wikini '.$wikini['gewi_code_alpha_wikini'].' : le dossier n\'existe pas'.NL.NL.NL.NL; |
| continue; |
| } |
| |
| $chemin_base_wiki_defaut = $this->config['appli']['chemin_wiki_defaut']; |
| |
| $nom_admin = $this->config['appli']['nom_admin_wiki']; |
| $mail_admin = $this->config['appli']['adresse_admin_wiki']; |
| $pass_admin = $this->config['appli']['pass_admin_wiki']; |
| |
| $infos_admin = array('name' =>$nom_admin, 'email' => $mail_admin, 'password' => $pass_admin); |
| |
| //if(!$this->verifierPresenceTableTriple($base, $prefixe)) { |
| echo 'migration du wiki '.$wikini['gewi_code_alpha_wikini'].NL; |
| // $this->creerTableTriple($base, $prefixe); |
| // $this->ajouterUtilisateurAdmin($base,$prefixe, $infos_admin); |
| $this->copierFichiersWikini($chemin_base_wiki_defaut, $chemin_wiki); |
| $this->changerVersionWakkaConfig($chemin_wiki); |
| echo 'migration du wiki '.$wikini['gewi_code_alpha_wikini'].' effectuée '.NL.NL.NL.NL; |
| //} else { |
| // echo 'wiki dejà à jour '.$wikini['gewi_code_alpha_wikini'].NL.NL.NL.NL; |
| //} |
| } |
| } |
| |
| private function verifierPresenceTableTriple($base, $prefixe) { |
| |
| $requete_presence_table = 'SELECT COUNT(*) as table_existe FROM information_schema.tables |
| WHERE TABLE_SCHEMA = "'.$base.'" AND TABLE_NAME = "'.$prefixe.'triples"'; |
| |
| $resultat_presence_table = $this->executerRequete($requete_presence_table); |
| |
| $presence_table = false; |
| |
| foreach($resultat_presence_table as $table_est_presente) { |
| if($table_est_presente['table_existe'] >= 1) { |
| $presence_table = true; |
| break; |
| } |
| } |
| |
| return $presence_table; |
| } |
| |
| private function creerTableTriple($base, $prefixe) { |
| |
| echo 'Création de la table triple '.NL; |
| |
| $requete_creation_table = 'CREATE TABLE '.$base.'.'.$prefixe.'triples (' . |
| ' id int(10) unsigned NOT NULL auto_increment,' . |
| ' resource varchar(255) NOT NULL default \'\',' . |
| ' property varchar(255) NOT NULL default \'\',' . |
| ' value text NOT NULL default \'\',' . |
| ' PRIMARY KEY (id),' . |
| ' KEY resource (resource),' . |
| ' KEY property (property)' . |
| ') TYPE=MyISAM'; |
| |
| return $this->executerRequeteManip($requete_creation_table); |
| } |
| |
| private function verifierPresenceTableUsers($base, $prefixe) { |
| |
| $requete_presence_table = 'SELECT COUNT(*) as table_existe FROM information_schema.tables |
| WHERE TABLE_SCHEMA = "'.$base.'" AND TABLE_NAME = "'.$prefixe.'users"'; |
| |
| $resultat_presence_table = $this->executerRequete($requete_presence_table); |
| |
| $presence_table = false; |
| |
| foreach($resultat_presence_table as $table_est_presente) { |
| if($table_est_presente['table_existe'] >= 1) { |
| $presence_table = true; |
| break; |
| } |
| } |
| |
| return $presence_table; |
| } |
| |
| private function ajouterUtilisateurAdmin($base, $prefixe, $infos_admin) { |
| |
| if(!$this->verifierPresenceTableUsers($base, $prefixe)) { |
| echo 'Impossible d\'ajouter l\'adminwiki : '.$prefixe.'_users n\'existe_pas'.NL; |
| return; |
| } |
| |
| echo 'Ajout de l\'utilisateur wikiAdmin '.NL; |
| |
| $requete_suppression_si_admin_present = 'DELETE FROM '.$base.'.'.$prefixe.'users '. |
| 'WHERE name ="'.$infos_admin['name'].'"'; |
| |
| $this->executerRequeteManip($requete_suppression_si_admin_present); |
| |
| $requete_creation_admin = "INSERT INTO ".$base.'.'.$prefixe."users SET ". |
| "signuptime = now(), ". |
| "name = '".$infos_admin['name']."', ". |
| "email = '".$infos_admin['email']."', ". |
| "password = md5('".$infos_admin['password']."')"; |
| |
| return $this->executerRequeteManip($requete_creation_admin); |
| } |
| |
| private function changerVersionWakkaConfig($chemin_wikini) { |
| |
| if(file_exists($chemin_wikini.'/wakka.config.php')) { |
| |
| $contenu_wakka_config = file_get_contents($chemin_wikini.'/wakka.config.php'); |
| $contenu_wakka_config_maj = str_replace('"wikini_version" => "0.4.3"','"wikini_version" => "0.5.0"',$contenu_wakka_config); |
| $contenu_wakka_config_maj = str_replace("'wikini_version' => '0.4.3'","'wikini_version' => '0.5.0'",$contenu_wakka_config_maj); |
| |
| if(self::dry_run) { |
| echo 'Wakka Config mis à jour '.$contenu_wakka_config_maj.NL; |
| } else { |
| file_put_contents($chemin_wikini.'/wakka.config.php', $contenu_wakka_config_maj); |
| } |
| |
| echo 'Changement de la version de wikini '.NL; |
| } else { |
| echo 'Attention ! le fichier '.$chemin_wikini.'/wakka.config.php n\'existe pas '.NL; |
| } |
| } |
| |
| private function copierFichiersWikini($chemin_base_wiki_defaut, $chemin_wiki_dest) { |
| |
| echo 'copie de '.$chemin_base_wiki_defaut.' vers '.$chemin_wiki_dest.NL; |
| if(self::dry_run) { |
| $copie_recursive = true; |
| } else { |
| if(trim($chemin_base_wiki_defaut) != '/' && trim($chemin_wiki_dest) != '/') { |
| echo " cp -Rf -a ".$chemin_base_wiki_defaut."* ".$chemin_wiki_dest."/ 2>&1 "; |
| $copie_recursive = shell_exec( " cp -Rf -a ".$chemin_base_wiki_defaut."* ".$chemin_wiki_dest."/ 2>&1 " ); |
| } |
| } |
| |
| return $copie_recursive; |
| } |
| } |
| ?> |