Helix\DB\SQL

Complexity

Total Complexity

9

Size/Duplication

Total Lines	52
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

9 Methods

Rating	Name	Duplication	Size	Complexity
	marks()	0	13	?
	__construct()	0	1	?
	slots()	0	6	?
A	hp$0 ➔ marks()	0	13	3
A	hp$0 ➔ __toString()	0	2	1
A	hp$0 ➔ __construct()	0	1	1
	slotsEqual()	0	6	?
A	hp$0 ➔ slotsEqual()	0	6	2
A	hp$0 ➔ slots()	0	6	2

<?php

namespace Helix\DB;

use Countable;
use Helix\DB\SQL\ExpressionInterface;

/**
 * Static helper for building SQL.
 *
 * The methods here are driver agnostic, and do not quote values.
 */
class SQL {

    /**
     * Returns an array of `?` placeholders.
     *
     * @param int|array|Countable $count
     * @return ExpressionInterface[]
     */
    public static function marks ($count): array {
        static $mark;
        $mark ??= new class implements ExpressionInterface {

            public function __toString () {
                return '?';
            }
        };

        if (is_array($count) or $count instanceof Countable) {
            $count = count($count);
        }
        return array_fill(0, $count, $mark);
    }

    /**
     * Converts an array of columns to `:named` placeholders for prepared queries.
     *
     * Qualified columns are slotted as `qualifier__column` (two underscores).
     *
     * @param string[] $columns
     * @return string[] `["column" => ":column"]`
     */
    public static function slots (array $columns): array {
        $slots = [];
        foreach ($columns as $column) {
            $slots[$column] = ':' . str_replace('.', '__', $column);
        }
        return $slots;
    }

    /**
     * @param string[] $columns
     * @return string[] `["column" => "column=:column"]`
     */
    public static function slotsEqual (array $columns): array {
        $slots = static::slots($columns);
        foreach ($slots as $column => $slot) {
            $slots[$column] = "{$column} = {$slot}";
        }
        return $slots;
    }

    final private function __construct () {
    }
}