UpdateRoutine::generateBody() - Code Metrics - DatabaseStratum/php-stratum-mysql - Measure and Improve Code Quality continuously with Scrutinizer

UpdateRoutine::generateBody() B
last analyzed 2024-09-22 10:16 UTC

↳ Parent: UpdateRoutine

Complexity

Conditions	6
Paths	18

Size

Total Lines	55
Code Lines	30

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	6
eloc	30
nc	18
nop	0
dl	0
loc	55
rs	8.8177
c	0
b	0
f	0

How to fix Long Method

<?php
declare(strict_types=1);

namespace SetBased\Stratum\MySql\Crud\Helper;

/**
 * Generates the code for a stored routine that updates a row.
 */
class UpdateRoutine extends BaseRoutine
{
  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritdoc
   */
  protected function generateBody(): void
  {
    $this->codeStore->append(sprintf('update %s', $this->tableName));
    $this->codeStore->append('set');

    $offset  = mb_strlen($this->codeStore->getLastLine());
    $columns = $this->tableColumnsWithoutAutoIncrement();
    $width   = $this->maxColumnNameLength($columns);

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

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

    $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);
        $line   = sprintf($format, '', $column['column_name'], $column['column_name']);
        $this->codeStore->appendToLastLine($line);

        $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->generateDocBlockAllColumnsWithKeyList();
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * 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');
  }

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

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


1			<?php
2			declare(strict_types=1);
3
4			namespace SetBased\Stratum\MySql\Crud\Helper;
5
6			/**
7			* Generates the code for a stored routine that updates a row.
8			*/
9			class UpdateRoutine extends BaseRoutine
10			{
11			//--------------------------------------------------------------------------------------------------------------------
12			/**
13			* @inheritdoc
14			*/
15			protected function generateBody(): void
16			{
17			$this->codeStore->append(sprintf('update %s', $this->tableName));
18			$this->codeStore->append('set');
19
20			$offset = mb_strlen($this->codeStore->getLastLine());
21			$columns = $this->tableColumnsWithoutAutoIncrement();
22			$width = $this->maxColumnNameLength($columns);
23
24			$first = true;
25			foreach ($columns as $column)
26			{
27			if ($first)
28			{
29			$format = sprintf("%%%ds %%-%ds = p_%%s", $offset, $width);
30			$this->codeStore->appendToLastLine(sprintf($format, '', $column['column_name'], $column['column_name']));
31
32			$first = false;
33			}
34			else
35			{
36			$format = sprintf("%%-%ds %%-%ds = p_%%s", $offset + 3, $width);
37			$this->codeStore->append(sprintf($format, ',', $column['column_name'], $column['column_name']));
38			}
39			}
40
41			$this->codeStore->append('where');
42
43			$columns = $this->keyColumns();
44			$width = $this->maxColumnNameLength($columns);
45
46			$first = true;
47			foreach ($columns as $column)
48			{
49			if ($first)
50			{
51			$format = sprintf("%%%ds %%-%ds = p_%%s", 1, $width);
52			$line = sprintf($format, '', $column['column_name'], $column['column_name']);
53			$this->codeStore->appendToLastLine($line);
54
55			$first = false;
56			}
57			else
58			{
59			$format = sprintf("and%%%ds %%-%ds = p_%%s", 3, $width);
60			$this->codeStore->append(sprintf($format, '', $column['column_name'], $column['column_name']));
61			}
62			}
63
64			if (empty($this->uniqueIndexes))
65			{
66			$this->codeStore->append('limit 0,1');
67			}
68
69			$this->codeStore->append(';');
70			}
71
72			//--------------------------------------------------------------------------------------------------------------------
73			/**
74			* @inheritDoc
75			*/
76			protected function generateDocBlock(): void
77			{
78			$this->generateDocBlockAllColumnsWithKeyList();
79			}
80
81			//--------------------------------------------------------------------------------------------------------------------
82			/**
83			* Generates the function name and parameters of the stored routine.
84			*/
85			protected function generateRoutineDeclaration(): void
86			{
87			$this->generateRoutineDeclarationWithKey();
88			}
89
90			//--------------------------------------------------------------------------------------------------------------------
91			/**
92			* @inheritDoc
93			*/
94			protected function generateSqlDataAndDesignationType(): void
95			{
96			$this->codeStore->append('modifies sql data');
97			$this->codeStore->append('-- type: none');
98			}
99
100			//--------------------------------------------------------------------------------------------------------------------
101			}
102
103			//----------------------------------------------------------------------------------------------------------------------
104

DatabaseStratum / php-stratum-mysql

UpdateRoutine::generateBody() B last analyzed 2024-09-22 10:16 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like

UpdateRoutine::generateBody() B
last analyzed 2024-09-22 10:16 UTC