LicenseStdCommentDaoTest.php

Go to the documentation of this file.

<?php
namespace Fossology\Lib\Dao;

use Fossology\Lib\Db\DbManager;
use PHPUnit\Framework\TestCase;
use Fossology\Lib\Test\TestPgDb;

class LicenseStdCommentDaoTest extends TestCase
{

  const COMMENTS_IN_DB = 7;

  private $testDb;

  private $dbManager;

  private $licenseStdCommentDao;

  private $assertCountBefore;

  private $authClass;

  protected function setUp()
  {
    $this->testDb = new TestPgDb("licensestdcommentdao");
    $this->dbManager = $this->testDb->getDbManager();
    $this->licenseStdCommentDao = new LicenseStdCommentDao($this->dbManager);
    $this->assertCountBefore = \Hamcrest\MatcherAssert::getCount();
    $this->testDb->createPlainTables(["users", "license_std_comment"]);
    $this->testDb->createSequences(["license_std_comment_lsc_pk_seq"]);
    $this->testDb->alterTables(["license_std_comment"]);
    $this->testDb->insertData(["users", "license_std_comment"]);
    $this->authClass = \Mockery::mock('alias:Fossology\Lib\Auth\Auth');
    $this->authClass->expects('getUserId')->andReturn(2);
  }

  protected function tearDown()
  {
    $this->addToAssertionCount(
      \Hamcrest\MatcherAssert::getCount() - $this->assertCountBefore);
    $this->testDb = null;
    $this->dbManager = null;
  }

  public function testGetAllCommentsEverything()
  {
    $allComments = $this->licenseStdCommentDao->getAllComments();
    $this->assertCount(self::COMMENTS_IN_DB, $allComments);
    $this->assertContains([
      "lsc_pk" => 2,
      "name" => "Test comment #1",
      "comment" => "This will be your first comment!",
      "is_enabled" => "t"
    ], $allComments, false);
    $this->assertContains([
      "lsc_pk" => 8,
      "name" => "not-set",
      "comment" => "This comment is not set!",
      "is_enabled" => "f"
    ], $allComments, false);
  }

  public function testGetAllCommentsWithSkips()
  {
    $filteredComments = $this->licenseStdCommentDao->getAllComments(true);
    $this->assertCount(self::COMMENTS_IN_DB - 1, $filteredComments);
    $this->assertContains([
      "lsc_pk" => 2,
      "name" => "Test comment #1",
      "comment" => "This will be your first comment!",
      "is_enabled" => true
    ], $filteredComments, false);
    $this->assertNotContains([
      "lsc_pk" => 8,
      "name" => "not-set",
      "comment" => "This comment is not set!",
      "is_enabled" => false
    ], $filteredComments);
  }

