94e1127a-1381-4e0d-b6ba-190c789ac9d0

Committed 16 Oct 2024 09:01AM UTC coverage: 88.603% (-0.02%) from 88.621%

Build # 94e1127a-1381-4e0d-b6ba-190c789ac9d0

Build Type

push

circleci

Committed by

aimeos

Commit Message

Support for Doctrine DBAL 4.x, dropped support for 2.x

Run Details

18 of 28 new or added lines in 4 files covered. (64.29%)

3 existing lines in 2 files now uncovered.

1687 of 1904 relevant lines covered (88.6%)

5.98 hits per line

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

71.43

/src/DB/Statement/DBAL/Prepared.php

<?php

/**
 * @license LGPLv3, https://opensource.org/licenses/LGPL-3.0
 * @copyright Aimeos (aimeos.org), 2016-2024
 * @package Base
 * @subpackage DB
 */


namespace Aimeos\Base\DB\Statement\DBAL;


/**
 * Database statement class for prepared DBAL statements
 *
 * @package Base
 * @subpackage DB
 */
class Prepared extends \Aimeos\Base\DB\Statement\Base implements \Aimeos\Base\DB\Statement\Iface
{
        private array $binds = [];
        private string $sql;


        /**
         * Initializes the statement object
         *
         * @param \Aimeos\Base\DB\Connection\DBAL $conn Database connection object
         * @param string $sql SQL statement
         */
        public function __construct( \Aimeos\Base\DB\Connection\DBAL $conn, string $sql )
        {
                parent::__construct( $conn );
                $this->sql = $sql;
        }


        /**
         * Returns the SQL string as sent to the database (magic PHP method)
         *
         * @return string SQL statement
         */
        public function __toString()
        {
                return $this->sql . ":\n" . print_r( array_column( $this->binds, 0 ), true );
        }


        /**
         * Binds a value to a parameter in the statement
         *
         * @param int $position Position index of the placeholder
         * @param mixed $value Value which should be bound to the placeholder
         * @param int $type Type of given value defined in \Aimeos\Base\DB\Statement\Base as constant
         * @return \Aimeos\Base\DB\Statement\Iface Statement instance for method chaining
         * @throws \Aimeos\Base\DB\Exception If an error occured in the unterlying driver
         */
        public function bind( int $position, $value, int $type = \Aimeos\Base\DB\Statement\Base::PARAM_STR ) : \Aimeos\Base\DB\Statement\Iface
        {
                $this->binds[$position] = [$value, $type];
                return $this;
        }


        /**
         * Executes the statement
         *
         * @return \Aimeos\Base\DB\Result\Iface Result object
         * @throws \Aimeos\Base\DB\Exception If an error occured in the unterlying driver
         */
        public function execute() : \Aimeos\Base\DB\Result\Iface
        {
                try {
                        $result = $this->exec();
                } catch( \PDOException $e ) {
                        throw new \Aimeos\Base\DB\Exception( $e->getMessage() . ': ' . $this->sql . json_encode( array_column( $this->binds, 0 ) ), $e->getCode() );
                }

                return new \Aimeos\Base\DB\Result\DBAL( $result );
        }


        /**
         * Binds the parameters and executes the SQL statment
         *
         * @return \Doctrine\DBAL\Driver\Statement|\Doctrine\DBAL\Driver\Result DBAL statement or result object
         */
        protected function exec()
        {
                try
                {
                        $stmt = $this->getConnection()->getRawObject()->getNativeConnection()->prepare( $this->sql );

                        foreach( $this->binds as $position => $list ) {
                                $stmt->bindValue( $position, $list[0], $this->getDbalType( $list[1], $list[0] ) );
                        }

                        $result = $stmt->execute();

                        if( $result instanceof \Doctrine\DBAL\Driver\Result ) {
                                return $result;
                        }

                        return $stmt;
                }
                catch( \PDOException $e )
                {
                        throw new \Aimeos\Base\DB\Exception( $e->getMessage(), $e->getCode() );
                }
        }


        /**
         * Returns the PDO type mapped to the Aimeos type
         *
         * @param integer $type Type of given value defined in \Aimeos\Base\DB\Statement\Base as constant
         * @param mixed $value Value which should be bound to the placeholder
         * @return integer PDO parameter type constant
         * @throws \Aimeos\Base\DB\Exception If the type is unknown
         */
        protected function getDbalType( int $type, $value ) : int
        {
                switch( $type )
                {
                        case \Aimeos\Base\DB\Statement\Base::PARAM_NULL:
                                $dbaltype = \PDO::PARAM_NULL; break;
                        case \Aimeos\Base\DB\Statement\Base::PARAM_BOOL:
                                $dbaltype = \PDO::PARAM_BOOL; break;
                        case \Aimeos\Base\DB\Statement\Base::PARAM_INT:
                                $dbaltype = \PDO::PARAM_INT; break;
                        case \Aimeos\Base\DB\Statement\Base::PARAM_FLOAT:
                                $dbaltype = \PDO::PARAM_STR; break;
                        case \Aimeos\Base\DB\Statement\Base::PARAM_STR:
                                $dbaltype = \PDO::PARAM_STR; break;
                        case \Aimeos\Base\DB\Statement\Base::PARAM_LOB:
                                $dbaltype = \PDO::PARAM_LOB; break;
                        default:
                                throw new \Aimeos\Base\DB\Exception( sprintf( 'Invalid parameter type "%1$s"', $type ) );
                }

                if( is_null( $value ) ) {
                        $dbaltype = \PDO::PARAM_NULL;
                }

                return $dbaltype;
        }
}

