Lines 96.10% 74 / 77
Methods 87.50% 7 / 8
Classes 0.00% 0 / 1
Covered by tests of size
Name Lines Methods CRAP
 __construct 100.00% 1 / 1 100.00% 1 / 1 1
 updateConfigValue 100.00% 10 / 10 100.00% 1 / 1 1
 fetchAll 100.00% 6 / 6 100.00% 1 / 1 2
 insert 100.00% 10 / 10 100.00% 1 / 1 1
 delete 100.00% 9 / 9 100.00% 1 / 1 1
 renameKey 100.00% 10 / 10 100.00% 1 / 1 1
 fetchValue 100.00% 11 / 11 100.00% 1 / 1 3
 fetchValues 85.00% 17 / 20 0.00% 0 / 1 6.12
25readonly class DatabaseConfigurationStore implements ConfigurationStoreInterface
26{
27    public function __construct(
28        private DatabaseDriver $databaseDriver,
29        private string $tableName = 'faqconfig',
30    ) {
31    }
32
33    public function updateConfigValue(string $key, string $value): bool
34    {
35        $sql = <<<'SQL'
36                UPDATE %s%s SET config_value = '%s' WHERE config_name = '%s'
37            SQL;
38        $query = sprintf(
39            $sql,
40            Database::getTablePrefix(),
41            $this->tableName,
42            $this->databaseDriver->escape(trim($value)),
43            $this->databaseDriver->escape(trim($key)),
44        );
45
46        return (bool) $this->databaseDriver->query($query);
47    }
48
49    /**
50     * @return array<int, \stdClass>
51     */
52    public function fetchAll(): array
53    {
54        $sql = <<<'SQL'
55                SELECT config_name, config_value FROM %s%s
56            SQL;
57        $query = sprintf($sql, Database::getTablePrefix(), $this->tableName);
58
59        $result = $this->databaseDriver->query($query);
60        $rows = $this->databaseDriver->fetchAll($result);
61        return is_array($rows) ? $rows : [];
62    }
63
64    public function insert(string $name, string $value): bool
65    {
66        $sql = <<<'SQL'
67                INSERT INTO %s%s (config_name, config_value) VALUES ('%s', '%s')
68            SQL;
69        $query = sprintf(
70            $sql,
71            Database::getTablePrefix(),
72            $this->tableName,
73            $this->databaseDriver->escape(trim($name)),
74            $this->databaseDriver->escape(trim($value)),
75        );
76
77        return (bool) $this->databaseDriver->query($query);
78    }
79
80    public function delete(string $name): bool
81    {
82        $sql = <<<'SQL'
83                DELETE FROM %s%s WHERE config_name = '%s'
84            SQL;
85        $query = sprintf(
86            $sql,
87            Database::getTablePrefix(),
88            $this->tableName,
89            $this->databaseDriver->escape(trim($name)),
90        );
91
92        return (bool) $this->databaseDriver->query($query);
93    }
94
95    public function renameKey(string $currentKey, string $newKey): bool
96    {
97        $sql = <<<'SQL'
98                UPDATE %s%s SET config_name = '%s' WHERE config_name = '%s'
99            SQL;
100        $query = sprintf(
101            $sql,
102            Database::getTablePrefix(),
103            $this->tableName,
104            $this->databaseDriver->escape(trim($newKey)),
105            $this->databaseDriver->escape(trim($currentKey)),
106        );
107
108        return (bool) $this->databaseDriver->query($query);
109    }
110
111    public function fetchValue(string $name): ?string
112    {
113        $sql = <<<'SQL'
114                SELECT config_value FROM %s%s WHERE config_name = '%s'
115            SQL;
116        $query = sprintf(
117            $sql,
118            Database::getTablePrefix(),
119            $this->tableName,
120            $this->databaseDriver->escape(trim($name)),
121        );
122
123        $result = $this->databaseDriver->query($query);
124        $row = $this->databaseDriver->fetchObject($result);
125
126        return is_object($row) && property_exists($row, 'config_value') ? (string) $row->config_value : null;
127    }
128
129    /**
130     * @param array<int, string> $names
131     * @return array<string, ?string>
132     */
133    public function fetchValues(array $names): array
134    {
135        if ($names === []) {
136            return [];
137        }
138
139        $trimmedNames = array_values(array_unique(array_map(static fn(string $name): string => trim($name), $names)));
140        $quotedNames = array_map(
141            fn(string $name): string => "'" . $this->databaseDriver->escape($name) . "'",
142            $trimmedNames,
143        );
144
145        $sql = <<<'SQL'
146                SELECT config_name, config_value FROM %s%s WHERE config_name IN (%s)
147            SQL;
148        $query = sprintf($sql, Database::getTablePrefix(), $this->tableName, implode(', ', $quotedNames));
149
150        $result = $this->databaseDriver->query($query);
151        $rows = $this->databaseDriver->fetchAll($result);
152
153        $values = array_fill_keys($trimmedNames, value: null);
154        if (!is_array($rows)) {
155            return $values;
156        }
157
158        foreach ($rows as $row) {
159            if (!property_exists($row, 'config_name') || !property_exists($row, 'config_value')) {
160                continue;
161            }
162
163            $values[(string) $row->config_name] = (string) $row->config_value;
164        }
165
166        return $values;
167    }
168}