SetBased\Stratum\MySql\Wrapper\Singleton0Wrapper

Complexity

Total Complexity

8

Size/Duplication

Total Lines	98
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	generateMethodBodyWithLobReturnData()	0	22	2
A	generateMethodBodyWithLobFetchData()	0	16	1
A	generateMethodBodyWithoutLob()	0	16	2
A	getReturnTypeDeclaration()	0	9	2
A	getDocBlockReturnType()	0	3	1

<?php
declare(strict_types=1);

namespace SetBased\Stratum\MySql\Wrapper;

use SetBased\Stratum\Common\Wrapper\Helper\WrapperContext;
use SetBased\Stratum\Middle\Exception\ResultException;
use SetBased\Stratum\MySql\Exception\MySqlDataLayerException;
use SetBased\Stratum\MySql\Loader\Helper\MySqlDataTypeHelper;

/**
 * Class for generating a wrapper method for a stored procedure that selects 0 or 1 row having a single column only.
 */
class Singleton0Wrapper extends MysqlWrapper
{
  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritdoc
   */
  protected function generateMethodBodyWithLobFetchData(WrapperContext $context): void
  {
    $context->codeStore->append('$row = [];');
    $context->codeStore->append('$this->bindAssoc($stmt, $row);');
    $context->codeStore->append('');
    $context->codeStore->append('$tmp = [];');
    $context->codeStore->append('while (($b = $stmt->fetch()))');
    $context->codeStore->append('{');
    $context->codeStore->append('$new = [];');
    $context->codeStore->append('foreach($row as $value)');
    $context->codeStore->append('{');
    $context->codeStore->append('$new[] = $value;');
    $context->codeStore->append('}');
    $context->codeStore->append('$tmp[] = $new;');
    $context->codeStore->append('}');
    $context->codeStore->append('');
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritdoc
   */
  protected function generateMethodBodyWithLobReturnData(WrapperContext $context): void
  {
    $this->throws(MySqlDataLayerException::class);
    $this->throws(ResultException::class);

    $context->codeStore->append('if ($b===false)');
    $context->codeStore->append('{');
    $context->codeStore->append('throw $this->dataLayerError(\'mysqli_stmt::fetch\');');
    $context->codeStore->append('}');
    $context->codeStore->append('if (sizeof($tmp)>1)');
    $context->codeStore->append('{');
    $context->codeStore->append('throw new ResultException([0, 1], sizeof($tmp), $query);');
    $context->codeStore->append('}');
    $context->codeStore->append('');

    if ($context->phpStratumMetadata['designation']['return']===['bool'])
    {
      $context->codeStore->append('return !empty($tmp[0][0]);');
    }
    else
    {
      $context->codeStore->append('return $tmp[0][0] ?? null;');
    }
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritdoc
   */
  protected function generateMethodBodyWithoutLob(WrapperContext $context): void
  {
    $this->throws(MySqlDataLayerException::class);
    $this->throws(ResultException::class);

    if ($context->phpStratumMetadata['designation']['return']===['bool'])
    {
      $context->codeStore->append(sprintf("return !empty(\$this->executeSingleton0('call %s(%s)'));",
                                          $context->phpStratumMetadata['routine_name'],
                                          $this->getRoutineArgs($context)));
    }
    else
    {
      $context->codeStore->append(sprintf("return \$this->executeSingleton0('call %s(%s)');",
                                          $context->phpStratumMetadata['routine_name'],
                                          $this->getRoutineArgs($context)));
    }
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritdoc
   */
  protected function getDocBlockReturnType(WrapperContext $context): string
  {
    return implode('|', $context->phpStratumMetadata['php_doc']['return']);
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritdoc
   */
  protected function getReturnTypeDeclaration(WrapperContext $context): string
  {
    $type = MySqlDataTypeHelper::phpTypeHintingToPhpTypeDeclaration($this->getDocBlockReturnType($context));
    if ($type==='')
    {
      return '';
    }

    return ': '.$type;
  }

  //--------------------------------------------------------------------------------------------------------------------
}

//----------------------------------------------------------------------------------------------------------------------