db.php

<?php
/*
 SPDX-FileCopyrightText: © 2008 Hewlett-Packard Development Company, L.P.
 
 SPDX-License-Identifier: GPL-2.0-only
*/
 
require_once (dirname(__FILE__) . '/../TestEnvironment.php');
require_once (dirname(__FILE__) . '/../../ui/common/common-ui.php');
 
global $URL;
global $USER;
global $PASSWORD;
 
class db {
  private $_pg_conn;
  private $pg_rows;
  protected $pg_Error;
  private $dbName;
  private $dbUser;
  private $dbPassword;
  private $dbHost;
  public  $Debug;
 
  function __construct($options = NULL) {
    global $URL;
    global $USER;
    global $PASSWORD;
 
    if (is_null($options)) {
      //$this->dbHost = parse_url($URL, PHP_URL_HOST);
      $this->dbHost = 'localhost';
      //$this->dbName   = $DBNAME;
      $this->dbUser = $USER;
      $this->dbPassword = $PASSWORD;
 
      $this->_docon();
    }
    else {
      $this->_docon($options);
    }
    if(is_resource($this->_pg_conn)) {
      $this->pg_Error = 0;
      return (TRUE);
    }
    else {
      $this->pg_ERROR = 1;
      return (FALSE);
    }
  } // __construct
 
  public function get_pg_ERROR() {
    return($this->pg_ERROR);
  }
 
  public function connect($options = NULL) {
    if (is_resource($this->_pg_conn)) {
      return ($this->_pg_conn);
    }
    else {
      $this->_docon($options);
      return ($this->_pg_conn);
    }
  } // connect
 
  private function _docon($options = NULL) {
    // fix the hardcode below, enhance create test env...
    $dbname = 'fossology';
 
    if (is_null($options)) {
      $this->_pg_conn = pg_pconnect("host=$this->dbHost dbname=$dbname " .
                        "user=$this->dbUser password=$this->dbPassword");
    }
    else {
      $this->_pg_conn = pg_pconnect(str_replace(";", " ", $options));
    }
    $res = pg_last_error($this->_pg_conn);
 
    if(is_null($this->_pg_conn)) {
      $this->pg_Error = TRUE;
      print "DB: could not connect to the db, connection is NULL\n";
      return(FALSE);
    }
 
    if($this->_pg_conn === FALSE) {
      $this->pg_Error = TRUE;
      print "DB: could not connect to the db, connect is FALSE\n";
      return(FALSE);
    }
    if (!isset ($this->_pg_conn)) {
      $this->pg_Error = 1;
      return (0);
    }
    $this->pg_Error = 0;
    return (1);
  }
  public function dbQuery($Sql) {
    /*
     * sql query's can return False on error or NULL (no error, no
     * results)
     *
     * This code is pretty much copied from Action in db-core.  Look for
     * areas where better error checking can be done (e.g. where the @
     * is used)
     */
    $uid = posix_getuid();
    $uidInfo = posix_getpwuid($uid);
    $this->pg_rows = array ();
    if (!$this->_pg_conn) {
      return ($this->pg_rows); // think about this, is false better?
    }
    if (empty ($Sql)) {
      return ($this->pg_rows); // same as above
    }
 
    @ $result = pg_query($this->_pg_conn, $Sql);
    DBCheckResult($result, $Sql, __FILE__, __LINE__);
 
    $this->Error = 0;
    $this->pg_rows = pg_affected_rows($result);
 
    /* if the query returned nothing then just return*/
    if (!isset ($result)) {
      print "DB-Query: result not set!\n";
      return;
    }
    @ $rows = pg_fetch_all($result);
 
    if (!is_array($rows)) {
      $rows = array ();
    }
    //print "DB-QU: rows is\n"; print_r($rows) . "\n";
    @ pg_free_result($result);
    return $rows;
  } // dbQuery
} // class db