}
var $opts = false;
+ var $disabled = array();
var $cli = false;
{
PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError'));
+ $this->checkSystem();
+
+ $ff = HTML_FlexyFramework::get();
+
+ $this->disabled = explode(',', $ff->disable);
//$this->fixSequencesPgsql();exit;
$this->opts = $opts;
$this->checkOpts($opts);
-
-
if (empty($opts['data-only'])) {
$this->importSQL();
}
$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->runExtensions();
+
}
function output() {
$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;
}
$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..
' ' . basename($url['path']);
- echo $psql_cmd . "\n" ;if($dir = '/home/edward/gitlive/web.registrar/Pman/Registrar/pgsql'){
- print_R($dir);exit;
- }
-
+ echo $psql_cmd . "\n" ;
echo "scan : $dir\n";
+
if (is_file($dir)) {
$files = array($dir);
echo "$bfn: $cmd ". ($ff->cli ? "\n" : "<BR>\n");
-
passthru($cmd);
if ($fn) {
function importmysqldir($dburl, $dir)
{
+
+ $this->fixMysqlInnodb(); /// run once
+
echo "Import MYSQL :: $dir\n";
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 "OK - {$line}\n"; flush();
+ continue;
+ }
+ $continue =0;
+ switch($matches[1]) {
+ 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 1054: // Unknown column -- triggered by CHANGE COLUMN - but may hide other errrors..
+ $continue = 1;
+ break;
+
+ }
+ if ($continue) {
+ echo "IGNORE - {$line}\n"; flush();
+ continue;
+ }
+ // real errors...
+ // 1051: // Unknown table -- normally drop = add iff exists..
+ echo "File: $fn\n$line\n";
+ exit;
+
+
+ }
+
}
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;
'name' => 'system-email-from',
'type' => 0, // system
),
+ array(
+ 'name' => 'core-person-signup-bcc',
+ 'type' => 0, // system
+ ),
));
}
}
+
+ 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..
function fixMysqlInnodb()
{
+
+ static $done_check = false;
+ if ($done_check) {
+ return;
+ }
// innodb in single files is far more efficient that MYD or one big innodb file.
// first check if database is using this format.
$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;;
}
+ var $extensions = array(
+ 'EngineCharset',
+ 'Links',
+ );
+
+ function runExtensions()
+ {
+
+ $ff = HTML_Flexyframework::get();
+
+ $dburl = parse_url($ff->DB_DataObject['database']);
+
+ $dbtype = $dburl['scheme'];
+
+ 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();
+
+ }
+
+ }
+
+
+ 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