SetBased\Stratum\MySql\Crud\Helper\DeleteRoutine

Complexity

Total Complexity

7

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	generateBody()	0	31	4
A	generateRoutineDeclaration()	0	3	1
A	generateDocBlock()	0	3	1
A	generateSqlDataAndDesignationType()	0	4	1

<?php
declare(strict_types=1);

namespace SetBased\Stratum\MySql\Crud\Helper;

/**
 * Generates the code for a stored routine that deletes a row.
 */
class DeleteRoutine extends BaseRoutine
{
  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritDoc
   */
  protected function generateBody(): void
  {
    $this->codeStore->append(sprintf('delete from %s', $this->tableName));
    $this->codeStore->append('where');

    $columns = $this->keyColumns();
    $width   = $this->maxColumnNameLength($columns);

    $first = true;
    foreach ($columns as $column)
    {
      if ($first)
      {
        $format = sprintf("%%%ds %%-%ds = p_%%s", 1, $width);
        $this->codeStore->appendToLastLine(sprintf($format, '', $column['column_name'], $column['column_name']));

        $first = false;
      }
      else
      {
        $format = sprintf("and%%%ds %%-%ds = p_%%s", 3, $width);
        $this->codeStore->append(sprintf($format, '', $column['column_name'], $column['column_name']));
      }
    }

    if (empty($this->uniqueIndexes))
    {
      $this->codeStore->append('limit 0,1');
    }

    $this->codeStore->append(';');
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritDoc
   */
  protected function generateDocBlock(): void
  {
    $this->generateDocBlockWithKey();
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * Generates the function name and parameters of the stored routine.
   */
  protected function generateRoutineDeclaration(): void
  {
    $this->generateRoutineDeclarationWithKey();
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritDoc
   */
  protected function generateSqlDataAndDesignationType(): void
  {
    $this->codeStore->append('modifies sql data');
    $this->codeStore->append('-- type: none');
  }
}
//----------------------------------------------------------------------------------------------------------------------