  public function testUpdateCommentAsAdmin()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $returnVal = $this->licenseStdCommentDao->updateComment(2,
      "Updated comment #1", "This comment is updated!");
    $this->assertTrue($returnVal);
    $sql = "SELECT * FROM license_std_comment WHERE lsc_pk = 2;";
    $row = $this->dbManager->getSingleRow($sql);
    $this->assertEquals("Updated comment #1", $row["name"]);
    $this->assertEquals("This comment is updated!", $row["comment"]);
    $this->assertRegExp("/^" . date('Y-m-d') . ".*/", $row['updated']);
    $this->assertEquals(2, $row['user_fk']);
  }

  public function testUpdateCommentAsNonAdmin()
  {
    $this->authClass->expects('isAdmin')->andReturn(false);

    $returnVal = $this->licenseStdCommentDao->updateComment(3,
      "Updated comment #2", "This comment is updated!");
    $this->assertFalse($returnVal);
    $sql = "SELECT name, comment FROM license_std_comment WHERE lsc_pk = 3;";
    $row = $this->dbManager->getSingleRow($sql);
    $this->assertNotEquals("Updated comment #2", $row["name"]);
    $this->assertNotEquals("This comment is updated!", $row["comment"]);
  }

  public function testUpdateCommentAsAdminInvalidId()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $this->expectException(\UnexpectedValueException::class);
    $this->licenseStdCommentDao->updateComment(- 1, "Invalid comment #1",
      "This comment is invalid!");
  }

  public function testUpdateCommentFromArrayAsAdmin()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $newValues = [];
    $newValues[3]['name'] = "Updated comment #2";
    $newValues[3]['comment'] = "This comment is updated!";
    $newValues[4]['name'] = "Updated comment #3";
    $newValues[4]['comment'] = "This comment is updated!";

    $returnVal = $this->licenseStdCommentDao->updateCommentFromArray($newValues);

    $this->assertEquals(2, $returnVal);
    $sql = "SELECT * FROM license_std_comment WHERE lsc_pk IN (3, 4);";
    $rows = $this->dbManager->getRows($sql);
    $id = 3;
    foreach ($rows as $row) {
      $this->assertEquals("Updated comment #" . ($id - 1), $row["name"]);
      $this->assertEquals("This comment is updated!", $row["comment"]);
      $this->assertRegExp("/^" . date('Y-m-d') . ".*/", $row['updated']);
      $this->assertEquals(2, $row['user_fk']);
      $id++;
    }
  }

  public function testUpdateCommentFromArrayAsNonAdmin()
  {
    $this->authClass->expects('isAdmin')->andReturn(false);

    $newValues = [];
    $newValues[5]['name'] = "Updated comment #4";
    $newValues[5]['comment'] = "This comment is updated!";

    $returnVal = $this->licenseStdCommentDao->updateCommentFromArray($newValues);

    $this->assertFalse($returnVal);
  }

  public function testUpdateCommentFromArrayInvalidId()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $newValues = [];
    $newValues[-1]['name'] = "Updated comment #4";
    $newValues[-1]['comment'] = "This comment is updated!";

    $this->expectException(\UnexpectedValueException::class);

    $this->licenseStdCommentDao->updateCommentFromArray($newValues);
  }

  public function testUpdateCommentFromArrayInvalidFields()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $newValues = [];
    $newValues[5]['naaaaame'] = "Updated comment #4";
    $newValues[5]['commmmmment'] = "This comment is updated!";

    $this->expectException(\UnexpectedValueException::class);

    $this->licenseStdCommentDao->updateCommentFromArray($newValues);
  }

  public function testUpdateCommentFromArrayEmptyArray()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $newValues = [];

    $returnVal = $this->licenseStdCommentDao->updateCommentFromArray($newValues);
    $this->assertEquals(0, $returnVal);
  }

  public function testUpdateCommentFromArrayEmptyValues()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $newValues = [3 => []];

    $this->expectException(\UnexpectedValueException::class);

    $this->licenseStdCommentDao->updateCommentFromArray($newValues);
  }

  public function testGetCommentValid()
  {
    $commentId = 7;
    $returnVal = $this->licenseStdCommentDao->getComment($commentId);

    $this->assertTrue(is_string($returnVal) || $returnVal === null);
    if ($returnVal !== null) {
      $this->assertEquals("This will be the sixth comment!", $returnVal);
    }
  }

  public function testGetCommentInvalid()
  {
    $this->expectException(\UnexpectedValueException::class);

    $commentId = -1;
    $returnVal = $this->licenseStdCommentDao->getComment($commentId);
  }

  public function testInsertCommentAsAdmin()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $returnVal = $this->licenseStdCommentDao->insertComment("Inserted comment #1",
      "This first inserted comment!");
    $this->assertTrue(is_numeric($returnVal));
    $this->assertEquals(1, $returnVal);
    $sql = "SELECT * FROM license_std_comment WHERE lsc_pk = $1;";
    $row = $this->dbManager->getSingleRow($sql, [$returnVal]);
    $this->assertEquals("Inserted comment #1", $row["name"]);
    $this->assertEquals("This first inserted comment!", $row["comment"]);
    $this->assertRegExp("/^" . date('Y-m-d') . ".*/", $row['updated']);
    $this->assertEquals(2, $row['user_fk']);
    $this->assertEquals("t", $row["is_enabled"]);
  }

  public function testInsertCommentAsNonAdmin()
  {
    $this->authClass->expects('isAdmin')->andReturn(false);

    $returnVal = $this->licenseStdCommentDao->insertComment("Inserted comment #1",
      "This first inserted comment!");
    $this->assertEquals(-1, $returnVal);
  }

  public function testInsertCommentEmptyValues()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $returnVal = $this->licenseStdCommentDao->insertComment("",
      "       ");
    $this->assertEquals(-1, $returnVal);
  }

  public function testToggleCommentAsAdmin()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $returnVal = $this->licenseStdCommentDao->toggleComment(5);
    $this->assertTrue($returnVal);
    $sql = "SELECT is_enabled FROM license_std_comment WHERE lsc_pk = 5;";
    $row = $this->dbManager->getSingleRow($sql);
    $this->assertEquals("f", $row["is_enabled"]);
  }

  public function testToggleCommentAsNonAdmin()
  {
    $this->authClass->expects('isAdmin')->andReturn(false);

    $returnVal = $this->licenseStdCommentDao->toggleComment(5);
    $this->assertFalse($returnVal);
  }

  public function testToggleCommentInvalidId()
  {
    $this->authClass->expects('isAdmin')->andReturn(true);

    $this->expectException(\UnexpectedValueException::class);

    $commentId = -1;
    $returnVal = $this->licenseStdCommentDao->toggleComment($commentId);
  }
}