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