Maphper\Lib\Sql\In

Complexity

Total Complexity

5

Size/Duplication

Total Lines	17
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getSql()	0	12	3
A	matches()	0	2	2

<?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);
        for ($i = 0; $i < $count; $i++) {
            $args[$key . $i] = $value[$i];
            $inSql[] = ':' . $key . $i;
        }
        if (count($inSql) == 0) return [];
        else $sql = [$key . ' IN ( ' .  implode(', ', $inSql) . ')'];

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