MartinGeorgiev\Utils\DataStructure

Complexity

Total Complexity

14

Size/Duplication

Total Lines	75
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	2
Bugs	1	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
B	transformPostgresTextArrayToPHPArray()	0	38	9
A	transformPHPArrayToPostgresTextArray()	0	23	5

<?php

declare(strict_types=1);

namespace MartinGeorgiev\Utils;

/**
 * Util class with helpers for working with PostgreSQL data structures.
 *
 * @since 0.9
 *
 * @author Martin Georgiev <martin.georgiev@gmail.com>
 */
class DataStructure
{
    /**
     * This method supports only single-dimensioned text arrays and
     * relays on the default escaping strategy in PostgreSQL (double quotes).
     */
    public static function transformPostgresTextArrayToPHPArray(string $postgresArray): array
    {
        $transform = static function (string $textArrayToTransform): array {
            $indicatesMultipleDimensions = \mb_strpos($textArrayToTransform, '},{') !== false
                || \mb_strpos($textArrayToTransform, '{{') === 0;
            if ($indicatesMultipleDimensions) {
                throw new \InvalidArgumentException('Only single-dimensioned arrays are supported');
            }

            $phpArray = \str_getcsv(\trim($textArrayToTransform, '{}'), escape: '\\');
            foreach ($phpArray as $i => $text) {
                if ($text === null) {
                    unset($phpArray[$i]);

                    break;
                }

                $isInteger = \is_numeric($text) && ''.(int) $text === $text;
                if ($isInteger) {
                    $phpArray[$i] = (int) $text;

                    continue;
                }

                $isFloat = \is_numeric($text) && ''.(float) $text === $text;
                if ($isFloat) {
                    $phpArray[$i] = (float) $text;

                    continue;
                }

                $phpArray[$i] = \stripslashes(\str_replace('\"', '"', $text));
            }

            return $phpArray;
        };

        return $transform($postgresArray);
    }

    /**
     * This method supports only single-dimensioned PHP arrays.
     * This method relays on the default escaping strategy in PostgreSQL (double quotes).
     *
     * @see https://stackoverflow.com/a/5632171/3425372 Kudos to jmz for the inspiration
     */
    public static function transformPHPArrayToPostgresTextArray(array $phpArray): string
    {
        $transform = static function (array $phpArrayToTransform): string {
            $result = [];
            foreach ($phpArrayToTransform as $text) {
                if (\is_array($text)) {
                    throw new \InvalidArgumentException('Only single-dimensioned arrays are supported');
                }

                if (\is_numeric($text) || \ctype_digit($text)) {
                    $escapedText = $text;
                } else {
                    \assert(\is_string($text));
                    $escapedText = \sprintf('"%s"', \addcslashes($text, '"\\'));
                }

                $result[] = $escapedText;
            }

            return '{'.\implode(',', $result).'}';
        };

        return $transform($phpArray);
    }
}