mindplay\sql\framework\QueryFormatter

Complexity

Total Complexity

4

Size/Duplication

Total Lines	19
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	2
Bugs	1	Features	1

1 Method

Rating	Name	Duplication	Size	Complexity
A	formatQuery()	0	11	4

<?php

namespace mindplay\sql\framework;

/**
 * This is a pseudo-namespace for a simple query-formatter *strictly* for diagnostic
 * purposes - it implements a simple emulation of PDO placeholder interpolation, so
 * that queries can be rendered in error-messages with actual parameter values.
 */
abstract class QueryFormatter
{
    /**
     * @param string              $sql
     * @param array<string,mixed> $params
     *
     * @return string SQL with emulated prepare (for diagnostic purposes only)
     */
    public static function formatQuery(string $sql, array $params): string
    {
        $quoted_params = [];

        foreach ($params as $name => $value) {
            $quoted_params[":{$name}"] = $value === null
                ? "NULL"
                : (is_numeric($value) ? $value : "'{$value}'");
        }

        return strtr($sql, $quoted_params);
    }
}