8356500215

Committed 20 Mar 2024 09:21AM UTC coverage: 94.0% (-2.0%) from 96.0%

Build Type

push

github

Committed by scrs_zdenek

Commit Message

dev

Run Details

47 of 50 relevant lines covered (94.0%)

2.82 hits per line

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

96.15

/src/Drago/Database/Repository.php

<?php

declare(strict_types=1);

/**
 * Drago Extension
 * Package built on Nette Framework
 */

namespace Drago\Database;

use Dibi\Connection;
use Dibi\Exception;
use Dibi\Fluent;
use Dibi\Result;
use Drago\Attr\AttributeDetection;
use Drago\Attr\AttributeDetectionException;


/**
 * Repository base.
 * @property-read Connection $db
 */
trait Repository
{
        use AttributeDetection;

        /**
         * Get records from table.
         * @throws AttributeDetectionException
         */
        public function table(?string $column = null, ...$args): Fluent
        {
                $query = $this->db
                        ->select('*')
                        ->from($this->getDatabaseTable());

                if ($column && $args) {
                        $query->where("$column = ?", $args);
                }

                return $query;
        }


        /**
         * Find record by id.
         * @throws AttributeDetectionException
         */
        public function get(int $id): Fluent
        {
                return $this->table($this->getPrimaryKey(), $id);
        }


        /**
         * Deleting a records by the primary key.
         * @throws Exception
         * @throws AttributeDetectionException
         */
        public function remove(int $id): Result|int|null
        {
                return $this->db
                        ->delete($this->getDatabaseTable())
                        ->where("{$this->getPrimaryKey()} = ?", $id)
                        ->execute();
        }


        /**
         * Saving a records.
         * @throws Exception
         * @throws AttributeDetectionException
         */
        public function put(mixed $data): Result|int|null
        {
                if ($data instanceof Entity) {
                        $data = $data->toArray();

                } elseif ($data instanceof EntityOracle) {
                        $data = $data->toArrayUpper();
                }

                $id = $data[$this->getPrimaryKey()] ?? null;
                $query = $id > 0
                        ? $this->db->update($this->getDatabaseTable(), $data)->where("{$this->getPrimaryKey()} = ?", $id)
                        : $this->db->insert($this->getDatabaseTable(), $data);
                return $query->execute();
        }


        /**
         * Get the id of the inserted record.
         * @throws Exception
         */
        public function getInsertId(?string $sequence = null): int
        {
                return $this->db->getInsertId($sequence);
        }
}

1	<?php
2
3	declare(strict_types=1);
4
5	/**
6	* Drago Extension
7	* Package built on Nette Framework
8	*/
9
10	namespace Drago\Database;
11
12	use Dibi\Connection;
13	use Dibi\Exception;
14	use Dibi\Fluent;
15	use Dibi\Result;
16	use Drago\Attr\AttributeDetection;
17	use Drago\Attr\AttributeDetectionException;
18
19
20	/**
21	* Repository base.
22	* @property-read Connection $db
23	*/
24	trait Repository
25	{
26	use AttributeDetection;
27
28	/**
29	* Get records from table.
30	* @throws AttributeDetectionException
31	*/
32	public function table(?string $column = null, ...$args): Fluent	3✔
33	{
34	$query = $this->db	3✔
35	->select('*')	3✔
36	->from($this->getDatabaseTable());	3✔
37
38	if ($column && $args) {	3✔
39	$query->where("$column = ?", $args);	3✔
40	}
41
42	return $query;	3✔
43	}
44
45
46	/**
47	* Find record by id.
48	* @throws AttributeDetectionException
49	*/
50	public function get(int $id): Fluent	3✔
51	{
52	return $this->table($this->getPrimaryKey(), $id);	3✔
53	}
54
55
56	/**
57	* Deleting a records by the primary key.
58	* @throws Exception
59	* @throws AttributeDetectionException
60	*/
61	public function remove(int $id): Result\|int\|null	3✔
62	{
63	return $this->db	3✔
64	->delete($this->getDatabaseTable())	3✔
65	->where("{$this->getPrimaryKey()} = ?", $id)	3✔
66	->execute();	3✔
67	}
68
69
70	/**
71	* Saving a records.
72	* @throws Exception
73	* @throws AttributeDetectionException
74	*/
75	public function put(mixed $data): Result\|int\|null	3✔
76	{
77	if ($data instanceof Entity) {	3✔
78	$data = $data->toArray();	3✔
79
80	} elseif ($data instanceof EntityOracle) {	3✔
81	$data = $data->toArrayUpper();	×
82	}
83
84	$id = $data[$this->getPrimaryKey()] ?? null;	3✔
85	$query = $id > 0	3✔
86	? $this->db->update($this->getDatabaseTable(), $data)->where("{$this->getPrimaryKey()} = ?", $id)	3✔
87	: $this->db->insert($this->getDatabaseTable(), $data);	3✔
88	return $query->execute();	3✔
89	}
90
91
92	/**
93	* Get the id of the inserted record.
94	* @throws Exception
95	*/
96	public function getInsertId(?string $sequence = null): int	3✔
97	{
98	return $this->db->getInsertId($sequence);	3✔
99	}
100	}

drago-ex / database / 8356500215

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