$options = array('persistent' => false, 'portability' => DB_PORTABILITY_ALL);
$dbh =& DB::connect(PEAR_DATABASE_DSN, $options);
}
$pear_rest = new pearweb_Channel_REST_Generator($rest_path, $dbh);
}
ob_end_clean();
PEAR::setErrorHandling(PEAR_ERROR_DIE);
require_once 'System.php';
System::rm(array('-r', $rest_path));
System::mkdir(array('-p', $rest_path));
chmod($rest_path, 0777);
echo "Generating Category REST...\n";
include_once 'pear-database-category.php';
foreach (category::listAll() as $category) {
echo " {$category['name']}...";
$pear_rest->saveCategoryREST($category['name']);
echo "done\n";
}
$pear_rest->saveAllCategoriesREST();
echo "Generating Maintainer REST...\n";
$maintainers = $dbh->getAll('SELECT users.* FROM users, karma WHERE users.handle = karma.user
AND (karma.level = "pear.dev" OR karma.level = "pear.admin")', array(), DB_FETCHMODE_ASSOC);
foreach ($maintainers as $maintainer) {
echo " {$maintainer['handle']}...";
$pear_rest->saveMaintainerREST($maintainer['handle']);
echo "done\n";
}
echo "Generating All Maintainers REST...\n";
$pear_rest->saveAllMaintainersREST();
echo "done\n";
echo "Generating Package REST...\n";
/**
* Updates a categories details
*
* @param integer $id Category ID
* @param string $name Category name
* @param string $desc Category Description
* @return mixed True on success, pear_error otherwise
*/
static function update($id, $name, $desc = '')
{
global $dbh;
$sql = 'SELECT name FROM categories WHERE id = ?';
$data = $GLOBALS['dbh']->getOne($sql, array($id));
include_once 'pear-rest.php';
$pear_rest = new pearweb_Channel_REST_Generator(PEAR_REST_PATH, $dbh);
$pear_rest->deleteCategoryREST($data);
$sql = 'UPDATE categories SET name = ?, description = ? WHERE id = ?';
$ret = $GLOBALS['dbh']->query($sql, array($name, $desc, $id));
$pear_rest->saveCategoryREST($name);
$pear_rest->saveAllCategoriesREST();
$pear_rest->savePackagesCategoryREST($name);
return $ret;
}
