11645849762

Committed 02 Nov 2024 09:11PM UTC coverage: 86.209% (-0.1%) from 86.318%

Build # 11645849762

Build Type

push

github

Committed by

olvlvl

Commit Message

Tidy Query

Run Details

1369 of 1588 relevant lines covered (86.21%)

24.39 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

64.15

/lib/ActiveRecord/Table.php

<?php

namespace ICanBoogie\ActiveRecord;

use ICanBoogie\ActiveRecord\Config\TableDefinition;
use LogicException;
use RuntimeException;
use Throwable;

use function array_combine;
use function array_diff_key;
use function array_fill;
use function array_flip;
use function array_keys;
use function array_merge;
use function array_values;
use function count;
use function implode;
use function is_array;
use function is_numeric;
use function is_string;
use function strtr;

/**
 * A representation of a database table.
 */
readonly class Table
{
    /**
     * Name of the table, without the prefix defined by the connection.
     *
     * @var non-empty-string
     */
    public string $unprefixed_name;

    /**
     * Name of the table, including the prefix defined by the connection.
     *
     * @var non-empty-string
     */
    public string $name;

    /**
     * Alias for the table's name, which can be defined using the {@link ALIAS} attribute
     * or automatically created.
     *
     * This is the value for the "{primary}" placeholder.
     *
     * @var non-empty-string
     */
    public string $alias;
    public Schema $schema;

    /**
     * Primary key of the table, retrieved from the schema defined using the {@link SCHEMA} attribute.
     *
     * @var non-empty-string|non-empty-array<non-empty-string>|null
     */
    public array|string|null $primary;

    /**
     * SQL fragment for the FROM clause of the query, made of the table's name and alias and those
     * of the hierarchy.
     */
    public string $update_join;

    public function make_update_join(): string
    {
        $join = '';
        $parent = $this->parent;

        while ($parent) {
            assert(is_string($this->primary));

            $join .= " INNER JOIN `$parent->name` `$parent->alias` USING(`$this->primary`)";
            $parent = $parent->parent;
        }

        return $join;
    }

    /**
     * SQL fragment for the FROM clause of the query, made of the table's name and alias and those
     * of the related tables, inherited and implemented.
     *
     * This is the value for the `{self_and_related}` placeholder.
     */
    public string $select_join;

    private function make_select_join(): string
    {
        return "`$this->alias`" . $this->update_join;
    }

    public Schema $extended_schema;

    /**
     * Returns the extended schema.
     */
    private function make_extended_schema(): Schema
    {
        $table = $this;
        $columns = [];

        while ($table) {
            $columns[] = $table->schema->columns;

            $table = $table->parent;
        }

        $columns = array_reverse($columns);
        $columns = array_merge(...array_values($columns));

        return new Schema($columns, primary: $this->primary);
    }

    public function __construct(
        public Connection $connection,
        TableDefinition $definition,
        public ?self $parent = null,
    ) {
        $this->unprefixed_name = $definition->name;
        $this->name = $connection->table_name_prefix . $this->unprefixed_name;
        $this->alias = $definition->alias;
        $this->schema = $definition->schema;
        $this->primary = $this->schema->primary;
        $this->extended_schema = $this->parent
            ? $this->make_extended_schema()
            : $this->schema;
        $this->update_join = $this->make_update_join();
        $this->select_join = $this->make_select_join();
    }

    /**
     * Interface to the connection's query() method.
     *
     * The statement is resolved using the resolve_statement() method and prepared.
     *
     * @param non-empty-string $query
     * @param mixed[] $args
     */
    public function __invoke(string $query, array $args = []): Statement
    {
        $statement = $this->prepare($query);

        return $statement($args);
    }

    /*
    **

    INSTALL

    **
    */

    /**
     * Creates table.
     *
     * @throws Throwable if install fails.
     */
    public function install(): void
    {
        $this->connection->create_table($this->unprefixed_name, $this->schema);
    }

    /**
     * Drops table.
     *
     * @throws Throwable if uninstall fails.
     */
    public function uninstall(): void
    {
        $this->drop();
    }

    /**
     * Checks whether the table is installed.
     */
    public function is_installed(): bool
    {
        return $this->connection->table_exists($this->unprefixed_name);
    }

    /**
     * Resolves statement placeholders.
     *
     * The following placeholders are replaced:
     *
     * - `{alias}`: The alias of the table.
     * - `{prefix}`: The prefix used for the tables of the connection.
     * - `{primary}`: The primary key of the table.
     * - `{self}`: The name of the table.
     * - `{self_and_related}`: The escaped name of the table and the possible JOIN clauses.
     *
     * Note: If the table has a multi-column primary keys `{primary}` is replaced by
     * `__multi-column_primary__<concatenated_columns>` where `<concatenated_columns>` is the columns
     * concatenated with an underscore ("_") as separator. For instance, if a table primary key is
     * made of columns "p1" and "p2", `{primary}` is replaced by `__multi-column_primary__p1_p2`.
     * It's not very helpful, but we still have to decide what to do with this.
     *
     * @param string $statement The statement to resolve.
     */
    public function resolve_statement(string $statement): string
    {
        $primary = $this->primary;
        $primary = is_array($primary) ? '__multicolumn_primary__' . implode('_', $primary) : $primary;

        return strtr($statement, [

            '{alias}' => $this->alias,
            '{prefix}' => $this->connection->table_name_prefix,
            '{primary}' => $primary,
            '{self}' => $this->name,
            '{self_and_related}' => "`$this->name`" . ($this->select_join ? " $this->select_join" : '')

        ]);
    }

    /**
     * Interface to the connection's prepare method.
     *
     * The statement is resolved by the {@link resolve_statement()} method before the call is
     * forwarded.
     *
     * @param non-empty-string $query
     */
    public function prepare(string $query): Statement
    {
        $query = $this->resolve_statement($query);

        return $this->connection->prepare($query);
    }

    /**
     * Executes a statement.
     *
     * The statement is prepared by the {@link prepare()} method before it is executed.
     *
     * @param non-empty-string $query
     * @param array<int|string, mixed> $args
     */
    public function execute(string $query, array $args = []): Statement
    {
        $statement = $this->prepare($query);

        return $statement($args);
    }

    /**
     * Filters mass assignment values.
     *
     * @param array<string, mixed> $values
     *
     * @return array{ array<int|string|null>, array<string, string>, array<string> }
     */
    private function filter_values(array $values, bool $extended = false): array
    {
        $filtered = [];
        $holders = [];
        $identifiers = [];
        $schema = $extended ? $this->extended_schema : $this->schema;
        $driver = $this->connection->driver;

        foreach ($schema->filter_values($values) as $identifier => $value) {
            $quoted_identifier = $driver->quote_identifier($identifier);

            $filtered[] = $driver->cast_value($value);
            $holders[$identifier] = "$quoted_identifier = ?";
            $identifiers[] = $quoted_identifier;
        }

        return [ $filtered, $holders, $identifiers ];
    }

    /**
     * Saves values.
     *
     * @param array<string, mixed> $values
     * @param array<string, mixed> $options
     *
     * @throws Throwable
     */
    public function save(array $values, int $id = null, array $options = []): int|false
    {
        // TODO: If we have a parent, we should do the changes in a transaction.

        if ($id) {
            $this->update($values, $id);

            return $id;
        }

        return $this->save_callback($values, $id, $options);
    }

    /**
     * @param array<string, mixed> $values
     * @param array<string, mixed> $options
     */
    private function save_callback(array $values, int $id = null, array $options = []): int
    {
        assert(count($values) > 0);

        if ($id) {
            $this->update($values, $id);

            return $id;
        }

        $parent_id = 0;

        if ($this->parent) {
            $parent_id = $this->parent->save_callback($values, options: $options)
                ?: throw new RuntimeException(
                    "Parent save failed: {$this->parent->name} returning $parent_id"
                );

            assert(is_string($this->primary));
            assert(is_numeric($parent_id));

            $values[$this->primary] = $parent_id;
        }

        $driver_name = $this->connection->driver_name;

        [ $filtered, $holders, $identifiers ] = $this->filter_values($values);

        // FIXME: ALL THIS NEED REWRITE !

        if ($holders) {
            // If we have a parent, its primary key values must be used.

            if ($driver_name === 'mysql') {
                if ($parent_id && empty($holders[$this->primary])) {
                    $filtered[] = $parent_id;
                    $holders[] = '`{primary}` = ?';
                }

                $statement = 'INSERT INTO `{self}` SET ' . implode(', ', $holders);
                $statement = $this->prepare($statement);

                $statement->execute($filtered);
            } elseif ($driver_name === 'sqlite') {
                $this->insert($values);
            } else {
                throw new LogicException("Don't know what to do with $driver_name");
            }
        } elseif ($parent_id) {
            #
            # a new entry has been created, but we don't have any other fields then the primary key
            #

            if (empty($identifiers[$this->primary])) {
                $identifiers[] = '`{primary}`';
                $filtered[] = $parent_id;
            }

            $identifiers = implode(', ', $identifiers);
            $placeholders = implode(', ', array_fill(0, count($filtered), '?'));

            $statement = "INSERT INTO `{self}` ($identifiers) VALUES ($placeholders)";
            $statement = $this->prepare($statement);

            $statement->execute($filtered);
        }

        if ($parent_id) {
            return $parent_id;
        }
//
//        if (!$rc) {
//            return false;
//        }

        return $this->connection->last_insert_id;
    }

    /**
     * Inserts values into the table.
     *
     * @param non-empty-array<mixed> $values The values to insert.
     * @param bool $ignore Optional value to ignore insert errors.
     * @param bool $upsert Optional value to update the row if there's a matching primary key.
     */
    public function insert(array $values, bool $ignore = false, bool $upsert = false): void
    {
        [ $values, $holders, $identifiers ] = $this->filter_values($values);

        if (!$values) {
            throw new LogicException("No values to insert");
        }

        $driver_name = $this->connection->driver_name;

        if ($driver_name == 'mysql') {
            $query = 'INSERT';

            if ($ignore) {
                $query .= ' IGNORE ';
            }

            $query .= ' INTO `{self}` SET ' . implode(', ', $holders);

            if ($upsert) {
                #
                # We use the same input values, but we take care of
                # removing the primary key and its corresponding value
                #

                $update_values = array_combine(array_keys($holders), $values);
                $update_holders = $holders;

                $primary = $this->primary;

                if (is_array($primary)) {
                    $flip = array_flip($primary);

                    $update_holders = array_diff_key($update_holders, $flip);
                    $update_values = array_diff_key($update_values, $flip);
                } else {
                    unset($update_holders[$primary]);
                    unset($update_values[$primary]);
                }

                $update_values = array_values($update_values);

                $query .= ' ON DUPLICATE KEY UPDATE ' . implode(', ', $update_holders);

                $values = array_merge($values, $update_values);
            }
        } elseif ($driver_name == 'sqlite') {
            $holders = array_fill(0, count($identifiers), '?');

            $query = 'INSERT'
                . ($ignore | $upsert ? ' OR' : '')
                . ($ignore ? ' IGNORE' : '')
                . ($upsert ? ' REPLACE' : '')
                . ' INTO `{self}` (' . implode(', ', $identifiers) . ')'
                . ' VALUES (' . implode(', ', $holders) . ')';
        } else {
            throw new LogicException("Unsupported drive: $driver_name.");
        }

        $this->execute($query, $values);
    }

    /**
     * Update the values of an entry.
     *
     * Even if the entry is spread over multiple tables, all the tables are updated in a single
     * step.
     *
     * @param array<string, mixed> $values
     */
    public function update(array $values, int|string $key): void
    {
        #
        # SQLite doesn't support UPDATE with INNER JOIN.
        #

        if ($this->connection->driver_name == 'sqlite') {
            $table = $this;

            while ($table) {
                [ $table_values, $holders ] = $table->filter_values($values);

                if ($holders) {
                    $query = 'UPDATE `{self}` SET ' . implode(', ', $holders) . ' WHERE `{primary}` = ?';
                    $table_values[] = $key;

                    $table->execute($query, $table_values);
                }

                $table = $table->parent;
            }

            return;
        }

        [ $values, $holders ] = $this->filter_values($values, true);

        $query = "UPDATE `{self}` $this->update_join  SET " . implode(', ', $holders) . ' WHERE `{primary}` = ?';
        $values[] = $key;

        $this->execute($query, $values);
    }

    /**
     * Deletes a record.
     *
     * @param int|string|array<int|string> $key
     */
    public function delete(int|string|array $key): void
    {
        $this->parent?->delete($key);

        $where = 'WHERE ';

        if (is_array($this->primary)) {
            $parts = [];

            foreach ($this->primary as $identifier) {
                $parts[] = "`$identifier` = ?";
            }

            $where .= implode(' AND ', $parts);
        } else {
            $where .= '`{primary}` = ?';
        }

        $statement = $this->prepare('DELETE FROM `{self}` ' . $where);
        $statement((array)$key);
    }

    /**
     * Truncates table.
     *
     * @FIXME-20081223: what about extends ?
     */
    public function truncate(bool $reset_autoincrement = false): void
    {
        if ($this->connection->driver_name == 'sqlite') {
            $this->execute("DELETE FROM {self}");
            if ($reset_autoincrement) {
                $this->execute("DELETE FROM sqlite_sequence WHERE name = '{self}'");
            }
            $this->execute('vacuum');

            return;
        }

        $this->execute("TRUNCATE TABLE {self}");
        $this->execute("ALTER TABLE {self} AUTO_INCREMENT = 1");
    }

    /**
     * Drops table.
     *
     * @throws StatementNotValid when the table cannot be dropped.
     */
    public function drop(bool $if_exists = false): void
    {
        $query = 'DROP TABLE' . ($if_exists ? ' IF EXISTS ' : '') . ' `{self}`';

        $this->execute($query);
    }
}

