test_common_pkg.php

Go to the documentation of this file.

<?php
/*
 SPDX-FileCopyrightText: © 2011 Hewlett-Packard Development Company, L.P.
 
 SPDX-License-Identifier: GPL-2.0-only
*/
 
use Fossology\Lib\Db\ModernDbManager;
use Fossology\Lib\Test\TestPgDb;
 
require_once(dirname(__FILE__) . '/../common-pkg.php');
require_once(dirname(__FILE__) . '/../common-db.php');
 
class test_common_pkg extends \PHPUnit\Framework\TestCase
{
  private $testDb;
 
  private $dbManager;
 
  /* initialization */
  protected function setUp() : void
  {
 
    $this->testDb = new TestPgDb("fosslibtest");
    $tables = array('mimetype');
    $this->testDb->createPlainTables($tables);
    $sequences = array('mimetype_mimetype_pk_seq');
    $this->testDb->createSequences($sequences);
    $this->testDb->createConstraints(['dirmodemask', 'mimetype_pk']);
    $this->testDb->alterTables($tables);
    $this->dbManager = $this->testDb->getDbManager();
  }
 
  function test_GetPkgMimetypes()
  {
    print "test function GetPkgMimetypes()\n";
 
    #prepare database testdata
    $mimeType = "application/x-rpm";
    $sql = "DELETE FROM mimetype where mimetype_name in ('$mimeType');";
    $result = $this->dbManager->getSingleRow($sql, [], __METHOD__ . "delete.mimetype");
    $sql = "INSERT INTO mimetype(mimetype_pk, mimetype_name) VALUES(10000, '$mimeType');";
    $result = $this->dbManager->getSingleRow($sql, [], __METHOD__ . "insert.mimetype");
 
    #begin test GetPkgMimetypes()
    $sql = "select * from mimetype where
             mimetype_name='application/x-rpm'";
    $row = $this->dbManager->getSingleRow($sql, [], __METHOD__ . "select.mimetype");
    $expected = $row['mimetype_pk'];
 
    $result = GetPkgMimetypes();
    $this->assertContains($expected, $result);
 
    $sql = "DELETE FROM mimetype where mimetype_name in ('$mimeType');";
    $result = $this->dbManager->getSingleRow($sql, [], __METHOD__ . "delete.mimetype");
  }
 
  protected function tearDown() : void
  {
    if (!is_callable('pg_connect')) {
      return;
    }
    $this->testDb->fullDestruct();
    $this->testDb = null;
    $this->dbManager = null;
  }
}