ellisgl / GeekLab-GLPDO2

src/Bindings/MySQL/MySQLNumericBindings.php

<?php

namespace GeekLab\GLPDO2\Bindings\MySQL;

use PDO;
use InvalidArgumentException;
use GeekLab\GLPDO2\Bindings\NumericBindingInterface;

class MySQLNumericBindings implements NumericBindingInterface
{
    /**
     * Bind a float.
     *
     * @param float | int | string | null $value
     * @param int                         $decimals
     * @param bool                        $null
     *
     * @return array{?string}

The doc comment array{?string} at position 2 could not be parsed: Expected ':' at position 2, but found '?string'.

     * @throws InvalidArgumentException
     */
    public function bFloat(float | int | string | null $value = null, int $decimals = 3, bool $null = false): array
    {
        // Use NULL?
        if ($value === null) {
            if ($null) {
                return ['NULL'];
            }

            throw new InvalidArgumentException('Can not bind NULL in float spot.');
        }

        if (!is_numeric($value)) {
            throw new InvalidArgumentException('Can not bind "' . $value . '" in float spot.');
        }

        $format = sprintf('%%0.%df', $decimals);

        // Apparently using PDO::PARAM_STR makes this fail!
        return [sprintf($format, $value)];
    }

    /**
     * Bind an integer with optional NULL.
     *
     * @param float | bool | int | string | null $value
     * @param bool                               $null
     *
     * @return array{?int, int}

The doc comment array{?int, int} at position 2 could not be parsed: Expected ':' at position 2, but found '?int'.

     * @throws InvalidArgumentException
     */
    public function bInt(float | bool | int | string | null $value = null, bool $null = false): array
    {
        // Use NULL?
        if ($value === null) {
            if ($null) {
                return [null, PDO::PARAM_NULL];
            }

            throw new InvalidArgumentException('Can not bind NULL in integer spot.');
        }

        if (!is_numeric($value)) {
            throw new InvalidArgumentException('Can not bind "' . $value . '" in integer spot.');
        }

        return [(int)sprintf('%u', $value), PDO::PARAM_INT];
    }

    /**
     * Convert array of integers to comma separated values. Uses %%
     * Great for IN() statements.
     *
     * @param array{} | array{mixed} $data

The doc comment array{} | array{mixed} at position 6 could not be parsed: Expected ':' at position 6, but found 'mixed'.

     *
     * @return array{string}

The doc comment array{string} at position 2 could not be parsed: Expected ':' at position 2, but found 'string'.

     * @throws InvalidArgumentException
     */
    public function bIntArray(array $data): array
    {
        if (empty($data)) {
            throw new InvalidArgumentException('Can not bind an empty array.');
        }

        // Make unique integer array
        $numbers = [];

        foreach ($data as $value) {
            $numbers[(int)$value] = true;
        }

        $numbers = array_keys($numbers);

        // Turn into a comma delimited string.
        return [implode(', ', $numbers)];
    }
}