/** * Tests update scripts list * * @return void */ public function testGetUpgradeScripts() { $update_scripts = \Galette\Core\Install::getUpdateScripts(GALETTE_BASE_PATH . '/install', 'pgsql', '0.6'); $knowns = array('0.60' => 'upgrade-to-0.60-pgsql.sql', '0.61' => 'upgrade-to-0.61-pgsql.sql', '0.62' => 'upgrade-to-0.62-pgsql.sql', '0.63' => 'upgrade-to-0.63-pgsql.sql', '0.70' => 'upgrade-to-0.70.php', '0.71' => 'upgrade-to-0.71-pgsql.sql', '0.74' => 'upgrade-to-0.74-pgsql.sql', '0.75' => 'upgrade-to-0.75-pgsql.sql', '0.76' => 'upgrade-to-0.76-pgsql.sql', '0.8' => 'upgrade-to-0.8.php', '0.81' => 'upgrade-to-0.81-pgsql.sql', '0.82' => 'upgrade-to-0.82-pgsql.sql'); //as of 0.8, we got 10 update scripts total $this->array($update_scripts)->hasSize(count($knowns))->isIdenticalTo($knowns); $update_scripts = \Galette\Core\Install::getUpdateScripts(GALETTE_BASE_PATH . '/install', 'pgsql', '0.7'); //if we're from 0.7.0, there are only 6 update scripts left $this->array($update_scripts)->hasSize(count($knowns) - 4); $update_scripts = \Galette\Core\Install::getUpdateScripts(GALETTE_BASE_PATH . '/install'); //without specifying database nor version, we got 10 update scripts total $this->array(array_values($update_scripts))->hasSize(count($knowns))->isEqualTo(array_keys($knowns)); $this->_install->setMode(\Galette\Core\Install::UPDATE); $errors = array(); $this->_install->setDbType(\Galette\Core\Db::PGSQL, $errors); $this->_install->setInstalledVersion('0.6'); $update_scripts = $this->_install->getScripts(GALETTE_BASE_PATH . '/install'); $this->array($update_scripts)->hasSize(count($knowns))->isIdenticalTo($knowns); $this->_install->setMode(\Galette\Core\Install::INSTALL); $update_scripts = $this->_install->getScripts(GALETTE_BASE_PATH . '/install'); $this->array($update_scripts)->hasSize(1)->hasKey('current')->strictlyContains(\Galette\Core\Db::PGSQL . '.sql'); }
$update_scripts = Install::getUpdateScripts($plugin['root'], TYPE_DB); $tpl->assign('update_scripts', $update_scripts); $title = _T("Previous version selection"); break; case 'i4': case 'u4': if ($step == 'i4') { $title = _T("Creation of the tables"); } else { $title = _T("Update of the tables"); } // begin : copyright (2002) the phpbb group (support@phpbb.com) // load in the sql parser include GALETTE_ROOT . 'includes/sql_parse.php'; if ($step == 'u4') { $update_scripts = Install::getUpdateScripts($plugin['root'], TYPE_DB, $_POST['previous_version']); } else { $update_scripts['current'] = TYPE_DB . '.sql'; } $sql_query = ''; while (list($key, $val) = each($update_scripts)) { $sql_query .= @fread(@fopen($plugin['root'] . '/scripts/' . $val, 'r'), @filesize($plugin['root'] . '/scripts/' . $val)); $sql_query .= "\n"; } $sql_query = preg_replace('/galette_/', PREFIX_DB, $sql_query); $sql_query = remove_remarks($sql_query); $sql_query = split_sql_file($sql_query, ';'); for ($i = 0; $i < sizeof($sql_query); $i++) { $query = trim($sql_query[$i]); if ($query != '' && $query[0] != '-') { //some output infos