function _performUpgrade()
{
$dbType = 'mysql';
$sqlupgradedir = KT_DIR . 'sql/' . $dbType . '/upgrade/';
$queries = SQLFile::sqlFromFile($sqlupgradedir . $this->name);
return $this->dbUtilities->runQueries($queries);
}
function _performUpgrade()
{
global $default;
$sqlupgradedir = KT_DIR . '/sql/' . $default->dbType . '/upgrade/';
$queries = SQLFile::sqlFromFile($sqlupgradedir . $this->name);
return DBUtil::runQueries($queries, $default->_admindb);
}
function upgradePlugin($iStart, $iEnd)
{
if (is_null($this->sSQLDir)) {
return $iEnd;
// no db changes, must reach the "end".
}
global $default;
DBUtil::setupAdminDatabase();
for ($i = $iStart; $i <= $iEnd; $i++) {
$sqlfile = sprintf("%s/upgradeto%d.sql", $this->sSQLDir, $i);
if (!file_exists($sqlfile)) {
continue;
// skip it.
}
$queries = SQLFile::sqlFromFile($sqlfile);
$res = DBUtil::runQueries($queries, $default->_admindb);
if (PEAR::isError($res)) {
return $i;
// break out completely, indicating how far we got pre-error.
}
}
return $iEnd;
}
function testSQLFile()
{
$aExpected = array("SELECT \"as;\";", "SELECT \"as\\\";\";", "SELECT \"as\\\\\";", "SELECT \"as\\\\\";", "SELECT \"as\\\\\";", "SELECT \"as\\\\\";", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT 'as\\';';", "SELECT \"'as\\'\"';';", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT 'as\\\\';", "SELECT '\nasdf; \"\\\" \\'\n\nasdf; ';");
$aReceived = SQLFile::sqlFromFile(dirname(__FILE__) . "/test_sqlfile.sql");
$this->assertExpectedResults($aExpected, $aReceived);
}
