/
SqliteTest.php
95 lines (85 loc) · 2.59 KB
/
SqliteTest.php
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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
<?php
/**
* PHP Version 5.4
*
* CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
* Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
*
* Licensed under The MIT License
* For full copyright and license information, please see the LICENSE.txt
* Redistributions of files must retain the above copyright notice.
*
* @copyright Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
* @link http://cakephp.org CakePHP(tm) Project
* @package Cake.Model
* @since CakePHP(tm) v 3.0.0
* @license MIT License (http://www.opensource.org/licenses/mit-license.php)
*/
namespace Cake\Test\TestCase\Database\Driver;
use Cake\Core\Configure;
use Cake\Database\Connection;
use Cake\Database\Driver\Sqlite;
use Cake\Testsuite\TestCase;
use \PDO;
/**
* Tests Sqlite driver
*/
class SqliteTest extends TestCase {
/**
* Test connecting to Sqlite with default configuration
*
* @return void
*/
public function testConnectionConfigDefault() {
$driver = $this->getMock('Cake\Database\driver\Sqlite', ['_connect']);
$expected = [
'persistent' => false,
'database' => ':memory:',
'encoding' => 'utf8',
'login' => null,
'password' => null,
'flags' => [],
'init' => [],
'dsn' => 'sqlite::memory:'
];
$expected['flags'] += [
PDO::ATTR_PERSISTENT => false,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
];
$driver->expects($this->once())->method('_connect')
->with($expected);
$driver->connect([]);
}
/**
* Test connecting to Sqlite with custom configuration
*
* @return void
*/
public function testConnectionConfigCustom() {
$driver = $this->getMock('Cake\Database\driver\Sqlite', ['_connect', 'connection']);
$config = [
'persistent' => true,
'host' => 'foo',
'database' => 'bar.db',
'flags' => [1 => true, 2 => false],
'encoding' => 'a-language',
'init' => ['Execute this', 'this too']
];
$expected = $config;
$expected += ['login' => null, 'password' => null];
$expected['dsn'] = 'sqlite:bar.db';
$expected['flags'] += [
PDO::ATTR_PERSISTENT => true,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
];
$connection = $this->getMock('StdClass', ['exec']);
$connection->expects($this->at(0))->method('exec')->with('Execute this');
$connection->expects($this->at(1))->method('exec')->with('this too');
$connection->expects($this->exactly(2))->method('exec');
$driver->expects($this->once())->method('_connect')
->with($expected);
$driver->expects($this->any())->method('connection')
->will($this->returnValue($connection));
$driver->connect($config);
}
}