1	<?php
2
3	namespace ICanBoogie\ActiveRecord;
4
5	use ICanBoogie\ActiveRecord\Config\TableDefinition;
6	use LogicException;
7	use RuntimeException;
8	use Throwable;
9
10	use function array_combine;
11	use function array_diff_key;
12	use function array_fill;
13	use function array_flip;
14	use function array_keys;
15	use function array_merge;
16	use function array_values;
17	use function count;
18	use function implode;
19	use function is_array;
20	use function is_numeric;
21	use function is_string;
22	use function strtr;
23
24	/**
25	* A representation of a database table.
26	*/
27	readonly class Table
28	{
29	/**
30	* Name of the table, without the prefix defined by the connection.
31	*
32	* @var non-empty-string
33	*/
34	public string $unprefixed_name;
35
36	/**
37	* Name of the table, including the prefix defined by the connection.
38	*
39	* @var non-empty-string
40	*/
41	public string $name;
42
43	/**
44	* Alias for the table's name, which can be defined using the {@link ALIAS} attribute
45	* or automatically created.
46	*
47	* This is the value for the "{primary}" placeholder.
48	*
49	* @var non-empty-string
50	*/
51	public string $alias;
52	public Schema $schema;
53
54	/**
55	* Primary key of the table, retrieved from the schema defined using the {@link SCHEMA} attribute.
56	*
57	* @var non-empty-string\|non-empty-array<non-empty-string>\|null
58	*/
59	public array\|string\|null $primary;
60
61	/**
62	* SQL fragment for the FROM clause of the query, made of the table's name and alias and those
63	* of the hierarchy.
64	*/
65	public string $update_join;
66
67	public function make_update_join(): string
68	{
69	$join = '';	78✔
70	$parent = $this->parent;	78✔
71
72	while ($parent) {	78✔
73	assert(is_string($this->primary));
74
75	$join .= " INNER JOIN `$parent->name` `$parent->alias` USING(`$this->primary`)";	55✔
76	$parent = $parent->parent;	55✔
77	}
78
79	return $join;	78✔
80	}
81
82	/**
83	* SQL fragment for the FROM clause of the query, made of the table's name and alias and those
84	* of the related tables, inherited and implemented.
85	*
86	* This is the value for the `{self_and_related}` placeholder.
87	*/
88	public string $select_join;
89
90	private function make_select_join(): string
91	{
92	return "`$this->alias`" . $this->update_join;	78✔
93	}
94
95	public Schema $extended_schema;
96
97	/**
98	* Returns the extended schema.
99	*/
100	private function make_extended_schema(): Schema
101	{
102	$table = $this;	55✔
103	$columns = [];	55✔
104
105	while ($table) {	55✔
106	$columns[] = $table->schema->columns;	55✔
107
108	$table = $table->parent;	55✔
109	}
110
111	$columns = array_reverse($columns);	55✔
112	$columns = array_merge(...array_values($columns));	55✔
113
114	return new Schema($columns, primary: $this->primary);	55✔
115	}
116
117	public function __construct(
118	public Connection $connection,
119	TableDefinition $definition,
120	public ?self $parent = null,
121	) {
122	$this->unprefixed_name = $definition->name;	78✔
123	$this->name = $connection->table_name_prefix . $this->unprefixed_name;	78✔
124	$this->alias = $definition->alias;	78✔
125	$this->schema = $definition->schema;	78✔
126	$this->primary = $this->schema->primary;	78✔
127	$this->extended_schema = $this->parent	78✔
128	? $this->make_extended_schema()	55✔
129	: $this->schema;	78✔
130	$this->update_join = $this->make_update_join();	78✔
131	$this->select_join = $this->make_select_join();	78✔
132	}
133
134	/**
135	* Interface to the connection's query() method.
136	*
137	* The statement is resolved using the resolve_statement() method and prepared.
138	*
139	* @param non-empty-string $query
140	* @param mixed[] $args
141	*/
142	public function __invoke(string $query, array $args = []): Statement
143	{
144	$statement = $this->prepare($query);	×
145
146	return $statement($args);	×
147	}
148
149	/*
150	**
151
152	INSTALL
153
154	**
155	*/
156
157	/**
158	* Creates table.
159	*
160	* @throws Throwable if install fails.
161	*/
162	public function install(): void
163	{
164	$this->connection->create_table($this->unprefixed_name, $this->schema);	66✔
165	}
166
167	/**
168	* Drops table.
169	*
170	* @throws Throwable if uninstall fails.
171	*/
172	public function uninstall(): void
173	{
174	$this->drop();	1✔
175	}
176
177	/**
178	* Checks whether the table is installed.
179	*/
180	public function is_installed(): bool
181	{
182	return $this->connection->table_exists($this->unprefixed_name);	36✔
183	}
184
185	/**
186	* Resolves statement placeholders.
187	*
188	* The following placeholders are replaced:
189	*
190	* - `{alias}`: The alias of the table.
191	* - `{prefix}`: The prefix used for the tables of the connection.
192	* - `{primary}`: The primary key of the table.
193	* - `{self}`: The name of the table.
194	* - `{self_and_related}`: The escaped name of the table and the possible JOIN clauses.
195	*
196	* Note: If the table has a multi-column primary keys `{primary}` is replaced by
197	* `__multi-column_primary__<concatenated_columns>` where `<concatenated_columns>` is the columns
198	* concatenated with an underscore ("_") as separator. For instance, if a table primary key is
199	* made of columns "p1" and "p2", `{primary}` is replaced by `__multi-column_primary__p1_p2`.
200	* It's not very helpful, but we still have to decide what to do with this.
201	*
202	* @param string $statement The statement to resolve.
203	*/
204	public function resolve_statement(string $statement): string
205	{
206	$primary = $this->primary;	45✔
207	$primary = is_array($primary) ? '__multicolumn_primary__' . implode('_', $primary) : $primary;	45✔
208
209	return strtr($statement, [	45✔
210
211	'{alias}' => $this->alias,	45✔
212	'{prefix}' => $this->connection->table_name_prefix,	45✔
213	'{primary}' => $primary,	45✔
214	'{self}' => $this->name,	45✔
215	'{self_and_related}' => "`$this->name`" . ($this->select_join ? " $this->select_join" : '')	45✔
216
217	]);	45✔
218	}
219
220	/**
221	* Interface to the connection's prepare method.
222	*
223	* The statement is resolved by the {@link resolve_statement()} method before the call is
224	* forwarded.
225	*
226	* @param non-empty-string $query
227	*/
228	public function prepare(string $query): Statement
229	{
230	$query = $this->resolve_statement($query);	40✔
231
232	return $this->connection->prepare($query);	40✔
233	}
234
235	/**
236	* Executes a statement.
237	*
238	* The statement is prepared by the {@link prepare()} method before it is executed.
239	*
240	* @param non-empty-string $query
241	* @param array<int\|string, mixed> $args
242	*/
243	public function execute(string $query, array $args = []): Statement
244	{
245	$statement = $this->prepare($query);	40✔
246
247	return $statement($args);	40✔
248	}
249
250	/**
251	* Filters mass assignment values.
252	*
253	* @param array<string, mixed> $values
254	*
255	* @return array{ array<int\|string\|null>, array<string, string>, array<string> }
256	*/
257	private function filter_values(array $values, bool $extended = false): array
258	{
259	$filtered = [];	39✔
260	$holders = [];	39✔
261	$identifiers = [];	39✔
262	$schema = $extended ? $this->extended_schema : $this->schema;	39✔
263	$driver = $this->connection->driver;	39✔
264
265	foreach ($schema->filter_values($values) as $identifier => $value) {	39✔
266	$quoted_identifier = $driver->quote_identifier($identifier);	38✔
267
268	$filtered[] = $driver->cast_value($value);	38✔
269	$holders[$identifier] = "$quoted_identifier = ?";	38✔
270	$identifiers[] = $quoted_identifier;	38✔
271	}
272
273	return [ $filtered, $holders, $identifiers ];	39✔
274	}
275
276	/**
277	* Saves values.
278	*
279	* @param array<string, mixed> $values
280	* @param array<string, mixed> $options
281	*
282	* @throws Throwable
283	*/
284	public function save(array $values, int $id = null, array $options = []): int\|false
285	{
286	// TODO: If we have a parent, we should do the changes in a transaction.
287
288	if ($id) {	34✔
289	$this->update($values, $id);	1✔
290
291	return $id;	1✔
292	}
293
294	return $this->save_callback($values, $id, $options);	34✔
295	}
296
297	/**
298	* @param array<string, mixed> $values
299	* @param array<string, mixed> $options
300	*/
301	private function save_callback(array $values, int $id = null, array $options = []): int
302	{
303	assert(count($values) > 0);
304
305	if ($id) {	34✔
306	$this->update($values, $id);	×
307
308	return $id;	×
309	}
310
311	$parent_id = 0;	34✔
312
313	if ($this->parent) {	34✔
314	$parent_id = $this->parent->save_callback($values, options: $options)	30✔
315	?: throw new RuntimeException(	×
316	"Parent save failed: {$this->parent->name} returning $parent_id"	×
317	);	×
318
319	assert(is_string($this->primary));
320	assert(is_numeric($parent_id));
321
322	$values[$this->primary] = $parent_id;	30✔
323	}
324
325	$driver_name = $this->connection->driver_name;	34✔
326
327	[ $filtered, $holders, $identifiers ] = $this->filter_values($values);	34✔
328
329	// FIXME: ALL THIS NEED REWRITE !
330
331	if ($holders) {	34✔
332	// If we have a parent, its primary key values must be used.
333
334	if ($driver_name === 'mysql') {	34✔
335	if ($parent_id && empty($holders[$this->primary])) {	×
336	$filtered[] = $parent_id;	×
337	$holders[] = '`{primary}` = ?';	×
338	}
339
340	$statement = 'INSERT INTO `{self}` SET ' . implode(', ', $holders);	×
341	$statement = $this->prepare($statement);	×
342
343	$statement->execute($filtered);	×
344	} elseif ($driver_name === 'sqlite') {	34✔
345	$this->insert($values);	34✔
346	} else {
347	throw new LogicException("Don't know what to do with $driver_name");	×
348	}
349	} elseif ($parent_id) {	×
350	#
351	# a new entry has been created, but we don't have any other fields then the primary key
352	#
353
354	if (empty($identifiers[$this->primary])) {	×
355	$identifiers[] = '`{primary}`';	×
356	$filtered[] = $parent_id;	×
357	}
358
359	$identifiers = implode(', ', $identifiers);	×
360	$placeholders = implode(', ', array_fill(0, count($filtered), '?'));	×
361
362	$statement = "INSERT INTO `{self}` ($identifiers) VALUES ($placeholders)";	×
363	$statement = $this->prepare($statement);	×
364
365	$statement->execute($filtered);	×
366	}
367
368	if ($parent_id) {	34✔
369	return $parent_id;	30✔
370	}
371	//
372	// if (!$rc) {
373	// return false;
374	// }
375
376	return $this->connection->last_insert_id;	34✔
377	}
378
379	/**
380	* Inserts values into the table.
381	*
382	* @param non-empty-array<mixed> $values The values to insert.
383	* @param bool $ignore Optional value to ignore insert errors.
384	* @param bool $upsert Optional value to update the row if there's a matching primary key.
385	*/
386	public function insert(array $values, bool $ignore = false, bool $upsert = false): void
387	{
388	[ $values, $holders, $identifiers ] = $this->filter_values($values);	39✔
389
390	if (!$values) {	39✔
391	throw new LogicException("No values to insert");	1✔
392	}
393
394	$driver_name = $this->connection->driver_name;	38✔
395
396	if ($driver_name == 'mysql') {	38✔
397	$query = 'INSERT';	×
398
399	if ($ignore) {	×
400	$query .= ' IGNORE ';	×
401	}
402
403	$query .= ' INTO `{self}` SET ' . implode(', ', $holders);	×
404
405	if ($upsert) {	×
406	#
407	# We use the same input values, but we take care of
408	# removing the primary key and its corresponding value
409	#
410
411	$update_values = array_combine(array_keys($holders), $values);	×
412	$update_holders = $holders;	×
413
414	$primary = $this->primary;	×
415
416	if (is_array($primary)) {	×
417	$flip = array_flip($primary);	×
418
419	$update_holders = array_diff_key($update_holders, $flip);	×
420	$update_values = array_diff_key($update_values, $flip);	×
421	} else {
422	unset($update_holders[$primary]);	×
423	unset($update_values[$primary]);	×
424	}
425
426	$update_values = array_values($update_values);	×
427
428	$query .= ' ON DUPLICATE KEY UPDATE ' . implode(', ', $update_holders);	×
429
430	$values = array_merge($values, $update_values);	×
431	}
432	} elseif ($driver_name == 'sqlite') {	38✔
433	$holders = array_fill(0, count($identifiers), '?');	38✔
434
435	$query = 'INSERT'	38✔
436	. ($ignore \| $upsert ? ' OR' : '')	38✔
437	. ($ignore ? ' IGNORE' : '')	38✔
438	. ($upsert ? ' REPLACE' : '')	38✔
439	. ' INTO `{self}` (' . implode(', ', $identifiers) . ')'	38✔
440	. ' VALUES (' . implode(', ', $holders) . ')';	38✔
441	} else {
442	throw new LogicException("Unsupported drive: $driver_name.");	×
443	}
444
445	$this->execute($query, $values);	38✔
446	}
447
448	/**
449	* Update the values of an entry.
450	*
451	* Even if the entry is spread over multiple tables, all the tables are updated in a single
452	* step.
453	*
454	* @param array<string, mixed> $values
455	*/
456	public function update(array $values, int\|string $key): void
457	{
458	#
459	# SQLite doesn't support UPDATE with INNER JOIN.
460	#
461
462	if ($this->connection->driver_name == 'sqlite') {	1✔
463	$table = $this;	1✔
464
465	while ($table) {	1✔
466	[ $table_values, $holders ] = $table->filter_values($values);	1✔
467
468	if ($holders) {	1✔
469	$query = 'UPDATE `{self}` SET ' . implode(', ', $holders) . ' WHERE `{primary}` = ?';	1✔
470	$table_values[] = $key;	1✔
471
472	$table->execute($query, $table_values);	1✔
473	}
474
475	$table = $table->parent;	1✔
476	}
477
478	return;	1✔
479	}
480
481	[ $values, $holders ] = $this->filter_values($values, true);	×
482
483	$query = "UPDATE `{self}` $this->update_join SET " . implode(', ', $holders) . ' WHERE `{primary}` = ?';	×
484	$values[] = $key;	×
485
486	$this->execute($query, $values);	×
487	}
488
489	/**
490	* Deletes a record.
491	*
492	* @param int\|string\|array<int\|string> $key
493	*/
494	public function delete(int\|string\|array $key): void
495	{
496	$this->parent?->delete($key);	×
497
498	$where = 'WHERE ';	×
499
500	if (is_array($this->primary)) {	×
501	$parts = [];	×
502
503	foreach ($this->primary as $identifier) {	×
504	$parts[] = "`$identifier` = ?";	×
505	}
506
507	$where .= implode(' AND ', $parts);	×
508	} else {
509	$where .= '`{primary}` = ?';	×
510	}
511
512	$statement = $this->prepare('DELETE FROM `{self}` ' . $where);	×
513	$statement((array)$key);	×
514	}
515
516	/**
517	* Truncates table.
518	*
519	* @FIXME-20081223: what about extends ?
520	*/
521	public function truncate(bool $reset_autoincrement = false): void
522	{
523	if ($this->connection->driver_name == 'sqlite') {	1✔
524	$this->execute("DELETE FROM {self}");	1✔
525	if ($reset_autoincrement) {	1✔
526	$this->execute("DELETE FROM sqlite_sequence WHERE name = '{self}'");	1✔
527	}
528	$this->execute('vacuum');	1✔
529
530	return;	1✔
531	}
532
533	$this->execute("TRUNCATE TABLE {self}");	×
534	$this->execute("ALTER TABLE {self} AUTO_INCREMENT = 1");	×
535	}
536
537	/**
538	* Drops table.
539	*
540	* @throws StatementNotValid when the table cannot be dropped.
541	*/
542	public function drop(bool $if_exists = false): void
543	{
544	$query = 'DROP TABLE' . ($if_exists ? ' IF EXISTS ' : '') . ' `{self}`';	2✔
545
546	$this->execute($query);	2✔
547	}
548	}

ICanBoogie / ActiveRecord / 11645849762

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous