test_common_license_file.php

Go to the documentation of this file.

<?php
/*
 Copyright (C) 2011-2013 Hewlett-Packard Development Company, L.P.

 This program is free software; you can redistribute it and/or
 modify it under the terms of the GNU General Public License
 version 2 as published by the Free Software Foundation.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License along
 with this program; if not, write to the Free Software Foundation, Inc.,
 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 */

use Fossology\Lib\Db\ModernDbManager;
use Fossology\Lib\Test\TestLiteDb;

require_once(dirname(__FILE__) . '/../common-license-file.php');
require_once(dirname(__FILE__) . '/../common-db.php');
require_once(dirname(__FILE__) . '/../common-dir.php');
require_once(dirname(__FILE__) . '/../common-ui.php');

class test_common_license_file extends \PHPUnit\Framework\TestCase
{
  public $upload_pk = 0;
  public $uploadtree_pk_parent = 0;
  public $uploadtree_pk_child = 0;
  public $agent_pk = 0;
  public $uploadtree_tablename = 'uploadtree';

  public $DB_COMMAND =  "";
  public $DB_NAME =  "";

  private $testDb;
  private $dbManager;

  private $logFileName;

  protected function setUp()
  {
    global $PG_CONN;
    global $upload_pk;
    global $pfile_pk_parent;
    global $pfile_pk_child;
    global $agent_pk;

    global $DB_COMMAND;
    global $DB_NAME;

    $DB_COMMAND  = dirname(dirname(dirname(dirname(__FILE__))))."/testing/db/createTestDB.php";
    print "*** path to test db creation command: " . $DB_COMMAND;
    exec($DB_COMMAND, $dbout, $rc);
    if (!empty($rc)) {
      throw new Exception(implode("\n", $dbout));
    }
    preg_match("/(\d+)/", $dbout[0], $matches);
    $test_name = $matches[1];
    $db_conf = $dbout[0];
    $DB_NAME = "fosstest".$test_name;

    $PG_CONN = DBconnect($db_conf);

    $logger = new Monolog\Logger('default');
    $this->logFileName = dirname(dirname(dirname(dirname(dirname(__FILE__))))) . '/db.sqlite.log';
    $logger->pushHandler(new Monolog\Handler\StreamHandler($this->logFileName, Monolog\Logger::ERROR));
    $this->dbManager = new ModernDbManager($logger);
    $this->dbManager->setDriver(new Fossology\Lib\Db\Driver\Postgres($PG_CONN));

    $upload_filename = "license_file_test"; /* upload file name */

    $this->dbManager->prepare($stmt='pfile.insert',
              $sql = "INSERT INTO pfile (pfile_sha1,pfile_md5,pfile_size) VALUES ($1,$2,$3)");
    $this->dbManager->freeResult($this->dbManager->execute($stmt,array(
      'AF1DF2C4B32E4115DB5F272D9EFD0E674CF2A0BC', '2239AA7DAC291B6F8D0A56396B1B8530', '4560')));
    $this->dbManager->freeResult($this->dbManager->execute($stmt,array(
      'B1938B14B9A573D59ABCBD3BF0F9200CE6E79FB6', '55EFE7F9B9D106047718F1CE9173B869', '1892')));

    $this->dbManager->queryOnce($sql="INSERT INTO agent (agent_name) VALUES('nomos')");

    $this->dbManager->prepare($stmt='license_ref.insert',
            $sql="INSERT INTO license_ref"
            . " (rf_pk, rf_shortname, rf_text, marydone, rf_active, rf_text_updatable, rf_detector_type)"
            . " VALUES ($1,$2,$3,$4,$5,$6,$7)");
    $this->dbManager->freeResult($this->dbManager->execute($stmt,
            array(1, 'test_ref', 'test_ref', 'false', 'true', 'false', 1)));

    $this->dbManager->prepare($stmt='license_ref.select',
          $sql = "SELECT pfile_pk from pfile where pfile_sha1"
            . " IN ('AF1DF2C4B32E4115DB5F272D9EFD0E674CF2A0BC', 'B1938B14B9A573D59ABCBD3BF0F9200CE6E79FB6')");
    $result = $this->dbManager->execute($stmt);
    $row = $this->dbManager->fetchArray($result);
    $pfile_pk_parent = $row['pfile_pk'];
    $row = $this->dbManager->fetchArray($result);
    $pfile_pk_child= $row['pfile_pk'];
    $this->dbManager->freeResult($result);

    $agent_nomos = $this->dbManager->getSingleRow("SELECT agent_pk from agent where agent_name = 'nomos'",array(),__METHOD__.'.agent.select');
    $agent_pk = $agent_nomos['agent_pk'];
    $this->dbManager->prepare($stmt='license_file.insert',
                       $sql = "INSERT INTO license_file(rf_fk, agent_fk, pfile_fk) VALUES ($1,$2,$3)");
    $this->dbManager->freeResult($this->dbManager->execute($stmt, array(1, $agent_pk, $pfile_pk_parent)));
    $this->dbManager->freeResult($this->dbManager->execute($stmt, array(2, $agent_pk, $pfile_pk_child)));

    $this->dbManager->queryOnce("INSERT INTO upload (upload_filename,upload_mode,upload_ts, pfile_fk, uploadtree_tablename)"
            . " VALUES ('$upload_filename',40,now(), '$pfile_pk_parent', '$this->uploadtree_tablename')");
    $row = $this->dbManager->getSingleRow("SELECT upload_pk from upload where upload_filename = '$upload_filename'",array(),__METHOD__.'.upload.select');
    $upload_pk= $row['upload_pk'];

    $this->dbManager->prepare($stmtIn=__METHOD__.'.uploadtree.insert',
            "INSERT INTO uploadtree (parent, upload_fk, pfile_fk, ufile_mode, lft, rgt, ufile_name) VALUES ($1,$2,$3,$4,$5,$6,$7)");
    $this->dbManager->freeResult(
       $this->dbManager->execute($stmtIn,array(NULL, $upload_pk, $pfile_pk_parent, 33188, 1, 2, 'license_test.file.parent')));

    $this->dbManager->prepare($stmtOut=__METHOD__.'uploadtree.select',
            "SELECT uploadtree_pk from uploadtree where pfile_fk=$1");
    $res = $this->dbManager->execute($stmtOut,array($pfile_pk_parent));
    $row = $this->dbManager->fetchArray($res);
    $this->dbManager->freeResult($res);
    $this->uploadtree_pk_parent = $row['uploadtree_pk'];

    $this->dbManager->freeResult(
       $this->dbManager->execute($stmtIn,array($this->uploadtree_pk_parent, $upload_pk, $pfile_pk_child, 33188, 1, 2, 'license_test.file.child')));

    $res = $this->dbManager->execute($stmtOut,array($pfile_pk_child));
    $row = $this->dbManager->fetchArray($res);
    $this->dbManager->freeResult($res);
    $this->uploadtree_pk_child = $row['uploadtree_pk'];

    $this->uploadtree_tablename = GetUploadtreeTableName($upload_pk);
    print('.');
  }

