test_common_cache.php

Go to the documentation of this file.

<?php
/*
 Copyright (C) 2011 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.
 */

require_once(dirname(__FILE__) . '/../common-cache.php');
require_once(dirname(__FILE__) . '/../common-db.php');

class test_common_cached extends \PHPUnit\Framework\TestCase
{
  public $PG_CONN;
  public $upload_pk = 0;
  public $uploadtree_pk = 0;
  public $UserCacheStat = 0;

  protected function setUp()
  {
    global $PG_CONN;
    $sysconfig = dirname(__FILE__).'/sysconfigDirTest';
    if (!is_callable('pg_connect')) {
      $this->markTestSkipped("php-psql not found");
    }
    $PG_CONN = DBconnect($sysconfig);
  }

  function preparation4ReportCachePut()
  {
    global $PG_CONN;
    global $upload_pk;
    global $uploadtree_pk;

    $sql = "INSERT INTO upload (upload_filename,upload_mode,upload_ts) VALUES ('cache_test',40,now());";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    $sql = "SELECT upload_pk from upload where upload_filename = 'cache_test';";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $upload_pk= $row['upload_pk'];
    pg_free_result($result);

    $sql= "INSERT INTO uploadtree (upload_fk) VALUES($upload_pk)";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    $sql = "SELECT uploadtree_pk from uploadtree where upload_fk = $upload_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $uploadtree_pk= $row['uploadtree_pk'];
    pg_free_result($result);
  }

  function testReportCachePut_upload_id_not_null()
  {
    print "Start unit test for common-cache.php\n";
    print "test function ReportCachePut()\n";
    global $PG_CONN;
    global $upload_pk;
    global $uploadtree_pk;

    $this->preparation4ReportCachePut();

    $CacheKey = "?mod=nomoslicense&upload=$upload_pk&item=$uploadtree_pk&show=detail";
    $CacheValue = "no data";
    ReportCachePut($CacheKey, $CacheValue);
    $sql = "SELECT report_cache_value from report_cache where report_cache_uploadfk = $upload_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $value = $row['report_cache_value'];
    pg_free_result($result);
    $this->assertEquals($CacheValue, $value);
    $this->resetEnv4ReportCachePut();
  }

  function testReportCachePut_upload_id_null()
  {
    print "test function ReportCachePut()\n";
    global $PG_CONN;
    global $upload_pk;
    global $uploadtree_pk;

    $this->preparation4ReportCachePut();

    $CacheKey = "?mod=nomoslicense&item=$uploadtree_pk&show=detail";
    $CacheValue = "no data";
    ReportCachePut($CacheKey, $CacheValue);
    $sql = "SELECT report_cache_value from report_cache where report_cache_uploadfk = $upload_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $value = $row['report_cache_value'];
    pg_free_result($result);
    $this->assertEquals($CacheValue, $value);
    $this->resetEnv4ReportCachePut();
  }

  function testReportCacheGet()
  {
    print "test function ReportCacheGet()\n";
    global $PG_CONN;
    global $upload_pk;
    global $uploadtree_pk;
    global $UserCacheStat;

    $this->preparation4ReportCachePut();

    $CacheKey = "?mod=nomoslicense&upload=$upload_pk&item=$uploadtree_pk&show=detail";
    $CacheValue = "no data";
    ReportCachePut($CacheKey, $CacheValue);
    $UserCacheStat = 2; 
    $value = ReportCacheGet($CacheKey);
    $this->assertEquals($CacheValue, $value);
    $this->resetEnv4ReportCachePut();
    print "unit test for common-cache.php end\n";
  }

  function resetEnv4ReportCachePut()
  {
    global $PG_CONN;
    global $upload_pk;
    $sql = "DELETE from report_cache where report_cache_uploadfk = $upload_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);
    $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 upload where upload_pk = $upload_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);
  }

  protected function tearDown()
  {
    global $PG_CONN;
    if (is_callable('pg_close')) {
      pg_close($PG_CONN);
    }
  }
}