1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
<?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik\Tests\Integration\Updater\Migration\Db;
use Piwik\Tests\Framework\TestCase\IntegrationTestCase;
use Piwik\Updater\Migration\Db\BoundSql;
/**
* @group Core
* @group Updater
* @group Migration
* @group BoundSql
* @group BoundSqlTest
*/
class BoundSqlTest extends IntegrationTestCase
{
private $testQuery = 'ALTER TABLE foobar ADD COLUMN barbaz VARCHAR(1)';
public function test_toString_shouldAppendSemicolonIfNeeded()
{
$sql = $this->boundSql($this->testQuery, array());
$this->assertSame($this->testQuery . ';', '' . $sql);
}
public function test_toString_shouldNotAppendSemicolonIfNotNeeded()
{
$sql = $this->boundSql($this->testQuery . ';');
$this->assertSame($this->testQuery . ';', '' . $sql);
}
public function test_toString_shouldReplacePlaceHolders()
{
$sql = $this->boundSql('DELETE FROM table WHERE x=?, foobar = ?, xyz = ?', array(
'my value 1', 5, 'test\' val\ue"'
));
$this->assertSame("DELETE FROM table WHERE x='my value 1', foobar = 5, xyz = 'test\' val\\\\ue\\\"';", '' . $sql);
}
public function test_constructor_shouldConvertErrorCodeToArray_IfNeeded()
{
$sql = $this->boundSql($this->testQuery, array(), 1091);
$this->assertSame(array(1091), $sql->getErrorCodesToIgnore());
}
public function test_constructor_shouldNotConvertErrorCodeToArray_IfNotNeeded()
{
$sql = $this->boundSql($this->testQuery, array(), array(1091, 1061));
$this->assertSame(array(1091, 1061), $sql->getErrorCodesToIgnore());
}
private function boundSql($query, $bind = array(), $errorCode = array())
{
return new BoundSql($query, $bind, $errorCode);
}
}
|