source: build-queue/package.php @ 7542

<?php

class Package 
{
    private $_id;
    private $_pkgname;
    private $_developer;
    private $_distro;
    private $_status = FALSE;
    
    private $_db;
    private $_update = FALSE;
    
    public function __construct($id=NULL)
    {
        $this->_id = $id;

        if($id != NULL) {
            $this->_connect();
            $result=$this->_query("select * from queue where id='$id'");
            $row=$this->_fetch($result);
        
            $this->setPkgName($row['pkgname']);
            $this->setId($row['id']);
            $this->setDeveloper($row['developer']);
            $this->setDistro($row['distro']);
            $this->setStatus($row['status']);
            $this->_setUpdate(FALSE);
        }
    }
    
    protected function _connect()
    {
        $this->_db = sqlite_open(SQLITE_LOCATION);
    }

    private function _disconnect()
    {
        if($this->_db) {
            $this->_db = sqlite_open(SQLITE_LOCATION);
        }
    }

    protected function _query($query)
    {
        if(!$this->_db) {
            die("OOPS, call Alan ! 001");
        }

        return sqlite_query($this->_db,$query);
    }

    protected function _fetch($result)
    {
        if(!$this->_db) {
            die("OOPS, Call Alan ! 002");
        }

        return sqlite_fetch_array($result);    
    }

    public function setPkgName($name)
    {
        $this->_pkgname = $name;
        $this->_update  = TRUE;
    }

    public function getPkgName()
    {
        return $this->_pkgname;
    }
    
    public function setId($id)
    {
        $this->_id     = $id;
        $this->_update = TRUE;
    }
    
    public function getId()
    {
        return $this->_id;
    }
    
    public function setDeveloper($name)
    {
        $this->_developer = $name;
        $this->_update    = TRUE;
    }

    public function getDeveloper()
    {
        return $this->_developer;
    }

    public function setDistro($name)
    {
        $this->_distro = $name;
        $this->_update = TRUE;
    }

    public function getDistro()
    {
        return $this->_distro;
    }

    public function setStatus($bool)
    {
        $this->_status = $bool;
        $this->_update = TRUE;
    }

    public function getStatus()
    {
        return $this->_status;
    }

    protected function _setUpdate($value){
        $this->_update=$value;
    }

    public function checkisuniq(){
        $this->_connect();
        if(trim($this->_pkgname)=='')
                return FALSE;
        $result=$this->_query("select * from queue where pkgname='{$this->_pkgname}' and distro='{$this->_distro}' ");
        if(!sqlite_num_rows($result))
                return TRUE;
        return FALSE;
        
    }
    private function _new()
    {
        
        $this->_connect();
        if($this->checkisuniq($this->_pkgname,$this->_distro)){
                $this->_query("insert into queue values (NULL,'{$this->_pkgname}','{$this->_developer}','{$this->_distro}','{$this->_status}')");
                $this->_update=FALSE;
                return TRUE;
        }
        return FALSE;

   }
       
    private function _edit()
    {
        $this->_query("update queue set pkgname='{$this->_pkgname}', developer='{$this->_developer}', ".
                      "distro='{$this->_distro}', status='{$this->_status}' where id='{$this->_id}'");
        $this->_update=FALSE;
    }

    private function _delete($id){
        $this->_query("delete from queue where id='$id'");
    }

    public function delete(){
        if($this->_id!=null)
           $this->_delete($this->_id);
    }

    public function save(){

            if($this->_id == NULL) {
                 $this->_new();
            } else {
                $this->_edit();
            }

    }

    public function __destruct()
    {
        if($this->_update==TRUE)
            $this->save();
            $this->_disconnect();
    }

}

class Packages extends Package {

    public function getAll($condition='') {

        $this->_connect();
        if($condition!='')
                $condition= ' And ' . $condition;
        $result = $this->_query("select * from queue where 1 $condition");

               $objs=array();
        while($row = $this->_fetch($result)) {
                $obj=new Package();
                $obj->setPkgName($row['pkgname']);
                $obj->setId($row['id']);
                $obj->setDeveloper($row['developer']);
                $obj->setDistro($row['distro']);
                $obj->setStatus($row['status']);
                $obj->_setUpdate(FALSE);
                $objs[]=$obj;

        }

        return ($objs);
    }

    public function deleteAll() {
        $this->_connect();
        $this->_query("delete from queue where 1");
    }   
}