diff options
Diffstat (limited to 'tests/simple_unit/ActiveRecord/FindBySqlTestCase.php')
-rw-r--r-- | tests/simple_unit/ActiveRecord/FindBySqlTestCase.php | 44 |
1 files changed, 0 insertions, 44 deletions
diff --git a/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php b/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php deleted file mode 100644 index 14da0833..00000000 --- a/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php +++ /dev/null @@ -1,44 +0,0 @@ -<?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); - } -} |