Completed
Pull Request — experimental/3.1 (#2154)
by Kentaro
448:33 queued 441:10
created

Normalize   A

Complexity

Total Complexity 4

Size/Duplication

Total Lines 30
Duplicated Lines 0 %

Coupling/Cohesion

Components 1
Dependencies 5

Test Coverage

Coverage 75%

Importance

Changes 0
Metric Value
c 0
b 0
f 0
dl 0
loc 30
ccs 12
cts 16
cp 0.75
rs 10
wmc 4
lcom 1
cbo 5

2 Methods

Rating   Name   Duplication   Size   Complexity  
A parse() 0 7 1
A getSql() 0 15 3
1
<?php
2
/*
3
 * This file is part of EC-CUBE
4
 *
5
 * Copyright(c) 2000-2016 LOCKON CO.,LTD. All Rights Reserved.
6
 *
7
 * http://www.lockon.co.jp/
8
 *
9
 * This program is free software; you can redistribute it and/or
10
 * modify it under the terms of the GNU General Public License
11
 * as published by the Free Software Foundation; either version 2
12
 * of the License, or (at your option) any later version.
13
 *
14
 * This program is distributed in the hope that it will be useful,
15
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17
 * GNU General Public License for more details.
18
 *
19
 * You should have received a copy of the GNU General Public License
20
 * along with this program; if not, write to the Free Software
21
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
22
 */
23
24
namespace Eccube\Doctrine\ORM\Query;
25
26
use Doctrine\ORM\Query\AST\Functions\FunctionNode;
27
use Doctrine\ORM\Query\Lexer;
28
use Doctrine\ORM\Query\Parser;
29
use Doctrine\ORM\Query\SqlWalker;
30
31
/**
32
 * @package Eccube\Doctrine\ORM\Query
33
 */
34
class Normalize extends FunctionNode
35
{
36
    protected $string;
37
    const FROM = 'あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをんがぎぐげござじずぜぞだぢづでどばびぶべぼぱぴぷぺぽぁぃぅぇぉっゃゅょわいえー';
38
    const TO   = 'アイウエオカキクケコサシスセソタチツテトナニヌネノハヒフヘホマミムメモヤユヨラリルレロワヲンガギグゲゴザジズゼゾダヂヅデドバビブベボパピプペポァィゥェォッャュョヮヰヱー';
39
40 1
    public function parse(Parser $parser)
0 ignored issues
show
introduced by
Missing function doc comment
Loading history...
41
    {
42 1
        $parser->match(Lexer::T_IDENTIFIER);
43 1
        $parser->match(Lexer::T_OPEN_PARENTHESIS);
44 1
        $this->string = $parser->ArithmeticPrimary();
45 1
        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
46
    }
47
48 1
    public function getSql(SqlWalker $sqlWalker)
0 ignored issues
show
introduced by
Missing function doc comment
Loading history...
49
    {
50 1
        switch ($sqlWalker->getConnection()->getDriver()->getName()) {
51 1
            case 'pdo_pgsql':
52 1
                $sql = sprintf("LOWER(TRANSLATE(%s, '%s', '%s'))", $this->string->dispatch($sqlWalker), self::FROM, self::TO);
53 1
                break;
54
            case 'pdo_mysql':
55
                $sql = sprintf('%s COLLATE utf8_unicode_ci', $this->string->dispatch($sqlWalker));
56
                break;
57
            default:
58
                $sql = sprintf('LOWER(%s)', $this->string->dispatch($sqlWalker));
59 1
                break;
60
        }
61 1
        return $sql;
0 ignored issues
show
introduced by
Missing blank line before return statement
Loading history...
62
    }
63
}
64