ApiTest.php

Go to the documentation of this file.

<?php
 
namespace Drupal\Tests\dkan_sql_endpoint\Unit\Controller;
 
use Dkan\Datastore\Resource;
use Drupal\Core\Config\Config;
use Drupal\Core\Config\ConfigFactory;
use Drupal\Core\Config\ImmutableConfig;
use Drupal\Core\Database\Connection;
use Drupal\Core\DependencyInjection\Container;
use Drupal\dkan_common\Plugin\DataModifierBase;
use Drupal\dkan_common\Plugin\DataModifierManager;
use MockChain\Chain;
use MockChain\Options;
use Drupal\dkan_datastore\Storage\DatabaseTable;
use Drupal\dkan_datastore\Storage\DatabaseTableFactory;
use Drupal\dkan_sql_endpoint\Controller\Api;
use Drupal\dkan_sql_endpoint\Service;
use PHPUnit\Framework\TestCase;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\RequestStack;
use Drupal\dkan_datastore\Service\Factory\Resource as ResourceServiceFactory;
use Drupal\dkan_datastore\Service\Resource as ResourceService;
 
class ApiTest extends TestCase {
 
  public function test() {
    $controller = Api::create($this->getCommonMockChain()->getMock());
    $response = $controller->runQueryGet();
    $this->assertEquals("[{\"column_1\":\"hello\",\"column_2\":\"goodbye\"}]", $response->getContent());
  }
 
  public function test2() {
    $controller = Api::create($this->getCommonMockChain()->getMock());
    $response = $controller->runQueryPost();
    $this->assertEquals("[{\"column_1\":\"hello\",\"column_2\":\"goodbye\"}]", $response->getContent());
  }
 
  public function testWithDataModifierPlugin() {
    $pluginMessage = "Resource hidden since dataset access level is non-public.";
    $pluginCode = 401;
 
    $container = $this->getCommonMockChain()
      ->add(DataModifierManager::class, 'getDefinitions', [['id' => 'foobar']])
      ->add(DataModifierManager::class, 'createInstance', DataModifierBase::class)
      ->add(DataModifierBase::class, 'requiresModification', TRUE)
      ->add(DataModifierBase::class, 'message', $pluginMessage)
      ->add(DataModifierBase::class, 'httpCode', $pluginCode);
 
    $controller = Api::create($container->getMock());
    $response = $controller->runQueryGet();
    $expected = '{"message":"Resource hidden since dataset access level is non-public."}';
    $this->assertEquals($expected, $response->getContent());
  }
 
  public function getCommonMockChain() {
    $container = (new Chain($this))
      ->add(Container::class, "get", ConfigFactory::class)
      ->add(ConfigFactory::class, "get", ImmutableConfig::class)
      ->add(ImmutableConfig::class, "get", "100")
      ->getMock();
 
    $options = (new Options())
      ->add('dkan_sql_endpoint.service', Service::create($container))
      ->add("database", Connection::class)
      ->add('dkan_datastore.service.factory.resource', ResourceServiceFactory::class)
      ->add('request_stack', RequestStack::class)
      ->add('dkan_datastore.database_table_factory', DatabaseTableFactory::class)
      ->add('plugin.manager.dkan_common.data_modifier', DataModifierManager::class)
      ->index(0);
 
    $query = '[SELECT * FROM abc][WHERE abc = "blah"][ORDER BY abc DESC][LIMIT 1 OFFSET 3];';
    $body = json_encode(["query" => $query]);
 
    $row = (object) ['record_number' => 1, 'column_1' => "hello", 'column_2' => "goodbye"];
 
    return (new Chain($this))
      ->add(Container::class, "get", $options)
      ->add(RequestStack::class, 'getCurrentRequest', Request::class)
      ->add(Request::class, 'get', $query)
      ->add(Request::class, 'getContent', $body)
      ->add(ConfigFactory::class, 'get', Config::class)
      ->add(Config::class, 'get', 1000)
      ->add(ResourceServiceFactory::class, 'getInstance', ResourceService::class)
      ->add(ResourceService::class, 'get', Resource::class)
      ->add(Resource::class, 'getId', "1")
      ->add(DatabaseTableFactory::class, 'getInstance', DatabaseTable::class)
      ->add(DatabaseTable::class, 'query', [$row])
      ->add(DataModifierManager::class, 'getDefinitions', [])
      ->add(DataModifierManager::class, 'createInstance', DataModifierBase::class)
      ->add(DataModifierBase::class, 'requiresModification', FALSE);
  }
 
}