Maphper\Lib\Sql\In

Complexity

Total Complexity

6

Size/Duplication

Total Lines	24
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	matches()	0	2	2
A	getSql()	0	19	4

<?php
namespace Maphper\Lib\Sql;

class In implements WhereConditional {
    public function matches($key, $value, $mode) {
        return !is_numeric($key) && is_array($value);
    }

    public function getSql($key, $value, $mode) {
        $args = [];
        $inSql = [];
        $count = count($value);
        $value = array_values($value); // fix numeric index being different than $i
        for ($i = 0; $i < $count; $i++) {
            $args[$key . $i] = $value[$i];
            $inSql[] = ':' . $key . $i;
        }

        $notText = '';
        if (\Maphper\Maphper::FIND_NOT & $mode) {
            $notText = ' NOT';
        }

        if (count($inSql) == 0) return ['args' => [], 'sql' => ''];
        else $sql = [$key . $notText . ' IN ( ' .  implode(', ', $inSql) . ')'];

        return ['args' => $args, 'sql' => $sql];
    }
}