source: build-queue/package.php @ 2500

<?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();
        }
    }
    
    private function _connect()
    {
        $this->_db = sqlite_open(SQLITE_LOCATION);
    }

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

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

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

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

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

    public function __destruct()
    {
        if($this->_update == TRUE && $this->_id == NULL) {
            $this->_new();
        } else if ($this->_update == TRUE) {
            $this->_edit();
        }
        
        $this->_disconnect();
    }

}

class packages extends package {

    public function getAll() {
        $this->_connect();
        $result = $this->_query("select * from queue");

        $objs=array();
        while($row = $this->_fetch($result)) {
                
        }
    }

    public function deleteAll() {

    }

   
}