Sqlite::columnName() - Code Metrics - Inspection of "Queries\Parts : Now use SGBD system to generate sq..." - bulton-fr/bfw-sql - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — 2.0 ( 987f1a...8caec2 )

by Vermeulen

created 2018-11-14 17:46 UTC

Sqlite::columnName() A

↳ Parent: Sqlite

Complexity

Conditions	4
Paths	3

Size

Total Lines	15
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	4
eloc	6
nc	3
nop	4
dl	0
loc	15
rs	10
c	0
b	0
f	0

<?php

namespace BfwSql\Queries\SGBD;

class Sqlite extends AbstractSGBD
{
    /**
     * {@inheritdoc}
     * 
     * Disable all joins for update queries with sqlite
     */
    protected function obtainPartsToDisable(): array
    {
        return [
            'delete' => [],
            'insert' => [],
            'select' => [],
            'update' => ['join', 'joinLeft', 'joinRight']
        ];
    }
    
    /**
     * {@inheritdoc}
     * 
     * Not add table name/shortcut before column name for an update query.
     */
    public function columnName(
        string $colName,
        string $tableName,
        bool $isFunction,
        bool $isJoker
    ): string {
        if ($this->obtainRequestType() === 'update') {
            if ($isFunction === true || $isJoker === true) {
                return $colName;
            } else {
                return '`'.$colName.'`';
            }
        }
        
        return parent::columnName($colName, $tableName, $isFunction, $isJoker);
    }
}


1			<?php
2
3			namespace BfwSql\Queries\SGBD;
4
5			class Sqlite extends AbstractSGBD
6			{
7			/**
8			* {@inheritdoc}
9			*
10			* Disable all joins for update queries with sqlite
11			*/
12			protected function obtainPartsToDisable(): array
13			{
14			return [
15			'delete' => [],
16			'insert' => [],
17			'select' => [],
18			'update' => ['join', 'joinLeft', 'joinRight']
19			];
20			}
21
22			/**
23			* {@inheritdoc}
24			*
25			* Not add table name/shortcut before column name for an update query.
26			*/
27			public function columnName(
28			string $colName,
29			string $tableName,
30			bool $isFunction,
31			bool $isJoker
32			): string {
33			if ($this->obtainRequestType() === 'update') {
34			if ($isFunction === true \|\| $isJoker === true) {
35			return $colName;
36			} else {
37			return '`'.$colName.'`';
38			}
39			}
40
41			return parent::columnName($colName, $tableName, $isFunction, $isJoker);
42			}
43			}
44

bulton-fr / bfw-sql

Push — 2.0 ( 987f1a...8caec2 )

Sqlite::columnName() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like