Concerns
2 weeks ago
Connection.php
2 years ago
MySqlDriver.php
2 weeks ago
PostgresDriver.php
2 weeks ago
SQLiteDriver.php
2 weeks ago
SqlServerConnection.php
2 weeks ago
SqlServerDriver.php
2 weeks ago
Connection.php
164 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWPSCOPED\Illuminate\Database\PDO; |
| 4 | |
| 5 | use IAWPSCOPED\Doctrine\DBAL\Driver\PDO\Exception; |
| 6 | use IAWPSCOPED\Doctrine\DBAL\Driver\PDO\Result; |
| 7 | use IAWPSCOPED\Doctrine\DBAL\Driver\PDO\Statement; |
| 8 | use IAWPSCOPED\Doctrine\DBAL\Driver\Result as ResultInterface; |
| 9 | use IAWPSCOPED\Doctrine\DBAL\Driver\ServerInfoAwareConnection; |
| 10 | use IAWPSCOPED\Doctrine\DBAL\Driver\Statement as StatementInterface; |
| 11 | use IAWPSCOPED\Doctrine\DBAL\ParameterType; |
| 12 | use PDO; |
| 13 | use PDOException; |
| 14 | use PDOStatement; |
| 15 | /** @internal */ |
| 16 | class Connection implements ServerInfoAwareConnection |
| 17 | { |
| 18 | /** |
| 19 | * The underlying PDO connection. |
| 20 | * |
| 21 | * @var \PDO |
| 22 | */ |
| 23 | protected $connection; |
| 24 | /** |
| 25 | * Create a new PDO connection instance. |
| 26 | * |
| 27 | * @param \PDO $connection |
| 28 | * @return void |
| 29 | */ |
| 30 | public function __construct(PDO $connection) |
| 31 | { |
| 32 | $this->connection = $connection; |
| 33 | } |
| 34 | /** |
| 35 | * Execute an SQL statement. |
| 36 | * |
| 37 | * @param string $statement |
| 38 | * @return int |
| 39 | */ |
| 40 | public function exec(string $statement) : int |
| 41 | { |
| 42 | try { |
| 43 | $result = $this->connection->exec($statement); |
| 44 | \assert($result !== \false); |
| 45 | return $result; |
| 46 | } catch (PDOException $exception) { |
| 47 | throw Exception::new($exception); |
| 48 | } |
| 49 | } |
| 50 | /** |
| 51 | * Prepare a new SQL statement. |
| 52 | * |
| 53 | * @param string $sql |
| 54 | * @return \Doctrine\DBAL\Driver\Statement |
| 55 | */ |
| 56 | public function prepare(string $sql) : StatementInterface |
| 57 | { |
| 58 | try { |
| 59 | return $this->createStatement($this->connection->prepare($sql)); |
| 60 | } catch (PDOException $exception) { |
| 61 | throw Exception::new($exception); |
| 62 | } |
| 63 | } |
| 64 | /** |
| 65 | * Execute a new query against the connection. |
| 66 | * |
| 67 | * @param string $sql |
| 68 | * @return \Doctrine\DBAL\Driver\Result |
| 69 | */ |
| 70 | public function query(string $sql) : ResultInterface |
| 71 | { |
| 72 | try { |
| 73 | $stmt = $this->connection->query($sql); |
| 74 | \assert($stmt instanceof PDOStatement); |
| 75 | return new Result($stmt); |
| 76 | } catch (PDOException $exception) { |
| 77 | throw Exception::new($exception); |
| 78 | } |
| 79 | } |
| 80 | /** |
| 81 | * Get the last insert ID. |
| 82 | * |
| 83 | * @param string|null $name |
| 84 | * @return mixed |
| 85 | */ |
| 86 | public function lastInsertId($name = null) |
| 87 | { |
| 88 | try { |
| 89 | if ($name === null) { |
| 90 | return $this->connection->lastInsertId(); |
| 91 | } |
| 92 | return $this->connection->lastInsertId($name); |
| 93 | } catch (PDOException $exception) { |
| 94 | throw Exception::new($exception); |
| 95 | } |
| 96 | } |
| 97 | /** |
| 98 | * Create a new statement instance. |
| 99 | * |
| 100 | * @param \PDOStatement $stmt |
| 101 | * @return \Doctrine\DBAL\Driver\PDO\Statement |
| 102 | */ |
| 103 | protected function createStatement(PDOStatement $stmt) : Statement |
| 104 | { |
| 105 | return new Statement($stmt); |
| 106 | } |
| 107 | /** |
| 108 | * Begin a new database transaction. |
| 109 | * |
| 110 | * @return void |
| 111 | */ |
| 112 | public function beginTransaction() |
| 113 | { |
| 114 | return $this->connection->beginTransaction(); |
| 115 | } |
| 116 | /** |
| 117 | * Commit a database transaction. |
| 118 | * |
| 119 | * @return void |
| 120 | */ |
| 121 | public function commit() |
| 122 | { |
| 123 | return $this->connection->commit(); |
| 124 | } |
| 125 | /** |
| 126 | * Rollback a database transaction. |
| 127 | * |
| 128 | * @return void |
| 129 | */ |
| 130 | public function rollBack() |
| 131 | { |
| 132 | return $this->connection->rollBack(); |
| 133 | } |
| 134 | /** |
| 135 | * Wrap quotes around the given input. |
| 136 | * |
| 137 | * @param string $input |
| 138 | * @param string $type |
| 139 | * @return string |
| 140 | */ |
| 141 | public function quote($input, $type = ParameterType::STRING) |
| 142 | { |
| 143 | return $this->connection->quote($input, $type); |
| 144 | } |
| 145 | /** |
| 146 | * Get the server version for the connection. |
| 147 | * |
| 148 | * @return string |
| 149 | */ |
| 150 | public function getServerVersion() |
| 151 | { |
| 152 | return $this->connection->getAttribute(PDO::ATTR_SERVER_VERSION); |
| 153 | } |
| 154 | /** |
| 155 | * Get the wrapped PDO connection. |
| 156 | * |
| 157 | * @return \PDO |
| 158 | */ |
| 159 | public function getWrappedConnection() : PDO |
| 160 | { |
| 161 | return $this->connection; |
| 162 | } |
| 163 | } |
| 164 |