DataObjects/Core_domain.php
[Pman.Core] / UpdateDatabase.php
index 7441e4f..9176712 100644 (file)
@@ -105,6 +105,7 @@ class Pman_Core_UpdateDatabase extends Pman
     }
     
     var $opts = false;
+    var $disabled = array();
     
     
     var $cli = false;
@@ -130,6 +131,17 @@ class Pman_Core_UpdateDatabase extends Pman
     {
         PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError'));
    
+        $this->checkSystem();
+   
+        $ff = HTML_FlexyFramework::get();
+        
+        if(!empty($ff->Core_Notify)){
+            require_once 'Pman/Core/NotifySmtpCheck.php';
+            $x = new Pman_Core_NotifySmtpCheck();
+            $x->check();
+        }
+        
+        $this->disabled = explode(',', $ff->disable);
         
         //$this->fixSequencesPgsql();exit;
         $this->opts = $opts;
@@ -138,8 +150,6 @@ class Pman_Core_UpdateDatabase extends Pman
         
         $this->checkOpts($opts);
         
-        
-     
         if (empty($opts['data-only'])) {
             $this->importSQL();
         }
@@ -150,12 +160,13 @@ class Pman_Core_UpdateDatabase extends Pman
         $this->runUpdateModulesData();
         
         
-        if (!empty($opts['add-company'])) {
+        if (!empty($opts['add-company']) && !in_array('Core', $this->disabled)) {
             // make sure we have a good cache...?
            
             DB_DataObject::factory('companies')->initCompanies($this, $opts);
         }
-        $this->fixLinks();
+        
+        $this->runExtensions();
          
          
     }
@@ -186,10 +197,16 @@ class Pman_Core_UpdateDatabase extends Pman
        
         
         $ar = $this->modulesList();
-       
+        
         
         foreach($ar as $m) {
-             echo "Importing SQL from module $m\n";
+            
+            if(in_array($m, $this->disabled)){
+                echo "module $m is disabled \n";
+                continue;
+            }
+            
+            echo "Importing SQL from module $m\n";
             if (!empty($this->opts['only-module-sql']) && $m != $this->opts['only-module-sql']) {
                 continue;
             }
@@ -230,6 +247,7 @@ class Pman_Core_UpdateDatabase extends Pman
             
             $this->{$dirmethod}($dburl, $fd);
             
+            
             // new -- sql directory..
             // new style will not support migrate ... they have to go into mysql-migrate.... directories..
             // new style will not support pg.sql etc.. naming - that's what the direcotries are for..
@@ -341,6 +359,9 @@ class Pman_Core_UpdateDatabase extends Pman
     
     function importmysqldir($dburl, $dir)
     {
+        
+        $this->fixMysqlInnodb(); /// run once 
+        
         echo "Import MYSQL :: $dir\n";
         
         
@@ -377,11 +398,50 @@ class Pman_Core_UpdateDatabase extends Pman
                     continue;
                 }
                 
-                $cmd = "$mysql_cmd -f < " . escapeshellarg($fn) ;
+                $cmd = "$mysql_cmd -f < " . escapeshellarg($fn) ." 2>&1" ;
                 
                 echo basename($dir).'/'. basename($fn) .    '::' .  $cmd. ($this->cli ? "\n" : "<BR>\n");
                 
-                passthru($cmd);
+                
+                $fp = popen($cmd, "r"); 
+                while(!feof($fp)) 
+                { 
+                    // send the current file part to the browser 
+                    $line = trim(fgets($fp, 1024));
+                    if (empty($line)) {
+                        continue;
+                    }
+                    $matches = array();
+                    if (!preg_match('/^ERROR\s+([0-9]+)/', $line, $matches)) {
+                        echo " ---- {$line}\n"; flush();
+                        continue;
+                    }
+                    $continue =0;
+                    switch($matches[1]) {
+                        case 1017: // cause by renaming table -- old one does not exist..
+                        case 1050: // create tables triggers this..
+                        case 1060: //    Duplicate column name
+                        case 1061: // Duplicate key name - triggered by add index.. but could hide error. - unlikely though.
+                        case 1091: // drop index -- name does not exist.. might hide errors..
+                        
+                        case 1146: // drop a index on an unknown table.. - happens rarely...
+                        case 1054: // Unknown column -- triggered by CHANGE COLUMN - but may hide other errrors..
+                            $continue = 1;
+                            break;
+                        
+                    }
+                    if ($continue) {
+                        echo " ---- {$line}\n"; flush();
+                        continue;
+                    }
+                    // real errors...
+                    // 1051: // Unknown table -- normally drop = add iff exists..
+                    echo "File: $fn\n$line\n";
+                    exit;
+                    
+                    
+                } 
+                
             
                 
         }
@@ -546,22 +606,27 @@ class Pman_Core_UpdateDatabase extends Pman
     
     function runUpdateModulesData()
     {
-        
-        
         HTML_FlexyFramework::get()->generateDataobjectsCache(true);
-        echo "Running jsonImportFromArray\n";
-        Pman_Core_UpdateDatabase::jsonImportFromArray($this->opts);
         
+        if(!in_array('Core', $this->disabled)){
+            echo "Running jsonImportFromArray\n";
+            Pman_Core_UpdateDatabase::jsonImportFromArray($this->opts);
+
+
+            echo "Running updateData on modules\n";
+            // runs core...
+            echo "Core\n";
+            $this->updateData(); 
+        }
         
-        echo "Running updateData on modules\n";
-        // runs core...
-        echo "Core\n";
-        $this->updateData(); 
         $modules = array_reverse($this->modulesList());
         
         // move 'project' one to the end...
         
         foreach ($modules as $module){
+            if(in_array($module, $this->disabled)){
+                continue;
+            }
             $file = $this->rootDir. "/Pman/$module/UpdateDatabase.php";
             if($module == 'Core' || !file_exists($file)){
                 continue;
@@ -705,6 +770,79 @@ class Pman_Core_UpdateDatabase extends Pman
         
     }
     
+    
+    function initEmails($templateDir, $emails)
+    {
+      
+        $pg = HTML_FlexyFramework::get()->page;
+        foreach($emails as $name=>$data) {
+            $cm = DB_DataObject::factory('core_email');
+            $update = $cm->get('name', $name);
+            $old = clone($cm);
+            
+            if (empty($cm->bcc_group)) {
+                if (empty($data['bcc_group'])) {
+                    $this->jerr("missing bcc_group for template $name");
+                }
+                $g = DB_DataObject::Factory('Groups')->lookup('name',$data['bcc_group']);
+                
+                if (!$g) {
+                    $this->jerr("bcc_group {$data['bcc_group']} does not exist when importing template $name");
+                }
+                if (!$g->members('email')) {
+                      $this->jerr("bcc_group {$data['bcc_group']} does not have any members");
+                }
+                
+                
+                $cm->bcc_group = $g->id;
+            }
+            if (empty($cm->test_class)) {
+                if (empty($data['test_class'])) {
+                    $this->jerr("missing test_class for template $name");
+                }
+                $cm->test_class = $data['test_class'];
+            }
+            require_once $cm->test_class . '.php';
+            
+            $clsname = str_replace('/','_', $cm->test_class);
+            try {
+                $method = new ReflectionMethod($clsname , 'test_'. $name) ;
+                $got_it = $method->isStatic();
+            } catch(Exception $e) {
+                $got_it = false;
+                
+            }
+            if (!$got_it) {
+                $this->jerr("template {$name} does not have a test method {$clsname}::test_{$name}");
+            }
+            if ($update) {
+                $cm->update($old);
+                echo "email: {$name} - checked\n";
+                continue; /// we do not import the body content of templates that exist...
+            } else {
+                $cm->insert();
+            }
+            
+            
+    //        $basedir = $this->bootLoader->rootDir . $mail_template_dir;
+            
+            $opts = array(
+                'update' => 1,
+                'file' => $templateDir. $name .'.html'
+            );
+            
+            if (!empty($data['master'])) {
+                $opts['master'] = $templateDir . $master .'.html';
+            }
+            require_once 'Pman/Core/Import/Core_email.php';
+            $x = new Pman_Core_Import_Core_email();
+            $x->get('', $opts);
+            
+            echo "email: {$name} - CREATED\n";
+        }
+    }
+    
+    
     function updateData()
     {
         // fill i18n data..
@@ -733,15 +871,11 @@ class Pman_Core_UpdateDatabase extends Pman
         $db = DB_DataObject::factory('core_enum');
         $db->query("show variables like 'innodb_file_per_table'");
         $db->fetch();
-        var_dump($db);
-        // Value should == ON
-        
-        // I think it needs to look in the mysql directory.... to see if the idb exists..
-        $db = DB_DataObject::factory('core_enum');
-        $db->query("SHOW TABLE STATUS");
-        // Engine should be InnoDB - and file XXX.idb should exist...
-        
+        if ($db->Value == 'OFF') {
+            die("Error: set innodb_file_per_table = 1 in my.cnf\n\n");
+        }
         
+        $done_check = true;;
 
  
         
@@ -842,7 +976,12 @@ class Pman_Core_UpdateDatabase extends Pman
        
     }
     
-    function fixLinks()
+    var $extensions = array(
+        'EngineCharset',
+        'Links',
+    );
+    
+    function runExtensions()
     {
         
         $ff = HTML_Flexyframework::get();
@@ -851,16 +990,77 @@ class Pman_Core_UpdateDatabase extends Pman
         
         $dbtype = $dburl['scheme'];
        
-        $scls = ucfirst($dbtype). 'Links';
-        $cls = 'Pman_Core_UpdateDatabase_'. $scls;
-        $fn = implode('/',explode('_', $cls)).'.php';
-        if (!file_exists(__DIR__.'/UpdateDatabase/'. $scls .'.php')) {
-            return;
+        foreach($this->extensions as $ext) {
+       
+            $scls = ucfirst($dbtype). $ext;
+            $cls = __CLASS__ . '_'. $scls;
+            $fn = implode('/',explode('_', $cls)).'.php';
+            if (!file_exists(__DIR__.'/UpdateDatabase/'. $scls .'.php')) {
+                return;
+            }
+            require_once $fn;
+            $c = new $cls();
+            
         }
-        require_once $fn;
-        $c = new $cls();
         
+    }
+    
+    
+    function checkSystem()
+    {
+        // most of these are from File_Convert...
+        
+        // these are required - and have simple dependancies.
+        require_once 'System.php';
+        $req = array( 
+            'convert',
+            'grep',
+            'pdfinfo',
+            'pdftoppm',
+            'rsvg-convert',  //librsvg2-bin
+            'strings',
+        );
+         
+         
+         
+        // these are prefered - but may have complicated depenacies
+        $pref= array(
+            'abiword',
+            'faad',
+            'ffmpeg',
+            'html2text', // not availabe in debian squeeze
+            'pdftocairo',  //poppler-utils - not available in debian squeeze.
+
+            'lame',
+            'ssconvert',
+            'unoconv',
+            'wkhtmltopdf',
+            'xvfb-run',
+        );
+        $res = array();
+        $fail = false;
+        foreach($req as $r) {
+            if (!System::which($r)) {
+                $res[] = $r;
+            }
+            $fail = true;
+        }
+        if ($res) {
+            $this->jerr("Missing these programs - need installing\n" . implode("\n",$res));
+        }
+        foreach($pref as $r) {
+            if (!System::which($r)) {
+                $res[] = $r;
+            }
+            $fail = true;
+        }
+        if ($res) {
+            echo "WARNING: Missing these programs - they may need installing\n". implode("\n",$res);
+            sleep(5);
+        }
         
         
     }
+    
+    
 }
\ No newline at end of file