AddColumn.php
5 years ago
AddColumns.php
5 years ago
AddIndex.php
5 years ago
AddPrimaryKey.php
5 years ago
AddUniqueKey.php
5 years ago
BatchInsert.php
5 years ago
BoundSql.php
5 years ago
ChangeColumn.php
5 years ago
ChangeColumnType.php
5 years ago
ChangeColumnTypes.php
5 years ago
CreateTable.php
5 years ago
DropColumn.php
5 years ago
DropColumns.php
5 years ago
DropIndex.php
5 years ago
DropPrimaryKey.php
5 years ago
DropTable.php
5 years ago
Factory.php
5 years ago
Insert.php
5 years ago
Sql.php
5 years ago
Sql.php
100 lines
| 1 | <?php |
| 2 | /** |
| 3 | * Matomo - free/libre analytics platform |
| 4 | * |
| 5 | * @link https://matomo.org |
| 6 | * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later |
| 7 | */ |
| 8 | namespace Piwik\Updater\Migration\Db; |
| 9 | use Piwik\Common; |
| 10 | use Piwik\Db; |
| 11 | use Piwik\Updater\Migration\Db as DbMigration; |
| 12 | |
| 13 | /** |
| 14 | * Executes a given SQL query. |
| 15 | * |
| 16 | * @see Factory::sql() |
| 17 | * @ignore |
| 18 | */ |
| 19 | class Sql extends DbMigration |
| 20 | { |
| 21 | |
| 22 | /** |
| 23 | * @var string |
| 24 | */ |
| 25 | protected $sql; |
| 26 | |
| 27 | /** |
| 28 | * @var false|int|array |
| 29 | */ |
| 30 | private $errorCodesToIgnore; |
| 31 | |
| 32 | /** |
| 33 | * Sql constructor. |
| 34 | * @param string $sql |
| 35 | * @param int|int[] $errorCodesToIgnore If no error should be ignored use an empty array. |
| 36 | */ |
| 37 | public function __construct($sql, $errorCodesToIgnore) |
| 38 | { |
| 39 | if (!is_array($errorCodesToIgnore)) { |
| 40 | $errorCodesToIgnore = array($errorCodesToIgnore); |
| 41 | } |
| 42 | |
| 43 | $this->sql = $sql; |
| 44 | $this->errorCodesToIgnore = $errorCodesToIgnore; |
| 45 | } |
| 46 | |
| 47 | public function shouldIgnoreError($exception) |
| 48 | { |
| 49 | if (empty($this->errorCodesToIgnore)) { |
| 50 | return false; |
| 51 | } |
| 52 | |
| 53 | foreach ($this->errorCodesToIgnore as $code) { |
| 54 | if (Db::get()->isErrNo($exception, $code)) { |
| 55 | return true; |
| 56 | } |
| 57 | } |
| 58 | |
| 59 | return false; |
| 60 | } |
| 61 | |
| 62 | /** |
| 63 | * @internal |
| 64 | * @param int $errorCode |
| 65 | * @return $this |
| 66 | */ |
| 67 | public function addErrorCodeToIgnore($errorCode) |
| 68 | { |
| 69 | $this->errorCodesToIgnore[] = $errorCode; |
| 70 | |
| 71 | return $this; |
| 72 | } |
| 73 | |
| 74 | /** |
| 75 | * @internal |
| 76 | */ |
| 77 | public function getErrorCodesToIgnore() |
| 78 | { |
| 79 | return $this->errorCodesToIgnore; |
| 80 | } |
| 81 | |
| 82 | public function __toString() |
| 83 | { |
| 84 | $sql = $this->sql; |
| 85 | |
| 86 | if (!empty($sql) && !Common::stringEndsWith($sql, ';')) { |
| 87 | $sql .= ';'; |
| 88 | } |
| 89 | |
| 90 | return $sql; |
| 91 | } |
| 92 | |
| 93 | public function exec() |
| 94 | { |
| 95 | if (!empty($this->sql)) { |
| 96 | Db::exec($this->sql); |
| 97 | } |
| 98 | } |
| 99 | } |
| 100 |