1	<?php
2
3	/**
4	* @license LGPLv3, https://opensource.org/licenses/LGPL-3.0
5	* @copyright Aimeos (aimeos.org), 2016-2024
6	* @package Base
7	* @subpackage DB
8	*/
9
10
11	namespace Aimeos\Base\DB\Statement\DBAL;
12
13
14	/**
15	* Database statement class for prepared DBAL statements
16	*
17	* @package Base
18	* @subpackage DB
19	*/
20	class Prepared extends \Aimeos\Base\DB\Statement\Base implements \Aimeos\Base\DB\Statement\Iface
21	{
22	private array $binds = [];
23	private string $sql;
24
25
26	/**
27	* Initializes the statement object
28	*
29	* @param \Aimeos\Base\DB\Connection\DBAL $conn Database connection object
30	* @param string $sql SQL statement
31	*/
32	public function __construct( \Aimeos\Base\DB\Connection\DBAL $conn, string $sql )
33	{
34	parent::__construct( $conn );	21✔
35	$this->sql = $sql;	21✔
36	}
37
38
39	/**
40	* Returns the SQL string as sent to the database (magic PHP method)
41	*
42	* @return string SQL statement
43	*/
44	public function __toString()
45	{
46	return $this->sql . ":\n" . print_r( array_column( $this->binds, 0 ), true );	×
47	}
48
49
50	/**
51	* Binds a value to a parameter in the statement
52	*
53	* @param int $position Position index of the placeholder
54	* @param mixed $value Value which should be bound to the placeholder
55	* @param int $type Type of given value defined in \Aimeos\Base\DB\Statement\Base as constant
56	* @return \Aimeos\Base\DB\Statement\Iface Statement instance for method chaining
57	* @throws \Aimeos\Base\DB\Exception If an error occured in the unterlying driver
58	*/
59	public function bind( int $position, $value, int $type = \Aimeos\Base\DB\Statement\Base::PARAM_STR ) : \Aimeos\Base\DB\Statement\Iface
60	{
61	$this->binds[$position] = [$value, $type];	19✔
62	return $this;	19✔
63	}
64
65
66	/**
67	* Executes the statement
68	*
69	* @return \Aimeos\Base\DB\Result\Iface Result object
70	* @throws \Aimeos\Base\DB\Exception If an error occured in the unterlying driver
71	*/
72	public function execute() : \Aimeos\Base\DB\Result\Iface
73	{
74	try {
75	$result = $this->exec();	20✔
76	} catch( \PDOException $e ) {	3✔
UNCOV 77	throw new \Aimeos\Base\DB\Exception( $e->getMessage() . ': ' . $this->sql . json_encode( array_column( $this->binds, 0 ) ), $e->getCode() );	×
78	}
79
80	return new \Aimeos\Base\DB\Result\DBAL( $result );	17✔
81	}
82
83
84	/**
85	* Binds the parameters and executes the SQL statment
86	*
87	* @return \Doctrine\DBAL\Driver\Statement\|\Doctrine\DBAL\Driver\Result DBAL statement or result object
88	*/
89	protected function exec()
90	{
91	try
92	{
93	$stmt = $this->getConnection()->getRawObject()->getNativeConnection()->prepare( $this->sql );	20✔
94
95	foreach( $this->binds as $position => $list ) {	20✔
96	$stmt->bindValue( $position, $list[0], $this->getDbalType( $list[1], $list[0] ) );	19✔
97	}
98
99	$result = $stmt->execute();	18✔
100
101	if( $result instanceof \Doctrine\DBAL\Driver\Result ) {	17✔
NEW 102	return $result;	×
103	}
104
105	return $stmt;	17✔
106	}
107	catch( \PDOException $e )	3✔
108	{
109	throw new \Aimeos\Base\DB\Exception( $e->getMessage(), $e->getCode() );	1✔
110	}
111	}
112
113
114	/**
115	* Returns the PDO type mapped to the Aimeos type
116	*
117	* @param integer $type Type of given value defined in \Aimeos\Base\DB\Statement\Base as constant
118	* @param mixed $value Value which should be bound to the placeholder
119	* @return integer PDO parameter type constant
120	* @throws \Aimeos\Base\DB\Exception If the type is unknown
121	*/
122	protected function getDbalType( int $type, $value ) : int
123	{
124	switch( $type )
125	{
126	case \Aimeos\Base\DB\Statement\Base::PARAM_NULL:
NEW 127	$dbaltype = \PDO::PARAM_NULL; break;	×
128	case \Aimeos\Base\DB\Statement\Base::PARAM_BOOL:
NEW 129	$dbaltype = \PDO::PARAM_BOOL; break;	×
130	case \Aimeos\Base\DB\Statement\Base::PARAM_INT:
131	$dbaltype = \PDO::PARAM_INT; break;	5✔
132	case \Aimeos\Base\DB\Statement\Base::PARAM_FLOAT:
NEW 133	$dbaltype = \PDO::PARAM_STR; break;	×
134	case \Aimeos\Base\DB\Statement\Base::PARAM_STR:
135	$dbaltype = \PDO::PARAM_STR; break;	17✔
136	case \Aimeos\Base\DB\Statement\Base::PARAM_LOB:
NEW 137	$dbaltype = \PDO::PARAM_LOB; break;	×
138	default:
139	throw new \Aimeos\Base\DB\Exception( sprintf( 'Invalid parameter type "%1$s"', $type ) );	2✔
140	}
141
142	if( is_null( $value ) ) {	18✔
NEW 143	$dbaltype = \PDO::PARAM_NULL;	×
144	}
145
146	return $dbaltype;	18✔
147	}
148	}

aimeos / aimeos-base / 94e1127a-1381-4e0d-b6ba-190c789ac9d0

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