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
|
<?php
class MultipleConnectionTest extends PHPUnit_Framework_TestCase {
const ALTERNATE = 'alternate'; // Used as name of alternate connection
public function setUp() {
// Set up the dummy database connections
ORM::set_db(new MockPDO('sqlite::memory:'));
ORM::set_db(new MockDifferentPDO('sqlite::memory:'), self::ALTERNATE);
// Enable logging
ORM::configure('logging', true);
ORM::configure('logging', true, self::ALTERNATE);
}
public function tearDown() {
ORM::reset_config();
ORM::reset_db();
}
public function testMultiplePdoConnections() {
$this->assertInstanceOf('MockPDO', ORM::get_db());
$this->assertInstanceOf('MockPDO', ORM::get_db(ORM::DEFAULT_CONNECTION));
$this->assertInstanceOf('MockDifferentPDO', ORM::get_db(self::ALTERNATE));
}
public function testRawExecuteOverAlternateConnection() {
$expected = "SELECT * FROM `foo`";
ORM::raw_execute("SELECT * FROM `foo`", array(), self::ALTERNATE);
$this->assertEquals($expected, ORM::get_last_query(self::ALTERNATE));
}
public function testFindOneOverDifferentConnections() {
ORM::for_table('widget')->find_one();
$statementOne = ORM::get_last_statement();
$this->assertInstanceOf('MockPDOStatement', $statementOne);
ORM::for_table('person', self::ALTERNATE)->find_one();
$statementOne = ORM::get_last_statement(); // get_statement is *not* per connection
$this->assertInstanceOf('MockDifferentPDOStatement', $statementOne);
$expected = "SELECT * FROM `widget` LIMIT 1";
$this->assertNotEquals($expected, ORM::get_last_query()); // Because get_last_query() is across *all* connections
$this->assertEquals($expected, ORM::get_last_query(ORM::DEFAULT_CONNECTION));
$expectedToo = "SELECT * FROM `person` LIMIT 1";
$this->assertEquals($expectedToo, ORM::get_last_query(self::ALTERNATE));
}
}
|
