File Source for tangra_module_release

<?php
// $Id$
/**
* Contains class Tangra_Module_Release_DBC
*
* @package tangra_lib
* @subpackage modules_manager
*/
/**
*
*/
require_once(TANGRA_MAIN_DIR.'interfaces/i_db_storable.class.php');
/**
*
*/
require_once('tangra_module_release.class.php');
/**
* Tangra module release DBC
*
* @package tangra_lib
* @subpackage modules_manager
*/
class Tangra_Module_Release_DBC extends Tangra_Module_Release implements I_DB_Storable {
/**
* Saves the record
*
* @param DB_Connection $dbc
* @return integer On success returns module ID, on failure - false
*/
public function save(DB_Connection $dbc) {
$ret = false;
if ($this->get_id()) {
$ret = $this->update($dbc);
} else {
$ret = $this->insert($dbc);
$this->set_id($ret);
}
return $ret;
}
/**
* Loads record by id
*
* @param DB_Connection $dbc
* @param integer $id
* @return integer On success returns module ID, on failure - false
*/
public function load_by_id(DB_Connection $dbc, $id) {
$ret = false;
$sql = "select module, ".
"version, ".
"description, ".
"maintainer, ".
"url, ".
"requires_tangra_lib_version, ".
"requires_php_version, ".
"online, ".
"release_date, ".
"changes ".
"from tmod_releases ".
"where id = $id";
$rez = $dbc->execute($sql);
if (!$rez->is_eof()) {
$rez_obj = $rez->fetch_object();
$this->set_id($id);
$this->set_module($rez_obj->MODULE);
$this->set_version(stripslashes($rez_obj->VERSION));
$this->set_description(stripslashes($rez_obj->DESCRIPTION));
$this->set_maintainer(stripslashes($rez_obj->MAINTAINER));
$this->set_url(stripslashes($rez_obj->URL));
$this->set_requires_tangra_lib_version(stripslashes($rez_obj->REQUIRES_TANGRA_LIB_VERSION));
$this->set_requires_php_version(stripslashes($rez_obj->REQUIRES_PHP_VERSION));
$this->set_online($rez_obj->ONLINE);
$this->set_release_date($rez_obj->RELEASE_DATE);
$this->set_changes(stripslashes($rez_obj->CHANGES));
$ret = $id;
}
return $ret;
}
/**
* Inserts record
*
* @param DB_Connection $dbc
* @return integer On success returns module ID, on failure - false
* @internal
*/
protected function insert(DB_Connection $dbc) {
$ret = false;
$id = $dbc->generate_id('tmod_releases_seq');
$module = $this->get_module();
$version = $this->get_version();
$description = addslashes($this->get_description());
$maintainer = addslashes($this->get_maintainer());
$url = addslashes($this->get_url());
$requires_tangra_lib_version = addslashes($this->get_requires_tangra_lib_version());
$requires_php_version = addslashes($this->get_requires_php_version());
$online = $this->get_online() ? 1 : 0;
$release_date = $this->get_release_date();
$changes = addslashes($this->get_changes());
if ($id) {
$sql = "insert into tmod_releases (id, ".
"module, ".
"version, ".
"description, ".
"maintainer, ".
"url, ".
"requires_tangra_lib_version, ".
"requires_php_version, ".
"online, ".
"release_date, ".
"changes ".
") ".
"values ".
"($id,".
"$module, ".
"'$version', ".
"'$description', ".
"'$maintainer', ".
"'$url', ".
"'$requires_tangra_lib_version', ".
"'$requires_php_version', ".
"'$online', ".
"'$release_date', ".
"'$changes'".
")";
$dbc->execute($sql);
$ret = $id;
} else {
throw new TE_Exception('ID not generated - tmod_releases_seq');
}
return $ret;
}
/**
* Updates record
*
* @param DB_Connection $dbc
* @return integer On success returns module ID, on failure - false
* @internal
*/
protected function update(DB_Connection $dbc) {
$id = $this->get_id();
$module = $this->get_module();
$version = $this->get_version();
$description = addslashes($this->get_description());
$maintainer = addslashes($this->get_maintainer());
$url = addslashes($this->get_url());
$requires_tangra_lib_version = addslashes($this->get_requires_tangra_lib_version());
$requires_php_version = addslashes($this->get_requires_php_version());
$online = $this->get_online() ? 1 : 0;
$release_date = $this->get_release_date();
$changes = addslashes($this->get_changes());
$sql = "update tmod_releases set ".
"version = '$version', ".
"description = '$description', ".
"maintainer = '$maintainer', ".
"url = '$url', ".
"requires_tangra_lib_version = '$requires_tangra_lib_version', ".
"requires_php_version = '$requires_php_version', ".
"online = $online, ".
"release_date = '$release_date', ".
"changes = '$changes' ".
"where id = ".$id;
$dbc->execute($sql);
$ret = $id;
return $ret;
}
/**
* Gets SQL for grid
*
* @return string SQL statement
*/
public static function get_sql_for_grid() {
$sql = "select id, version from tmod_releases order by version desc";
return $sql;
}
/**
* Gets count SQL for grid
*
* @return string SQL statement
*/
public static function get_sql_count_for_grid() {
$sql = "select count(id) as total_rows from tmod_releases";
return $sql;
}
/**
* Checks if it is unique version
*
* @param DB_Connection $dbc
* @param string $version
* @param integer $module_id Module ID
* @param integer $id ID of current release
* @return boolean
*/
public static function is_unique_version(DB_Connection $dbc, $version, $module_id, $id = 0) {
tangra_if_not_int_throw_e($id);
tangra_if_not_int_throw_e($module_id);
$version = addslashes($version);
$sql = "select id from tmod_releases where module = $module_id and version = '$version' and id <> $id";
$rez = $dbc->execute($sql);
return $rez->is_eod();
}
/**
* Loads all releases for module
*
* @param DB_Connection $dbc
* @param integer $module Module ID
* @return array Array of Tangra_Module_Release_DBC objects
*/
public static function load_all_for_module(DB_Connection $dbc, $module) {
tangra_if_not_int_throw_e($module);
$sql = "select id from tmod_releases where module = $module order by id desc";
$ret = array();
$rez = $dbc->execute($sql);
while ($rez_obj = $rez->fetch_object()) {
$tmp = new Tangra_Module_Release_DBC();
$tmp->load_by_id($dbc, $rez_obj->ID);
$ret[] = clone $tmp;
}
return $ret;
}
/**
* Loads all online releases for module
*
* @param DB_Connection $dbc
* @param integer $module Module ID
* @return array Array of Tangra_Module_Release_DBC objects
*/
public static function load_all_online_for_module(DB_Connection $dbc, $module) {
tangra_if_not_int_throw_e($module);
$sql = "select id from tmod_releases where module = $module and online = 1 order by id desc";
$ret = array();
$rez = $dbc->execute($sql);
while ($rez_obj = $rez->fetch_object()) {
$tmp = new Tangra_Module_Release_DBC();
$tmp->load_by_id($dbc, $rez_obj->ID);
$ret[] = clone $tmp;
}
return $ret;
}
/**
* Loads previos online release
*
* @param DB_Connection $dbc
* @param integer $current_release_id Current release ID
* @param integer $module_id Module ID
* @return Tangra_Module_Release_DBC On success return object of type Tangra_Module_Release_DBC, on failure - false
*/
public static function load_previous_online_release(DB_Connection $dbc, $current_release_id, $module_id) {
tangra_if_not_int_throw_e($current_release_id);
tangra_if_not_int_throw_e($module_id);
$ret = false;
$sql = "select id from tmod_releases where module = $module_id and id < $current_release_id order by id desc";
$rez = $dbc->execute($sql);
if (!$rez->is_eod()) {
$rez_obj = $rez->fetch_object();
$ret = new Tangra_Module_Release_DBC();
$ret->load_by_id($dbc, $rez_obj->ID);
}
return $ret;
}
/**
* Deletes record
*
* @param DB_Connection $dbc
* @param integer $release_id ID of the release record
*/
public static function delete(DB_Connection $dbc, $release_id) {
tangra_if_not_int_throw_e($release_id);
$sql = "delete from tmod_releases where id = $release_id";
$dbc->execute($sql);
}
// TODO - following to be removed (?)
// public static function load_last_online_release(DB_Connection $dbc, $module_id) {
// $ret = false;
//
// $sql = "select id from tmod_releases where module = $module_id order by id desc";
// $rez = $dbc->execute($sql);
//
// if (!$rez->is_eod()) {
// $rez_obj = $rez->fetch_object();
// $ret = new Tangra_Module_Release_DBC();
// $ret->load_by_id($dbc, $rez_obj->ID);
// }
//
// return $ret;
// }
/**
* Loads highest online release for module
*
* @param DB_Connection $dbc
* @param integer $module_id Module ID
* @return Tangra_Module_Release_DBC On success return object of type Tangra_Module_Release_DBC, on failure - false
*/
public static function load_highest_online_release(DB_Connection $dbc, $module_id) {
$ret = false;
$sql = "select id, version from tmod_releases where module = $module_id order by id desc";
$rez = $dbc->execute($sql);
$versions = array();
while($rez_obj = $rez->fetch_object()) {
$versions[$rez_obj->VERSION] = $rez_obj->ID;
}
if ($versions) {
if (count($versions) > 1) {
uasort($versions, 'version_compare');
$sorted_desc = array_reverse($versions);
reset($sorted_desc);
$ret = new Tangra_Module_Release_DBC();
$ret->load_by_id($dbc, current($sorted_desc));
} else {
$ret = new Tangra_Module_Release_DBC();
$ret->load_by_id($dbc, current($versions));
}
}
return $ret;
}
/**
* Loads release by module ID and version
*
* @param DB_Connection $dbc
* @param integer $module_id Module ID
* @param string $version Version literal
* @return Tangra_Module_Release_DBC On success returns object of type Tangra_Module_Release_DBC, on failure - false
*/
public function load_by_module_and_version(DB_Connection $dbc, $module_id, $version) {
tangra_if_not_int_throw_e($module_id);
$version = addslashes($version);
$ret = false;
$sql = "select id from tmod_releases where module = $module_id and version = '$version'";
$rez = $dbc->execute($sql);
if (!$rez->is_eod()) {
$rez_obj = $rez->fetch_object();
$ret = $this->load_by_id($dbc, $rez_obj->ID);
}
return $ret;
}
/**
* Loads release by module HID and version
*
* @param DB_Connection $dbc
* @param string $module_hid Module HID
* @param string $version Version literal
* @return Tangra_Module_Release_DBC On success returns object of type Tangra_Module_Release_DBC, on failure - false
*/
public function load_by_module_hid_and_version(DB_Connection $dbc, $module_hid, $version) {
$module_hid = addslashes($module_hid);
$version = addslashes($version);
$ret = false;
$sql = "select id from tmods where hid = '$module_hid'";
$rez = $dbc->execute($sql);
if (!$rez->is_eod()) {
$rez_obj = $rez->fetch_object();
$ret = $this->load_by_module_and_version($dbc, $rez_obj->ID, $version);
}
return $ret;
}
/**
* Loads hids for all releases
*
* @param DB_Connection $dbc
* @return array
*/
public static function load_all_hids_as_array(DB_Connection $dbc) {
$sql = "select tmods.hid as hid, tmod_releases.version as version from tmods, tmod_releases where tmod_releases.module = tmods.id";
$rez = $dbc->execute($sql);
$ret = array();
while ($rez_obj = $rez->fetch_object()) {
$ret[$rez_obj->HID.'-'.$rez_obj->VERSION] = false;
}
return $ret;
}
public static function load_arr_latest_online(DB_Connection $dbc, $count) {
$sql = "select tmod_releases.id, tmods.hid from tmod_releases, tmods where tmod_releases.online = 1 and tmod_releases.module = tmods.id order by id desc";
$ret = array();
$rez = $dbc->execute($sql);
$c = 0;
while (($rez_obj = $rez->fetch_object()) && $c < $count) {
$tmp = new Tangra_Module_Release_DBC();
$tmp->load_by_id($dbc, $rez_obj->ID);
$ret[$c]['rel'] = clone $tmp;
$ret[$c]['mod'] = $rez_obj->HID;
$c++;
}
return $ret;
}
}

Source for file tangra_module_release_dbc.class.php