  function testGetFileLicenses()
  {
    global $PG_CONN;
    global $agent_pk;

    $license_array = GetFileLicenses($agent_pk, '' , $this->uploadtree_pk_parent, $this->uploadtree_tablename);
    $sql = "SELECT rf_shortname from license_ref where rf_pk = 1;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $license_value_expected = $row['rf_shortname'];
    pg_free_result($result);
    $count = count($license_array);

    $this->assertEquals($license_value_expected, $license_array[1]);
    $this->assertEquals(1, $count);
  }

  function testGetFileLicensesDul()
  {
    global $PG_CONN;
    global $pfile_pk_parent;
    global $agent_pk;
    $sql = "INSERT INTO license_file(rf_fk, agent_fk, pfile_fk) VALUES(1, $agent_pk, $pfile_pk_parent);";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    $license_array = GetFileLicenses($agent_pk, '' , $this->uploadtree_pk_parent, $this->uploadtree_tablename, "yes");
    $sql = "SELECT rf_shortname from license_ref where rf_pk = 1;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $license_value_expected = $row['rf_shortname'];
    pg_free_result($result);

    $count = count($license_array);
    $this->assertEquals(2, $count);
    $this->assertEquals($license_value_expected, $license_array[1]);
    $this->assertEquals($license_value_expected, $license_array[3]);
  }

  function testGetFileLicenses_string()
  {
    global $PG_CONN;
    global $agent_pk;

    $license_string = GetFileLicenses_string($agent_pk, '', $this->uploadtree_pk_parent, $this->uploadtree_tablename);
    $sql = "SELECT rf_shortname from license_ref where rf_pk = 1;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $license_value_expected = $row['rf_shortname'];
    pg_free_result($result);

    $this->assertEquals($license_value_expected, $license_string);
  }

  function testGetFilesWithLicense()
  {
    global $PG_CONN;
    global $pfile_pk_parent;
    global $agent_pk;

    $sql = "SELECT rf_shortname from license_ref where rf_pk = 1;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $rf_shortname = $row['rf_shortname'];
    pg_free_result($result);

    $files_result = GetFilesWithLicense($agent_pk, $rf_shortname, $this->uploadtree_pk_parent, false, 0, "ALL", "", null, $this->uploadtree_tablename);
    $row = pg_fetch_assoc($files_result);
    $pfile_id_actual = $row['pfile_fk'];
    pg_free_result($files_result);
    $this->assertEquals($pfile_pk_parent, $pfile_id_actual);
  }

  function testLevel1WithLicense()
  {
    global $PG_CONN;
    global $agent_pk;

    $sql = "SELECT rf_shortname from license_ref where rf_pk = 1;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $rf_shortname = $row['rf_shortname'];
    pg_free_result($result);

    $file_name = Level1WithLicense($agent_pk, $rf_shortname, $this->uploadtree_pk_parent, false, $this->uploadtree_tablename);
    $this->assertEquals("license_test.file.child", $file_name[$this->uploadtree_pk_child]);
  }


  protected function tearDown()
  {
    if (!is_callable('pg_connect')) {
      return;
    }
    global $PG_CONN;
    global $pfile_pk_parent;
    global $pfile_pk_child;
    global $upload_pk;
    global $DB_COMMAND;
    global $DB_NAME;

    $sql = "DELETE FROM uploadtree where upload_fk = $upload_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    $sql = "DELETE FROM license_file where pfile_fk IN ($pfile_pk_parent, $pfile_pk_child);";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    $sql = "DELETE FROM upload where upload_pk = $upload_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    $sql = "DELETE FROM pfile where pfile_pk IN ($pfile_pk_parent, $pfile_pk_child);";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    $sql = "DELETE FROM agent where agent_name = 'nomos';";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    pg_close($PG_CONN);
    exec("$DB_COMMAND -d $DB_NAME");
  }
}