Subversion Repositories Applications.projet

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