blob: be67b33165de85a0422a13e220167ac8d60a7a80 (
plain)
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
|
<?php
class QueryBuilderMssqlTest extends PHPUnit_Framework_TestCase {
public function setUp() {
// Enable logging
ORM::configure('logging', true);
// Set up the dummy database connection
$db = new MockMsSqlPDO('sqlite::memory:');
ORM::set_db($db);
}
public function tearDown() {
ORM::reset_config();
ORM::reset_db();
}
public function testFindOne() {
ORM::for_table('widget')->find_one();
$expected = 'SELECT TOP 1 * FROM "widget"';
$this->assertEquals($expected, ORM::get_last_query());
}
public function testLimit() {
ORM::for_table('widget')->limit(5)->find_many();
$expected = 'SELECT TOP 5 * FROM "widget"';
$this->assertEquals($expected, ORM::get_last_query());
}
}
|