blob: 14da08334a2477746af36cbe84019e0b6116f024 (
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
33
34
35
36
37
38
39
40
41
42
43
44
|
<?php
Prado::using('System.Data.ActiveRecord.TActiveRecord');
require_once(dirname(__FILE__).'/records/DepartmentRecord.php');
require_once(dirname(__FILE__).'/records/UserRecord.php');
class UserRecord2 extends UserRecord
{
public $another_value;
}
class SqlTest extends TActiveRecord
{
public $category;
public $item;
const TABLE='items';
}
class FindBySqlTestCase extends UnitTestCase
{
function setup()
{
$conn = new TDbConnection('pgsql:host=localhost;dbname=test', 'test','test');
TActiveRecordManager::getInstance()->setDbConnection($conn);
}
function test_find_by_sql()
{
$deps = DepartmentRecord::finder()->findBySql('SELECT * FROM departments');
$this->assertTrue(count($deps) > 0);
}
function test_find_by_sql_arb()
{
$sql = 'SELECT c.name as category, i.name as item
FROM items i, categories c
WHERE i.category_id = c.category_id LIMIT 2';
$items = TActiveRecord::finder('SqlTest')->findBySql($sql);
$sql = "SELECT users.*, 'hello' as another_value FROM users LIMIT 2";
$users = TActiveRecord::finder('UserRecord2')->findBySql($sql);
var_dump($users);
}
}
|
